As a Senior QA Engineer, you will ensure the quality of ETL processes, APIs, and data pipelines through testing and automation. You will develop test cases, collaborate with teams, write SQL queries, and maintain data integrity while following best practices in CI/CD. Your role includes backend testing across environments and validating reporting tools.
Overview:
We’re looking for a Senior QA Engineer with a strong background in ETL, backend data validation, and automation testing. This role is all about ensuring the quality of data pipelines, APIs, and reporting systems while helping to implement automated testing frameworks. You’ll be working with complex financial datasets, ensuring smooth and accurate data movement across various systems. If you’re detail-oriented, analytical, and driven to solve problems efficiently, this role is for you.
Key Responsibilities
- Test ETL/ELT processes, APIs, and data pipelines to ensure data accuracy and integrity.
- Develop and maintain automated and manual test cases for backend systems and reporting tools.
- Collaborate with teams to identify, document, and resolve issues.
- Write and optimize SQL queries for advanced testing scenarios.
- Introduce and follow best practices for continuous integration and delivery (CI/CD).
- Implement strategies to monitor and maintain data integrity over time.
- Ensure deliverables meet functional, design, and business requirements.
- Identify and mitigate QA risks proactively.
- Perform backend testing across multiple environments, focusing on database and API validation.
- Validate dashboards and reports (e.g., Looker Studio, BigQuery).
Required Skills & Experience:
- 3+ years of experience in QA for ETL, data pipelines, and backend systems.
- Proficiency with ETL tools (e.g., Informatica, SSIS, Talend).
- Advanced SQL skills, with the ability to write and optimize complex queries.
- Experience with API testing (SOAP/REST) and large datasets.
- Strong communication skills and a team-oriented mindset.
- A self-starter with a passion for delivering high-quality results.
- Proven ability to handle complex data systems and ensure data quality.
Nice To Have
- Familiarity with cloud platforms (AWS, Snowflake) and RDBMS like SQL Server, PostgreSQL, or Redshift.
#LI-TH1 #LI-Hybrid
Top Skills
SQL
Similar Jobs
Be an Early Applicant
The Quality Engineer will ensure adherence to quality standards in production processes and finished goods. Responsibilities include conducting engineering evaluations, using system analysis tools, leading root cause analysis, and collaborating across departments to resolve customer concerns and improve quality practices.
Be an Early Applicant
The Quality Assurance Lead at Mondelēz International is responsible for overseeing food safety and quality programs, managing a team of Quality Technicians, and implementing continuous improvement processes. This includes facilitating root-cause analysis, training teams in CI tools, and maintaining compliance with safety standards while supporting various quality initiatives.
Be an Early Applicant
The Software Quality Assurance Specialist will develop testing strategies, execute and implement test plans for vehicle systems, and collaborate with teams for software verification across ICE, Electric, and Autonomous vehicles. The role emphasizes the creation of automated test scripts and requires proficiency in C/C++ and Python, among other technologies.
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.