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