QA Data Tester – SQL, ETL & Database Testing


Job Location:

Mississauga - Canada

Monthly Salary: K 10 - 10
Experience Required: 5years
Posted on: 6 days ago
Vacancies: 1 Vacancy

Job Summary

Data Tester

Location: Remote (Canada)
Duration: 6 Months
Work Model: 100% Remote

Role Overview

We are seeking a detail-oriented Data Tester with strong experience in SQL database testing and ETL validation. The ideal candidate will be responsible for ensuring data accuracy integrity and quality by validating backend systems executing complex SQL queries and performing end-to-end data testing across multiple database platforms.

Key Responsibilities

  • Design develop and execute test cases for database and data validation testing.

  • Perform backend data validation using complex SQL queries.

  • Validate ETL processes and ensure accurate data movement between source and target systems.

  • Test stored procedures triggers functions and database objects.

  • Verify data integrity consistency and accuracy across multiple environments.

  • Conduct data migration testing and identify discrepancies.

  • Collaborate with developers business analysts and QA teams to resolve data-related defects.

  • Log track and manage defects using JIRA or Quality Center.

  • Analyze test results and provide detailed reports on data quality and testing outcomes.

  • Support regression integration and system testing activities related to database applications.

Required Skills

Database & SQL

  • Strong SQL query writing and troubleshooting skills

  • Solid understanding of database concepts including Tables Views Joins Indexes Constraints and Keys

  • Experience with Stored Procedures Triggers and Functions testing

Data & ETL Testing

  • Hands-on experience with ETL testing and data validation

  • Knowledge of data integrity and data migration testing

  • Experience performing backend database testing

Database Platforms

  • Oracle

  • SQL Server

  • MySQL

  • PostgreSQL

Testing & Defect Management

  • Test case creation and execution

  • Defect lifecycle management

  • Experience with JIRA and/or Quality Center

Core Competencies

  • Strong analytical and problem-solving skills

  • Excellent debugging and troubleshooting abilities

  • Attention to detail and data accuracy

  • Effective communication and collaboration skills

Preferred Qualifications

  • Experience working in enterprise data testing environments

  • Knowledge of software testing methodologies and SDLC/STLC

  • Experience with automation testing for backend or database applications is an added advantage

  • Exposure to Agile development methodologies is preferred

Primary Skills

  • SQL

  • Data Validation

  • Database Testing

  • ETL Testing

  • Backend Testing

  • Oracle

  • SQL Server

  • PostgreSQL

  • MySQL

  • Stored Procedures

  • Triggers

  • Functions

  • Data Migration Testing

  • JIRA

  • Quality Center

  • Defect Tracking

  • Analytical & Troubleshooting Skills




Required Skills:

60-70


Required Education:

Backend Engineer Kotlin Microservices & AKSRole Overview:We are seeking a highly skilled backend developer with strong experience in modern programming languages and frameworks with primary expertise in Kotlin and exposure to Java microservices and cloud Skills:Proficiency in Kotlin with additional experience in Java (Spring Boot Spring Security) and JavaScript () 5 years of backend development experience including: oUnit testing frameworks (e.g.

Data TesterLocation: Remote (Canada)Duration: 6 MonthsWork Model: 100% RemoteRole OverviewWe are seeking a detail-oriented Data Tester with strong experience in SQL database testing and ETL validation. The ideal candidate will be responsible for ensuring data accuracy integrity and quality by valida...