Senior Engineer, Informatica MDM

Royal Caribbean Group; Town of Florida (NY); On-site; USD 120,000 - 165,000; Full time

Job summary

Royal Caribbean Group is seeking an experienced Senior Engineer to specialize in Informatica MDM with a focus on a Party Model implementation. You will configure, customize, and optimize the SAS MDM platform, ensuring accurate party data and seamless integrations across source systems.

Based onsite in Miramar, Florida, you will work with cross-functional teams, implement data quality rules, perform data profiling, and drive performance improvements while delivering comprehensive technical

Qualifications

• Bachelor’s degree in a technical discipline.
• 4+ years of MDM development experience with Informatica MDM and Party Model implementation.
• Hands-on experience with Informatica SAS MDM.

Responsibilities

• Configure and customize Informatica SAS MDM to implement the Party Model, defining entities, relationships, business rules, match and merge strategies, and user interfaces.
• Data modelling for party-related entities within the Informatica SAS MDM platform.
• Integrate data from source systems via IDMC, with profiling, cleansing, and transformation.
• Implement match and merge rules to consolidate duplicates and create a single view.
• Configure Address Doctor Engine references and email/phone verification.
• Define and implement data quality rules and workflows in SAS MDM.
• Work with Reference 360 in the MDM domain.
• Identify bottlenecks and optimize loading, matching, and retrieval processes.
• Conduct unit and integration testing for MDM configurations.
• Maintain technical documentation: design specs, guides, and troubleshooting.
• Develop UNIX shell scripts for job scheduling and repository backup automation.
• Work with SFTP/SSH transfers and loading using SQL, PL/SQL, and SQL*Loader.

Skills

MDM development

Informatica MDM

Party Model implementation

Data quality management

Data modeling

Data integration

Problem-solving

Communication skills

Agile methodologies

Cross-functional collaboration

Presentation skills

Travel/hospitality experience

Education

Bachelor’s Degree in Computer Science, Information Systems, Engineering, Business or related field

Tools

Informatica SAS MDM

IDMC

CAI

CDI

CDQ

SQL/PL-SQL

UNIX shell scripting

SFTP/SSH

Data warehouses / lakehouse

Job description

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

The Royal Caribbean Group’s Data Analytics and AI Team has an exciting career opportunity for a full time Senior Engineer, Informatica MDM reporting to the Director of Enterprise MDM & Quality .

The position is onsite and based in Miramar, Florida.

The position is also not eligible for work authorization sponsorship.

Position Summary

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

• 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.
• Experieince 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.

Position Requirements

• 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.

We know there'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 any additional questions. Thank you again for your interest in Royal Caribbean Group. We'll hope 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 harassment on the basis of race, 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.