Data Warehouse Tester/QA – AWS, ETL Testing
Toronto, Ontario, CanadaFull timePosted Jun 9, 2026
Job description
Primary Skill:
- ETL Tester / AWS Data QA Engineer
- ETL Testing & Automation Expertise Required Skills:
- Data Warehouse BI Testing
- AI and Automation
- Automated QA
- TestComplete Role Description:
- Design and execute test cases for ETL processes, ensuring data completeness, transformation accuracy, and consistency.
- Validate data across source systems, staging layers, and target databases/data warehouses.
- Perform data validations including row count, schema checks, and aggregation checks.
- Conduct data reconciliation and verify transformation logic.
- Perform regression and integration testing for ETL pipelines.
- Demonstrate expertise in SQL and database concepts.
- Possess familiarity with coding languages such as Java or Python.
- Have working knowledge of cloud technologies used in ETL processes.
- Perform ETL automation and backend automation.
- Collaborate effectively with cross-functional teams.
- Work closely with stakeholders and managers on a daily basis, providing regular updates.
- Communicate test results, defects, and risks to stakeholders and managers.
- Show strong ownership and proactively go the extra mile to meet critical milestones.