ETL Data Engineer (Hybrid, Markham, CAD Salary)
HR POD Careers · Markham, Canada ·
- Category
- Data engineering
- Experience
- 8+ years
Designs, builds, and maintains scalable ETL pipelines and data integration solutions using Informatica and Hadoop, writes advanced SQL for reconciliation and validation, and supports BI/reporting needs. Hybrid role in Markham, Canada, in the insurance domain.
- 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.
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.