QA Automation Engineer - Database & ETL Testing

Infoya Inc.; Toronto; On-site; CAD 100,000 - 115,000; Full time

Job summary

Infoya in Toronto is seeking a Senior Automation Engineer to lead test automation, database testing, ETL validation, and data-pipeline testing across cloud-based platforms. The role blends hands-on testing with BI validation work in a hybrid, Toronto-based environment.

The ideal candidate has 5–8 years in software QA, strong SQL skills, and experience with PostgreSQL, StarRocks, Tableau, and GCP. Join a global IT solutions provider focused on data quality and performance.

Qualifications

• 5–8 years of software QA with database and ETL testing.
• Experience developing automated test scripts and reusable testing frameworks.
• Strong SQL skills with complex queries, joins, and data validation.
• Experience with PostgreSQL, StarRocks, Tableau, and GCP.
• Familiarity with Agile delivery environments.

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 and QA productivity through automation.
• Database Testing & Data Validation: design and execute database testing strategies for complex enterprise apps.
• Perform SQL-based validation including complex joins and data reconciliation.
• Validate data integrity across source and target systems.
• Conduct backend testing using PostgreSQL and StarRocks.
• Identify data quality issues and performance bottlenecks.
• Validate end-to-end ETL/ELT workflows and data pipelines.
• Test batch and streaming data pipelines for accuracy and reliability.
• Validate transformation rules and data mappings.

Skills

Automation testing

SQL expertise

PostgreSQL

Tableau

GCP familiarity

Tools

PostgreSQL

StarRocks

Tableau

GCP

Job description

Infoya is a global IT solutions provider specializing in transforming complex challenges into streamlined, AI-powered outcomes. Through proprietary technology accelerators and full-scale enterprise services, Infoya automates workflows, enhances operational efficiency, and drives digital transformation across industries. With a presence in Canada, the US, India, and Costa Rica, we blend technical depth with creative problem-solving to deliver measurable impact.

Job Description

About theJob: Infoya is looking for anexperiencedSenior Automation Engineerwith strong expertisein test automation , database testing, ETL validation, and data pipelinetesting. The ideal candidate will have hands-on experience working withcloud-based data platforms, complex data architectures, and businessintelligence solutions. The candidate will be responsible for ensuring dataaccuracy, integrity, consistency, reliability, and performance acrossenterprise data pipelines and analytical platforms .

Office Location: Toronto

Employment Type: Permanent

Work Arrangement: Hybrid (2 days in office)

Position Responsibilities:

Test Automation (Mandatory)

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

Database Testing & Data Validation

• Design and execute comprehensive database testingstrategies for complex enterprise applications.
  
• Perform advanced SQL-based validation, includingcomplex joins, aggregations, stored procedures, and data reconciliation.
  
• Validate data integrity, completeness, accuracy, andconsistency across source and target systems.
  
• Conduct backend testing using PostgreSQL andStarRocks.
  
• Identify data quality issues, transformation defects,and performance bottlenecks.
  
• Validate end-to-end ETL/ELT workflows, including dataextraction, transformation, loading, and reconciliation.
  
• Test batch and streaming data pipelines for accuracy,completeness, and reliability.
  
• Validate transformation rules, data mappings, businesslogic, and aggregation calculations.
  
• Perform incremental load, full load, duplicatedetection, and data consistency testing.
  
• Verify error handling, recovery mechanisms, and datapipeline dependencies.
  
• Work with Google Cloud Platform (GCP) to validatecloud-based data processing and storage solutions.
  
• Perform data validation across PostgreSQL, StarRocks,and other enterprise data platforms.
  
• Collaborate with Data Engineers, Cloud Engineers, andDevelopers to troubleshoot data-related issues.
  

Business Intelligence & ReportingValidation

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

Performance Testing (Good to have knowledge)

• Perform database query performance testing andoptimization validation.
  
• Evaluate ETL pipeline throughput, processing latency,and scalability.
  
• Support load, stress, and volume testing fordata-intensive applications.
  
• Identify performance bottlenecks and collaborate withengineering teams on improvements.
  

Requirements

Required Qualifications:

• 5-8 years of experience in Software QualityEngineering, with significant hands-on experience in database and ETLtesting.
  
• Strong experience in developing automated test scriptsand reusable testing frameworks.
  
• Excellent SQL skills with expertise in complexqueries, joins, aggregations, and data validation.
  
• Practical experience with PostgreSQL, StarRocks,Tableau, and GCP.
  
• Knowledge with GCP services such as BigQuery, CloudStorage, Dataflow, or Cloud Composer.
  
• Proven experience validating end-to-end data pipelinesand 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, andstakeholder collaboration skills.
  

Preferred Qualifications:

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

Salary Range: $100,000 to $115,000 CAD/ year

The final compensation offered will depend on local marketconditions and geographic location, as well as job-related factors such as thecandidate’s knowledge, skills, qualifications, relevant experience, andeducation/training. Compensation may also include additional components such asbenefits, and/or other incentives, where applicable. In accordance with newemployment standards requirements, we retain copies of this job posting andapplicant information for three (3) years after the posting is removed. We donot use AI technology; all applications are also reviewed by our recruitmentteam.

Infoya is an equal opportunity employer committed todiversity and inclusion. We welcome applications from all qualifiedindividuals, 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.