Talent.com
Astra North Infoteck Inc.
ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data ValidationAstra North Infoteck Inc. • Toronto, ON, ca
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
5 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

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

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

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 hireETL Tester/Data Tester.Please find below the job details and share your ... Show more

 • Promoted

Remote Data Engineer Focused on Scalable ETL and Client Solutions

ShyftLabsToronto, Ontario, Canada
Remote
Full-time

Transform enterprise data challenges as a versatile Data Engineer.Engage directly with clients while developing robust ETL pipelines and data infrastructures for effective analytics and reporting.T... Show more

 • Promoted

ETL Developer

United States Digital Space LLCToronto, ON, CA
Full-time

ETL Developer to join our team and support the development and maintenance of enterprise data integration solutions.In this role, you will design, develop, and optimize ETL pipelines while ensuring... Show more

 • Promoted

IVR Test Engineer

TechDoQuestToronto, ON, CA
Full-time

Contributes to the overall success of the QA - COAT Delivery Center - Agility & Assurance team ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team... Show more

 • Promoted

Senior Data Engineer with Strong ETL Skills

HRbrain Inc.Toronto, ON, CA
Full-time

Become a pivotal Senior Data Engineer focusing on ETL and data transformations.Create and manage data workflows from inception to dashboard implementation using expert skills.This role is suited fo... 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

ETL QA Tester

TEKsystemsMarkham, York Region, CA
Temporary

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Location: Markham, ON ( 4 days onsite per week ).Contract Term: 6 months to start.We’re hiring an expe... Show more

 • Promoted

ETL SDET with EDI experince.

Epsilon Solutions Ltd.Toronto, Ontario, Canada
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

Senior ETL Engineer - Azure Data Lakes, D365 (Hybrid)

Source CodeToronto, ON, CA
Temporary

A leading technology company is seeking a Sr.Software Developer - ETL to work in a hybrid model in Toronto, ON.The ideal candidate will have over 8 years of experience in data integration and ETL d... 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

Senior ETL Consultant

Maarut IncToronto, ON, CA
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Maarut Inc.Participate in the review of project, work request and m... 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

Senior Engineer - ETL Data for Autonomous Vehicles

Waabitoronto, on, 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

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

ETL Developer - Snowflake (Pharmaceutical client experience mandatory)

Cygnus Professionals Inc.Toronto, Ontario, Canada
Temporary

ETL Developer - Snowflake (Pharmaceutical client experience mandatory).ETL Developer - Snowflake (Pharmaceutical client experience mandatory).Direct message the job poster from Cygnus Professionals... Show more