Informatica MDM 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.