Database Architect

Requirements:

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

Preferred Qualifications/Nice to Have:

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

• Advanced experience with Informatica platform performance tuning.

• Experience with enterprise-scale MDM deployments