ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.

Overview

Join to apply for the ETL Developer - Informatica PowerCenter role at Aviva Canada.

What You'll Do

• Design, develop, and maintain ETL (Informatica Power Center) processes to extract, transform, and load data from various sources into our finance systems.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Monitor daily/monthly jobs and resolve failures.
• Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.
• Build Qlik reports.
• Perform data analysis and solve data-related issues.
• Implement data quality checks and validation processes.
• Provide solutions by building complex Finance calculations using PostgreSQL st...