Talent.com
Aviva Canada
ETL Developer - Informatica PowerCenterAviva Canada • Markham, York Region, Canada
ETL Developer - Informatica PowerCenter

ETL Developer - Informatica PowerCenter

Aviva Canada • Markham, York Region, Canada
30+ days ago
Job type
  • Full-time
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

#J-18808-Ljbffr

Create a job alert for this search

ETL Developer - Informatica PowerCenter • Markham, York Region, Canada

Similar jobs

Microgrid System Developer - Energy Management & Control

Huawei CanadaMarkham, York Region, CA
Full-time +1

Microgrid System Developer - Energy Management & Control.Huawei Canada has an immediate permanent opening for a Microgrid System Developer.The Smart Grid Technology Lab’s research focuses on Power ... Show more

 • Promoted

Business Support Analyst (Application Support)

Green Infrastructure PartnersMarkham
Full-time

Reporting to the Business Operations Manager, the Business Support Analyst will provide application support for core business systems used to manage construction and project operations.This role fo... Show more

 • Promoted

Informatica Developer

RaiseToronto, Ontario, Canada
Full-time

Duration: 6 months - Potential for extension.Hybrid: Every Monday and the first Friday of the month.Hours/week, 9-5 Monday to Friday.Interview Process: 2 rounds of interviews.RISK SERVICES TECHNOLO... Show more

 • Promoted

Etl Developer & Qa For Unicef Fundraising

UNICEF CanadaToronto, Canada
Full-time

Join UNICEF Canada as a Data Integration Developer & QA to create ETL solutions that support child welfare initiatives.Your role will be crucial in a flexible hybrid setting.As part of UNICEF C... Show more

 • Promoted

Java ETL Developer for Efficient Workflows

ScotiabankToronto, ON, CA
Full-time

Elevate data solutions as a detail-oriented Java ETL Developer.Focus on designing and developing processes that enhance data integration across applications.In this role, you will collaborate with ... Show more

 • Promoted

Vertical Lead Generation Specialist

TP-Link Canada Inc.Richmond Hill, York Region, CA
Full-time

Be among the first 25 applicants.Founded in 1996, TP-Link is a global provider of reliable networking devices and accessories, involved in all aspects of everyday life.Supplying reliable networking... Show more

 • Promoted

Talend Lead Developer — ETL & Data Integration

Aarorn Technologies IncToronto, Ontario, Canada
Full-time

A technology firm is seeking a highly skilled Talend Lead Developer in Toronto, ON to design and optimize ETL workflows.The successful candidate will lead data engineering initiatives, ensuring dat... Show more

 • Promoted

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto
Full-time

We are on the lookout for a Senior ETL Developer with expertise in DataStage and Talend to lead our ETL initiatives.Enhance enterprise data integration and analytics through your skills.As a Senior... Show more

 • Promoted

IT Support Analyst

360°kidsMarkham, Ontario, Canada
Full-time

Kids is a vitally important community agency serving all of York Region.We have been a leader in the delivery of innovative support services for more than 35 years and work to improve the lives of ... Show more

 • Promoted

Developer

Absorb SoftwareToronto, Ontario, Canada
Full-time

Absorb is seeking an intermediate-level Developer to take ownership of an internal ETL tool that supports billing, accounting, and operations.In this individual contributor role, you’ll help mainta... Show more

 • Promoted

Remote Construction ERP Support Analyst – Evening Shift

SRA GroupMarkham, York Region, CA
Remote
Full-time

A leading construction software provider is seeking a Customer Support Analyst to support clients using ERP modules like Job Costing and Payroll.This remote position requires a late shift after tra... Show more

 • Promoted

Remote Senior Data Engineer: Scalable ETL & Data Platform

LumenaltaToronto, Ontario, Canada
Remote
Full-time

A leading data engineering firm is seeking a Senior Data Engineer who can design and maintain effective ETL pipelines.The ideal candidate will have over 7 years’ experience and be proficient in Pyt... Show more

 • Promoted

Data Engineer

Compunnel Inc.Markham, York region, Canada
Full-time

Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Compunnel Inc.University degree in Computer Engineering or Computer Science.Solid grasp/experience w... Show more

 • Promoted

Remote Technical Implementation Engineer — Data & ETL Specialist

ODAIAToronto
Remote
Full-time

A remote first organization is seeking a Technical Implementation Engineer to configure and implement their AI-driven platform for customer success.The role requires strong skills in data analysis,... Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

Fidelity CanadaEast York, Canada
Remote
Full-time

Develop and support ETL data integration solutions using Informatica and Snowflake SQL for Fidelity Canada.Requires 3+ years of relevant experience. Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

FidelityToronto, Canada
Remote
Full-time

Join to apply for the Data Engineer role at Fidelity CanadaJob DescriptionYou will be working on a 100% remote schedule as part of Fidelity's dynamic working arrangement.Current work authorization ... Show more

 • Promoted

DSP / Digital Engineer

Sonele Inc.Markham
Full-time

The DSP/Digital Engineer develops FPGA and digital processing pipelines for ultrasound acquisition and beamforming, enabling high-throughput, low-latency data paths from front‑end electronics to im... Show more

 • Promoted

Informatica Developer – IICS/CAI

ProcomToronto, Ontario, Canada
Temporary

Be among the first 25 applicants.Direct message the job poster from Procom.On behalf of our Financial Services client, Procom is searching for a Informatica Developer – IICS/CAIfor a 7 month contra... Show more

 • Promoted

Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain)

Cygnus Professionals IncToronto, Ontario, Canada
Temporary

Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain).Be among the first 25 applicants.Direct message the job poster from Cygnus Professionals Inc.ETL Developer... Show more

 • Promoted

P&C Insurance ETL & QA Tester | SQL Expert

TechDoQuestMarkham, York region, Canada
Full-time

A technology company in Markham is seeking a Mid-Senior level IT Analyst to deliver solutions and test applications in the P&C insurance domain.Responsibilities include analyzing requirements, cond... Show more