Informatica MDM Consultant

Role: Senior Data Engineer Master Data Management (MDM)

Experience: 6–10 years
Location: Andheri East, Mumbai
Technology Stack: Python, Snowflake, Azure Data Factory,Informatica mdm
Business Function: Data & Analytics / Digital & IT

Role Purpose

The Senior Data Engineer – MDM will be responsible for designing, building, and supporting enterprisescale Master Data Management solutions for SaintGobain’s global data platform. The role focuses on ensuring consistency, quality, and governance of master data across domains such as Customer, Product, Supplier, and Materials.

Key Responsibilities

• Design and implement MDMcentric data pipelines aligned with SaintGobain’s global data architecture
• Develop and manage data ingestion and orchestration workflows using Azure Data Factory
• Implement data transformation, standardization, validation, and matching logic using Python
• Design and manage Snowflake data models supporting master data and golden record creation
• Apply data quality checks, survivorship rules, deduplication, and reconciliation mechanisms
• Collaborate with business and functional teams to understand master data definitions, hierarchies, and rules
• Support data governance and compliance requirements, including metadata, lineage, and audit controls
• Optimize performance and reliability of data pipelines and MDM processes
• Provide production support, troubleshooting, and continuous improvement

Mandatory Skills & Experience

• Strong experience in Master Data Management concepts, including: 
• Golden record management
• Match & merge logic
• Survivorship and hierarchy management
• Data quality frameworks
• Handson experience with Python for data processing and rule implementation
• Strong expertise in Snowflake, including: 
• Advanced SQL
• Data modeling and optimization
• Handling enterprisescale datasets
• Handson experience with Azure Data Factory
• Pipeline design and orchestration
• Parameterization and monitoring
• Solid understanding of ETL / ELT design patterns and cloud data architectures
• Experience working in large, global enterprise environments

Preferred / Good to Have

• Exposure to commercial MDM platforms (Informatica, Reltio, Semarchy, Profisee, etc.)
• Experience with data governance tools (Microsoft Purview or equivalent)
• Familiarity with manufacturing, supply chain, or p
• roduct master data
• Understanding of Medallion Architecture (Bronze / Silver / Gold)
• Experience with BI or analytics consumption (Power BI or similar)

Soft Skills & Working Style

• Strong analytical and problemsolving abilities
• Ability to work with global stakeholders and crossfunctional teams
• Clear communication and documentation skills
• Experience working in structured delivery and governance models