Informatica MDM Architect: Data Consolidation & Integration

LTM; Charlotte (NC); On-site; USD 140,000 - 200,000; Full time

Benefits offered by this job

Comprehensive Medical Plan

Short/Long-Term Disability Coverage

401(k) Plan with Company match

Life Insurance

Vacation Time, Sick Leave, Holidays

Paid Paternity and Maternity Leave

Job summary

LTIMindtree is seeking an Informatica MDM Architect in the United States (Charlotte, NC) to lead end-to-end MDM solutions. You will architect data models, design data flows from IDQ to MDM, and ensure seamless publish layer integration with BES and SIF.

Strong Java and SQL skills are required to implement business logic and data handling. Ideal candidates have hands-on BES/SIF experience, deep MDM match/merge knowledge, and a proven track record in Oracle database environments.

Qualifications

• Must have architect experience in Informatica MDM implementations.
• Strong understanding of MDM match merge survivorship and consolidation logic.
• Hands-on experience with BES and SIF.
• Proficiency in Core Java and Java web services.
• Experience in SQL and Oracle stored procedure development.

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 BES and SIF for data services and integration.
• 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.

Skills

Informatica MDM

PowerCenter

IDQ

IICS

Oracle databases

Linux

Shell scripts

Tools

BES

SIF

Core Java

Java Web Services

SQL

Oracle stored procedures

Job description

LTIMindtree is seeking an Informatica MDM Architect in the United States (Charlotte, NC) to lead end-to-end MDM solutions. You will architect data models, design data flows from IDQ to MDM, and ensure seamless publish layer integration with BES and SIF.

Strong Java and SQL skills are required to implement business logic and data handling. Ideal candidates have hands-on BES/SIF experience, deep MDM match/merge knowledge, and a proven track record in Oracle database environments.