Informatica MDM Architect -Remote in Fayetteville

Should be an ITAR EC resource Should have strong Informatica MDM Onprem knowledge should be able to write and understand complex SQLs ETL and scripting knowledge Needs to be handson and should be able to independently handle GCS cases

\n

Technical Skills

\n

Informatica MDM Hub MatchMerge Trust Survivorship Hierarchies

\n

Good experience with ETL tools Informatica PowerCenter IDQ IICS

\n

Strong expertise in Oracle relational databases

\n

Proficient in LINUX OS environment Shell Scripts, Proven experience in an Architect role within Informatica MDM implementations Mandatory

\n

Strong understanding of MDM Match Merge survivorship and consolidation logic Mandatory

\n

Handson experience with BES SIF and user exits Mandatory

\n

Proficiency in Core Java and Java web services Mandatory

\n

Experience in SQL and Oracle stored procedure development Mandatory

n

\n

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

\n

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

\n

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

\n

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

\n

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

\n

Analyze and optimize Oracle stored procedures for data manipulation and extraction

\n

Build and refine complex SQL queries to meet business data requirement

\n