The role involves testing ETL processes, backend data validation, and automation testing of data pipelines and APIs, while ensuring data quality and integrity.
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
APIs
AWS
ETL
Informatica
Postgres
Redshift
Snowflake
SQL
SQL Server
Ssis
Talend
Similar Jobs
Food
The Quality Specialist will implement QA programs, ensure product quality, conduct audits, train employees, and resolve quality-related issues.
Top Skills:
MS Office
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Lead and support R&D projects in automation, manage project documentation, conduct research, coordinate equipment testing, and prepare technical reports.
Top Skills:
Allen-BradleyAutomation HardwareAutomation SoftwareAutomation TechnologyBeckhoffCadMechatronics EngineeringPlc ProgrammingSiemens
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a UI Engineer, you will build and maintain single-page web applications with Ember.js, collaborate with diverse teams, and drive technical aspects of product delivery.
Top Skills:
AWSCSSEmberGitHTMLJavaScriptMochaPostcssQunitSassTailwind Css
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.
