Sr Data Warehouse Developer

 

Description:

 

The BI & CRM support group provides support for Customer Relationship Management, Data Warehouse and Business Intelligence applications for Fidelity Investments Canada.

Key Accountabilities

  • Work as an integrated member of the Data Warehouse technology team and drive cross functional data initiatives from beginning to end with various business units
  • Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems.
  • Strong experience in working with various source and target systems (Oracle, Snowflake, Sales Force, API, flat files) using informatica Power Center and iPaaS
  • Work with Salesforce CRM and BI team members to develop Informatica Power Center and iPaaS ETL and PL/SQL code to satisfy business requirements
  • Create ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter and iPaaS
  • Develop stored procedures, SQL queries and tune/optimize SQL code on Oracle and Snowflake databases
  • Perform administrative duties for Informatica Power Center application
  • 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
  • Mentor developers on best practice ETL and data modelling standards, drive and participate in design and code review sessions

 

Apply Now
You'll sign in or register, then come back to this job.
No resume yet? Make one free and apply.
Organization Fidelity Canada
Industry IT / Telecom / Software Jobs
Occupational Category SR Data warehouse Developer
Job Location Toronto, ON, Canada
Shift Type Morning
Job Type Full Time
Gender No Preference
Career Level Experienced Professional
Experience 7 Years
Posted at 2023-09-12 11:44 am
Expires on 2026-12-21