Backend Engineer (ETL)

Manulife - Boston, MA4.0

Full-timeEstimated: $100,000 - $130,000 a year
EducationSkills
Are you looking for unlimited opportunities to develop and succeed? With work that challenges and makes a difference, within a flexible and supportive environment, we can help our customers achieve their dreams and aspirations.

Job Description

Are you looking for unlimited opportunities to develop and succeed? With work that challenges and makes a difference and a flexible and supportive environment, we can help our customers achieve their dreams and aspirations.Manulife/John Hancock is on an exciting journey to transform to an agile way of working. Our vision is to delight our customers by making data-driven, human-centered design prioritizations within our agile squads. We foresee a highly engaged and skilled workforce executing on this vision.

We are looking for a Backend Engineer to join our agile development and support team within our John Hancock Investments division.

In this role you will support and grow a datawarehouse solution and contribute to the design and development of ETL solutions using Informatica Data Integration. You will also be involved in projects related to other technologies used within John Hanock Investments.

Are you interested to solve critical problems for the future of our business? If you are passionate about delivering value, we would like to talk to you.

Responsibilities:
Deliver cloud based solutions to enable and support business operations
Collaborate with project analysts and data architect to create ETL high level and detail design mapping specifications in line with established standards.
Develop Informatica objects to meet the technical specification requirements.
Build stored procedures to effectively return datasets for multiple platforms.
Demonstrate a systemic thought process through all phases of software development ( Agile).
Participate in open discussions during the analysis and design phases of developmen
Build ad-hoc queries to assist the business and the technology group.
Partner with client and offshore, supporting and monitoring systems as needed

You will bring:
Experience working on a data interchange system that includes a wide array of varying data sets
Experience with ETL tools ( Informatica power center, Data stage etc)
Experience developing a data analytics ETL environment to support data analytics
Experience with Structured Query Language (“SQL”) ( Oracle, SQL).
You have curiosity for constant learning from both success and failure, remaining open to change and continuous improvement
Excellent organizational and problem-solving abilities that enable you to manage through creative abrasion
Strong verbal and written communication with the ability to effectively articulate and communicate technical vision, possibilities, and outcomes across all levels in the organization
Understanding of the fundamentals of capital markets or financial services in support of our service or product offerings (or are ready to learn by doing)

Preferred Qualifications:
You have experience accessing Flat file, Salesforce ( CRM tool) and you you have worked with customers in data validation, troubleshooting, or collecting business requirements;
Experience performing database development using SQL or Procedural Language/Structured Query Language (“PL/SQL”)
Experience working with Tableau visualizations.
Education

Bachelor Degree in Science, Technology, Engineering, Mathematical areas of study

If you are ready to unleash your potential it’s time to start your career with Manulife/John Hancock.

About Manulife
Manulife Financial Corporation is a leading international financial services group that helps people achieve their dreams and aspirations by putting customers' needs first and providing the right advice and solutions. We operate as John Hancock in the United States and Manulife elsewhere. We provide financial advice, insurance, as well as wealth and asset management solutions for individuals, groups and institutions. At the end of 2016, we had approximately 35,000 employees, 70,000 agents, and thousands of distribution partners, serving more than 22 million customers. At the end of 2016, we had $977 billion (US$728 billion) in assets under management and administration, and in the previous 12 months we made almost $26 billion in payments to our customers.

Our principal operations are in Asia, Canada and the United States where we have served customers for more than 100 years. With our global headquarters in Toronto, Canada, we trade as 'MFC' on the Toronto, New York, and the Philippine stock exchanges and under '945' in Hong Kong.

Manulife is committed to supporting a culture of diversity and accessibility across the organization. It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will consult with applicants contacted to participate at any stage of the recruitment process who request an accommodation. Information received regarding the accommodation needs of applicants will be addressed confidentially.