MDM ETL Expert

Required Qualifications

• 8+ years of experience in MDM, ETL, data integration, enterprise data platforms.

• 5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.

• Strong experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.

• Strong SQL experience, with large MDM and DBMS enterprise relational platforms.

• Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts.

• Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery.

• Experience with Python programming for scripting, automation, testing, or data processing support.

• Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Preferred Qualifications

• Experience working in other MDM tools including Cloud-native MDM solutions.
• Experience developing software or workflows in Python or other open-source tools.
• Experience working in State Government, public sector, or regulated environments.
• Experience with Agile/Scrum Sprint development and iterative/incremental delivery.
• Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.
• Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR.
• Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, Data Lake, or comparable technologies is a plus.
• Experience with on-prem-to-cloud migration, MDM modernization, or EDW / ETL modernization initiatives.
• Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality is a plus.
• Ability to operate in a telecommute environment and matrix organization with minimal direction.