MDM Lead Architect - Remote Data Mastery & Governance

Optum; Chicago (IL); Remote; USD 113,000 - 193,000; Full time

Job summary

Optum is seeking an experienced Master Data Management (MDM) Technical Lead Architect to deliver technical leadership for the HHSi2 project supporting Illinois HHFS. Focus areas include Informatica MDM, PowerCenter, data quality, governance, and data integration to create a unified statewide client view.

You will lead MDM technical delivery, guide ETL specialists, support data loads, optimize SQL/Python automation, and troubleshoot production issues while maintaining reliable MDM operations.

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.

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 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 transformations and corrections.
• Provide project direction and assign work to MDM ETL Specialists.
• Automate the staging of data by scheduling scripts to run at optimal times.
• Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
• Schedule and monitor ETL/Informatica jobs in development, testing, and production environments.

Skills

MDM/Data Integration

Informatica MDM

Informatica PowerCenter

SQL

Python scripting

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica MDM

Informatica PowerCenter

SQL

Python

Teradata

Job description

Optum is seeking an experienced Master Data Management (MDM) Technical Lead Architect to deliver technical leadership for the HHSi2 project supporting Illinois HHFS. Focus areas include Informatica MDM, PowerCenter, data quality, governance, and data integration to create a unified statewide client view.

You will lead MDM technical delivery, guide ETL specialists, support data loads, optimize SQL/Python automation, and troubleshoot production issues while maintaining reliable MDM operations.