Remote MDM ETL Specialist & Data Engineer

Myticas Consulting Inc.; Springfield (IL); Remote; USD 77,000 - 91,000; Full time

Job summary

Clover Consulting seeks an experienced MDM ETL Specialist/Developer to deliver and support Master Data Management services for the HHSi2 project. You will work under the MDM Technical Lead to implement Informatica MDM workflows, data quality measures, and governance across state agency data interfaces.

The role focuses on data integration, complex SQL, and Python-based automation, with 100% telecommute and occasional travel to Illinois. Strong collaboration with QA and other vendors is 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.

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.

Skills

Informatica MDM

Informatica PowerCenter

SQL

Python

Data governance

Data quality

Education

Bachelor's degree in Computer Science or related

Tools

Teradata

Job description

Clover Consulting seeks an experienced MDM ETL Specialist/Developer to deliver and support Master Data Management services for the HHSi2 project. You will work under the MDM Technical Lead to implement Informatica MDM workflows, data quality measures, and governance across state agency data interfaces.

The role focuses on data integration, complex SQL, and Python-based automation, with 100% telecommute and occasional travel to Illinois. Strong collaboration with QA and other vendors is required.