Senior Data Engineer

Manulife • Boston, MA

22h • $104,860 - $194,740 • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

• Bachelor’s Degree or equivalent in Computer Science
• Experience in Java is preferred but not required.

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees