• Work with other DW team members to develop Informatica IICS/IDMC and Power Center mappings and Snowflake/Oracle procedures to satisfy business requirements.
• Analyze data requirements and their impact to the system.
• Perform administrative duties for IICS/IDMC and Informatica Power Center.
• 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.

• University Degree, preferably in Computer Science.
• 3+ years of experience with Snowflake SQL and Oracle PL/SQL development.
• 3 + years of experience with ETL informatica development in IICS and Power Center.
• 3 + years of development experience with Oracle database.
• 2+ years of experience with Snowflake data warehouse environment.
• 1+ years of experience with AWS.

• Experience in a Data Warehouse/Business Intelligence environment.
• 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.

• Flexible working arrangements - 100% remote, hybrid, and in office options
• Competitive total compensation, including company contributions to your group RRSP without a matching requirement from you
• Comprehensive health benefits that start on your first day, with 100% employer-paid premiums, that include up to $5000 annually for mental health services and therapy
• Parental leave top-up to 100% of your salary for a period of 25 weeks
• Up to $650 for home office equipment
• Generous time off policy, including 2 paid days annually to volunteer at a charity of your choice
• Diversity and inclusion programs, including an active network of Employee Resource Groups
• Extensive professional development opportunities, including access to over 11,000 training and development courses, tuition reimbursement, and monetary rewards for completing a required designation
• We care a lot about fostering a compassionate, people-centric culture, and are proud to have been named one of Canada’s Top 100 employers for the last five years.

• Canada's Top 100 Employers

o Greater Toronto's Top Employers
o Canada's Top Family-Friendly Employers
o Canada's Top Employers for Young People

• Great Place To Work® Certified

o Best Workplaces for Inclusion
o Best Workplaces for Mental Wellness
o Best Workplaces for Today's Youth
o Best Workplaces for Women
o Best Workplaces in Financial Services & Insurance
o Best Workplaces in Ontario
o Best Workplaces with Most Trusted Executive Teams

• Linked In Top Companies in Canada

• Human Resource Director (HRD) - Best Place To Work

o HRD - 5-Star Benefit Program
o HRD - 5-Star Diversity & Inclusion Employer