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