Informatica MDM Consultant

Job SummaryWe are seeking an experienced Informatica MDM Developer with expertise in Informatica Multidomain MDM, Python, Snowflake, and Azure Data Factory (ADF). The ideal candidate will be responsible for designing, developing, and supporting Master Data Management solutions while integrating data from multiple enterprise systems to ensure high-quality, governed master data.Required Skills

• Informatica Multidomain MDM (10.x)
• Informatica Data Quality (IDQ)
• Informatica PowerCenter (preferred)
• Python
• Snowflake
• Azure Data Factory (ADF)
• SQL and Database Concepts
• REST APIs
• Git/Azure DevOps
• Azure Cloud

Roles & Responsibilities

• Design, develop, and maintain Informatica MDM solutions.
• Configure data models, match-merge rules, survivorship, hierarchies, and workflows.
• Develop and support inbound and outbound integrations between MDM and enterprise applications.
• Build data pipelines using Azure Data Factory for loading and transforming master data.
• Develop Python scripts for automation, data validation, and API integrations.
• Create and optimize Snowflake objects including tables, views, stored procedures, and tasks.
• Implement data quality rules using Informatica Data Quality (IDQ).
• Perform root cause analysis and resolve production issues.
• Collaborate with business users, data stewards, architects, and application teams.
• Participate in code reviews, unit testing, and deployment activities.
• Ensure adherence to data governance, security, and best practices.

Technical SkillsMust Have

• 4+ years of Informatica MDM experience
• Strong experience with Informatica Multidomain MDM
• Python development
• Snowflake SQL development
• Azure Data Factory (ADF)
• SQL
• Data Modeling
• REST API integration

Good to Have

• Informatica Data Quality (IDQ)
• Informatica PowerCenter
• Azure Data Lake Storage (ADLS)
• Azure Functions
• Azure DevOps
• CI/CD pipelines
• Master Data Governance concepts
• Agile/Scrum methodology

Responsibilities

• Configure Business Entities, Base Objects, Landing Tables, Crosswalks, and Hierarchies.
• Configure Match and Merge rules.
• Configure Trust and Survivorship rules.
• Develop Batch Jobs and Workflows.
• Build data ingestion pipelines in Azure Data Factory.
• Develop Python utilities for data processing.
• Implement Snowflake-based transformations and performance tuning.
• Support production deployments and incident resolution.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 510 years of IT experience.
• Minimum 4 years of Informatica MDM implementation experience.
• Experience working with Azure Cloud and Snowflake.
• Strong analytical and problem-solving skills.

Mandatory Skills

• Informatica MDM
• Python
• Snowflake
• Azure Data Factory (ADF)
• SQL

Preferred Skills

• Informatica IDQ
• PowerCenter
• Azure
• Azure DevOps
• REST APIs
• Git