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 Engineer with 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.

- Solid understanding of data warehousing concepts,dimensional modeling, and data quality principles.

- Experience working in Agile delivery environments.

- Strong analytical, troubleshooting, communication, andstakeholder collaboration skills.

Preferr

📌 QA Automation Engineer (Toronto)
🏢 Infoya
📍 Toronto