Job Title: MDM Solution Architect
Location: San Jose, CA (Day 1 onsite, 4 days office)
Duration: Long term contract
Rate: DOE
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
- B.E./B.Tech/MCA in Computer Science, IT or a related field.