Informatica MDM - 21 Aug (Friday)-5+ Years Virtual Interview

Tata Consultancy Services; New Delhi, Pune District, Bengaluru; On-site; INR 2,000,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services seeks an Informatica MDM Developer (Product 360) to design, develop, and support product master data solutions using IDMC Product 360. The role emphasizes data modeling, match & merge, survivorship, and hierarchy management to deliver accurate, governed Golden Records.

You will implement product classifications, SKU-based concepts, and integrate with ERP, PIM, and eCommerce systems while maintaining data quality and lineage across the product domain.

Qualifications

• 48+ years of experience in MDM implementations.
• Hands-on experience with Informatica MDM.
• 2+ years experience with IDMC Product 360.
• Expertise in: Product data modeling
• Match & Merge
• Survivorship
• Hierarchy management
• Strong SQL knowledge
• Understanding of Product master data concepts (SKU, variants, attributes)
• Configure and customize IDMC Product 360 for product master data management
• Develop and manage: Product Business Entities, Attributes and attribute groups & Reference data and lookup tables
• Implement product classifications, categories, and hierarchies
• Configure product relationships
• Design logical and physical Product data models
• Define mandatory, optional, and conditional attributes
• Handle multilevel product hierarchies and variants
• Ensure alignment with downstream systems (ERP, PIM, eCommerce)
• Configure Match Models and Match Rules for product deduplication
• Implement exact and fuzzy matching for product identifiers

Responsibilities

• Design and develop master data solutions for product domains.
• Support data governance and scalable Product Golden Records.
• Implement product classifications, hierarchies, and relationships.
• Configure and customize IDMC Product 360 for product master data management.
• Ensure alignment with downstream systems (ERP, PIM, eCommerce).

Skills

MDM implementations

Informatica MDM

IDMC Product 360

Product data modeling

Match & Merge

Survivorship

Hierarchy management

SQL

Product master data concepts

Product classifications & hierarchies

Product relationships

Logical data modeling

Physical data modeling

Tools

Informatica IDMC

SQL tooling

Job description

The Informatica MDM Developer (Product 360) is responsible for designing, developing, and supporting master data solutions for Product domains using Informatica Intelligent Data Management Cloud (IDMC) Product 360.
The role is handson and focuses on data modeling, match & merge, data quality, enrichment, hierarchy management, and integrations, ensuring accurate, governed, and scalable Product Golden Records.

Mandatory Skills

• 48+ years of experience in MDM implementations
• Strong handson experience with Informatica MDM
• 2+ years experience with IDMC Product 360
• Expertise in:
• Product data modeling
• Match & Merge
• Survivorship
• Hierarchy management
• Strong SQL knowledge
• Understanding of Product master data concepts (SKU, variants, attributes)
• Configure and customize IDMC Product 360 for product master data management
• Develop and manage: Product Business Entities, Attributes and attribute groups & Reference data and lookup tables
• Implement product classifications, categories, and hierarchies
• Configure product relationships
• Design logical and physical Product data models
• Define mandatory, optional, and conditional attributes
• Handle multilevel product hierarchies and variants
• Ensure alignment with downstream systems (ERP, PIM, eCommerce)
• Configure Match Models and Match Rules for product deduplication
• Implement exact and fuzzy matching for:

Product name

Manufacturer part number

SKU, UPC, EAN

• Configure merge rules and survivorship logic
• Enable automerge and stewarddriven merge workflows
• Support unmerge and audit requirements
• Configure trust rules at: Source level & Attribute level
• Define survivorship strategies:
• Ensure highquality Golden Product Records