Senior ETL Developer

The Senior ETL Developer plays a critical role in designing developing and maintaining enterprisegrade data integration solutions that support analytics reporting and operational this role you will leverage deep expertise in Informatica SQL and cloudbased data platforms to build scalable reliable ETL pipelines. You will collaborate closely with business partners architects and crossfunctional 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 rootcause analysis and optimization of ETL processes.

• Contribute to cloudbased data initiatives and support continuous improvement of data engineering standards documentation and delivery practices.

Required Qualifications

• 710 years of overall experience in software and data engineering within large enterprise environments.

• 5 years of handson 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 crossfunctional collaboration skills.

Preferred Qualifications

• Familiarity with middleware and integration technologies such as MuleSoft.

• Prior experience in Life Insurance LongTerm 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

• Well empower you to learn and grow the career you want.

• Well recognize and support you in a flexible environment where wellbeing and inclusion are more than just words.

• As part of our global team well 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 $107450.00 - $199550.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 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 .

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