Talent.com
Informatica CDI Engineer

Informatica CDI Engineer

Four Seasons Hotels and ResortsFour Seasons Office Toronto
11 days ago
Job type
  • Full-time
Job description

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.

    Create a job alert for this search

    Engineer • Four Seasons Office Toronto