MDM ETL Specialist / Developer
Core
Design, build, and maintain Master Data Management (MDM) solutions and ETL pipelines using Informatica to integrate agency data, ensure data quality, and support public-sector decision-making.
Role type
Senior MDM ETL Developer
Builds
MDM repositories, ETL mappings, data marts, and automated data integration workflows for public and private sector clients.
Domain
Public sector data management, healthcare interoperability, and enterprise data engineering.
Required skills
Informatica MDM, ETL/ELT development, SQL, Python scripting, data quality and governance, Teradata, Agile/Scrum
Preferred skills
Cloud-native MDM tools, healthcare data (Medicaid/claims), interoperability formats (X12/HL7), cloud platforms (Azure/Databricks/Snowflake), AI/LLM engineering
Technologies
Informatica, Azure, Databricks, Snowflake, Python, SQL, Teradata, XML, JSON, HL7, FHIR, DevOps
Responsibilities
Create Informatica mappings, mapplets, sessions, and workflows; develop complex SQL queries for Teradata; automate data staging and scheduling; troubleshoot production issues; support validation and testing of MDM processes.
Seniority
Senior, hands-on IC