Senior ETL Developer

The Senior ETL Developer plays a critical role in designing, developing, and maintaining enterprise‑grade data integration solutions that support analytics, reporting, and operational decision‑making. In this role, you will leverage deep expertise in Informatica, SQL, and cloud‑based data platforms to build scalable, reliable ETL pipelines. You will collaborate closely with business partners, architects, and cross‑functional technology teams to integrate data across core enterprise systems while ensuring data quality, performance, and compliance. This position supports complex data initiatives within a regulated financial services environment.
 

Position 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.

Required Qualifications

• 7–10+ years of overall experience in software and data engineering within large enterprise environments.

• 5+ years of hands‑on experience 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.

• Practical experience integrating data with Salesforce and other enterprise systems, with working knowledge of Python for data processing or automation.

• Experience working with cloud platforms and modern data ecosystems (Azure preferred), along with strong communication and cross‑functional collaboration skills.

Preferred Qualifications

• Familiarity with middleware and integration technologies such as MuleSoft.

• Prior experience in Life Insurance, Long‑Term Care, Annuities, or other regulated financial services environments.

• Experience supporting enterprise data modernization or cloud migration initiatives.

• Exposure to data governance, data quality, or regulatory reporting requirements.

• Ability to mentor junior developers and contribute to technical design discussions

When You Join Our Team

• • We’ll empower you to learn and grow the career you want.

• • We’ll recognize and support you in a flexible environment where well‑being and inclusion are more than just words.

• • As part of our global team, we’ll support you in shaping the future you want to see.

If you are applying to this role in Massachusetts, please note the salary range is $107,450.00 - $199,550.00 USD. Additionally, employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

The role being advertised is an existing vacancy.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resource