ETL Developer - Informatica PowerCenter

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 stored procedures or ETL.
• Monitor and improve the performance of ETL processes and database systems.
• Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.
• Stay up to date with the latest industry trends and best practices in ETL and database management.

What You'll Bring

What You’ll Get

Please note that we may use AI tools to help us through the recruitment process. This is an existing position which has been posted both internally & externally.

Aviva Canada has an accommodation process in place to provide accommodations for employees with disabilities. If upon commencement of employment you require a specific accommodation because of a disability, please contact your Talent Acquisition Partner so that an appropriate accommodation can be arranged. This process applies throughout your career with Aviva Canada.

Seniority level

Entry level

Employment type

Full-time

Job function

Business Development and Sales

Industries

Insurance

#J-18808-Ljbffr