MDM Tech Lead

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