Senior Engineer, Informatica MDM
Royal Caribbean Group
full-time
Posted on:
Location Type: Office
Location: Miramar • Florida • United States
Visit company websiteExplore more
Job Level
Tech Stack
About the role
- Configure and customize Informatica SAS MDM to implement the Party Model, defining entity types, relationships, business rules, match and merge strategies, and user interfaces.
- 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.
- 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.
- Implement match and merge rules to identify and consolidate duplicate records within the party entities, enabling a single and accurate view of each entity.
- Define and implement data quality rules and workflows within the SAS MDM system to monitor, measure, and improve data quality across party related data.
- Identify performance bottlenecks within the SAS MDM system and optimize data loading, matching, and retrieval processes for efficient and seamless data operations.
- Conduct unit testing and integration testing to validate MDM configurations, ensuring accuracy and completeness of data within the MDM repository.
- 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
- 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.
- 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
- Competitive compensation and benefits package
- Excellent career development opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Informatica SAS MDMParty Model implementationdata profilingdata cleansingdata transformationUNIX shell scriptingSQLPL/SQLdata quality managementdata governance
Soft Skills
problem-solvinganalytical skillscommunicationcollaborationpresentation developmentpresentation delivery