ETL Developer - Informatica PowerCenter

Aviva Canada; Markham; On-site; CAD 75,000 - 95,000; Full time

Benefits offered by this job

Competitive salary

Annual bonus eligibility

Health benefits

Flexible vacation package

Corporate wellness programs

Job summary

A leading insurance company is seeking an Entry Level ETL Developer to design and maintain ETL processes, focusing on data integration within finance systems. The ideal candidate has expertise in ETL tools and PostgreSQL, complemented by experience in the insurance industry. This role offers a competitive compensation package, professional development opportunities, and a hybrid work model.

Qualifications

• Experience in the insurance industry with a solid understanding of underwriting data.
• Demonstrable experience as an ETL Developer, particularly with Informatica.
• Proven experience in writing complex SQL queries and supporting finance systems.

Responsibilities

• Design and maintain ETL processes to integrate data into finance systems.
• Develop and optimize SQL queries in PostgreSQL.
• Collaborate with teams to ensure data accuracy and integrity.

Skills

ETL development expertise

PostgreSQL proficiency

SQL query optimization

Problem-solving skills

Data analysis

Education

Bachelor’s degree in computer science or related field

Tools

Informatica PowerCenter

Qlik

Control-M

Job description

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

• Experience in the insurance industry and ability to understand underwriting data terminology.
• Experience in supporting finance systems.
• Demonstrable experience as an ETL Developer (Informatica PowerCenter and Informatica BDM).
• Experience as a PostgreSQL Developer.
• Proven experience as a Database Developer, hands-on experience in writing DDLs and DMLs for relational databases.
• Experience in writing complex SQL queries for ad hoc reporting.
• Expertise in ETL tools (especially Informatica) and PostgreSQL.
• Strong expertise in PostgreSQL and database design.
• Knowledge of data warehousing concepts and best practices.
• Experience with automation tools like Control-M, UNIX scripting experience.
• Experience in Qlik & Python reporting (nice to have).
• Experience with Snowflake (nice to have).
• Excellent problem-solving skills and attention to detail.
• Experience in Agile methodology & JIRA.
• Good communication and collaboration skills.
• Ability to work independently and as part of a team.
• Bachelor’s degree in computer science, information technology, or a related field preferred, but equivalent experience will also be considered.
• Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.
• Knowledge of data visualization tools (e.g., Qlik, Python, Power BI) an asset.

What You’ll Get

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
• Outstanding career development opportunities.
• Professional development support.
• Competitive vacation package with flexibility to purchase additional days.
• Employee-driven programs focused on diversity and inclusion.
• Corporate wellness programs to support physical and mental health.
• Hybrid flexible work model.

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