Senior Data Engineer

The Opportunity

John Hancock/ Manulife is looking for a technically strong hands-on, collaborative Senior Data Engineer with Informatica experience who can bring thought leadership to the table and can build fabulous experiences for our customers.

Work location: Boston - USA (ideally) or Toronto - Canada

Work arrangement: Hybrid - 3 days in office, 2 days from home; Remote working arrangement is not available.

Position Responsibilities:

• Builds, codes, tests, maintain high quality software

• Participates in Agile sprints and ceremonies; supports rapid iteration and development

• Design, develop, and implement data integration solutions using Informatica PowerCenter to support business requirements.

• Collaborate with business analysts and stakeholders to understand data needs and translate them into technical specifications.

• Develop and maintain data mappings, transformations, and workflows within Informatica PowerCenter.

• Optimize and tune ETL processes for efficiency and performance.

• Manage and maintain database systems, ensuring data integrity and security.

• Develop scripts for automation and improved data processing.

• Troubleshoot and resolve issues related to data integration and ETL processes.

• Document technical specifications and maintain comprehensive records of development activities.

• Participate in code reviews to ensure best practices and quality standards are met.

• Work with cross-functional teams to support data-related projects and initiatives.

• Experience in Java is preferred but not required.

• Performs various investigative "Spikes" in order to mitigate technical uncertainty and risk

• Updates progress daily through the tracking tool (Jira) or Kanban board

• Completes and ensures completion of any required documentation required e.g. deployment, maintenance, support and business needs

• Participate in the weekly Look Ahead meetings to assist the Product Owner to refine the Product Backlog including providing initial estimates

• Apply disciplined coding practices to enable agility and delivery of high quality code

Required Qualifications:

• Minimum 8 years’ experience with IT experience

• Proven experience of over 5 Years as an Informatica Developer, with expertise in Informatica PowerCenter 10.5 and up.

• Strong understanding of database systems, preferably with experience in DBMS such as DB2.

• Proficiency in scripting languages such as Python, Shell, or Perl.

• Experience with data modeling, data warehousing, and data integration concepts.

• Experience with performance tuning and optimization of ETL processes.

Preferred Qualifications:

• Bachelor’s Degree or equivalent in Computer Science

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.

#LI-JH

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 employ