Talent.com
Astra North Infoteck Inc.
ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data ValidationAstra North Infoteck Inc. • Toronto, ON, ca
No longer accepting applications
ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation

ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation

Astra North Infoteck Inc. • Toronto, ON, ca
30+ days ago
Job type
  • Full-time
Job description

ETL Data Tester – ETL Testing, Data Warehouse, SQL, UNIX/Linux, Informatica


Key Responsibilities


• Perform end-to-end testing of ETL processes, data pipelines, and Data Warehouse solutions

• Validate source-to-target data mappings, data transformations, and business rules

• Design, develop, and execute test cases, test scenarios, and test scripts for data validation

• Perform data reconciliation, completeness, accuracy, and integrity checks across systems

• Write complex SQL queries for data analysis, validation, and defect investigation

• Utilize UNIX/Linux commands for file validation, batch job monitoring, and troubleshooting

• Collaborate with developers, business analysts, and stakeholders to understand requirements and resolve defects

• Support defect tracking, root cause analysis, and test reporting activities

• Exposure to Informatica workflows, mappings, and ETL jobs is preferred

• Experience with Python automation for test automation, data validation, and reporting will be considered a strong advantage


Required Skills


• ETL Testing

• Data Warehouse Testing

• Strong SQL

• UNIX/Linux

• Basic Informatica Knowledge


Good to Have


• Python Automation

• Data Validation Automation Frameworks

• Agile Testing Experience


Create a job alert for this search

ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation • Toronto, ON, ca

Similar jobs

Test Lead (Azure- Databricks)

nugget.aiToronto, ON, CA
Full-time

At least 10+ years of work experience in Quality Engineering (Testing) in Data platforms.Canadian Banking domain experience.Experience in leading and testing large scale, complex Data Modernization... Show more

 • Promoted

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto, ON, CA
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

Lead QA Engineer: Data Warehouse & ETL Testing

Canadian Institute for Health Information (CIHI)Toronto, ON, CA
Full-time

A leading health information organization in Toronto seeks a Team Lead for Quality Assurance.This individual will oversee QA processes ensuring the delivery of high-quality applications.Responsibil... Show more

 • Promoted

ETL Developer - Informatica PowerCenter

Aviva CanadaMarkham, York Region, CA
Full-time

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.Join to apply for the ETL Deve... Show more

 • Promoted

Toronto ETL Quality Engineer Position

Lorven Technologies Inc.Toronto, ON, CA
Full-time

Elevate data quality in your career as an ETL Quality Engineer based in Toronto.This role focuses on automation and requires four days a week on-site presence, making it ideal for hands-on performe... Show more

 • Promoted

Remote.NET Developer for ETL & Data Integrations

Absorb SoftwareToronto, ON, CA
Remote
Full-time

A cloud-based learning management company is seeking an intermediate-level Developer to enhance an internal ETL tool.This fully remote role involves developing integrations between platforms like S... Show more

 • Promoted

Remote Test Data Engineer (TDM) & Data Automation

YochanaToronto, ON, CA
Remote
Full-time

A technology company is seeking a skilled professional in Test Data Management (TDM) to define and implement TDM strategies.Responsibilities include creating and managing test data, ensuring data s... Show more

 • Promoted

ETL Tester

Iris Software Inc.Toronto, Ontario, Canada
Full-time

Lead Talent Acquisition | Financial Services | Client relations.Iris's client, the largest bank in Canada, is looking to hire.Please find below the job details and share your resume if interested a... Show more

 • Promoted

Senior Engineer - ETL Data for Autonomous Vehicles

WaabiToronto, Ontario, Canada
Full-time

Lead advancements in self-driving technology with Waabi as a Senior Engineer focused on ETL data pipelines.This key role develops critical data infrastructure for autonomous vehicle mapping solutio... Show more

 • Promoted

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

Fidelity CanadaToronto, Canada
Remote
Full-time

Join to apply for the Data Engineer role at Fidelity Canada Job Description You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.Current work authorizatio... Show more

 • Promoted

Senior ETL Engineer – Databricks, Delta Lake, Hybrid

Rubicon PathToronto, ON, CA
Full-time

A leading technology firm in Toronto seeks a Software Developer - ETL to design and implement ETL processes using Azure Databricks.This role involves optimizing data flow for analytics and data lak... Show more

 • Promoted

Mid-Senior Data Engineer - ETL, SQL & Kubernetes

VySystemsToronto, ON, CA
Full-time

A technology solutions provider based in Toronto, Ontario is seeking a mid-senior level Data Engineer with at least 3 years of relevant professional experience.Candidates should have a background i... Show more

 • Promoted

Test Data Engineer (TDM)

YochanaToronto, ON, CA
Full-time

Test Data Management (TDM) plays a key role in sourcing the right data with every changing need to ensure software testing is done effectively.Test data administration is the process of creating no... Show more

 • Promoted

Remote Senior Data Engineer: Scalable ETL & Data Platform

LumenaltaToronto, ON, CA
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

Databricks Data Engineer - ETL Lead (Hybrid Toronto)

SPECTRAFORCEToronto, ON, CA
Full-time

A leading financial technology provider in Canada is seeking a Mid-Senior level professional to lead ETL development and manage a Databricks platform for Capital Markets.This role requires strong e... 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

ETL SDET with EDI experince.

Epsilon Solutions Ltd.Toronto, ON, CA
Full-time

Team Lead Recruitment @ Epsilon Solutions Ltd.EDI (Electronic Data Interchange) experience is a must.Must-Have Skills: ETL Testing, Python, PySpark, AWS S3, Redshift, Kafka, Informatica, Complex SQ... Show more

 • Promoted

Remote Technical Implementation Engineer — Data & ETL Specialist

ODAIAToronto, ON, CA
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

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

Data Engineer

Compunnel Inc.Markham, York Region, CA
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