Job Summary (Data Engineer – Informatica PowerCenter, HHSC, State of Texas)
- Project Leadership & Technical Guidance
- Serve as a technical leader within an agile development team, leading projects and mentoring team members.
- Participate in requirements gathering, design sessions, and sprint ceremonies.
- Data Integration & ETL Development
- Develop and automate ETL processes using Informatica PowerCenter/IICS.
- Acquire and integrate data from multiple sources (Oracle, SQL Server, Excel, Access, PDF).
- Design and develop complex SQL scripts (Oracle/Snowflake) for transforming data into dimensional models and creating database views.
- Automation & Programming
- Automate data validation and verification processes.
- Develop scripts and code using Python, Java, JavaScript, and C#.
- Build CI/CD pipelines utilizing GitHub and Git Actions.
- Collaboration & Communication
- Collaborate with architects, other data engineers, and stakeholders to design and implement optimal data solutions.
- Work with customers to develop mockups and validate solutions.
- Produce and maintain technical documentation, specifications, and diagrams.
- System Analysis & Problem Solving
- Analyze user requirements and business processes to identify solutions and improvements.
- Conduct studies and cost/benefit analyses of alternatives.
- Troubleshoot and resolve technical problems related to data integration and system performance.
- Operations & Support
- Provide operational support and enhancements for the data integration hub.
- Assist with the implementation and configuration of development tools.
- Additional Responsibilities
- Ensure compliance with security principles, especially regarding healthcare data (PII/PHI).
- Adhere to best practices in software development, technical writing, and agile methodologies.
- All other duties as assigned.
Key Technologies & Tools:
- Informatica PowerCenter/IICS, Oracle, SQL Server, Snowflake, Tableau
- Python, Java, JavaScript, C#
- JIRA, GitHub, Git Actions, MS Office Suite, Visio, Erwin
- Mulesoft, SAS Viya
Preferred Experience:
- Healthcare industry and HHS agency experience
- Working with PII/PHI data
- Web Services (REST, SOAP)
- Understanding of security principles in healthcare data
Location: Austin, TX (Local candidates preferred)
Contract Type: Long-term contract
Client: Texas Health and Human Services Commission (HHSC)