Senior Engineer, Informatica MDM

Royal Caribbean Cruises Ltd; Town of Florida (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Royal Caribbean Group in Miramar, Florida seeks an experienced Senior Engineer to advance Informatica SAS MDM and implement the Party Model. You will configure and optimize the MDM platform, ensure data accuracy, and collaborate with cross-functional teams to deliver reliable master data for the enterprise.

This role emphasizes data quality, integration, and governance with IDMC and Reference360 experience.

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.
• 4+ years of experience in MDM development with a focus on Informatica MDM and Party Model implementation.
• Hands-on experience implementing Informatica’s SAS MDM application.
• Experience working with Reference360 and its usage within the MDM domain.
• Experience with CAI, CDI and CDQ.
• 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.

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 Informatica SAS MDM platform, ensuring data accuracy and consistency.
• Data Integration: Integrate data from various source systems into Informatica SAS MDM via IDMC, performing profiling, cleansing, and transformation.
• Match and Merge: Implement match and merge rules to identify and consolidate duplicate records within party entities.
• Configure Address DoctorEngine-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.
• Experience working with Reference360 and its usage within the MDM domain.
• Performance Optimization: Identify performance bottlenecks and optimize data loading, matching, and retrieval processes.
• Testing and Validation: Conduct unit and integration testing to validate MDM configurations.
• Documentation: Maintain technical documentation including design specs and configuration guides.
• Build UNIX shell scripting and automation for Informatica job scheduling and repository backup.
• Work with SFTP/SSH file transfer and loading using SQL, PL/SQL, SQL*Loader.

Skills

Informatica SAS MDM

Party Model

Data Modelling

Data Integration

Data Quality Management

IDMC

UNIX shell scripting

SQL/PLSQL

Cross-functional collaboration

Agile methodologies

Education

Bachelor's degree in Computer Science/Information Systems/Engineering/Business

Tools

IDMC

Reference360

CDI/CAI/CDQ

SQL*Loader

Job description

Select how often (in days) to receive an alert:

Journey with us! Combine your career goals and sense of adventure by joining our exciting team of employees. Royal Caribbean Group is pleased to offera competitivecompensationandbenefits package, and excellent career development opportunities, each offering unique ways to explore the world.

We are proud to be thevacation-industryleader with global brands — including Royal Caribbean International, Celebrity Cruises and Silversea Cruises — the most innovative fleet and private destinations, and the best people.Together, we are dedicated to turning the vacation of a lifetime into a lifetime of vacations for our guests.

The Royal CaribbeanGroup’s DataAnalytics and AI Teamhasan exciting career opportunity for a full time Senior Engineer, Informatica MDM reporting to the Director of Enterprise MDM & Quality .

This position will work on-site inMiramar, Florida .

Position Summary

We are seeking an experienced MDM Developer with a strong focus on Informatica SAS MDM and Party Model implementation. The ideal candidate willbe responsible forconfiguring and customizing the MDM platform, ensuring data accuracy and consistency, integrating data from various sources, andoptimizingperformance.Proficiencyin data quality management, data modeling, and effective communication with cross-functional teams is essential for this role.

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 andmaintainthe 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 toidentifyandconsolidateduplicate records within thepartyentities, enabling a single andaccurateview of each entity.
• Configure Address DoctorEngine-referenceand email and phone verification.
• Data Quality Management: Define and implement data quality rules and workflows within the SAS MDM system tomonitor, measure, and improve data quality across party related data.
• Experieinceworking withRefernce360 andit’susage within the MDM domain.
• Performance Optimization:Identifyperformance bottlenecks within the SAS MDM system andoptimizedata loading, matching, and retrieval processes for efficient and seamless data operations.
• Testing and Validation: Conduct unit testing and integration testing tovalidateMDM configurations, ensuring accuracy and completeness of data within the MDM repository.
• Documentation:Maintaincomprehensive 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 MDMDevelopment experiencewith a focus on Informatica MDM and Party Model implementation.
• Must havehands onexperience implementing Informatica’s SAS MDM application.
• Experieinceworking withRefernce360 andit’susage within the MDM domain.
• Experience working with CAI,CDIand CDQ isa 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.
• Proficiencyin data profiling, data cleansing, and data transformation processes.
• Excellent problem-solving and analytical skills to troubleshoot MDM-related issues.
• Strong communicationand collaboration skills to work effectively with cross functional teams and stakeholders.
• Knowledgeablein technology and software development processes.
• Good presentation development and delivery skills.
• Fairunderstanding 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.

Agency and Third-Party Submissions:

Please note this is a direct search by the Company, and applications through agencies and other third parties will not be accepted, nor will fees be paid for unsolicited resumes. Any unsolicited resumes will be considered the Company's property.

We knowthere's a lot to consider. As you go through the application process, our recruiters will be glad to provide guidance, and more relevant details to answer anyadditionalquestions. Thank you again for your interest in Royal Caribbean Group.We'llhope to see you onboard soon!

It is the policy of the Company to ensure equal employment and promotion opportunity to qualified candidates without discrimination or harassmenton the basis ofrace, color, religion, sex, age, national origin, disability, sexual orientation, sexuality, gender identity or expression, marital status, or any other characteristic protected by law. Royal Caribbean Group and each of its subsidiaries prohibit and will not tolerate discrimination or harassment.