Data Engineer II - MDM

Overview

Design and build data pipelines for Master Data Management through ETL/ELT processes, and integrate upstream and downstream systems using cloud-native patterns and APIs for an enterprise data warehouse that supports Regulatory Reporting, Finance, Risk steering, and Customer 360.

What you'll do

• Design, build, and optimize data pipelines using Informatica IICS and PowerCenter.
• Develop integration workflows between upstream and downstream systems using cloud-native patterns and APIs.
• Implement data transformation logic that ensures lineage, audit trail, data quality rules, and supports SOX/regulatory compliance.
• Collaborate with BAs, product owners, and architects to gather requirements and produce HLD/LLD.
• Support SaaS MDM implementation, working with Business Entities, Match/Merge rules, and survivorship strategies.
• Contribute to data modeling, metadata management, and semantic consistency.
• Ensure scalability, performance tuning, and operational monitoring of data flows on AWS.
• Participate in code reviews, testing, and release planning.
• Act as SME on legacy MDM transition and data mastering best practices.
• Performance tune complex data pipelines and SQL queries.
• Perform impact analysis of proposed changes on existing architecture, capabilities, system priorities, and technology solutions.
• Work in the Agile framework, participating in agile ceremonies and coordinating with scrum master, tech lead, and PO on sprint planning, backlog creation, refinement, demo, and retrospection.
• Work with Product Owners on PI goals, PI planning, requirement clarification, and delivery coordination.
• Provide technical support for production incidents and failures.
• Work with global technology teams across different time zones (primarily US) to deliver timely business value.

What you'll need

• Expertise in design and development of ETL/Data Engineering using Informatica PowerCenter and/or IICS.
• Experience in SaaS MDM (IDMC) for at least 1 year.
• Experience in mastering Party/Customer/Account domains.
• Experience designing integration pipelines in AWS Cloud.
• API-based integration using REST/SOAP.
• Experience with RDS, Redshift, S3, Snowflake or other cloud-native data stores.
• Knowledge of data governance, quality, lineage, and audit frameworks.
• Familiarity with SOX/compliance processes in regulated environments.
• Proficiency in data modeling, mapping specs, and design documentation.
• Performance tuning of data pipelines and DB objects to deliver optimal performance.
• Experience in GitLab version control and CI/CD processes.
• Functional skills: team player, excellent verbal, written, and interpersonal communication, problem solving with incident management and root cause analysis, partnership and collaboration with business and IT stakeholders, and attention to detail.

Nice to have

• Exposure to Informatica IDQ and Axon.
• Experience in the financial industry.

Details

• Location: Bangalore, India.
• Role type: Hybrid.
• Career level: P2; job category: Senior Associate.
• Reports to: Senior Manager - Data Engineering.