ETL Specialist

MSR Technology Group; Chicago (IL); On-site; USD 120,000 - 150,000; Full time

Job summary

MSR Technology Group seeks an experienced MDM ETL Specialist / Developer to deliver hands-on development and support for Master Data Management services across a Health and Human Services initiative. You will focus on Informatica MDM, PowerCenter, data integration, ETL development, data quality, governance, and analytics to create a unified client view across State programs.

The role involves building and maintaining Informatica workflows, developing and optimizing SQL queries, leveraging Python

Qualifications

• 5+ years in Master Data Management (MDM), ETL/ELT development, and data integration.
• 3+ years hands-on with Informatica MDM including mappings, mapplets, sessions and workflows.
• Strong SQL in large enterprise databases and Python automation for data processing.

Responsibilities

• Develop, support, and optimize MDM solutions and related data integration processes.
• Build and maintain Informatica workflows, mappings, mapplets, sessions, and schedules.
• Develop and optimize complex SQL queries and ETL processes.
• Automate data staging activities with Python; troubleshoot production issues.
• Collaborate with QA, analysts, and stakeholders; ensure data quality and governance.

Skills

MDM

ETL Development

SQL

Informatica MDM

Python

Education

Bachelor’s degree in CS/IS/Data Analytics

Tools

Informatica PowerCenter

Informatica MDM

Job description

• Must reside within the Continental United States.
• Candidates located in the Central U.S., Illinois, or Midwest region are preferred.

Travel:

Position Summary

We are seeking an experienced MDM ETL Specialist / Developer to provide hands-on technical development, support, and delivery for Master Data Management (MDM) services supporting a large-scale Health and Human Services innovation initiative.

This role focuses on Informatica MDM, Informatica PowerCenter, data integration, ETL development, data quality, data governance, and analytics supporting a unified cross-agency client/member view across State programs.

The selected candidate will work under the guidance of the MDM Technical Lead to:

• Develop and support MDM technical solutions
• Build and maintain Informatica workflows and data loads
• Develop and optimize SQL queries and ETL processes
• Leverage Python automation where appropriate
• Troubleshoot production issues
• Support QA, testing, and validation activities
• Ensure stable and reliable MDM operations

Program Overview

The MDM team supports a statewide initiative designed to:

• Integrate data from multiple State agencies to create a unified client/member view.
• Improve service delivery across State programs through consolidated and trusted data.
• Support advanced analytics, reporting, and business intelligence initiatives.
• Develop custom dashboards and reporting solutions.
• Leverage Informatica MDM and related integration technologies.
• Support enterprise-wide data quality and governance initiatives.
• Improve consistency, integrity, and stewardship of critical enterprise data.
• Enable policy development and program evaluation through trusted data assets.
• Identify opportunities to improve operational efficiency and program outcomes through data-driven insights.

Key Responsibilities

• Utilize Informatica MDM to combine and transform data from multiple source systems.
• Apply data transformations, corrections, and enhancement requests through established change management processes.
• Develop, maintain, and support MDM solutions and operational processes.
• Create and maintain Informatica:
  • Mappings
  • Mapplets
  • Sessions
  • Workflows
• Implement and support MDM jobs and data integration processes.

ETL Design & Support

• Work with ETL transformations including:
  • Aggregator
  • Expression
  • Filter
  • Router
  • Sequence Generator
  • Joiner
  • Rank
  • Source Qualifier
  • Lookup
• Schedule and monitor ETL/Informatica jobs across:
  • Development
  • Testing
• Automate data staging activities through scripting and scheduling.

SQL Development

• Develop, maintain, and optimize complex SQL queries and scripts.
• Support data marts and enterprise data solutions in large-scale relational database environments.
• Perform data validation, reconciliation, and troubleshooting activities.

Production Support

• Troubleshoot and resolve post-release production issues.
• Perform root cause analysis and implement corrective actions.
• Support operational stability and performance tuning activities.

Testing & Quality Assurance

• Collaborate with QA teams to:
  • Test MDM processes
  • Unit Testing
  • Integration Testing
  • System Testing

Technical Collaboration

• Participate in project discussions and architecture reviews.
• Document technical solutions and recommend alternative approaches when appropriate.
• Work closely with technical leads, analysts, developers, QA teams, and business stakeholders.

Required Qualifications

Experience

• 5+ years of experience in:
  • Master Data Management (MDM)
  • ETL/ELT Development
  • Data Integration Development
• 3+ years of hands-on experience implementing and supporting Informatica MDM.
• Strong experience with Informatica:
  • Mappings
  • Mapplets
  • Sessions
  • Workflows
  • Scheduling
  • Monitoring
  • Job Troubleshooting

Technical Skills

• Strong SQL experience in large enterprise database environments.
• Experience working with large MDM platforms and relational database systems.
• Python experience for:
  • Automation
  • Scripting
  • Testing
  • Data processing support

Data Management Experience

• Data Quality
• Data Matching
• Data Governance

Operations & Delivery

• Experience supporting:
  • MDM Operations
  • Performance Tuning
  • Production Support
  • SDLC Delivery

Education

Bachelor's Degree in:

• Computer Science
• Information Systems
• Data Analytics
• Or equivalent professional experience

Preferred Qualifications

MDM & Data Management

• Experience with additional MDM platforms and cloud-native MDM solutions.
• Experience supporting MDM modernization initiatives.

Industry Experience

Experience supporting:

• State Government
• Public Sector Organizations
• Regulated Environments
• Medicaid
• Claims Data
• Eligibility Data
• Provider Data
• Health & Human Services Programs

Agile Delivery

• Sprint-based development experience
• Iterative and incremental delivery methodologies

Integration Technologies

Experience or exposure to:

• X12
• EDI
• XML
• JSON
• REST APIs
• HL7/FHIR

Experience with:

• Databricks
• Snowflake
• Data Lakes

Modernization Initiatives

Experience supporting:

• On-Premises to Cloud Migrations
• MDM Modernization Programs
• EDW Modernization
• ETL Modernization Projects

Emerging Technologies

Exposure to:

• AI/ML
• Generative AI (GenAI)
• Test Automation
• Data Quality Automation

Additional Skills

• Ability to work independently in a remote and matrixed environment.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration abilities.

Ideal Candidate Profile

The ideal candidate will possess:

• Strong Informatica PowerCenter and ETL development expertise
• Python scripting and automation experience
• MDM data quality and governance knowledge
• Production support and troubleshooting experience
• Healthcare, Medicaid, or Public Sector experience
• Strong SDLC, testing, and Agile delivery experience