Lead Informatica MDM Architect

Air InfoSec

Austin, Texas

JOB DETAILS
SKILLS
Architectural Design, Artificial Intelligence (AI), Background Investigation, Cloud Computing, Cross-Functional, Customer/Client Research, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Department of Health and Human Services, Design Document, Enterprise Architecture, Government, Healthcare, Healthcare Quality, Hospital Systems, Informatica, Leadership, Machine Learning, Manufacturing Data Management, Master Data Management (MDM), Medicaid, Metadata, Operational Support, Process Improvement, Project Lifecycle, Project Tracking, Quality Management, Snowflake Schema, Software Administration, Software as a Service (SaaS), Sprint Planning, Stewardship, System Architecture, System Integration (SI), Technical Leadership, Technical Strategy, Technical Writing, Technical/Engineering Design, Test Plan/Schedule
LOCATION
Austin, Texas
POSTED
3 days ago
The Informatica MDM Architect <\/b>serves as a senior -level technical leader within the Texas Health and Human Services (HHSC) Enterprise Data Governance (EDG) Group, supporting the Enterprise Information Management (EIM) initiative. This role is responsible for the strategy, architecture, design, and hands -on implementation of the agency’s Master Data Management (MDM) solution to improve client data quality across multiple healthcare systems and enable unified reporting. The position provides both strategic oversight and technical execution, ensuring alignment between data governance frameworks, enterprise architecture, and operational systems. The architect collaborates with data architects, business stakeholders, and integration teams to deliver high -quality master data solutions across client and provider domains.
<\/div>

<\/div>
⸻
<\/div>

<\/div>
Responsibilities<\/b>
<\/div>
• Define and own the enterprise MDM architecture, including match -merge rules, survivorship, hierarchies, workflows, and data hub design.
<\/div>
• Design, develop, test, and maintain enhancements to MDM application layers and related components.
<\/div>
• Develop and optimize ETL processes to integrate source system data into Informatica MDM applications.
<\/div>
• Perform logical and physical data modeling for MDM databases and related structures.
<\/div>
• Lead modernization and migration efforts from on -premises Informatica MDM to Informatica MDM SaaS/IDMC where applicable.
<\/div>
• Design MDM solutions on cloud platforms (e.g., OCI) and integrate with cloud data warehouse platforms such as Snowflake.
<\/div>
• Manage and monitor the MDM project lifecycle, including sprint planning, task coordination, and deployment oversight.
<\/div>
• Collaborate with enterprise architects, subject matter experts, and integration teams to ensure delivery of accurate and consistent golden records.
<\/div>
• Develop and optimize landing, base, and cross -reference tables to support master data operations.
<\/div>
• Apply AI and machine -learning–based tools to enhance data quality, anomaly detection, duplicate resolution, and metadata enrichment within MDM platforms.
<\/div>

<\/div>
⸻
<\/div><\/span>

Requirements<\/h3>
Minimum Qualifications<\/b>
<\/div>
• 8 years of experience as a Technical Architect leading enterprise -wide data management solution architecture, design, implementation, and operations.
<\/div>
• 8 years of advanced Informatica and ETL development experience, including Informatica PowerCenter.
<\/div>
• 8 years of experience designing and implementing Master Data Management solutions.
<\/div>
• 8 years of experience designing and implementing custom Informatica PowerCenter solutions.
<\/div>
• 8 years of proficiency in SQL and database technologies.
<\/div>
• 8 years of experience configuring MDM on cloud platforms (e.g., OCI) or implementing Informatica IDMC.
<\/div>
• 8 years of experience integrating MDM solutions with cloud data warehouse platforms such as Snowflake.
<\/div>
• 8 years of experience managing MDM and Data Governance deliverables, including strategic roadmaps, frameworks, technical design documents, and data models.
<\/div>
• 8 years of experience facilitating cross -functional discussions and communicating MDM and Data Governance success factors to stakeholders.
<\/div>
• 8 years of demonstrated leadership in complex, large -scale data initiatives.
<\/div>
• 2 years of experience applying AI and machine -learning–based tools to improve data governance, lineage, stewardship workflows, and master data optimization.
<\/div>
• 8 years of Informatica MDM Development – Including Informatica IDMC Cloud Platform.<\/span><\/span>
<\/div>

<\/span><\/div>
⸻
<\/div>

<\/div>
Preferred Qualifications<\/b>
<\/div>
• Experience supporting HHSC TIERS.
<\/div>
• Healthcare industry experience in Medicaid, Government Medical, or Hospital Systems environments.
<\/div>

<\/div>
⸻
<\/div>

<\/div>
Additional Requirements<\/b>
<\/div>
• Criminal background checks and drug screening in accordance with Federal and State law.
<\/div>
• Offers of employment are contingent upon successful completion of required background checks.
<\/div>
Candidates must be available for onsite interviews in Austin, Texas if shortlisted.<\/b>
<\/div>
Must currently reside within 50 miles of the work location in Austin, Texas.
<\/b><\/div>

<\/div>
⸻
<\/div>

<\/div>
Work Location and Schedule<\/b>
<\/b><\/div>

<\/div>
Location: Austin, TX
<\/div>
Schedule: Not specified
<\/div>
Work Arrangement: 100% Onsite<\/b>
<\/b><\/div>

<\/div>
⸻
<\/div><\/span>

About the Company

A

Air InfoSec