Informatica CDI Engineer

About Four Seasons:

Four Seasons is powered by our people. We are a collective of individuals who crave to become better, to push ourselves to new heights and to treat each other as we wish to be treated in return. Our team members around the world create amazing experiences for our guests, residents, and partners through a commitment to luxury with genuine heart. We know that the best way to enable our people to deliver these exceptional guest experiences is through a world-class employee experience and company culture.

At Four Seasons, we believe in recognizing a familiar face, welcoming a new one and treating everyone we meet the way we would want to be treated ourselves. Whether you work with us, stay with us, live with us or discover with us, we believe our purpose is to create impressions that will stay with you for a lifetime. It comes from our belief that life is richer when we truly connect to the people and the world around us.

About the location:

Four Seasons Hotels and Resorts is a global, luxury hotel management company. We manage over 120 hotels and resorts and 50 private residences in 47 countries around the world and growing. Central to Four Seasons employee experience and social impact programming is the company’s commitment to supporting cancer research, and the advancement of diversity, inclusion, equality and belonging at Four Seasons corporate offices and properties worldwide. At Four Seasons, we are powered by people and our culture enables everything we do.

Job Posting - Informatica CDI Engineer Job Description

The Informatica CDI Engineer is a technical leader in our Data & Analytics commercial data engineering team.  Responsibilities include the design, build, optimization, and maintenance of experiments, prototypes and products across Four Seasons Informatica Platform.

The CDI Engineer will use modern and innovative technology to help business partners realize actionable insights and value from Four Seasons enterprise data platforms. This includes but is not limited to the design and build of data extraction, transformation, and loading processes by developing custom data integration pipelines.

The Engineer will be valued member of an internal Data Engineering capability working together to discover to define requirements, use cases and outcomes.  As a member of the IT Delivery team, the Engineer will build, configure, secure, migrate, optimize, and refactor Informatica platform solutions which includes Ingestion, ETL/ELT, Storage, Data Lakes, and Data Modelling.

The candidate can work with all levels of the organization with an ability to understand and translate institutional knowledge into technical solutions.  Strong service, communication and problem-solving skills are key.

This role is based in Four Seasons Hotels and Resorts, Toronto Corporate Office, reporting to the Manager, Data Engineering. This role involves interactions with internal executive stakeholders and project sponsors, technical operations and development teams, Four Seasons IT, end-user contracts and product users. Externally, the role will interact with various Four Seasons partners and data solution providers, Microsoft, and source data providers.

What You’ll Be Doing

CDI Engineering:

• Design, develop and optimize data integration pipelines using Informatica tools.
• Integrate IDQ (Data Quality), CDGC (Data Governance) and RDM (Reference Data Management) with on prem and cloud systems, datalakes, warehouses.
• Knowledge of Cloud Data Governance and Compliance principles, including the creation of domains, data lineage, business glossaries, and compliance monitoring within IICS.
• Implement and automate data workflows for metadata synchronization and governance.
• Debug and troubleshoot workflows, data mappings and API-based integrations.
• Ensure data quality, profiling and governance through effective metadata ingestion.
• Conduct unit testing, integration testing and performance testing of data pipelines.
• Monitor and optimize integration performance, addressing scalability and reliability concerns.
• Dimensional modelling experience is mandatory
• Adoption of best development practices for batch and stream processing
• Managing all work in Jira including but not limited to story creation, defect resolution etc.
• Documentation of the work in Confluence
• Identifies opportunities for new architectural initiatives makes recommendations on the increasing scalability and robustness of platforms and solutions.

Who You Are

• Strong analytical, problem-solving, and logical thinking skills.
• Excellent communication (interpersonal, written, oral) and customer service skills.
• Detail-oriented, self-motivated, and able to prioritize under pressure.
• Independent decision-making with a structured, process-oriented approach.
• Ability to lead teams, resolve technical roadblocks, and manage competing priorities.
• Strong time and project management skills; capable of handling multiple projects.
• Ability to translate business needs into data requirements and troubleshoot effectively.
• Versatile role engagement (trainer, support, tester, analyst).
• Ability to work on several un-related projects concurrently.
• Expertise in IDQ (Data Quality), CDGC (Data Governance), and RDM (Reference Data Management).
• Experience working with REST/SOAP APIs for data integration and automation.
• Strong SQL skills and hands-on knowledge of ETL tools.
• Proven experience integrating Informatica with cloud data platforms (Azure, AWS, GCP).
• Knowledge of data lineage, business glossaries, and compliance monitoring in CDGC.
• Familiarity with Agile development and CI/CD practices for data pipelines.
• Confluence, Jira, TestRail
• Helpdesk Tools and methods
• Microsoft Visio or similar software (Erwin, Lucid Charts, draw.io etc.)
• Microsoft Visual Studio
• Experience with GIT hub or Azure DevOps

What You Bring

• 5-7 years of experience in Informatica Data Integration (PowerCenter, IDMC, IICS).
• 5+ years of IT industry experience with the data related projects.
• Minimum 4+ years of experience in ETL development, data modeling, datawarehouse design and development, data migration related projects.
• Very good understanding of data warehousing concepts, data modeling concepts, performance improvement
• Relevant Informatica certifications (IDQ, IICS, CDGC) preferred.
• University or higher degree in Engineering, Mathematics, Information Systems, Computer Science or Technology

This role will be a Hybrid working model, which will require 3 days per week in the Four Seasons Corporate Office located at 1165 Leslie Street, Toronto, Ontario #LI-Hybrid 

Four Seasons is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act. If contacted for an employment opportunity, please advise Human Resources if you require accommodation.