Consultant | Informatica MDM | Bengaluru | Engineering

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft seeks an experienced MDM specialist to design, implement, and govern enterprise master data management solutions using Informatica MDM, IDMC, and IDQ.

You will drive end-to-end MDM lifecycle, build golden records, manage data models, and coordinate integration with ERP/CRM systems while ensuring data quality and governance across on-prem, cloud, or hybrid deployments.

Qualifications

• Must have hands-on experience delivering end-to-end MDM implementations.
• Experience with multi-domain master data in Customer, Product or Vendor areas.
• Ability to design scalable MDM architectures (On-Prem, Cloud or Hybrid).
• Strong data modeling, profiling, and data governance knowledge.
• Proficiency in building match/merge rules and golden records.

Responsibilities

• Lead end-to-end MDM lifecycle from requirements to deployment.
• Design and implement data models, hierarchies, and golden records.
• Configure and optimize match, survivorship, and data quality rules.
• Develop integration pipelines and APIs for ERP/CRM systems.
• Collaborate on data governance and stewardship with stakeholders.

Skills

Informatica MDM (Hub, ORS, SIF, Match&

Education

Bachelor's or Master's in Computer Science/Engineering

Tools

Informatica IDMC / Cloud MDM

Informatica Data Quality (IDQ)

Informatica BDM (Big Data Management)

PowerCenter / IICS

Reltio / Semarchy MDm tools

Job description

The team

Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.

Required skill :

• End-to-End MDM Solution Delivery:Design, develop, and implement end-to-end Master Data Management solutions using Informatica MDM (Multidomain) and Informatica Intelligent Data Management Cloud (IDMC).
• Drive MDM lifecycle implementation from requirements gathering to deployment and support.
• Build and manage Customer, Product, and Vendor master domains.
• MDM Architecture:Define and implement scalable MDM architectures (On-Prem, Cloud, or Hybrid).
• Design integration architecture involving MDM, upstream (ERP/CRM), and downstream consuming systems.Ensure alignment with enterprise data strategy and governance frameworks.
• Data Modeling:Develop conceptual, logical, and physical data models for master data entities.
• Define entity relationships, hierarchies, cross-reference models, and golden record structures.
• Implement flexible data models supporting multiple domains and business rules.
• Match & Merge:Configure and optimize match & merge rules including deterministic and probabilistic matching.Design survivorship rules and trust frameworks to establish golden records.Ensure high-quality deduplication and data consolidation processes.
• Informatica Data Quality (IDQ):Develop data profiling, validation, standardization, and cleansing rules.Implement data quality scorecards and monitoring frameworks.Integrate IDQ with MDM workflows for real-time and batch data quality enforcement.
• Big Data Management (BDM):Develop and manage BDM mappings and workflows for large-scale data processing.Implement data ingestion, transformation, and enrichment pipelines using big data platforms.Optimize performance for high-volume data environments (Hadoop/Spark ecosystems).
• IDMC (Cloud Capabilities):Utilize IDMC services for:Cloud Data Integration (CDI/IICS)Cloud MDMData Quality and GovernanceSupport cloud migration initiatives from on-prem MDM to IDMC.
• Integration & APIs:Design and develop integration services using SIF, APIs, and web services (REST/SOAP).Enable real-time and batch data synchronization across enterprise systems.
• Data Governance & Stewardship:Define and support data governance processes and workflows.Enable data stewardship and data issue management frameworks.Collaborate with business users and governance teams.
• Performance Optimization & Support:Optimize MDM batch jobs, match processes, and data loads.Troubleshoot and resolve data, performance, and integration issues.Ensure system scalability and reliability.

Required Skills

Technical Skills

• Strong hands-on experience in:Informatica MDM (Hub, ORS, SIF, Match & Merge)Informatica IDMC / Cloud MDMInformatica Data Quality (IDQ)Informatica BDM (Big Data Management)PowerCenter / IICS (Cloud Data Integration)
• Expertise in:Data modeling and data architecture
• Match & Merge strategiesETL/ELT processes

Additional Skills

• Strong SQL and database skills (Oracle/SQL Server, etc.)
• Experience with Hadoop, Spark, or Data Lake platformsKnowledge of API-based integrations

Functional Expertise

• Experience in Master Data domains:CustomerProductSupplier/VendorUnderstanding of:Data governanceData quality frameworksGolden record management

Experience

• 1–12+ years of experience in MDM/Data Management.Proven experience delivering end-to-end MDM implementations.

Preferred Qualifications

• Experience in cloud migration (On-prem to IDMC).
• Knowledge of Informatica Axon / EDC (Data Governance tools).
• Informatica certifications (MDM, IDQ, IDMC) are a plus.
• Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field.

Key Deliverables

MDM Architecture & Solution DesignData Models and Entity StructuresMatch & Merge ConfigurationsData Quality Rules and ReportsIntegration Pipelines and APIsGolden Record & Governance FrameworkDesigned and implemented match and merge rules, survivorship logic, ER diagrams, data validation, and cleansing processes across multiple MDM domains to maintain data quality, consistency, and reliability.

• Collaborated closely with clients to gather business requirements and deliver tailored MDM solutions.
• Created complex Oracle functions and procedures to address limitations of native Semarchy features and optimize performance.
• Worked on both Reltio and Semarchy MDM tools across different projects for global clients, leveraging the strengths of each platform to deliver robust master data solutions.
• Worked on Reltio L3 configurations, data model design, crosswalk management, API integrations, validation, and profiling activities.
• Contributed to Reltio MDM by configuring entities, attributes, and crosswalks, implementing advanced match/survivorship logic, and developing integrations using Reltio Integration Hub (RIH), REST APIs, and Postman.