What are the responsibilities and job description for the ETL Developer position at innovitusa?
Developing MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
• Developing extract/transform/load processes for HHS system data into MDM applications (using Oracle, Snowflake and Informatica tools).
• Developing, testing, and maintenance of enhancements/upgrades to MDM application layer(s).
• Working closely with EIM data architects, HHS subject matter experts, and HHS system data models to accurately represent as-is and to-be process models involving HHS master data.
• Operational responsibility for metadata loads.
• Planning and monitoring MDM/Metadata project lifecycle deployment using agile methods.
• Ensuring that the build and deployment of the MDM components are of high quality and comply HHSC IT coding and security standards.
Strategic Liaison and Translation
• Work with program areas and project sponsor to plan and execute multiple analytics projects asynchronously.
• Explain project findings and data limitations in simple, non-technical language to agency leadership and program staff.
AI Prompting and Data Synthesis
• Develop and refine effective AI prompts and query strategies to retrieve and synthesize master data for complex data domains.
• Develop a library of standardized prompts and query templates for common reporting needs.
• Provide subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations.
• Ensure all data outputs adhere to agency reporting standards, data governance, and compliance regulations.
• Promote a data-driven culture by enabling and empowering all staff to effectively utilize data and AI.
• Stay up to date on new AI and data analytics tools and techniques to continuously improve program competencies.
Collaboration and Problem-Solving
• Work closely with data engineering, IT, and Program teams to troubleshoot data-related issues and address inconsistencies and mitigation strategies.
• Provide expert guidance to program staff on interpreting data trends and answering complex data questions.
CANDIDATE SKILLS AND QUALIFICATIONS
Years
Required/Preferred
Experience
8
Required
Advanced Informatica and ETL developer skills
8
Required
Experience and understanding of Enterprise Information Management best practices
8
Required
Experience designing and implementing Master Data Management solutions
8
Required
Experience designing and implementing Informatica PowerCenter custom solutions
8
Required
Experience with Erwin and ERStudio data modeling tools or equivalent functional toolsets
8
Required
Strong Communication, analytical and interpersonal skills at all levels
8
Required
Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities
8
Required
Strong technical writing skills
5
Preferred
Some experience as an Oracle DBA desired, but not required
5
Preferred
Experience installing and configuring Informatica Metadata Manager architecture
5
Preferred
Experience architecting Master Data Management solutions
4
Preferred
Bachelor's degree in Computer Science, Systems Engineering or equivalent experience