MDM Tech Lead

LumenData; Miami (FL); On-site; USD 120,000 - 150,000; Full time

Job summary

LumenData in Miami, FL seeks an Informatica SAS MDM Developer to implement the Party Model, define entities and relationships, and ensure data quality across the MDM environment.

You will design data models, integrate diverse sources via IDMC, implement match/merge, and optimize performance while following governance standards. Strong SQL/UNIX scripting skills and collaboration with cross-functional teams are required.

Qualifications

• Six years of experience in MDM Development 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.
• Experience with travel and hospitality industry is a huge plus.
• Knowledge of Data Warehouses/Lakehouse architectures, Master Data Management, Data Quality Management, Data Integration, and Data Warehouse architecture

Responsibilities

• 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: Design and maintain the data model for party-related entities within the SAS MDM platform, ensuring data accuracy and consistency.
• Data Integration: Integrate data from various source systems into Informatica SAS MDM platform via IDMC, performing profiling, cleansing, and transformation.
• Match and Merge: Implement match and merge rules to identify and consolidate duplicate records.
• Configure Address Doctor Engine-reference and email and phone verification.
• Data Quality Management: Define and implement data quality rules and workflows within SAS MDM to monitor and improve data quality.
• Data Governance: Ensure adherence to data governance principles and data security practices.
• Performance Optimization: Identify bottlenecks and optimize loading, matching, and retrieval for efficiency.
• Collaboration: Work with data architects, data analysts, and business users to deliver MDM solutions.
• Testing and Validation: Conduct unit and integration testing to validate MDM configurations.
• Documentation: Maintain technical docs, including design specs and configuration guides.
• Build UNIX shell scripting and automation for Informatica job scheduling and repository backups.
• SFTP/SSH file transfer and loading using SQL, PL/SQL, and SQL*Loader

Skills

MDM Development

Informatica SAS MDM

IDMC

Data Modeling

Data Quality

Data Governance

SQL/PLSQL

UNIX Shell Scripting

Communication

Collaboration

Education

Bachelor's Degree in CS/IS/Engineering

Tools

Informatica SAS MDM Tools

SQL

PL/SQL

Job description

MiamiEssential Duties and Responsibilities Informatica SAS MDM Configuration: Configure and customize Informatica SAS M,

• City MiamiEssential Duties and Responsibilities Informatica SAS MDM Configuration: Configure and customize Informatica SAS M
• State/Province Florida
• Country United States

Job Description

Essential Duties and Responsibilities

• 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

Position 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.
  
• Experience with travel and hospitality industry is a huge plus.
  
• Knowledge of Data Warehouses/Lakehouse architectures, Master Data Management, Data Quality Management, Data Integration, and Data Warehouse architecture
  

Education Qualifications
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.