What are the responsibilities and job description for the ETL Developer / Data Integration Developer position at QED National?
Client: Public Sector Client
Title: ETL Developer / Data Integration Developer
Pay Rate Range: $60.00 - $65.00
Location: Austin, TX - candidate must be within 50mi of Austin
Job Type: Contact - 6month (likely to extend)
Work Mode: Hybrid 3 days remote 2 days on-site (Wed & Fri)
Job Description: The role requires understanding business objectives and problems, identifying alternative solutions, performing studies, and conducting cost/benefit analyses. The position involves analyzing user requirements, procedures, and problems to automate processes or improve existing computer systems. The individual will collaborate with personnel from various organizational units to analyze current operational procedures, identify issues, and determine specific input/output requirements such as forms of data input, data summarization, and report formats. The role also includes writing detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs. Furthermore, the individual will review system capabilities, specifications, and scheduling limitations to determine if requested programs or changes can be accommodated within the existing system.
Responsibilities:
This development effort will utilize an agile methodology, based on the approach currently in use at the client's integrated eligibility redesign system. As a member of the agile development team, responsibilities may include:
• Data acquisition from a variety of data sources for multiple uses.
• Developing complex SQL scripts to transform source data into a dimensional model and create views and materialized views in Oracle.
• Developing automation with Informatica IICS or Power Center to pull data from external sources and transform it into a dimensional model.
• Collaborating with the Data Engineering Team on optimal data design.
• Verification and validation of SQL scripts, Informatica automation, and database views.
• Developing automated means of verification and validation.
• Participating in all sprint ceremonies.
• Working closely with Architects and Data Engineering Team on implementation designs and data acquisition strategies.
• Enhancing and maintaining the Java web site that provides Tableau dashboards to users with various roles.
• Developing mock-ups and collaborating with customers for validation.
• Assisting with the implementation and configuration of developmental tools.
• Producing and maintaining technical specifications, diagrams, or other documentation as needed for DD&I efforts.
• Participation in requirements and design sessions.
• Interpreting new and changing business requirements to propose necessary enhancements.
Mandatory Skills & Experience:
Candidates must have ALL skills clearly outlined on their resume in order to be considered.
• 8 Years Required: Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
• 8 Years Required: Experience acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object (e.g., Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF).
• 8 Years Required: Experience designing and developing complex SQL scripts that are fast and efficient.
• 8 Years Required: Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
• 8 Years Required: Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, PowerPoint, MS Project).
• 8 Years Required: Experience in planning and delivering software platforms used across multiple products and organizational units.
• 8 Years Required: Experience designing and developing scripts using Python.
• 8 Years Required: Experience on an agile sprint team.
• 8 Years Required: Experience with JIRA software.
Preferred Skills:
• 6 Years Preferred: Excellent oral and written communication skills.
• 6 Years Preferred: Proven ability to write well-designed, testable, efficient code using best software development practices.
• 4 Years Preferred: Understanding of security principles and how they apply to healthcare data.
• 4 Years Preferred: Experience with state-of-the-art software components for performance metrics data visualization or business intelligence environments.
• 4 Years Preferred: Ability to effectively self-manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments as required.
• 4 Years Preferred: Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.
• 3 Years Preferred: Prior experience in the Healthcare Industry.
• 2 Years Preferred: Prior experience with an HHS agency.
• 2 Years Preferred: Prior experience working with PII or PHI data.
• 2 Years Preferred: Expertise and hands-on experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery, and APIs.
• 2 Years Preferred: Prior experience creating websites/user interfaces using standard HTML/CSS practices.
• 2 Years Preferred: Functional knowledge or hands-on design experience with Web Services (REST, SOAP, etc.).
• 2 Years Preferred: Experience developing dashboards and reports using Tableau, including connecting to external data sources.
Title: ETL Developer / Data Integration Developer
Pay Rate Range: $60.00 - $65.00
Location: Austin, TX - candidate must be within 50mi of Austin
Job Type: Contact - 6month (likely to extend)
Work Mode: Hybrid 3 days remote 2 days on-site (Wed & Fri)
Job Description: The role requires understanding business objectives and problems, identifying alternative solutions, performing studies, and conducting cost/benefit analyses. The position involves analyzing user requirements, procedures, and problems to automate processes or improve existing computer systems. The individual will collaborate with personnel from various organizational units to analyze current operational procedures, identify issues, and determine specific input/output requirements such as forms of data input, data summarization, and report formats. The role also includes writing detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs. Furthermore, the individual will review system capabilities, specifications, and scheduling limitations to determine if requested programs or changes can be accommodated within the existing system.
Responsibilities:
This development effort will utilize an agile methodology, based on the approach currently in use at the client's integrated eligibility redesign system. As a member of the agile development team, responsibilities may include:
• Data acquisition from a variety of data sources for multiple uses.
• Developing complex SQL scripts to transform source data into a dimensional model and create views and materialized views in Oracle.
• Developing automation with Informatica IICS or Power Center to pull data from external sources and transform it into a dimensional model.
• Collaborating with the Data Engineering Team on optimal data design.
• Verification and validation of SQL scripts, Informatica automation, and database views.
• Developing automated means of verification and validation.
• Participating in all sprint ceremonies.
• Working closely with Architects and Data Engineering Team on implementation designs and data acquisition strategies.
• Enhancing and maintaining the Java web site that provides Tableau dashboards to users with various roles.
• Developing mock-ups and collaborating with customers for validation.
• Assisting with the implementation and configuration of developmental tools.
• Producing and maintaining technical specifications, diagrams, or other documentation as needed for DD&I efforts.
• Participation in requirements and design sessions.
• Interpreting new and changing business requirements to propose necessary enhancements.
Mandatory Skills & Experience:
Candidates must have ALL skills clearly outlined on their resume in order to be considered.
• 8 Years Required: Experience developing mappings and workflows to automate ETL processes using Informatica IICS, IDMC, or Power Center.
• 8 Years Required: Experience acquiring and integrating data from multiple data sources/technologies using Informatica for use by a Tableau data visualization object (e.g., Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF).
• 8 Years Required: Experience designing and developing complex SQL scripts that are fast and efficient.
• 8 Years Required: Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
• 8 Years Required: Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, PowerPoint, MS Project).
• 8 Years Required: Experience in planning and delivering software platforms used across multiple products and organizational units.
• 8 Years Required: Experience designing and developing scripts using Python.
• 8 Years Required: Experience on an agile sprint team.
• 8 Years Required: Experience with JIRA software.
Preferred Skills:
• 6 Years Preferred: Excellent oral and written communication skills.
• 6 Years Preferred: Proven ability to write well-designed, testable, efficient code using best software development practices.
• 4 Years Preferred: Understanding of security principles and how they apply to healthcare data.
• 4 Years Preferred: Experience with state-of-the-art software components for performance metrics data visualization or business intelligence environments.
• 4 Years Preferred: Ability to effectively self-manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments as required.
• 4 Years Preferred: Bachelor's degree in Computer Science, Information Systems, Business, or equivalent experience.
• 3 Years Preferred: Prior experience in the Healthcare Industry.
• 2 Years Preferred: Prior experience with an HHS agency.
• 2 Years Preferred: Prior experience working with PII or PHI data.
• 2 Years Preferred: Expertise and hands-on experience with Web Applications and programming languages such as HTML, CSS, JavaScript, JQuery, and APIs.
• 2 Years Preferred: Prior experience creating websites/user interfaces using standard HTML/CSS practices.
• 2 Years Preferred: Functional knowledge or hands-on design experience with Web Services (REST, SOAP, etc.).
• 2 Years Preferred: Experience developing dashboards and reports using Tableau, including connecting to external data sources.
Salary : $60 - $65
