Job Description

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

• University Degree, preferably in Computer Science
• 5+ years of leadership experience
• 7+ years of experience with ETL informatica development Power Center
• 2+ years of experience with ETL informatica development IPAAS
• 7+ years of experience with SQL and PL/SQL development
• 7+ years of development experience with Oracle database
• 2+ years of experience with Snowflake data warehouse environment
• 1+ years of experience with AWS
• 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

isgSearch