Job Title: MDM Solution Architect Revanth

Location: San Jose, CA (Day 1 onsite, 4 days office)

Duration: Long term contract

Experience: 10+ years

Key responsibilities

Define the target MDM SaaS architecture on Customer 360 / Business 360 / Supplier 360 as applicable: business entities, relationships, hierarchies, reference data and source systems.
Design the MDM data model, including entity extensions, field groups, cross-references and history.
Define the match and merge strategy, trust and survivorship rules, and the golden record design together with the DQ Analyst and business owners.
Design data stewardship workflows, approval processes and role-based security in MDM SaaS.
Set up the IDMC org strategy (environments, sub-orgs, Secure Agents, runtime environments), the deployment approach, and IPU consumption planning.

CDI integration architecture

Define integration patterns for inbound loads to MDM SaaS and outbound publishing of golden records: batch, near real-time and event-driven.
Set CDI design standards for mappings, taskflows, parameterization, incremental loads, error handling, restartability and audit logging.
Design use of MDM SaaS ingress/egress jobs, REST APIs, business events and Cloud Application Integration (CAI) processes for real-time integration.
Define performance, scalability and pushdown optimization guidelines for CDI pipelines.

Salesforce integration design

Design bidirectional integration between Salesforce CRM and MDM SaaS: Account, Contact, Lead and custom objects, cross-reference management and syncing golden records back to Salesforce.
Define the approach for Salesforce bulk and incremental extraction (Bulk API, SOQL, change tracking), API limit management and conflict resolution.
Design duplicate prevention between Salesforce and MDM, such as search-before-create, real-time match and field ownership rules.
Work with Salesforce admins and architects on object model alignment, data ownership and changes to business processes.

Data quality and governance

Integrate Cloud Data Quality rules and profiling into the MDM data flow.
Align the MDM solution with data governance, and with metadata and lineage in Cloud Data Governance & Catalog (CDGC) where in scope.

Technical leadership and delivery

Run architecture and design reviews, and make sure builds follow Informatica best practices.
Guide MDM developers, CDI developers and DQ analysts on design decisions and technical problems.
Support estimation, solution proposals and SOW inputs.
Present the architecture, design decisions and trade-offs to client stakeholders and steering committees.

Mandatory skills

Informatica IDMC MDM SaaS architecture: 5+ years in Informatica MDM, including hands-on architecture of IDMC MDM SaaS (Customer 360 / Business 360). This must include business entity modeling, match and merge, survivorship, hierarchies and stewardship workflows.
Informatica Cloud Data Integration (CDI): strong CDI architecture and design experience covering integration patterns, mappings and taskflows, incremental loads, error handling, performance design, and MDM SaaS ingress/egress integration.
Salesforce integration design: proven experience designing Salesforce–MDM integration. This must include the Salesforce data model, Bulk/REST APIs, bidirectional sync, cross-reference management and duplicate prevention.

Must-have skills

At least 2 end-to-end Informatica MDM implementations as solution architect.
Experience with MDM SaaS REST APIs, business events and IDMC Cloud Application Integration (CAI).
Good knowledge of IDMC administration: org setup, Secure Agents, runtime environments and asset deployment.
Strong SQL and data analysis skills.
Excellent stakeholder management, communication and presentation skills.

Good-to-have skills

Oracle Fusion Cloud integration with MDM.
IDMC Cloud Data Quality, Cloud Data Profiling and CDGC.
Migration from MDM Hub 10.x or PowerCenter to IDMC.
Informatica certification in MDM SaaS or IDMC, and Salesforce Integration Architect certification.

Qualifications

MDM Solutions Architect

Key skills