MDM ETL Specialist Developer (36019)

Myticas Consulting Inc.; Illinois; Remote; USD 77,000 - 91,000; Full time

Job summary

Clover Consulting has a direct client in Springfield, IL in need of an MDM ETL Specialist/Developer for a 12+ months contract. The role focuses on Informatica MDM, PowerCenter, data integration and governance to support Illinois HHSi2.

You will work remotely with occasional travel to Illinois; rate $56–$66 per hour on W2/C2C. Relevant experience in MDM/ETL, SQL and Python required; bachelor’s degree preferred.

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 identifiers, standardization, reconciliation, and data governance.

Responsibilities

• Use Informatica MDM to combine source data from agency sources and create data changes.
• Support MDM development and operational activities.
• Automate data staging by scheduling ETL scripts for performance gains.
• Create mappings, mapplets, sessions, and workflows for MDM jobs.
• Work with various ETL transformations and monitor jobs in all environments.
• Troubleshoot post-release production issues and resolve defects.
• Develop and analyze complex SQL queries to create data marts in Teradata.
• Collaborate with QA to validate MDM processes and support testing.
• Participate in design discussions to suggest alternatives or requirements.
• Participate in unit, integration, and system testing.

Skills

Informatica MDM

Informatica PowerCenter

SQL

Data quality

Python

ETL/ELT

Education

Bachelor's degree in CS/IS or equivalent

Tools

Informatica MDM

Teradata

Job description

Clover Consulting has a direct client in Springfield, IL in need of an MDM ETL Specialist/Developer for a 12+ months contract. Job details are below. Thank you!

Role

MDM ETL Specialist/Developer

Location

Remote - occasional travel to Illinois possible

Term

12+ months contract, extensions possible

Rate

$56 W2 - $66 C2C

Seeking an experienced 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 across State programs.

MDM Services Summary

• Partner with the MDM Statewide initiative supporting and combining different agency data sources.
• Integrate State agency data to create a holistic view of the clients that the State serves and to administer all State agency programs more effectively and efficiently.
• Provide advanced analytics, data quality analysis, business/data analysis, and MDM data specialists in support of the Illinois Health and Human Services Incubator (HHSi2) project.
• Partner with the State to develop custom dashboards using data as part of the HHSi2 project.
• Provide technical expertise using Informatica MDM and related integration tools to support MDM data processing, data quality, and downstream system(s) needs.
• Support data quality strategy while allowing for data quality analysis and other data governance activities.
• Maintain data quality by using timely and consistent processes and evaluating data quality with the State.
• Leverage established data governance practices and work with State staff and other vendors/partners to improve and validate data consistency and integrity.
• Provide a structure to support business and data analysis using industry standard practices.
• Data analysis to support policy development and program evaluation.
• Identify opportunities/use-cases that help translate data analysis into cost savings and improved outcomes in programs and service areas

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.

Preferred Qualifications

• Experience working in other MDM tools including Cloud-native MDM solutions.
• 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.

Location & Work Model

• Work Arrangement: 100% telecommute
• Resource must be within the continental U.S. in alignment with project requirements. Central U.S. / Illinois / Midwest location is preferred.
• Occasional travel may be required for client or project needs.