Senior Engineer, Informatica MDM

Position Summary

We are seeking an experienced MDM Developer with a strong focus on Informatica SAS MDM and Party Model implementation.

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.
• Experience working with Refernce 360 and it’s usage within the MDM domain.
• Performance Optimization: Identify performance bottlenecks within the SAS MDM system and optimize data loading, matching, and retrieval processes for efficient and seamless data operations.
• 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.

Qualifications, Knowledge, And Skills

• 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.
• 4+ 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.
• Experieince working with Refernce 360 and it’s usage within the MDM domain.
• Experience working with CAI, CDI and CDQ is a must.
• 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.
• 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.

Benefits

The Royal Caribbean Group offers a competitive compensation and benefits package, and excellent career development opportunities.

Pay

The pay range for this role is $85,000 - $120,000 annually.

Schedule

The position requires a full-time schedule.