MDM Senior Data Engineer

Bangalore, Chennai, Hyderabad

Job Description

Curious about the role?

As a Senior Data Engineer, you will be responsible for design and develop Business Entity models, hierarchies, and relationships in Informatica MDM SaaS
Refactor and configure match rules, merge logic, and survivorship policies for golden record creation
Implement and optimize data quality rules for cleansing, standardization, and validation
Integrate Address Doctor and other DaaS services via Cloud Application Integration (CAI)
Build and maintain data pipelines for batch and real-time integration with enterprise systems and cloud platforms (e.g., Azure Data Lake)
Perform data profiling, deduplication, and enrichment activities
Lead the migration of master data from Informatica MDM on-premises to Informatica MDM SaaS, ensuring data integrity, completeness, and continuity
Collaborate with data architects, stewards, and business stakeholders to align MDM with governance policies
Conduct post-migration validation to ensure accuracy and completeness of master data
Support cutover planning, go-live readiness, and post-deployment stabilization
Mentor junior Data Engineers and contribute to best practices and technical documentation

Job Requirement

What do we expect?

● 8+ years of technical experience in Master Data Management with 5+ years of specialized experience with Informatica MDM (On-premises) and 3+ years in Informatica SaaS MDM or Informatica MDM modernization or cloud migration programs completed at least 2-3 full life cycle

● Expertise in Informatica MDM (Hub Console, IDD, BES, SIF APIs, Customization)

● Proven expertise in Informatica SaaS including Business Entity Services, Business 360 Console, Relationship 360, and Reference 360

● Strong understanding of Customer, Product, Supplier, Location, and Material domains.

● Demonstrated success in end-to-end MDM migrations from on-premises to SaaS, including data model refactoring, match/merge rules, survivorship logic, and stewardship workflows

● Strong command of data quality frameworks, including rule design, profiling, cleansing, and enrichment using Informatica Data Quality (IDQ)

● Experience integrating Cloud Application Integration (CAI) with external services like Address Doctor for real-time validation

● Proven track record in migrating on-prem MDM to SaaS, including:

o Designing migration playbooks/runbooks

o Automating entity model generation and metadata mapping

o Ensuring data integrity, security, and minimal downtime

o Source-to-target mapping

o Data profiling and cleansing

o Transformation logic and survivorship alignment

o Incremental and bulk load strategies

● Experience with zero-downtime cutover planning, rollback strategies, and parallel run validations

● Proficiency in SQL, Informatica - CDI/ CDQ/ CAI, and metadata management.

● Hands-on experience with cloud platforms - Azure and enterprise integration patterns

● Excellent communication and stakeholder engagement skills, with the ability to translate technical concepts into business value