Logo of Huzzle

Home

Matches

Explore

Manage

Data Engineer

image

Fidelity Canada

Dec 2, 2024

  • Job
    Full-time
    Mid Level
  • Data
    IT & Cybersecurity
  • Toronto
    Remote
  • Quick Apply

AI generated summary

  • You need a degree in Computer Science, 3+ years with Snowflake SQL, Oracle PL/SQL, ETL Informatica, and Oracle DB, plus 2+ years in Snowflake and 1+ year in AWS.
  • You will develop and support ETL solutions using Informatica and Snowflake, analyze data requirements, perform administration tasks, execute unit tests, and create technical documents while providing on-call support.

Requirements

  • University Degree, preferably in Computer Science.
  • 3+ years of experience with Snowflake SQL and Oracle PL/SQL development.
  • 3+ years of experience with ETL informatica development in IICS and Power Center.
  • 3+ years of development experience with Oracle database.
  • 2+ years of experience with Snowflake data warehouse environment.
  • 1+ years of experience with AWS.

Responsibilities

  • 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.
  • 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, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support.
  • Create and maintains technical documents, including data models.

FAQs

Is this position fully remote?

Yes, this position is 100% remote as part of Fidelity’s dynamic working arrangement.

What kind of work is expected from a Data Engineer at Fidelity?

You will be responsible for the development and support of ETL data integration solutions, including analyzing data, developing mappings and procedures, and providing technical support.

What qualifications are required for the Data Engineer role?

A university degree, preferably in Computer Science, along with 3+ years of experience in Snowflake SQL, Oracle PL/SQL development, ETL Informatica development, and experience with AWS.

Are there any specific technologies I need to be familiar with?

Yes, candidates should have experience with Informatica IICS, Power Center, Snowflake, Oracle databases, and AWS.

Does Fidelity offer any benefits for mental health services?

Yes, Fidelity provides comprehensive health benefits that start on your first day, including up to $5000 annually for mental health services and therapy.

What is the company’s stance on diversity and inclusion?

Fidelity Canada is committed to fostering a diverse and inclusive workplace and actively encourages applications from qualified candidates regardless of their background.

Are there professional development opportunities available?

Yes, Fidelity offers extensive professional development opportunities, including access to over 11,000 training courses and tuition reimbursement.

Is there support for parental leave?

Yes, Fidelity provides a parental leave top-up to 100% of your salary for a period of 25 weeks.

What is the application process for candidates with disabilities?

Fidelity welcomes applications from individuals with disabilities and offers accommodations upon request during the selection process.

Can I expect competitive compensation?

Yes, Fidelity offers competitive total compensation, including company contributions to your group RRSP without a matching requirement from you.

image

Fidelity Canada

Finance
Industry
1001-5000
Employees
1987
Founded Year

Mission & Purpose

Fidelity Canada provides investment management services, offering a wide range of mutual funds, ETFs, and other financial products to help individuals and institutions achieve their financial goals. Their mission is to build better financial futures by delivering superior investment solutions, backed by in-depth research and expert management. Fidelity is committed to supporting investors with innovative strategies and personalized service, ensuring they can navigate complex markets and grow their wealth with confidence.