Senior ETL & Data Integration Engineer

Manulife/John Hancock; Toronto; Hybrid; CAD 113,000 - 163,000; Full time

Benefits offered by this job

Incentive programs

Health and dental benefits

Job summary

Manulife/John Hancock in Toronto is seeking a Senior ETL Developer to design, build and maintain enterprise‑grade data integration solutions using Informatica PowerCenter and IICS. You will craft scalable ETL pipelines and ensure data quality for analytics and reporting.

The role requires strong SQL, data warehousing concepts, and experience with Salesforce integrations, plus Python for automation. Hybrid work and regulated financial services backdrop.

Qualifications

• 7–10+ years of overall software/data engineering experience in large enterprises.
• 5+ years hands-on Informatica PowerCenter and/or IICS experience.
• Strong SQL with relational databases and data warehousing concepts.
• Experience integrating data with Salesforce; Python for data processing or automation.
• Cloud platforms (Azure preferred) and cross-functional collaboration skills.

Responsibilities

• Design, develop, and maintain ETL solutions using Informatica PowerCenter and/or IICS.
• Build and optimize data pipelines, transformations, and workflows for data warehousing.
• Partner with business and tech teams to integrate data from Salesforce and other systems.
• Ensure data quality, reliability, and performance; monitor and troubleshoot ETL processes.
• Contribute to cloud data initiatives and improve data engineering standards.

Skills

Informatica PowerCenter

Informatica IICS

SQL

Data warehousing

ETL architecture

Data integration patterns

Python

Azure Cloud

Salesforce integration

Tools

Salesforce

Azure

Job description

Manulife/John Hancock in Toronto is seeking a Senior ETL Developer to design, build and maintain enterprise‑grade data integration solutions using Informatica PowerCenter and IICS. You will craft scalable ETL pipelines and ensure data quality for analytics and reporting.

The role requires strong SQL, data warehousing concepts, and experience with Salesforce integrations, plus Python for automation. Hybrid work and regulated financial services backdrop.