Senior MDM Architect — Informatica Data Quality & IDMC

Careers InitiateFirst; Austin, Northern (TX, KY); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Careers InitiateFirst is seeking an experienced MDM Developer to design and implement Informatica MDM Cloud solutions across development, test, QA, and production environments. You will configure match/merge logic, survivorship and trust rules, and manage data ingestion and integration jobs.

You will collaborate with stakeholders to define data requirements, ensure secure data flows, and perform Informatica administration tasks.

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 related field.

Responsibilities

• Design and develop projects/models within Informatica MDM Cloud for Development, Test, QA, and Production environments.
• 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 specifications.
• Oversee post-MDM development transition and training for ERS employees.

Skills

Informatica MDM

ETL/ELT workflows

SQL

Snowflake

DBT

Data modeling

Data quality

Education

Bachelor’s degree in Information Systems

Master’s degree in Information Systems

Tools

Snowflake

SQL

DBT

Job description

Careers InitiateFirst is seeking an experienced MDM Developer to design and implement Informatica MDM Cloud solutions across development, test, QA, and production environments. You will configure match/merge logic, survivorship and trust rules, and manage data ingestion and integration jobs.

You will collaborate with stakeholders to define data requirements, ensure secure data flows, and perform Informatica administration tasks.