Haystack
← Back to Jobs
Other

MDM Database Architect 3 With Texas State client experience

Care IT Services IncAustin, TX🇺🇸United StatesPosted 21 Jul 2026

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

GENERAL DESCRIPTION:
The MDM Developer will design, develop, and implement solutions on the Informatica MDM Cloud
platform to support ERS’s enterprise data strategy. This role will focus on building out models,
workflows, and integrations to ensure accurate, consistent, and accessible master data. The position
requires expertise in configuring Informatica MDM, implementing match/merge logic, defining
survivorship and trust rules, and optimizing platform performance. The MDM Developer will work
closely with business and technical stakeholders to translate requirements into robust, maintainable
solutions.
FUNCTIONAL RESPONSIBILITIES
Essential Functions include, but are not limited to:
• Design and develop projects/models within Informatica MDM Cloud for multiple environments
(Development, Test, QA, Production).
• Configure match/merge logic, survivorship rules, and trust/validation rules for master data.
• Build and maintain data ingestion and integration jobs for the MDM platform.
• Collaborate with stakeholders to gather data requirements and resolve technical challenges.
• Ensure secure, reliable data flows between internal systems and third-party applications.
• Perform Informatica administration tasks, including user management, monitoring, and
troubleshooting.
• Partner with architects to refine MDM architecture for performance and scalability.
• Develop and maintain Informatica Data Quality Components per design and functional
specifications.
• Responsible for post MDM development transition and training ERS employees on maintaining
Informatica IDMC.
WORKER SKILLS AND QUALIFICATION

Section

Skills and Qualifications

Required Minimum Qualifications

• 7+ years of experience as an MDM Developer, including configuring and deploying Informatica MDM.

 

• Strong database design and management skills (Snowflake, SQL, DBT).

 

• Experience with relational and dimensional data modeling.

 

• Proven experience implementing ETL/ELT workflows.

 

• Bachelor’s degree in Information Systems or a related field.

Preferred Qualifications / Nice to Have

• Master’s degree in Information Systems or a related field.

 

• Advanced experience with Informatica platform performance tuning.

 

• Experience with enterprise-scale MDM deployments.

Skills

SQL
ETL
Snowflake
dbt

Similar jobs