Master Data Management (MDM) Developer

MMC Group•Austin, TX

1d•Onsite

About The Position

We are seeking an experienced Senior Master Data Management (MDM) Developer / Systems Analyst III to support a large-scale Enterprise Information Management (EIM) initiative for the Texas Health and Human Services Commission (HHSC). This is an outstanding opportunity for a senior data professional with extensive experience in Informatica MDM, Informatica PowerCenter, SQL, and enterprise data integration. In this role, you will help build and maintain trusted master data solutions that improve reporting, analytics, and strategic decision making across statewide Health and Human Services programs. Working within an Agile environment, you will collaborate with business stakeholders, data engineers, architects, and analytics teams to develop enterprise identity management solutions supporting client and provider data.

Requirements

12+ years of experience with Informatica PowerCenter.
10+ years of experience with Informatica Master Data Management (MDM).
10+ years gathering business requirements and translating complex identity management and operational requirements into enterprise MDM solutions.
8+ years of advanced SQL experience for data identification, profiling, transformation, and analysis.
Experience developing client and provider identity resolution strategies supporting enterprise analytics.
Strong understanding of enterprise data integration, data profiling, and master data management principles.
Excellent communication, presentation, and stakeholder management skills.
Ability to communicate complex technical concepts to both technical and non-technical audiences.

Nice To Haves

Experience with Informatica Intelligent Cloud Services (IICS).
Experience with Business Intelligence and Enterprise Data Warehouse environments.
Experience with Data governance and enterprise data quality initiatives.
Experience in Health and Human Services, healthcare, Medicaid, or other highly regulated industries.
Experience with Enterprise data integration and identity management strategies.
Experience with AI prompt engineering and AI-assisted data management.
Serving as the primary technical resource for enterprise MDM initiatives.
Training and mentoring users on master data management best practices.

Responsibilities

Design, develop, and administer enterprise Master Data Management (MDM) solutions using Informatica technologies.
Collaborate with business users, subject matter experts, and technical teams to understand complex client and provider identity requirements.
Develop identity resolution strategies that support enterprise analytics and integrated reporting.
Gather business requirements and translate them into scalable MDM solutions and technical specifications.
Extract, integrate, profile, and analyze complex member and provider data from multiple enterprise systems.
Build and maintain SQL queries for data profiling, validation, transformation, and identity management.
Partner with analytics teams to develop trusted master data supporting enterprise reporting and decision making.
Support enterprise data governance, data quality, and identity management initiatives.
Validate AI-generated outputs related to master data and help improve AI-assisted data integration processes.
Develop standardized AI prompts and query templates for common data identity and integration use cases.
Create technical documentation, process guides, and training materials to improve enterprise adoption of MDM best practices.
Mentor business users and technical teams on master data concepts, identity management, and data governance.
Collaborate with Data Engineering, Business Intelligence, and IT teams to troubleshoot complex data integration and identity challenges.