ETL Developer

Fidelity Canada • Toronto, ON

1d • CA$46 - CA$65 • Remote

About The Position

You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement. This is a fixed-term contract position until February 2027. 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. The BI & CRM support group provides support for Customer Relationship Management, Data Warehouse and Business Intelligence applications for Fidelity Investments Canada.

Requirements

• 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
• Current work authorization for Canada is required for all openings.

Nice To Haves

• 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

Responsibilities

• Responsible for all aspects related to development and support of ETL data integration solutions for Fidelity Canada.
• 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.
• Working closely with other team members to ensure application availability, system maintenance, and on-call support.
• 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.

Benefits

• Flexible, hourly compensation model that reflects your expertise and the value you bring.
• Hourly rate ranges from $46.00 to $65.00, based on experience and qualifications.
• Market-aligned rates that recognize the specialized skills and agility required for this role.
• Compensation package that aligns with provincial pay transparency requirements.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree