Associate Staff Engineer - QA Tester
Nagarro View all jobs
- Mississauga, ON
- Permanent
- Full-time
Location - Mississauga, Greater Toronto Area, ON L5B 1M2, Canada
Work Model - Onsite - Hybrid
Employment type - Full-timeJob Overview:
- We are looking for a QA Data Engineer who will ensure data accuracy throughout the entire lifecycle, from backend ETL pipelines to frontend visualization.
- This position requires a hybrid approach, combining thorough manual data reconciliation with the implementation of automated testing frameworks for enterprise data platforms.
- Responsibilities include verifying that BI dashboard numbers match the source data, ensuring accuracy, completeness, and consistency of data as it moves through pipelines.
- The ideal candidate will possess a strong understanding of data architecture, manual exploratory testing, and automated validation at scale, along with the business acumen to confirm that data aligns with strategic KPIs and operational needs.
- Design and execute automated test plans for ETL/ELT pipelines to verify data transformations and schema integrity. Perform source-to-target mapping and reconciliation checks across data lakes, warehouses, and reporting layers.
- Implement data-specific automation using AWS DQDL framework.
- Validate performance of large-scale pipelines and identify bottlenecks in data processing runtimes.
- Conduct regression testing to ensure new ETL code deployments do not disrupt existing metrics or KPI calculations.
- Investigate data quality incidents end-to-end and provide technical feedback to engineers and product owners.
- Bachelor's degree in Computer Science, Engineering, or a related technical field.
- 4-7 years of experience in data quality assurance.
- Advanced proficiency in SQL, including complex queries, joins, window functions, and stored procedure validation.
- Proficiency in Python for scripting automated validation checks.
- Experience with cloud data warehouses (Iceberg, AWS Redshift, etc.) and file formats such as Parquet and JSON.
- Hands-on experience validating mappings and data lineage in ETL processes.
- Basic understanding of integrating tests into GitHub Actions workflows.
- Strong knowledge of relational databases and SQL for data validation.
- Experience with RESTful API testing tools like Postman.
- High attention to detail, critical thinking, and strong written and verbal communication skills.
- Familiarity with BI tools like Tableau for dashboard validation.
- Must have minimum 4 years of experience in to QA testing.
- SQL (Strong), Python (Strong), ETL Testing (Strong)