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 the Job:Infoya is looking for an experiencedSenior Automation Engineerwith strong expertise in database testing and automation, data pipeline testing and ETL validation . 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

Work Arrangement:Hybrid (2 days in office)

Position Responsibilities:

Database Testing & Data Validation

- Design and execute comprehensive database testing strategies for complex enterprise applications.
- Perform advanced PostgreSQL and 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.

Database Test Automation (Mandatory)

- Design, develop, and maintain automated testing frameworks for database, ETL, and data pipeline validation, data warehousing.
- 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
- 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.
- 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.

Required Qualifications:

- 5+ years of experience in Software Quality Engineering, with significant hands-on experience in Database Testing & Automation and ETL testing.
- Strong experience in developing automated test scripts and reusable testing frameworks.
- Excellent SQL, PostgreSQL, GBQ skills with expertise in complex queries, joins, aggregations, and data validation.
- Experience working on data pipeline, data validation, data warehousing.
- 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.
- Robust 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 tes

📌 Database Automation Test Engineer (Toronto)
🏢 Infoya
📍 Toronto