MDM ETL Developer - W2

MSR Technology Group; Illinois; On-site; USD 110,000 - 150,000; Full time

Job summary

MSR Technology Group is seeking an MDM ETL Specialist / Developer to design, implement, and support Master Data Management solutions. The role emphasizes Informatica MDM, PowerCenter, data integration, and governance to deliver a unified client view.

You will develop and optimize SQL and Python automation, support QA/testing, and ensure reliable MDM operations while collaborating with the MDM Technical Lead and QA teams.

Qualifications

• 5+ years in MDM, ETL/ELT, data engineering or data integration.
• 3+ years hands-on Informatica MDM implementation.
• Experience with SQL, data quality, governance concepts.

Responsibilities

• Develop and support MDM technical solutions.
• Automate MDM jobs with mappings, mapplets, sessions and workflows.
• Troubleshoot production issues and support QA/testing.
• Collaborate with QA and project discussions.

Skills

MDM/ETL

Data Integration

SQL

Python

Data Governance

SDLC

ETL Workflows

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Informatica MDM

Informatica PowerCenter

Teradata

Job description

MDM ETL Specialist / Developer to provide technical development and hands‑on delivery and support for Master Data Management services supporting the Health and Human Services Innovation Incubator project. This role will focus on Informatica MDM, Informatica PowerCenter, data integration, data quality, data governance, and analysis capabilities that support a unified cross-agency client/member view.

The selected candidate will develop and support MDM technical solutions, work under the guidance of the MDM Technical Lead, collaborate with other team members, support Informatica workflows and data loads, develop and optimize SQL and Python-enabled automation where appropriate, troubleshoot production issues, support QA/testing, and help maintain reliable MDM operations.

Key Responsibilities

• Use Informatica MDM tool to combine source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
• Working knowledge of Informatica MDM and ability to support MDM development and operational activities.
• Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
• Implementing MDM jobs by creating mappings, mapplets, sessions, and workflows.
• Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
• Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment.
• Troubleshoot post-release production support issues and develop solutions.
• Developing, maintaining, and analyzing complex SQL queries and scripts used to create data marts in Teradata.
• Work directly with the QA team to support defect resolution, validation, and testing of MDM-related processes.
• Participating in project discussions to document and recommend alternative technical solutions or requirements.
• Participating in unit, integration, and system testing.

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, scheduling, monitoring, and troubleshooting Informatica jobs.
• 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.

","IsExpired":false}