MDM ETL Expert / Technical Lead

RCR Technology Group; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

RCR Technology Corporation seeks an experienced MDM ETL Expert / Technical Lead to provide technical leadership and hands-on delivery for Master Data Management services supporting the HHSi2 project for the Illinois Department of Healthcare and Family Services. The role focuses on Informatica MDM, PowerCenter, data integration, data quality, and governance to support a unified statewide MDM view.

You will lead MDM technical delivery, guide MDM/ETL specialists, support workflows, optimize

Qualifications

• 8+ years of experience in MDM, ETL, data integration, enterprise data platforms.
• 5+ years of hands-on Informatica MDM and Informatica PowerCenter experience.
• Strong experience developing ETL mappings, mapplets, sessions, workflows, and troubleshooting Informatica jobs.
• Strong SQL experience with large MDM and DBMS enterprise relational platforms.
• Experience with data quality, matching, unique client identifiers, standardization, reconciliation, and data governance concepts.
• Experience with Python programming for scripting, automation, testing, or data processing support.

Responsibilities

• Own MDM technical solution delivery and design MDM solutions to meet business needs.
• Lead Informatica MDM and related ETL delivery activities.
• Automate data staging by scheduling scripts to improve performance.
• Develop MDM jobs by creating mappings, mapplets, sessions, and workflows.
• Schedule and monitor ETL/Informatica jobs across dev, test, and production environments.
• Troubleshoot production issues and provide guidance to development teams.

Skills

MDM / ETL experience

Informatica MDM

Informatica PowerCenter

SQL

Python scripting

Data governance concepts

Data quality

Education

Bachelor’s degree in CS / Data Analytics / IS / Engineering

Job description

For over twenty-seven years RCR Technology Corporation has delivered the highest quality services to our clients with an expansive portfolio of industry-relevant services, and deep technical capabilities around data management and application development.

We are seeking an experienced MDM ETL Expert / Technical Lead to provide technical leadership and hands-on delivery for Master Data Management services supporting the Health and Human Services Innovation Incubator (HHSi2) project led by the Illinois Department of Healthcare and Family Services (HFS). 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, as well as individual statewide MDM use cases.

The selected candidate will lead MDM technical delivery, guide MDM/ETL specialists and developers, 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

• · Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs.
• · Design MDM solution with security by design and privacy by design and align with the Chief Information Security Office (CISO) guidelines.
• · Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities.
• · 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.
• · Provide project direction and assign work to MDM ETL Specialists.
• · Ability to provide expertise and guidance with MDM and the Informatica MDM tool.
• · Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
• · Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
• · Work with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
• · Schedule and monitoring ETL/Informatica jobs in development, system testing, and production environment.
• · Document workflows and technical specifications.
• · Develop proactive processes for monitoring capacity and performance tuning.
• · Support and advise the development teams on technical issues.
• · Troubleshoot production support issues post-release deployment and produce solutions.
• · Troubleshoot server or software issues in coordination with State IT department
• · Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata.
• · Work directly with the Quality Assurance and business team to support validation, defect resolution, and testing of MDM-related data processes.
• · Participate in project discussions to document and recommend alternative technical solutions or requirements.
• · Participate in unit, integration, and system testing.
• · Maintain effective communication and relationships with all individuals involved with the project.
• · Learn new technologies as needed to be able to perform job duties effectively.
• · Provide status updates and meet deliverables to Optum's leadership and the State Project Managers.
• · Use other software tools such as Python as necessary to enhance MDM and data integration.

Requirements

Required Qualifications

• · 8+ years of experience in MDM, ETL, data integration, enterprise data platforms.
• · 5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.
• · Strong experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
• · Strong 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 developing software or workflows in Python or other open-source tools.
• · 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.