Talent.com
ETL Developer
ETL DeveloperFidelity Canada • Toronto, ON, CA
ETL Developer

ETL Developer

Fidelity Canada • Toronto, ON, CA
30+ days ago
Job type
  • Full-time
Job description

Join to apply for the Data Engineer role at Fidelity Canada

Job Description

You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement. Current work authorization for Canada is required for all openings. At Fidelity, we’ve been helping Canadian investors build better financial futures for over 35 years. We offer individuals and institutions a range of trusted investment portfolios and services, and we’re constantly seeking to find new and better ways to help our clients. As a privately owned company, we boldly embrace innovation in all areas as we continue to grow our business into the future.

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

You will be responsible for all aspects related to development and support of ETL data integration solutions for Fidelity Canada. This includes analyzing data and developing 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, and working 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.

What We’re Looking For

  • 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
  • The Skills You Bring

  • 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.
  • Some of the Ways We’ll Help You Feel Valued and Supported as Part of Our Team

  • Flexible working arrangements – 100% remote, hybrid, and in office options
  • Competitive total compensation, including company contributions to your group RRSP without a matching requirement from you
  • Comprehensive health benefits that start on your first day, with 100% employer‑paid premiums, that include up to $5,000 annually for mental health services and therapy
  • Parental leave top‑up to 100% of your salary for a period of 25 weeks
  • Up to $650 for home office equipment
  • Generous time off policy, including 2 paid days annually to volunteer at a charity of your choice
  • Diversity and inclusion programs, including an active network of Employee Resource Groups
  • Extensive professional development opportunities, including access to over 11,000 training and development courses, tuition reimbursement, and monetary rewards for completing a required designation
  • We care a lot about fostering a compassionate, people‑centric culture, and are proud to have been named one of Canada’s Top 100 employers for the last five years.
  • Fidelity Canada is an Equal Opportunity Employer

    Fidelity Canada is committed to fostering a diverse and inclusive workplace. We will consider all qualified applicants for employment regardless of race, color, religion, sex, sexual orientation, gender identity or expression, national or ethnic origin, age, disability, family status, protected veterans’ status, Aboriginal / Native American status or any other legally protected ground.

    Accommodation During the Application Process

    Fidelity Canada welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in the selection process. If you require an accommodation, please email us at FidelityCanadaStaffing@fidelity.ca.

    No Telephone Inquiries or Agencies Please

    We thank all applicants for their interest. We will only contact those selected for an interview.

    Why Work at Fidelity?

    We are proud to be recipients of the following awards :

    Awards

  • Canada's Top 100 Employers
  • Greater Toronto's Top Employers
  • Canada's Top Family-Friendly Employers
  • Canada's Top Employers for Young People
  • Great Place To Work® Certified
  • Best Workplaces for Inclusion
  • Best Workplaces for Mental Wellness
  • Best Workplaces for Today's Youth
  • Best Workplaces for Women
  • Best Workplaces in Financial Services & Insurance
  • Best Workplaces in Ontario
  • Best Workplaces with Most Trusted Executive Teams
  • LinkedIn Top Companies in Canada
  • Human Resource Director (HRD) – Best Place To Work
  • HRD – 5-Star Benefit Program
  • HRD – 5-Star Diversity & Inclusion Employer
  • Designations

  • Canadian Compassionate Companies – Certified
  • Benefits Canada's Workplace Benefits Award – Future of Work Strategy
  • TalentEgg National Recruitment Excellence Award – Special Award for Diversity & Inclusion in Recruiting
  • Canadian HR Reporter's Most Innovative HR Team
  • Seniority level : Mid‑Senior level

    Employment type : Full‑time

    Job function : Information Technology

    Referrals increase your chances of interviewing at Fidelity Canada by 2x.

    Location : Toronto, Ontario, Canada. Salary : CA$80,000.00 – CA$120,000.00

    #J-18808-Ljbffr

    Create a job alert for this search

    Etl Developer • Toronto, ON, CA

    Similar jobs
    ETL TESTER

    ETL TESTER

    Pyxidia Techlab LLP • Toronto, ON, Canada
    Full-time
    We are seeking a skilled ETL Tester with substantial hands-on experience in advanced SQL and Python.This role is open to candidates with either a Quality Assurance (QA) or Developer background, pro...Show more
    Last updated: 23 days ago • Promoted
    Senior ETL Developer (Talend) - toronto

    Senior ETL Developer (Talend) - toronto

    TekStaff IT Solutions • toronto, on, ca
    Full-time
    Involved in end-to-end ETL / ELT architectures using Talend (Studio, TAC, Data Integration, Real-Time Big Data, Data Quality). Select integration patterns (batch, micro-batch, streaming) aligned to bu...Show more
    Last updated: 20 hours ago • Promoted • New!
    Electrical hardware Developer

    Electrical hardware Developer

    SciCan • Greater Toronto Area, Canada
    Full-time
    We currently have an opening within our Research & Development team for an Electrical Hardware Developer.Design and development of new products, accessories and spare parts, and engineering support...Show more
    Last updated: 10 days ago • Promoted
    BI & ETL Tester - Hybrid

    BI & ETL Tester - Hybrid

    Software International • Toronto, ON, Canada
    Temporary
    Fortune 100 / 500 / 1000 companies to small and mid-sized organizations in Canada / US and Europe.We currently have a multiple, re-extendable, long term contract roles as a. SAP consulting client, working...Show more
    Last updated: 27 days ago • Promoted
    Senior ETL Developer - AWS, Kafka, Netezza

    Senior ETL Developer - AWS, Kafka, Netezza

    Astra North Infoteck Inc. • Toronto, ON, ca
    Full-time
    Quick Apply
    Required Skills : Netezza~Sybase Database~SQL Server 2012 Reporting Services(SSRS)~SQL Server 2012 Integration Services (SSIS). Essential Skills : ETL Developer.Resource have strong data warehouse tec...Show more
    Last updated: 9 days ago
    ETL & Functional Tester ( Canada Only)

    ETL & Functional Tester ( Canada Only)

    Divine Match Talent • Toronto, ON, Canada
    Full-time
    Our client is a leading provider of innovative healthcare technology solutions focused on organ transplantation and allocation. They deliver powerful, scalable platforms that support national-level ...Show more
    Last updated: 30+ days ago • Promoted
    Lead Data Engineer - Private Equity & Portfolio Support - Toronto (Hybrid role)

    Lead Data Engineer - Private Equity & Portfolio Support - Toronto (Hybrid role)

    Saragossa • Greater Toronto Area, Canada, Canada
    Full-time
    If you're an experienced data engineering professional with a buy side financial background who's ready for their next challenge, consider this greenfielf contract-to-hire opportunity.My client is ...Show more
    Last updated: 21 hours ago • Promoted • New!
    Senior ETL Developer (Talend)

    Senior ETL Developer (Talend)

    TekStaff IT Solutions • Toronto, ON, Canada
    Full-time
    Involved in end-to-end ETL / ELT architectures using Talend (Studio, TAC, Data Integration, Real-Time Big Data, Data Quality). Select integration patterns (batch, micro-batch, streaming) aligned to bu...Show more
    Last updated: 21 hours ago • Promoted • New!
    ETL Informatica Developer

    ETL Informatica Developer

    Cognizant • Toronto
    Full-time
    Get AI-powered advice on this job and more exclusive features.We Are Cognizant Artificial Intelligence.Digital technologies, including analytics and AI, give companies a once-in-a-generation opport...Show more
    Last updated: 14 days ago • Promoted
    DSP Engineer (Markham)

    DSP Engineer (Markham)

    Evertz Microsystems Limited • Markham, ON, Canada
    Full-time
    We are looking for DSP engineers responsible to work on DSP algorithm design and implementation on heterogeneous platforms, including CPU, GPU and FPGA.Architect solutions ...Show more
    Last updated: 30+ days ago • Promoted
    Senior Analyst

    Senior Analyst

    Vaco by Highspring • Richmond Hill, ON, CA
    Temporary
    Our client is sourcing a Senior Analyst for a 6-month contract.Responsible for month-end, quarter-end, and annual close process in accordance with company requirements. Responsible for expense reimb...Show more
    Last updated: 10 days ago • Promoted
    Algebra Private Tutoring Jobs Aurora

    Algebra Private Tutoring Jobs Aurora

    Superprof • Aurora, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    FRONT-END DEVELOPER

    FRONT-END DEVELOPER

    Finlink Group • Richmond Hill, ON, Canada
    Full-time
    Bring ideas to life with code that feels as smooth as it looks.We’re searching for a talented Front-End Developer who’s passionate about building sleek, scalable, and intuitive web appl...Show more
    Last updated: 30+ days ago • Promoted
    Coupa Business Analyst

    Coupa Business Analyst

    Yochana • richmond hill, on, ca
    Full-time
    Job Title – Coupa Business Analyst (Procure to Pay).As a Business System Analyst, you will oversee the transformation, maintenance, and enhancement of the. You will collaborate with global cross-fun...Show more
    Last updated: 20 hours ago • Promoted • New!
    Product Development Project Manager - Lorex Technology

    Product Development Project Manager - Lorex Technology

    Lorex Technology • markham, on, ca
    Full-time
    Department of Position : Product Management.Reports to : Senior Director, Product and Technology.Candidates with less experience may be considered for a Product Development Project Specialist or Prod...Show more
    Last updated: 20 hours ago • Promoted • New!
    ETL Tech Lead

    ETL Tech Lead

    Hays • Toronto, ON, Canada
    Full-time
    You’ll be joining a leading organization committed to delivering innovative solutions that support strategic initiatives across the health information sector. The company values collaboration, excel...Show more
    Last updated: 20 days ago • Promoted
    ETL Tech Lead - toronto

    ETL Tech Lead - toronto

    Hays • toronto, on, ca
    Full-time
    You’ll be joining a leading organization committed to delivering innovative solutions that support strategic initiatives across the health information sector. The company values collaboration, excel...Show more
    Last updated: 9 days ago • Promoted
    Azure Data Engineer : Build Scalable ETL with Databricks & ADF

    Azure Data Engineer : Build Scalable ETL with Databricks & ADF

    Themesoft Inc. • Toronto
    Full-time
    A data engineering company in Toronto is looking for an Associate to design and optimize large-scale ETL / ELT pipelines using Databricks and PySpark. The ideal candidate must have strong expertise in...Show more
    Last updated: 18 days ago • Promoted