ETL Specialist

MDM ETL Specialist / Developer

Work Location & Model

Work Arrangement: 100% Remote

Location Requirements:

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

Travel:

• Occasional travel may be required based on project needs.

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

Informatica MDM & ETL Development

• 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
• Update Strategy
• Joiner
• Rank
• Source Qualifier
• Lookup
• Sorter
• Schedule and monitor ETL/Informatica jobs across:
• Development
• Testing
• Production environments
• 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:
• Resolve defects
• Support validation efforts
• Test MDM processes
• Participate in:
• 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 Engineering
• Data Integration Development

Informatica Expertise

• 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
• Record Standardization
• Unique Client/Member Identifier Management
• Data Reconciliation
• Data Governance

Operations & Delivery

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

Education

Bachelor’s Degree in:

• Computer Science
• Information Systems
• Data Analytics
• Engineering
• 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
• Healthcare
• Medicaid
• Claims Data
• Eligibility Data
• Provider Data
• Health & Human Services Programs

Agile Delivery

• Agile/Scrum experience
• Sprint-based development experience
• Iterative and incremental delivery methodologies

Integration Technologies

Experience or exposure to:

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

Cloud & Modern Data Platforms

Experience with:

• Azure
• Azure Data Factory (ADF)
• Databricks
• Snowflake
• Data Lakes
• Cloud Data Platforms

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)
• LLM-Assisted Engineering
• 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:

✅ Hands-on Informatica MDM experience

✅ Strong Informatica PowerCenter and ETL development expertise

✅ Advanced SQL skills

✅ Python scripting and automation experience

✅ MDM data quality and governance knowledge

✅ Production support and troubleshooting experience

✅ Healthcare, Medicaid, or Public Sector experience

✅ Cloud platform exposure (Azure, Databricks, Snowflake, ADF)

✅ Strong SDLC, testing, and Agile delivery experience