Senior Specialist - Data Engineering

Informatica MDM Architect

Technical Skills

Informatica MDM Hub MatchMerge Trust Survivorship Hierarchies

Good experience with ETL tools Informatica PowerCenter IDQ IICS preferred

Strong expertise in Oracle relational databases

Proficient in LINUX OS environment Shell Scripts

Required Skills

Proven experience in an Architect role within Informatica MDM implementations Mandatory

Strong understanding of MDM Match Merge survivorship and consolidation logic Mandatory

Handson experience with BES SIF and user exits Mandatory

Proficiency in Core Java and Java web services Mandatory

Experience in SQL and Oracle stored procedure development Mandatory

Key Responsibilities

Architect and implement MDM solutions with a focus on Match Merge Deduplication and data consolidation

Design and manage data flows from IDQ to MDM and onward to publish layers

Configure and integrate Business Entity Services BES and Service Integration Framework SIF

Develop and manage user exits for custom business logic and data handling

Lead development of Core Java and Java web services for MDM integration

Analyze and optimize Oracle stored procedures for data manipulation and extraction

Build and refine complex SQL queries to meet business data requirements