ETL Informatica Developer with IICS

• Implementation and configuration of the infrastructure for the data integration hub
• Design, development, and implementation (DD&I) of the data integration hub using an agile methodology for all standard SDLC phases that includes, but is not limited to:
• Validation of performance metric requirements
• Creation of Epics/User Stories/Tasks
• Automation of data acquisition from a variety of data sources
• Development of complex SQL scripts
• Testing - integration, load and stress
• Deployment/publication internally and externally
• Operations support and enhancement of the data integration hub

This development effort will utilize an agile methodology based on the approach currently in use at HHSC for the Texas Integrated Eligibility Redesign System (TIERS).

Responsibilities Include:

• Filling the role of a technical leader, leading an agile development team through a project
• Data acquisition from a variety of data sources for multiple uses
• Developing complex SQL scripts to transform source data into a dimensional model
• Creating views and materialized views in Oracle
• Developing automation with Informatica Power Center/IICS to pull and transform external data
• Collaborating on the optimal data design with the Data Engineering Team
• Verification/validation of SQL scripts, Informatica automation, and database views
• Developing automated verification and validation methods
• Participating in all sprint ceremonies
• Working closely with Architects and Data Engineering Team on implementation designs
• Developing mockups and validating with customers
• Resolving technical issues collaboratively
• Assisting with implementation and configuration of development tools
• Producing and maintaining technical documentation, diagrams, and specifications
• Participating in requirements/design sessions
• Interpreting new/changing business requirements and proposing enhancements
• Performing other duties as assigned

YearsRequired/PreferredExperience8RequiredExperience developing mappings and workflows to automate ETL processes using Informatica Power Center or IICS8RequiredExperience acquiring and integrating data from multiple data sources/technologies using Informatica Power Center or IICS for use by a Tableau data visualization object. Data source techs should include Oracle, SQL Server, Excel, Access, and Adobe PDF8RequiredExperience designing and developing complex Oracle and/or Snowflake SQL scripts that are fast and efficient8RequiredStrong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project8RequiredTechnical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project8RequiredExperience in planning and delivering software platforms used across multiple products and organizational units8RequiredProven ability to write well designed, testable, efficient code by using best software development practices6PreferredExcellent oral and written communication skills6PreferredEffectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required4PreferredExperience on an agile sprint team4PreferredUnderstanding of security principles and how they apply to healthcare data4PreferredExperience with state-of-the-art software components for a performance metrics data visualization or business intelligence environment4PreferredBachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience4PreferredPrior experience in the Healthcare Industry4PreferredPrior experience with an HHS agency4PreferredPrior experience working with PII or PHI data4PreferredExperience designing and developing scripts using Python4PreferredExperience with JIRA software2PreferredFunctional knowledge or hands-on design experience with Web Services (REST, SOAP, etc.)2PreferredExperience designing and developing code using Java and JavaScript2PreferredExperience developing CI/CD pipelines with GitHub and Git Actions2PreferredExperience as a Mulesoft developer2PreferredExperience developing code in C#