Informatica MDM Lead/ Architect

Title:

Informatica MDM Lead/Architect

Visa: USC and GC ( Need Genuine Only)

Duration: 6CTH

Location: Miramar, FL - Onsite 4 days a week, remote Friday ( Need local)

Interview: 1 Technical Interview

Need updated LinkedIn with profile pic.

Job Description:

Notes from the Alignment Call:

Option 1:

Currently hosted on Siebel Platform (Siebel UCM) moving from on prem to Informatica Cloud Version 360 SAS version (Sas very important only out 2-3 years ago) cloud they don't want ON Prem informatica, this needs to be someone who has done a SAS transformation (at least 1 implementation)

Option 2:

If you find a strong MDM person LOCAL on site, they need to be strong on the databases running queries RDBMS and Data Lakes- if they don't have Siebel knowledge, that is okay as well any MDM knowledge as a LEAD/Architect.

Job Description:

Informatica SAS MDM Configuration: Configure and customize Informatica SAS MDM to implement the Party Model, defining entity types, relationships, business rules, match and merge strategies, and user interfaces.

Data Modelling: Work with data architects and stakeholders to design and maintain the data model for party-related entities within the Informatica SAS MDM platform, ensuring data accuracy and consistency.

Data Integration: Integrate data from various source systems into Informatica's SAS MDM platform through IDMC, performing data profiling, cleansing, and transformation to ensure data quality and integrity.

Match and Merge: Implement match and merge rules to identify and consolidate duplicate records within the party entities, enabling a single and accurate view of each entity.

Configure Address Doctor Engine-reference and email and phone verification.

Data Quality Management: Define and implement data quality rules and workflows within the SAS MDM system to monitor, measure, and improve data quality across party related data.

Data Governance: Ensure adherence to data governance principles and data security best practices during SAS MDM implementation and data management processes.

Performance Optimization: Identify performance bottlenecks within the SAS MDM system and optimize data loading, matching, and retrieval processes for efficient and seamless data operations.

Collaboration: Collaborate with cross-functional teams, including data architects, data analysts, and business users, to understand data requirements and deliver MDM solutions that meet business needs.

Testing and Validation: Conduct unit testing and integration testing to validate MDM configurations, ensuring accuracy and completeness of data within the MDM repository.

Documentation: Maintain comprehensive technical documentation, including design specifications, configuration guides, and troubleshooting manuals for the MDM implementation.

Build UNIX shell scripting, Pre-Session, Post-Session UNIX Commands for automation of Informatica job scheduling, backup of repository etc.,

Work with SFTP/SSH file transfer and loading using SQL, PL/SQL, SQL *Loader

Requirements

Six years of experience in MDM Development experience with a focus on Informatica MDM and Party Model implementation.

Must have hands on experience implementing Informatica's SAS MDM application.

In-depth knowledge of Informatica's SAS MDM tools, including IDMC, and their functionalities for party entities.

Familiarity with data modelling principles and data integration techniques.

Strong understanding of data quality management and data governance practices within an MDM environment.

Proficiency in data profiling, data cleansing, and data transformation processes.

Excellent problem-solving and analytical skills to troubleshoot MDM-related issues.

Strong communication and collaboration skills to work effectively with cross functional teams and stakeholders.

Knowledgeable in technology and software development processes

Good presentation development and delivery skills

Excellent organizational skills

Fair understanding of Agile methodologies (e.g., Scrum, Kanban) required.

Knowledge of Data Warehouses/Lakehouse architectures, Master Data Management, Data Quality Management, Data Integration, and Data Warehouse architecture

Education Qualification

Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline. #J-18808-Ljbffr