Find work in Canada.

529,839 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 8 days ago
B
Intern, Laboratory Operations & Continuous Improvement (Winter 2027)
Bombardier
Montreal, QC
- Volunteer
Experience with Power Automate, Power Apps, VBA, Python, SQL, or similar automation tools.
Added 8 days ago
UI
Process and automation specialist
UAP Inc.
Longueuil, QC
- Full-time
Develop automated solutions (Python, VBA, SQL, Power Platform, or other relevant tools) to optimize processes related to pricing, products, and master data.
Added 8 days ago
7
AI Workflow Engineer
7shifts
Canada
- Full-time
Technical foundation: You have experience building and deploying AI-powered solutions and connecting systems through APIs. You’re comfortable with Python or a similar programming language,…
Added 8 days ago
Senior Demand Planner
HelloFresh
Toronto, ON
Proficiency in demand planning software and tools (Google Sheets, Excel, SQL, Python, Tableau) complemented with exceptional analytical and problem solving skills
Added 8 days ago
T
Senior Data Engineer
TEEMA
Vancouver, BC
- $70 to $95 CAD / hour
- Contract
Build scalable data solutions using Databricks, Delta Lake, Delta Live Tables (DLT), Python, Spark, and SQL.
Added 8 days ago
I
Database Automation Test Engineer
INFOYA
Toronto, ON
- $75,000 to $80,000 CAD / year
- Full-time
in test automation , database testing, ETL validation, and data pipeline
Added 8 days ago
RB
Trade Support Analyst
Royal Bank of Canada
Toronto, ON
- Full-time
Other technical skills such as Python, VBA, SQL, or other automation tools.
Added 8 days ago
RB
Senior Manager, Forecast Delivery, Personal and Commercial Operations
Royal Bank of Canada
Toronto, ON
- Full-time
Proficiency in SQL and/or general-purpose programming languages (e.g., Python)
Added 8 days ago
OM
Research Analyst
Omnicom Media
Toronto, ON
- Full-time
Experience with Advanced Analytical Tools: Experience with analytical tools such as DisplayR, SPSS, Q, R, Python, or SQL is a plus.
Added 8 days ago
N
Senior Data Engineer, Analytics
nesto
Vancouver, BC
- Full-time
Design and maintain ELT pipelines from SQL Server, Azure SQL, REST APIs and SaaS platforms, with incremental loads, safe reruns and clear failure handling.
Added 8 days ago
T
Data Scientist - Credit Risk (ATH 5531)
TD
Toronto, ON
- Full-time
Strong SQL skills and experience working with large, complex data sets.
Added 8 days ago
T
Full Stack .NET Developer
Techso
Montreal, QC
- Full-time
Techso is looking for a Senior Full Stack .NET Developer to help design and develop digital solutions used by our clients across Canada.
Added 8 days ago
E
Databricks Engineer
E-Solutions
Toronto, ON
- Contract
Proficient in developing programs in Python and SQL
Added 8 days ago
C
Sr. Consultant, Full Stack Developer
CIBC
Toronto, ON
- Full-time
…issuing side. Must have familiarity with VISA/Mastercard network and card transaction lifecycle. Should have an experience of working on the vendor products (writing requirements,…
Added 8 days ago
Senior Manager, Expense Oversight and Transparency - Finance
Scotiabank
Toronto, ON
Data Analytics experience using SQL and Python is highly desirable
Added 8 days ago
FS
Senior Platform Engineer, Performance Management
Four Seasons Hotels and Resorts
Toronto, ON · Four Seasons Corporate Headquarters Toronto
- Full-time
…who crave to become better, to push ourselves to new heights and to treat each other as we wish to be treated in return. Our team members around the world create amazing experiences for our…
Added 8 days ago
Data Engineer Sr
Insight Enterprises, Inc.
Toronto, ON
Advanced SQL skills, including query optimization, performance tuning, and data modeling.
Added 8 days ago
SI
Business Intelligence Analyst
Spait Infotech
Canada
- Full-time
Write and optimize SQL queries to extract, transform, and analyze data from databases.
Added 8 days ago
ES
Databricks Lead Developer
Enterprise Solutions Inc.
Mississauga, ON
- Full-time
We are seeking an experienced Databricks Lead Developer to design, develop, and optimize scalable data engineering solutions using Azure Databricks. The ideal candidate will have strong…
Added 8 days ago
I
Database Automation Test Engineer
Infoya
Toronto, ON
- $75,000 to $80,000 CAD / year
- Full-time
Perform advanced PostgreSQL and SQL-based validation, including complex joins, aggregations, stored procedures, and data reconciliation.
Added 8 days ago
T
Full Stack Java Developer
Techso
Montreal, QC
- Full-time
Techso is looking for a Senior Full Stack Java Developer to help design and develop digital solutions used by leading clients in Montreal and internationally.
Added 8 days ago
PP
Manager, Commercial Analytics & Insights
Panago Pizza
Abbotsford, BC
- $100,000 to $110,000 CAD / year
- Full-time
Build and maintain workflows that extract, clean, reconcile, and report data using SQL, code, and automation, with version control and documented checks.
Added 8 days ago
R
Trade Support Analyst
RBC
Toronto, ON
- Full-time
Other technical skills such as Python, VBA, SQL, or other automation tools.
Added 8 days ago
Data Analyst, Investment Data Architecture
Connor, Clark & Lunn Financial Group Ltd.
Toronto, ON
SQL is an asset; familiarity with Python, PySpark, Lakehouse architecture, Microsoft Fabric or similar data platforms is a plus.
Added 8 days ago
Data Analyst, Investment Data Architecture
Connor, Clark & Lunn Financial Group Ltd.
Vancouver, BC
SQL is an asset; familiarity with Python, PySpark, Lakehouse architecture, Microsoft Fabric or similar data platforms is a plus.

INFOYA

Database Automation Test Engineer

Toronto, ON, Canada

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

Apply About employer

Applications open in a new tab.

Job details

Pay: $75,000 to $80,000 CAD / year
Job type: Full-time
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 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