Solution IT Inc. is looking for Senior Informatica MDM Lead/Developer - Product & Customer Domains for one of its clients in Los Alamitos CA (Remote)
Job Title: Senior Informatica MDM Lead/Developer - Product & Customer Domains
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.
Required Skills
- 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:
- Bachelors 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.
Work Site: Los Alamitos CA / Remote (Remote is fine but see if the candidate is OK to travel to CA on milestone basis)
Duration: 6-12 Months
Expected Start Date: Immediate
Number of Position: 1
Please send your responses back to
About Solution IT
Solution IT is a national IT consulting company specializing in: Technology Staffing and Oracle E-Business Solutions based in Boston Massachusetts.