Overview
Skills
Job Details
Job Title: Senior Informatica MDM Lead/Developer - Product & Customer Domains
Location: 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.