Remote ETL Developer: Snowflake/Oracle, AWS

Fidelity Canada; Toronto; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading financial services firm in Ontario is seeking an ETL Developer to handle data integration solutions. This role requires expertise in Snowflake SQL and Oracle PL/SQL, alongside experience with Informatica. The position is 100% remote, providing opportunities for growth within an inclusive workplace. Competitive compensation and comprehensive benefits are offered, fostering a supportive and valued cultural environment.

Benefits

Flexible working arrangements

Competitive total compensation

Comprehensive health benefits

Parental leave top-up

Home office equipment allowance

Generous time off policy

Diversity and inclusion programs

Professional development opportunities

Qualifications

• 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.

Responsibilities

• Analyze data and develop Informatica IICS and Power Center mappings.
• Perform administrative duties for IICS/IDMC and Informatica Power Center.
• Execute unit tests to ensure code accuracy and data integrity.
• Participate in team’s on-call support schedule.

Skills

Data Warehouse/Business Intelligence experience

data modelling tools

development in Mutual Funds industry

technical and data analysis skills

problem solving skills

customer service oriented

good communication skills

Education

University Degree in Computer Science or equivalent work experience

Tools

Informatica IICS

Power Center

Snowflake

Oracle PL/SQL

AWS

Job description

A leading financial services firm in Ontario is seeking an ETL Developer to handle data integration solutions. This role requires expertise in Snowflake SQL and Oracle PL/SQL, alongside experience with Informatica. The position is 100% remote, providing opportunities for growth within an inclusive workplace. Competitive compensation and comprehensive benefits are offered, fostering a supportive and valued cultural environment.