Apply on Employer Site

Envision Technology Solutions · 4 hours ago

MDM Lead (Informatica MDM – Backend)

Raritan, NJ

Contract

Onsite

Senior Level, Lead/Staff

10+ years exp

Envision Technology Solutions is seeking an MDM Lead specializing in Informatica MDM for a hands-on backend role. The successful candidate will be responsible for the end-to-end implementation and optimization of Informatica MDM solutions, focusing on backend processes and guiding the team across multiple complex data domains.

Information Technology & Services

No H1B

Hiring Manager

Suraj Nath Jha

Responsibilities

Deliver end‑to‑end MDM projects: data model design, hub configuration, match rules, performance tuning, and E360 configuration (if applicable)

Own backend solution for Informatica MDM (hub schemas, staging, landing, trust/survivorship, match/merge, SIF/API)

Design and implement match rules, external match strategies, and incremental/delta load patterns

Implement and maintain merge/unmerge, history tracking, and data stewardship processes

Plan and execute large data loads (e.g., 2M+ records) in manageable chunks; use MDM log analysis, block‑wise processing, external match, rowid‑based loads to optimize throughput

Design and oversee decommissioning for sources (soft delete vs hard delete) and RecalculateBVT processing

Monitor and manage history table growth, implement archiving strategies, and perform SQL deletions on history tables where appropriate

Analyze and resolve performance issues across match/merge, user exits, and batch jobs; provide concrete examples of tuning applied

Provide expertise in MDM architecture, data integration, data quality, data governance, and data security

Develop MDM + ETL solution architecture, including batch and real‑time integrations, and performance tuning considerations

Lead design of the MDM data model (base objects, cross‑references, relationships) and data mappings

Configure and customize MDM hub, services, web services, user exits, SIF/API packages, and integration patterns

Function as Design Authority in technical design reviews; approve code reviews and technical deliverables

Work closely with business & IT stakeholders to gather requirements, clarify scenarios, and design solutions

Perform impact analysis for changes (match rules, source additions, schema changes)

Maintain compliance with SDLC, change control, and development standards

Develop and review implementation plans and contingency plans; support estimation and scheduling

Client‑facing role: partner with customers, architects, and other consultants on‑site and remote

Lead and mentor team members (offshore/onshore), assign tasks, and review work

Provide clear communication, presentations, and documentation (including performance analysis, history/archive plans, and decommissioning strategies)

Qualification

Informatica MDMSQL/PLSQLData IntegrationData QualityData GovernanceETLCommunication SkillsTeam Leadership

Required

10+ years in Information Management

2–3 recent full lifecycle MDM implementations (Informatica MDM)

Strong SQL / PLSQL skills: backend tables, stored procedures, impact analysis

Informatica MDM backend expertise (Hub store)

Match rules, trust rules, add new sources, validate mapping and xRef behavior

Merge / Un‑merge logic, external match, and survivorship

SIF packages, API packages, user exits, and batch jobs

Deep knowledge of merge history tables and xRef history and how they impact performance, audit, and decommissioning

Ability to plan and execute large delta/full loads (e.g., daily 100k vs 2M from new source)

Decommissioning of a source (~5M+) via soft delete, hard delete, and RecalculateBVT

History table archiving and cleanup strategies

Efficient full reloads for existing sources (e.g., 6M+ records)

Complex reference value changes (e.g., splitting an area code 50 into 50A/50B and propagating to downstream)

Contract‑driven data removal (e.g., vendor asks to purge 10‑year, 1M record source)