MDM ETL Specialist / Developer

MDM ETL Specialist / Developer

100% Remote (U.S.)

Position Summary

We are seeking an experienced MDM ETL Specialist / Developer to provide technical development, hands-on delivery, and support for Master Data Management (MDM) services supporting a large-scale Health and Human Services data modernization initiative. This role will focus on Informatica MDM, Informatica PowerCenter, data integration, data quality, data governance, and analytics capabilities that support a unified cross-agency client/member view across multiple programs.

The selected candidate will develop and support MDM technical solutions, collaborate closely with the MDM Technical Lead and project team members, support Informatica workflows and data loads, develop and optimize SQL and Python-based automation, troubleshoot production issues, support QA/testing activities, and help maintain reliable MDM operations.

MDM Services Overview

• Support a statewide MDM initiative by integrating data from multiple agency and program sources.
• Create a holistic view of individuals served across programs to improve efficiency and service delivery.
• Provide advanced analytics, data quality analysis, business/data analysis, and MDM expertise.
• Develop custom dashboards and reporting solutions using enterprise data assets.
• Utilize Informatica MDM and related integration tools to support data processing, quality, and downstream system requirements.
• Support data quality strategies and governance initiatives.
• Maintain high levels of data integrity through standardized processes and continuous evaluation.
• Collaborate with stakeholders and partners to improve and validate data quality and consistency.
• Support business analysis and data-driven decision-making using industry best practices.
• Conduct data analysis to support policy development and program evaluation efforts.
• Identify opportunities where data insights can improve outcomes, operational efficiency, and cost savings.

Key Responsibilities

• Utilize Informatica MDM to integrate and transform data from multiple source systems.
• Apply data corrections, enhancements, and change requests within MDM processes.
• Support MDM development and operational activities.
• Automate data staging processes through scheduling and scripting.
• Develop mappings, mapplets, sessions, and workflows within Informatica.
• Work extensively with ETL transformations including:
• Aggregator
• Expression
• Filter
• Router
• Sequence Generator
• Update Strategy
• Joiner
• Rank
• Source Qualifier
• Lookup
• Sorter
• Schedule and monitor ETL/Informatica jobs across development, testing, and production environments.
• Troubleshoot production support issues and implement solutions.
• Develop, maintain, and optimize complex SQL queries and scripts for enterprise data environments.
• Partner with QA teams to support defect resolution, testing, and validation.
• Participate in technical discussions and recommend alternative solutions when needed.
• Support unit testing, integration testing, and system testing efforts.

Required Qualifications

• 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development.
• 3+ years of hands-on Informatica MDM implementation experience.
• Experience developing ETL mappings, mapplets, sessions, workflows, transformations, job scheduling, monitoring, and troubleshooting.
• Strong SQL experience working with large-scale enterprise relational database platforms.
• Experience with:
• Data Quality
• Matching & Survivorship
• Unique Client/Member Identification
• Data Standardization
• Data Reconciliation
• Data Governance
• Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC processes.
• Python experience 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 with additional MDM platforms, including cloud-native MDM solutions.
• Experience working within government, public-sector, healthcare, or other regulated environments.
• Experience with Agile/Scrum methodologies.
• Experience supporting:
• Healthcare Data
• Medicaid Programs
• Claims Data
• Eligibility Systems
• Provider Data
• Health & Human Services Programs
• Exposure to interoperability standards and technologies including:
• X12
• EDI
• XML
• JSON
• APIs
• HL7/FHIR
• Experience with cloud and data modernization technologies such as:
• Microsoft Azure
• Azure Data Factory (ADF)
• Databricks
• Snowflake
• Data Lake technologies
• Experience with EDW, ETL, or MDM modernization initiatives.
• Exposure to AI/ML, GenAI, or LLM-assisted development, testing, documentation, profiling, or data quality initiatives.
• Ability to work effectively within a remote and matrixed organization with minimal supervision.

Location & Work Model

• 100% Remote
• Candidates must reside within the continental United States.
• Central U.S. or Midwest location preferred.
• Occasional travel may be required based on project needs.