Senior Data Engineer

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

If you are applying for this role outside of the primary location, please contact [email protected] for the salary range for your location. 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. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

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.

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