MDM ETL Specialist / Developer

MSR Technology Group; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

MSR Technology Group is seeking an experienced MDM ETL Specialist/Developer to design and deliver Master Data Management solutions, focusing on Informatica MDM, PowerCenter, data integration, quality and governance to support a unified health services view across multiple programs.

You will collaborate with the MDM Technical Lead, support workflows, automate SQL and Python scripts, troubleshoot production issues, and help maintain reliable MDM operations across programs.

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, and Data Governance.
• Python for scripting, automation, testing, or data processing.
• Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Responsibilities

• Develop and support MDM technical solutions and data loads.
• Automate data staging processes and schedule jobs.
• Develop mappings, sessions, and workflows within Informatica.
• Troubleshoot production issues and support QA/testing.
• Partner with QA to support testing and validation.
• Support unit/integration/system testing.

Skills

Informatica MDM

ETL/ELT

SQL

Python scripting

Data governance

Data quality

Data integration

Data analytics

Education

Bachelor's degree in Computer Science, Data Analytics, Information Systems, Engineering

Tools

Informatica PowerCenter

ETL tooling

Job description

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
• Joiner
• Rank
• Source Qualifier
• Lookup
• 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
• 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:
• 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:
• 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.