Application Analyst- Etl - North York, Canada - Sun Life

Sun Life

Verified Company

North York, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self.

You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you.

Your leaders will inspire and help you reach your potential and soar to new heights.

Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do.

Discover how you can make a difference in the lives of individuals, families and communities around the world.

Do you want to build and maintain data processing and transformation systems that will help run one of Canada's biggest financial institutions? Do you enjoy being part of a tight-knit, empowered team? Do you have experience in ASP.NET / VB.

NET and/or MS Access / Excel Marco? If so, we'd like to hear from you

We are looking for an ASP.NET / VB.NET with a strong technical background and cloud experience to join the Corporate Application Solutions (CAS) team.

This is an exciting opportunity to be part of the IT organization dedicated to excellent customer service through digital transformation, supporting continuous learning, career growth and diversity.

What will you do?

Provide ongoing support and maintenance of ASP.NET / VB.NET and related integration components, including oncall support on a rotation basis, problem analysis, resolution, and escalation.
Contribute to defining timetables, project plans and product roadmaps.
Configure and install software products, patches, vendor releases in multiple environments.
Provide recommendations and alternatives for system enhancements.
Take complete ownership of work assignments and ensure the successful completion of assigned tasks.
Create and maintain technical documentation for supported systems.
Ensure Sun Life Information Security Policies and GCC are adhered to in any solution.
Maintain effective communication with management, team members and the business.

What you need to succeed:

Bachelor's degree in computer science, computer engineering, or equivalent experience.
5+ years of experience working with complex technical environments involving multiple IT platforms. We use Windows, Unix, Linux, Cloud, and ETL technologies.
3+ years of experience creating ETL jobs using cloud technologies (e.g., Glue, Data Bricks).
Experience with Relational SQL (PostgreSQL, SQL Server) databases.
Strong knowledge of SQL query language able to perform all CRUD operations.
Experience in any objectoriented/object function scripting language, such as Python.
Experience with Windows/Linux/Unix scripting languages.
Proficient with the ITIL framework and processes such as Change, Incident, Problem and Configuration Management.

Preferred Skills:

Experience with ASP.Net, VB.NET, MS Access / Excel Macro, Crystal Reports.
Experience with integrating vendor packages into an established Production environment consisting of various technologies and platforms.
Knowledge of Active Directory, Single Sign-On and Web Hosting concepts.
Handson experience with DevOps tools (e.g., Git, Jenkins, SourceTree, Ansible).

Notes/Unique requirements:

Occasional weekend and afterhours work.
Oncall support as part of a rotation.
Occasional travel between Sun Life locations may be required depending on work assignments.
Must be able to obtain Reliability Status through the Government of Canada before a start date can be confirmed (includes a background check with fingerprinting by the RCMP).

At Sun Life we strive to create a flexible work environment where our employees are empowered to do their best work.

Several flexible work options are available and can be discussed throughout the selection process depending on the role requirements and individual needs.

We thank all applicants for showing an interest in this position. Only those selected for an interview will be contacted.

Salary Range:

58,700/ ,900/93 900

Job Category:

IT - Application Development

Posting End Date:

20/04/2023