Senior ETL & Data Warehouse Engineer

Fidelity Canada; Toronto; On-site; CAD 123,000 - 152,000; Full time

Benefits offered by this job

Flexible working arrangements

RRSP contributions

Health benefits

Parental leave top-up

Home office budget

Volunteer days

Professional development

Job summary

Fidelity Canada is seeking a Senior ETL/Data Integration professional to develop and support its data integration efforts across the Data Warehouse and CRM platforms. The role involves building mappings, procedures, and on-call support to ensure data availability and performance.

The candidate should have substantial experience with Informatica PowerCenter or IDMC, Snowflake, Oracle, and AWS, and will mentor others while collaborating with business teams on data initiatives.

Qualifications

• University Degree, preferably in Computer Science or equivalent work experience.
• ,
• ],
• job_responsibilities_description":[

Responsibilities

• Develop and support ETL data integration solutions for Fidelity Canada.
• Analyze data and develop Informatica IICS/Power Center mappings and Snowflake SQL & Oracle PL/SQL procedures.
• Administer Informatica IICS and Power Center tools and provide on-call support.
• Create ETL mappings, Mapplets, Workflows, and integration components.
• Collaborate with partners and SMEs to design technical data warehouse solutions.
• Mentor developers on ETL best practices and data modeling standards.
• Lead technical aspects as SME for new data domains.

Skills

ETL development

Informatica PowerCenter

IDMC

SQL

PL/SQL

Oracle

Snowflake

AWS

Data modelling

Education

University degree in CS or related field

Tools

Informatica PowerCenter

Informatica IICS

Snowflake

Oracle SQL

Job description

Fidelity Canada is seeking a Senior ETL/Data Integration professional to develop and support its data integration efforts across the Data Warehouse and CRM platforms. The role involves building mappings, procedures, and on-call support to ensure data availability and performance.

The candidate should have substantial experience with Informatica PowerCenter or IDMC, Snowflake, Oracle, and AWS, and will mentor others while collaborating with business teams on data initiatives.