Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 20 days ago
SL
Senior Data Scientist
Sun Life
Toronto, ON · Waterloo, ON · Sun Life Toronto One York
- Full-time
…for: in-depth coding knowledge of an analytical tool(s) (i.e., Python); data science techniques and concepts; working with structured data and unstructured data. Thirst for learning. You…
Added 20 days ago
QW
QA Analyst
Quantum World Technologies Inc.
Toronto, ON
- Contract
Develop and maintain test automation scripts using Python/PyTest.
Added 20 days ago
B
Development Lead - AWS
BMO
Toronto, ON · BMOPLACE
- Full-time
…managed services environments, next-generation databases and, developer tools. Migrates existing applications to the cloud, and modifies existing applications for the cloud, or builds new…
Added 20 days ago
AI
Full Stack Engineer
Apptoza Inc.
Toronto, ON
- Contract
We are seeking an experienced Lead Full Stack Engineer with strong Java/Python backend development, React frontend expertise, and hands-on knowledge of Generative AI and Agentic AI. The…
Added 20 days ago
HT
Software Validation Technologist
Husky Technologies
Bolton, ON
- Full-time
Evaluate and verify some issues discovered, log probable software bugs in Husky tracking database.
Added 20 days ago
X
Software Engineer
XTronica
Burnaby, BC
- Full-time
Get exposure to Python scripting integration and API interface development.
Added 20 days ago
VP
Intelligent P&ID Systems Specialist
Vista Projects Limited
Calgary, AB
- Full-time
Understanding of data quality, data relationships, and database concepts as they apply to engineering information
Added 20 days ago
L
Marketing Operations Manager
LanceDB
Canada
- Full-time
Bonus points for: experience at an AI, database, data infrastructure, or developer tools company, or scripting and API experience (Python, webhooks, reverse ETL).
Added 20 days ago
UH
Data Science Analyst (Data Integration)
University Health Network
Toronto, ON
- Full-time
The pipeline is tracked end to end by an in-house Laboratory Information Management System (PHP, Python, PostgreSQL), developed and maintained by our senior database developer. As…
Added 20 days ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Must have Class 5 driver’s license
Added 20 days ago
Senior Database Administrator
WestJet Group
Calgary, AB
WestJet is seeking a highly motivated and results-driven Senior Database Administrator to join our Database Services team. This role combines hands-on technical expertise with mentorship,…
Added 20 days ago
HT
Software Validation Technologist
Husky Technologies
Bolton, ON
- Full-time
Evaluate and verify some issues discovered, log probable software bugs in Husky tracking database.
Added 20 days ago
CT
IT Support Specialist – Guelph, ON Canada
Connect Tech Inc.
Guelph, ON
- Full-time
PowerShell, SQL, Python, C#, AL, or other programming and scripting languages.
Added 20 days ago
CA
Manager – Data Engineering & Platforms
Canadian Addiction Treatment Centers
Markham, ON
- $125,000 to $150,000 CAD / year
- Full-time
…responsibility for CATC's Azure SQL data warehouse and the Python, SQL and dbt-based pipelines, integrations and APIs that connect CATC's operational systems, automation platforms and…
Added 21 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 21 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 21 days ago
SM
RQ11486 – Data Ops/Cloud Data Engineer – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
Work Arrangement: Onsite – 5 Days per Week · Candidates Must Demonstrate Strong Hands-on Experience In The Mandatory Technical Skills And Responsibilities Outlined In The Must Have And General
Added 21 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 21 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 21 days ago
SM
Python Developer
S M Software Solutions Inc
Mississauga, ON
- Full-time
This is an on-site assignment, requiring candidates to be present in the office five days per week
Added 21 days ago
C
Senior Enterprise Architecture Consultant – Enterprise Modernization
CGI
Vancouver, BC
- Full-time
Guide Python based matching services and related data processing, validation, and stewardship patterns.
Added 21 days ago
I
Database Automation Test Engineer
INFOYA
Toronto, ON
- $75,000 to $80,000 CAD / year
- Full-time
Work Arrangement: Hybrid (2 days in office)
Added 21 days ago
C
Software Developer II (Full Time) - Canada
Cisco
Ottawa, ON
- Full-time
As a software developer on our team, you will be the driving force behind crafting user-friendly, reliable software and tools that support critical technology platforms such as operating…
Added 21 days ago
N
Senior Data Engineer, Analytics
nesto
Vancouver, BC
- Full-time
Manage access control, database and user provisioning, and data sharing with internal teams and external partners.
Added 21 days ago
TO
GIS and Data Visualization Technologist
Town of Oakville
Oakville, ON
- Full-time
Utilizes scripting and automation tools such as Python, ArcPy, and Arcade to streamline workflows, enhance data processing, and support application development.

INFOYA

Database Automation Test Engineer

Toronto, ON, Canada

$75,000 to $80,000 CAD / year · Full-time

Apply on infoya.zohorecruit.com About employer

Applications open in a new tab.

Job details

Pay: $75,000 to $80,000 CAD / year
Job type: Full-time
Work location: Work Arrangement: Hybrid (2 days in office)
Experience: 5+ years of experience in Software Quality
Posting language: English
Posted: Oct 9, 2026

Original job description

About the Job: Infoya is looking for an experienced Senior Automation Engineer with strong expertise in test automation , database testing, ETL validation, and data pipeline testing. The ideal candidate will have hands-on experience working with cloud-based data platforms, complex data architectures, and business intelligence solutions. The candidate will be responsible for ensuring data accuracy, integrity, consistency, reliability, and performance across enterprise data pipelines and analytical platforms.

Office Location: Toronto

Employment Type: Permanent

Role Type: New position – current requirement

Work Arrangement: Hybrid (2 days in office)

Position Responsibilities:

Test Automation (Mandatory)

Design, develop, and maintain automated testing frameworks for database, ETL, and data pipeline validation.
Develop reusable automated test scripts using Python, SQL, or equivalent technologies.
Automate source-to-target reconciliation, data quality checks, schema validation, and regression testing.
Integrate automated tests into CI/CD pipelines.
Improve test coverage, execution efficiency, and overall QA productivity through automation

Database Testing & Data Validation

Design and execute comprehensive database testing strategies for complex enterprise applications.
Perform advanced SQL-based validation, including complex joins, aggregations, stored procedures, and data reconciliation.
Validate data integrity, completeness, accuracy, and consistency across source and target systems.
Conduct backend testing using PostgreSQL and StarRocks.
Identify data quality issues, transformation defects, and performance bottlenecks.

ETL & Data Pipeline Testing

Validate end-to-end ETL/ELT workflows, including data extraction, transformation, loading, and reconciliation.
Test batch and streaming data pipelines for accuracy, completeness, and reliability.
Validate transformation rules, data mappings, business logic, and aggregation calculations.
Perform incremental load, full load, duplicate detection, and data consistency testing.
Verify error handling, recovery mechanisms, and data pipeline dependencies.

Cloud & Data Platform Testing

Work with Google Cloud Platform (GCP) to validate cloud-based data processing and storage solutions.
Perform data validation across PostgreSQL, StarRocks, and other enterprise data platforms.
Test data ingestion, processing, transformation, and integration workflows.
Collaborate with Data Engineers, Cloud Engineers, and Developers to troubleshoot data-related issues.

Business Intelligence & Reporting Validation

Validate Tableau dashboards, reports, KPIs, and analytical outputs.
Reconcile dashboard data against underlying databases and source systems.
Verify business rules, filters, aggregations, calculations, and reporting accuracy.
Ensure consistency between analytical data layers and business reporting.

Performance Testing (Good to have knowledge)

Perform database query performance testing and optimization validation.
Evaluate ETL pipeline throughput, processing latency, and scalability.
Support load, stress, and volume testing for data-intensive applications.
Identify performance bottlenecks and collaborate with engineering teams on improvements.

Requirements

Required Qualifications:

5+ years of experience in Software Quality Engineering, with significant hands-on experience in database and ETL testing.
Strong experience in developing automated test scripts and reusable testing frameworks.
Excellent SQL skills with expertise in complex queries, joins, aggregations, and data validation.
Practical experience with PostgreSQL, StarRocks, Tableau, and GCP.
Knowledge with GCP services such as BigQuery, Cloud Storage, Dataflow, or Cloud Composer.
Proven experience validating end-to-end data pipelines and ETL/ELT processes.
Strong understanding of data warehousing concepts, dimensional modeling, and data quality principles.
Experience working in Agile delivery environments.
Strong analytical, troubleshooting, communication, and stakeholder collaboration skills.

Preferred Qualifications:

Performance testing experience for databases and large-scale data pipelines.
Familiarity with PyTest, Great Expectations, dbt testing, or similar data quality automation tools.
Experience testing large-volume datasets and near-real-time data processing.
Exposure to DevOps, CI/CD, and cloud-native testing practices.

Benefits

Salary Range: $75,000 to $80,000 CAD/ year

The final compensation offered will depend on local market conditions and geographic location, as well as job-related factors such as the candidate’s knowledge, skills, qualifications, relevant experience, and education/training. Compensation may also include additional components such as benefits, and/or other incentives, where applicable. In accordance with new employment standards requirements, we retain copies of this job posting and applicant information for three (3) years after the posting is removed. We do not use AI technology; all applications are also reviewed by our recruitment team.

Infoya is an equal opportunity employer committed to diversity and inclusion. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, aboriginal status, or any other legally protected factors.

Apply on infoya.zohorecruit.com About employer

More about this job

Responsibilities

The candidate will design and maintain automated testing frameworks for database, ETL, and data pipeline validation to ensure data integrity and performance. They will also collaborate with engineering teams to troubleshoot data issues and validate business intelligence reporting outputs.

Requirements

The role requires at least 5 years of experience in software quality engineering with a strong focus on database and ETL testing. Candidates must possess excellent SQL skills and practical experience with PostgreSQL, StarRocks, Tableau, and Google Cloud Platform.

Skills

Test automation
Database testing
ETL validation
Data pipeline testing
Python
SQL
PostgreSQL
StarRocks
Tableau
Google Cloud Platform
BigQuery
Data warehousing
CI/CD
Agile
Data quality
Performance testing

Visa sponsorship

Not detected in the job text

Keywords

Database Automation
Test Automation
ETL
Data Pipeline
Python
SQL
PostgreSQL
StarRocks
Tableau
Google Cloud Platform
BigQuery
Cloud Storage
Dataflow
Cloud Composer
Data Warehousing
Dimensional Modeling
Data Quality
Agile
CI/CD
DevOps
Performance Testing
PyTest
Great Expectations
dbt
Regression Testing
Schema Validation
Data Reconciliation
Business Intelligence
Analytical Platforms
Software Quality Engineering

Report this job

Work requirements

Jobs in Canada