[Hiring] ETL Developer @Fidelity Canada

Role Description

You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement. Please note that this is a fixed-term contract position until February 2027.

Working with us means you’ll be part of a diverse and dedicated group of people who make a real difference for our clients and communities every day. You’ll have a wide range of opportunities to grow and develop your career in an inclusive environment where you’ll feel valued and supported to be your best - both personally and professionally.

Business Overview

The BI & CRM support group provides support for Customer Relationship Management, Data Warehouse and Business Intelligence applications for Fidelity Investments Canada.

What You Will Do

• Responsible for all aspects related to development and support of ETL data integration solutions for Fidelity Canada.
• Analyze data and develop Informatica IICS and Power Center mappings and Snowflake SQL & Oracle PL/SQL procedures based on specific business requirements.
• Administration of Informatica IICS and Power Center tools.
• Work closely with other team members to ensure application availability, system maintenance, and on-call support.

The Value You Deliver

• Work with other DW team members to develop Informatica IICS/IDMC and Power Center mappings and Snowflake/Oracle procedures to satisfy business requirements.
• Analyze data requirements and their impact to the system.
• Perform administrative duties for IICS/IDMC and Informatica Power Center.
• Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met.
• Participate in team’s on-call support schedule, work on incident and enhancement/maintenance tickets assignments and deliver excellent technical support.
• Create and maintain technical documents, including data models.

Qualifications

• University Degree, preferably in Computer Science or equivalent work experience.
• 3+ years of experience with Snowflake SQL and Oracle PL/SQL development.
• 3+ years of experience with ETL Informatica development in IICS/IDMC.
• 3+ years of development experience with Oracle database.
• 2+ years of experience with Snowflake data warehouse environment.
• 1+ years of experience with AWS.

Requirements

• Experience in a Data Warehouse/Business Intelligence environment.
• Experience with data modelling tools.
• Development experience in Mutual Funds industry is an asset.
• Strong technical and data analysis skills.
• Excellent problem-solving skills.
• Customer service oriented.
• Good communication skills.
• Current work authorization for Canada is required for all openings.

Benefits

• This contract role offers a flexible, hourly compensation model that reflects your expertise and the value you bring. The hourly rate ranges from $46.00 to $65.00, based on experience and qualifications.
• We offer market-aligned rates that recognize the specialized skills and agility required for this role.
• We’re proud to offer a compensation package that aligns with provincial pay transparency requirements.