Open jobs near Pickering

Within 25 km of Pickering

Added 1 month ago
ETL Data Engineer (Hybrid, Markham, Ontario)
HR POD Careers
Markham, ON
Added 1 month ago
AWS Snowflake Architect (Hybrid, Markham, Ontario)
HR POD Careers
Markham, ON
Added 1 month ago
Java Full Stack Developer (Onsite, Markham, Ontario)
HR POD Careers
Markham, ON

No more jobs.

HR POD Careers

ETL Data Engineer (Hybrid, Markham, Ontario)

Markham, ON, Canada

Full-time

Within 25 km of Pickering · About 13.3 km from the city centre

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Experience: 8+ years of hands-on experience in ETL development, Data Engineering, or enterprise data integration.
Posted: Sep 22, 2026

Original job description

Requirements:

8+ years of hands-on experience in ETL development, Data Engineering, or enterprise data integration.
Strong expertise in Informatica, with proven experience developing and maintaining ETL workflows and data pipelines.
Hands-on experience working with Hadoop and large-scale data processing environments.
Advanced SQL skills, with strong experience working with complex datasets and queries.
Strong experience in data reconciliation, data validation, and data quality technologies.
Experience working with Business Intelligence tools and supporting reporting and analytics requirements.
Strong understanding of ETL architecture, data mapping, transformation, and data integration processes.
Experience in the insurance domain is preferred, while knowledge of P&C Insurance is a strong plus.

Responsibilities:

Design, develop, and maintain scalable ETL pipelines and data integration solutions using Informatica.
Develop data transformation and processing workflows across Hadoop and enterprise data environments.
Write and optimize advanced SQL queries for data extraction, transformation, reconciliation, and analysis.
Perform data reconciliation and validation to ensure data completeness, consistency, and accuracy across systems.
Identify and resolve data quality, integration, and ETL performance issues.
Support data requirements for Business Intelligence, reporting, and analytics platforms.
Collaborate with business, data, and technical teams to translate requirements into reliable and scalable data solutions.
Maintain comprehensive ETL documentation and ensure data pipelines adhere to established development, quality, and governance standards.

Apply About employer

More about this job

Responsibilities

Design, develop, and maintain scalable ETL pipelines and data integration solutions using Informatica and Hadoop. Collaborate with cross-functional teams to ensure data quality, consistency, and accuracy while supporting business intelligence and reporting requirements.

Requirements

Requires 8+ years of hands-on experience in ETL development, data engineering, and enterprise data integration. Strong expertise in Informatica, Hadoop, and advanced SQL is essential, with a preference for candidates with experience in the insurance domain.

Skills

Informatica
Data Engineering
ETL Development
Hadoop
SQL
Data Integration
Data Reconciliation
Data Validation
Data Quality
Business Intelligence
Data Mapping
Data Transformation
P&C Insurance
Data Pipelines
Enterprise Data Integration

Visa sponsorship

Not detected in the job text

Keywords

ETL
Data Engineering
Informatica
Hadoop
SQL
Data Integration
Data Reconciliation
Data Validation
Data Quality
Business Intelligence
Data Mapping
Data Transformation
P&C Insurance
Insurance
Data Pipelines
Enterprise Data
Data Governance
Analytics
Reporting
Scalable Solutions

Report this job

Open jobs near Pickering

ETL Data Engineer (Hybrid, Markham, Ontario)

AWS Snowflake Architect (Hybrid, Markham, Ontario)

Java Full Stack Developer (Onsite, Markham, Ontario)