ETL Developer - Informatica PowerCenterAviva • Markham, York Region, CA

No longer accepting applications

ETL Developer - Informatica PowerCenter

Aviva • Markham, York Region, CA

30+ days ago

Job type

Full-time

Job description

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

We are seeking a dedicated 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.

If you would like to be part of a leading company in the insurance industry, dedicated to providing top-notch financial solutions, then come join our team!

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 (if any)
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 complexed Finance calculations using Postgres store procedure 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 & able 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 Database Developer, hands on experience in writing DDLS and DMLS for relational databases

Experience in writing complex SQL queries for Adhoc reporting.

Expertise in ETL tools (especially Informatica) and PostgreSQL.

Strong expertise in Postgres and database design.

Knowledge of data warehousing concepts and best practices.

Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.

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 both 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.

We’ll support your professional development education.

Competitive vacation package with the option to purchase 5 extra days off per year.

Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.

Corporate wellness programs to support our employees’ 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.

#LI-PS1

#LI-Hybrid

#J-18808-Ljbffr

Create a job alert for this search

Etl Developer • Markham, York Region, CA

Similar jobs

Senior ETL & Data Warehouse Consultant

Virtusa • Toronto C6A, ON, Canada

Full-time

A leading technology consulting firm is seeking a Senior Consultant specializing in ETL development.The role involves designing and supporting applications in Line of Business strategies, with a fo...Show more

Last updated: 6 days ago • Promoted

IT Applications Analyst

Hire DigITalent • Toronto, ON, Canada

Full-time

North York, ON (Hybrid) OR Vancouver (Hybrid).We are seeking a detail-oriented and technically proficient.This role is hands-on with Jira / Confluence, Microsoft 365, automation tools, API integratio...Show more

Last updated: 30+ days ago • Promoted

Senior Programmer Analyst - Amico Corporation

Amico • Richmond Hill, ON, Canada

Full-time

The Amico group of companies is looking to fill the on-site role of .To join our growing team, please review the list of responsibilities and qualifications. We look forward to reviewing your r...Show more

Last updated: 3 days ago • Promoted

Senior ETL Engineer

Women Thrive Magazine • Toronto C6A, ON, Canada

Full-time

Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Show more

Last updated: 2 days ago • Promoted

Senior ETL Engineer

Thebusinessyear • Toronto C6A, ON, Canada

Full-time

Last updated: 7 days ago • Promoted

Senior BI Analyst

Black & McDonald Limited • Markham, ON, Canada

Full-time

Senior Business Intelligence (BI) Analyst.Black & McDonald's Business Intelligence / IT team is growing! If you are committed and collaborative professional looking to contribute to a hard-wo...Show more

Last updated: 30+ days ago • Promoted

Lead Systems Engineer, Launch Program

The Wohl Group - Recruitment Made Easy! • Markham, ON, Canada

Full-time

The Lead Systems Engineer owns cross-functional planning and execution for the launch program at a systems engineering level, ensuring work meets the company’s technical requirements, risk po...Show more

Last updated: 1 day ago • Promoted

Intermediate (Level 2) System Administrator

Exposant 3 • Toronto, Ontario, .CA

Full-time

Quick Apply

Join Exposant 3 (E3) : The Power of People at the Heart of Technology!.Exposant 3 is a consulting firm in business management and information technology, dedicated to supporting companies and organi...Show more

Last updated: 30+ days ago

Senior IT Business Analyst – Salesforce Integration (TOR, ON)

Recrute Action • Toronto, ON, ca

Full-time +2

Quick Apply

Senior IT Business Analyst – Salesforce Integration.Seeking an experienced professional with over 10 years in business analysis to support Salesforce integration with Java Spring Boot in the insura...Show more

Last updated: 30+ days ago

CMS (Content Management System) Developer

company • Greater Toronto Area, Canada

Full-time

CMS (Content Management System) Developer.Contract length : 6 months (possible extension).Location : Toronto (Dufferin / King). Hybrid policy : 3x per week on-site.Rate : 60-70 / hr incorporated (depends on...Show more

Last updated: 6 days ago • Promoted

Algebra Private Tutoring Jobs Hawkestone

Superprof • Hawkestone, Canada

Full-time +1

Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more

Last updated: 30+ days ago • Promoted

DSP Engineer (Markham)

Evertz Microsystems Limited • Markham, ON, Canada

Full-time

We are looking for DSP engineers responsible to work on DSP algorithm design and implementation on heterogeneous platforms, including CPU, GPU and FPGA.Architect solutions ...Show more

Last updated: 30+ days ago • Promoted

RQ09950 - Software Developer - ETL - Senior

Maarut Inc • East York, ON, Canada

Full-time

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Required to translate technical systems specifications into working, teste...Show more

Last updated: 1 day ago • Promoted

RQ09949 - Software Developer - ETL - Senior

Maarut Inc • Toronto, ON, ca

Full-time

Quick Apply

Last updated: 2 days ago

Algebra Private Tutoring Jobs Lake Simcoe

Superprof • Lake Simcoe, Canada

Full-time +1

Last updated: 30+ days ago • Promoted

ETL Tech Lead

Hays • Toronto, ON, Canada

Full-time

You’ll be joining a leading organization committed to delivering innovative solutions that support strategic initiatives across the health information sector. The company values collaboration, excel...Show more

Last updated: 7 days ago • Promoted

Application Support Analyst

Bay Street Staffing • Greater Toronto Area, Canada

Full-time

You’ll be joining BANK’s Application Operations team.You will be responsible for providing analysis and second level support on client issues, technical issues, system / web site outages and question...Show more

Last updated: 21 hours ago • Promoted • New!

Lead Business Analyst, ERP

Atlantic Packaging Products Ltd • Toronto, ON, Canada

Full-time

From corrugated packaging, paper bags, retail displays, pre-print, supply and inventory management, paper mills and recycling, Atlantic is strategically positioned to provide customers with a total...Show more

Last updated: 30+ days ago • Promoted