Senior Informatica MDM Lead/Developer - Product & Customer Domains

Overview

Remote
On Site
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6-12 Month(s)

Skills

Power BI
master data management
Azure
MDM
Cross-Functional Collaboration
MDM Architect
Snowflake Data Warehouse
Salesforce Integration
SAP Integration
REST/SOAP APIs
Agile / Scrum Methodologies
cloud platforms (AWS
Senior Informatica MDM Developer
Informatica MDM Lead
Product and Customer MDM
Informatica MDM
MDM Developer
Data Management Consultant
Informatica PowerCenter
Informatica Data Quality
Informatica Cloud Data Integration
Data Modeling in Informatica MDM
MDM Match/Merge Configuration
Cleanse Functions in MDM
SQL / PL-SQL
SAP IDocs
Data Enrichment Services
Data Flow Monitoring
IICS Data Pipelines
End-to-End MDM Implementation
Effort Estimation
UI/UX Design for MDM
Cloud MDM Solutions
GCP)
Solution Design & Development

Job Details

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:

  • 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.

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.