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 Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact [email protected].

Referenced Salary Location

Salary range is expected to be between

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact [email protected] for the salary range for your location.

Manulife/John Hancock offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension/401(k) savings plans and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in the U.S. includes up to 11 paid holidays, 3 personal days, 150 hours of vacation, and 40 hours of sick time (or more where required by law) each year, and we offer the full range of statutory leaves of absence.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement.

Know Your Rights I Family & Medical Leave I Employee Polygraph Protection I Right to Work I E-Verify