Senior Data Integration Engineer - ETL (Informatica)

John Hancock; Boston (MA); Hybrid; USD 80,000 - 115,000; Full time

Job summary

John Hancock, a Manulife Financial subsidiary, seeks a Senior ETL Developer to design, build, and maintain enterprise data integration pipelines using Informatica PowerCenter/IICS, SQL, and cloud platforms in a regulated financial services environment.

You will partner with business and technology teams, optimize data pipelines, and support Salesforce integrations while ensuring data quality and performance.

Qualifications

• 7–10+ years of software and data engineering in large enterprises.
• 5+ years with Informatica PowerCenter and/or IICS, including complex ETL design and development.
• Strong expertise in ETL architecture, data warehousing concepts, data integration patterns, and advanced SQL with relational databases.
• Experience integrating data with Salesforce and other enterprise systems, with working knowledge of Python for data processing or automation.
• Experience with cloud platforms and modern data ecosystems (Azure preferred) and strong communication/collaboration skills.

Responsibilities

• Design, develop, and maintain complex ETL solutions using Informatica PowerCenter and/or IICS to support enterprise data integration and reporting needs.
• Build and optimize data pipelines, transformations, and workflows aligned to data warehousing and integration best practices.
• Partner with application and business teams to integrate data from Salesforce and other enterprise platforms.
• Ensure data quality, reliability, and performance through monitoring, troubleshooting, root cause analysis, and optimization of ETL processes.
• Contribute to cloud-based data initiatives and support continuous improvement of data engineering standards, documentation, and delivery practices.

Skills

Informatica

ETL design

SQL

Salesforce

Python

Cloud platforms

Tools

Informatica PowerCenter

IICS

Job description

John Hancock, a Manulife Financial subsidiary, seeks a Senior ETL Developer to design, build, and maintain enterprise data integration pipelines using Informatica PowerCenter/IICS, SQL, and cloud platforms in a regulated financial services environment.

You will partner with business and technology teams, optimize data pipelines, and support Salesforce integrations while ensuring data quality and performance.