HR POD - Hiring Talent Globally
ETL Data Engineer (Hybrid, Markham, CAD Salary)
Builds and maintains large-scale ETL pipelines and enterprise data integrations using Informatica and Hadoop, writing advanced SQL for extraction, transformation, reconciliation, and BI/reporting support. Hybrid role based in Markham, Canada, paid in CAD; insurance-domain experience is a plus.
- Compensation
- Not disclosed
- Location
- Markham, Canada
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 8+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 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 with Hadoop and large-scale data processing environments
- Advanced SQL skills, with 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
Nice to have
- Experience in the insurance domain
- Knowledge of P&C insurance
Full description
Job Description
Job DescriptionRequirements:
- 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.