MDM Informatica Developer

Overview

Design, develop, test, and support Master Data Management solutions focused on Informatica MDM configuration and development, SQL-based data processing, data-quality controls, and integrations between Informatica, Data Hub, SAP, BW, and downstream systems.

What you'll do

• Develop, configure, maintain, and test Informatica MDM components supporting master-data creation, enrichment, validation, matching, merging, and distribution.
• Implement and support end-to-end MDM data flows, including Informatica egress files to Data Hub and Data Hub inputs to Informatica.
• Develop and maintain mappings, transformations, workflows, batch jobs, and integration processes required for MDM ingestion and outbound distribution.
• Work with source-system data from enterprise applications; profile and validate incoming data before MDM processing.
• Develop, optimize, and troubleshoot SQL queries, stored procedures, views, and database objects used by MDM processes.
• Configure and maintain MDM business rules, validation rules, match-and-merge logic, survivorship rules, hierarchies, crosswalks, and reference data as required.
• Develop, maintain, and test data dictionary elements, including tables, views, schemas, attributes, code sets, and related metadata.
• Investigate data-quality, integration, workflow, and batch-processing issues; perform root-cause analysis and implement sustainable fixes.
• Create unit-test cases, support system and integration testing, validate reconciliation results, and assist with user acceptance testing.
• Create and maintain technical documentation, including source-to-target mappings, solution designs, configuration details, support procedures, deployment notes, and operational runbooks.
• Participate in peer code and configuration reviews and adhere to established development, security, naming, and documentation standards.
• Implement and support CI/CD processes for Informatica configurations, database components, and integration artifacts across environments.
• Manage and version source code, scripts, configuration files, and deployment artifacts using Git.
• Provide production support, monitor scheduled jobs and interfaces, and coordinate incident resolution with cross-functional teams.

What you'll need

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent practical experience.
• 2+ years of hands-on experience in Informatica development, Master Data Management, data integration, or a related role.
• Hands-on experience with Informatica MDM concepts and components, including data models, mappings, batch processing, match-and-merge, survivorship, hierarchies, and reference data.
• Strong SQL skills, including development and troubleshooting of stored procedures, views, joins, transformations, reconciliation queries, and performance-aware SQL.
• Experience implementing and supporting inbound and outbound MDM integrations, including file-based interfaces and data exchange with Data Hub or comparable platforms.
• Understanding of master-data concepts, data governance, metadata, data quality, golden records, crosswalks, reference data, and data stewardship workflows.
• Experience analyzing data defects and integration failures across source, staging, MDM, and downstream layers.
• Working knowledge of Git-based source control and collaborative development practices.
• Familiarity with Azure DevOps or comparable CI/CD tooling for automated builds, releases, and environment promotion.
• Ability to create clear technical documentation and communicate effectively with technical, functional, and business stakeholders.
• Experience with data profiling, data-quality rules, exception management, reconciliation, and stewardship processes.

Details

• Location: Virtual - India.