Company Profile:

Sun Life is a leading financial services company with history of 150+ years that helps our clients achieve lifetime financial security and live healthier lives. We serve millions in Canada, the U.S., Asia, the U.K., and other parts of the world. We have a network of Sun Life advisors, third-party partners, and other distributors. Through them, we’re helping set our clients free to live their lives their way, from now through retirement. We’re working hard to support their wellness and health management goals, too. That way, they can enjoy what matters most to them. And that’s anything from running a marathon to helping their grandchildren learn to ride a bike. To do this, we offer a broad range of protection and wealth products and services to individuals, businesses, and institutions, including: Insurance. Life, health, wellness, disability, critical illness, stop-loss, and long-term care insurance. Investments. Mutual funds, segregated funds, annuities, and guaranteed investment products Advice. Financial planning and retirement planning services Asset management. Pooled funds, institutional portfolios, and pension funds.

Job description:

Your scope of work / key responsibilities:

Understand the project scope, identify activities/ tasks, task level estimates, schedule, dependencies, risks and provide inputs to Program Lead for review.
Develop a robust ETL solutions which can best meet the business requirements for investments applications.
Analyze the data sources, be it a RDBMS, CSV file, Salesforce, IMS or any other data source.
Understanding of scheduling tools like ZEKE/Autosys.
Prepare/Modify design documents (High level design and Detailed design documents) based on business requirements.
Suggest changes in design on technical grounds.
Work on the functional and technical upgrades of the application.
 Coordinate delivery of the assigned tasks with the onshore Partners or/and Business Analyst.
 Ensure timely notification and escalation of possible issues/problems, options and
recommendations for prompt resolution.
Follow development standards to ensure that code is clear, efficient, logical and easily
maintainable.
Create and maintain application documentation like Network diagrams, Technical project
handbook, technical data mapping doc, unit test documents, implementation plan.
Ensure SLF Information Security Policies and General Computing Control is compiled to in all situations.
Take complete ownership of work assignments and ensure the successful completion of assigned tasks.
Solid engineering, system administration/ provisioning, software development (programming), support, testing and system infra provisioning foundation.
Ability to develop moderate complexity code with Zero defect (e.g., functionality, business logics, formulas), written to be read as well as executed.
Effectively utilize multiple software development methodologies e.g., TDD, DDD, along with secure coding practices, development best practices and Agile/ DevOps principles.
Contribute in continuous improvement.

Key Qualifications and experience:

A degree in Computer Science, related technology degree, or equivalent experience.
Minimum 5 to 8 years of overall IT experience.
Strong knowledge of ETL (Informatica PowerCenter), IICS (Informatica Intelligent Cloud
Services)
Hands on experience on CDI (Cloud Data Integration) development, implementation &
support.
Relational databases (Microsoft SQL Server), Oracle, Postgres
Scheduling tools like Zeke, Autosys etc.
Good knowledge on scripting (Unix/Windows).
Hands on experience on CAI (Cloud Application Integration) development, implementation & support.
Experience with various DevOps tools - source code management tools such as Jenkins, Bit bucket, CI CD tools – Ansible, CDD etc.
Knowledge on Insurance Industry domain.