MDM ETL Expert

CSpring • Springfield, IL

3d

About The Position

CSpring is seeking an MDM ETL Expert to lead the design, delivery, and day-to-day operations of Master Data Management technical solutions. The role involves translating business needs into MDM solutions, applying security-by-design and privacy-by-design principles, and aligning with Chief Information Security Office guidelines. The technical lead will coordinate Informatica MDM and ETL delivery, direct and assign work to MDM ETL Specialists, and work with agency source data to apply transformations, corrections, and change-request updates.

The position implements and operates Informatica workflows across development, system testing, and production environments. It includes scheduling and monitoring jobs, automating data staging, tuning capacity and performance, documenting technical specifications, and resolving production and server or software issues. The role also develops complex SQL queries and scripts for Teradata data marts and may use Python and other tools to support MDM and integration.

The MDM ETL Expert works with Quality Assurance and business teams on validation, defect resolution, and unit, integration, and system testing. The role provides delivery status updates to Optum leadership and State Project Managers. CSpring describes its work as purpose-driven consulting across public and private sectors, with a collaborative, people-first culture and opportunities to contribute to data strategy, engineering, and analytics projects.

Requirements

• 8+ years of experience in MDM, ETL, data integration, and enterprise data platforms.
• 5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter.
• Strong experience developing ETL mappings, mapplets, sessions, workflows, and transformations, and 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 identifiers, 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.

Nice To Haves

• Experience with other MDM tools, including cloud-native MDM solutions.
• Experience developing software or workflows in Python or other open-source tools.
• Experience in State government, the public sector, or regulated environments.
• Experience with Agile/Scrum sprint development and iterative or 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.
• Experience with on-premises-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.
• Ability to operate in a telecommute environment and matrix organization with minimal direction.

Responsibilities

• Own MDM technical solution delivery, reviewing technical documentation and designing solutions that meet business needs.
• Design MDM solutions with security by design and privacy by design, aligned with Chief Information Security Office guidelines.
• Lead or coordinate Informatica Master Data Management and related MDM ETL delivery activities, provide project direction, and assign work to MDM ETL Specialists.
• Use Informatica MDM to combine agency source data, apply required transformations and source-file corrections, and add fields through the change request process.
• Implement MDM jobs by creating mappings, mapplets, sessions, and workflows using ETL transformations.
• Automate data staging by scheduling scripts and schedule and monitor ETL/Informatica jobs in development, system testing, and production environments.
• Develop proactive capacity-monitoring and performance-tuning processes, and document workflows and technical specifications.
• Troubleshoot production support issues after release deployment and coordinate resolution of server or software issues with the State IT department.
• Develop, maintain, and analyze complex SQL queries and scripts for creating Teradata data marts, and use tools such as Python to enhance MDM and data integration.
• Work with Quality Assurance and business teams on validation, defect resolution, and unit, integration, and system testing.
• Provide status updates and meet deliverables for Optum leadership and State Project Managers.

Benefits

• Support, autonomy, and community focused on employee growth.
• Purposeful projects with opportunities to improve systems and deliver measurable impact.
• Strategic, hands-on work across data architecture, documentation, client workshops, and solution delivery.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior