Overview
Skills
Job Details
Job Title: Senior Informatica MDM Lead/Developer - Product & Customer Domains
Location: Los Alamitos, CA Remote
Duration: 6 Months
We are seeking an experienced and highly skilled Informatica MDM professional to join our growing team. This is a critical role that will drive the successful implementation and ongoing support of our Informatica MDM platform, focusing on both Product and Customer domains. The ideal candidate will possess a strong blend of technical expertise in Informatica MDM (on-premise), ActiveVOS, Provisioning UI , Informatica PowerCenter / IICS , IDQ / CDQ , SQL, and proven experience with integrations, particularly with SAP (IDoc via Informatica Cloud Data Integration) and Salesforce.
Responsibilities:
Lead and contribute to the design, development, and configuration of Informatica MDM solutions for our Product and Customer domains.
Implement and support integrations between Informatica MDM and various enterprise systems, including SAP (using IDoc via Informatica Cloud Data Integration) and Salesforce.
Work closely with business stakeholders to understand requirements, translate them into technical specifications, and provide accurate effort estimates.
Develop and customize Provisioning UI, ActiveVOS for E360 and Task Management.
Develop and optimize Informatica MDM mappings, cleanse functions, and match/merge rules to ensure data quality and integrity.
Configure and customize Informatica MDM Data Models, Hub Console, and IDD applications to meet specific business needs.
Manage batch load processes and real-time APIs for data ingestion and consumption to/from MDM.
Perform match tuning and performance optimization for MDM processes.
Create and maintain SQL scripts for data loading into landing, staging, and base object tables.
Develop Informatica MDM queries, packages, import/export templates, and modify repository objects as required.
Support existing IICS and IDQ solutions, ensuring seamless data flow and quality.
Troubleshoot and resolve complex data quality and integration issues.
Collaborate with cross-functional teams, including business analysts, data architects, and other developers.
Contribute to defining best practices and standards for MDM development and operations.
Essential Technical Competencies:
Overall, 6-8 years of experience in designing, building, and configuring applications to meet business process and application requirements.
Must have development experience of at least 2 significant projects with around 4-5 years of relevant experience in Informatica MDM (on-premise). Including Hub, Provisioning UI, ActiveVOS , Match & Merge
Deep understanding of all core Informatica MDM functionalities.
Proven experience with Informatica PowerCenter and Informatica Data Quality (IDQ).
Strong proficiency in SQL (writing complex queries, stored procedures, etc.).
Demonstrable knowledge of Batch Load and Real-Time APIs to/from MDM.
Ability to carry out Match Tuning/Match Performance optimization.
Extensive experience with Customization and Configurations on Data Model/Hub Console/IDD.
Experience in creating source systems and configuring trust settings in MDM.
Proficiency in creating mappings and utilizing various cleanse functions.
Expertise in configuring Match/Merge settings.
Experience in writing SQL to load data into landing tables and defining processes to load staging tables and corresponding Base Objects.
Experience in creating Queries and packages within Informatica MDM.
Experience in modifying the repository according to business needs.
Proficient in creating import and export templates for loading and exporting data.
Strong experience with SAP integrations, specifically using IDocs (e.g. MATMAS) via Informatica Cloud - Data Integration (IICS).
Experience with Salesforce integration is a plus.
Good to Have Skills:
Experience with external Data Enrichment services.
Experience in UI design and development.
Familiarity with other Informatica products or cloud data integration platforms.
Certifications in Informatica MDM or other relevant technologies.
Experience with Snowflake Cloud Data Warehouse and Power BI
Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
Excellent analytical, problem-solving, and communication skills.
Ability to work independently and as part of a team in a fast-paced environment.
Strong commitment to delivering high-quality solutions.