Remote Informatica MDM Lead Architect

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

Benefits offered by this job

Comprehensive benefits

Equity stock purchase

401k contribution

Incentives and recognition programs

Job summary

Optum Insight, a part of UnitedHealth Group, seeks an experienced MDM Technical Lead Architect to deliver Informatica MDM/PowerCenter solutions for the HHSi2 project with Illinois HFS. You will guide MDM/ETL teams, optimize data quality, and implement governance across state programs.

The role offers 100% telecommute within the U.S. with occasional in-office requirements for Minneapolis or Washington, DC, about four days per week for certain locations.

Qualifications

• 8+ years of experience in MDM, ETL, data integration and enterprise data platforms.
• 5+ years hands-on MDM experience on any platform.
• 5+ years Python programming for scripting, automation, testing, or data processing.
• Strong SQL experience with large MDM and DBMS environments.
• Experience with data quality, matching, data governance concepts, and SDLC delivery.
• Experience supporting ETL/MDM operations, performance tuning and issue resolution.

Responsibilities

• Own MDM technical solution delivery and design to meet business needs.
• Lead Informatica MDM and related ETL delivery activities.
• Automate data staging and build mappings, mapplets, sessions, workflows.
• Schedule, monitor, and troubleshoot ETL/Informatica jobs across environments.
• Develop and optimize complex SQL queries and data marts (Teradata).
• Provide guidance to development teams and coordinate work for MDM specialists.

Skills

MDM experience

ETL

Python

SQL

Tools

Informatica MDM

Informatica PowerCenter

Teradata

Job description

Optum Insight, a part of UnitedHealth Group, seeks an experienced MDM Technical Lead Architect to deliver Informatica MDM/PowerCenter solutions for the HHSi2 project with Illinois HFS. You will guide MDM/ETL teams, optimize data quality, and implement governance across state programs.

The role offers 100% telecommute within the U.S. with occasional in-office requirements for Minneapolis or Washington, DC, about four days per week for certain locations.