ETL - QA Engineer

Algoworks

www.algoworks.com

About the Company

We are a global team of engineers, architects, designers, researchers, operators and innovators who share a passion for achieving client goals. Our engineering services help businesses thrive at the intersection of technology and people. From the latest AI implementations to legacy platform migrations and everything in between, our services span the enterprise technology spectrum. Our world class experience transformation playbook elevates digital success and increases ROI with a relentless focus on the human experience. Our customer base includes Fortune 500 companies around the globe. Weve got the skills and insights and were also fun to work with. Our global team spans a diverse cultural spectrum, with wide ranging interests, enabling us to bring personality and depth to every engagement.

Follow the video below to know about US!

Candidate Video

QA Engineer Data & Platform Quality Assurance

Experience Level

57 years of experience in data quality, ETL testing, and automation testing for data platforms.

Role Overview

The QA Engineer will ensure data accuracy, reliability, and SLA adherence across the Azure data platform. This role focuses on validating ETL pipelines, Synapse models, APIs, lineage, and reconciliation, with strong emphasis on automation and continuous testing.

The QA engineer will work closely with data engineers, DWH developers, and DevOps teams to embed quality checks throughout the delivery lifecycle.

Key Responsibilities

Data & ETL Testing

Validate data quality, schemas, row counts, and business logic.

Test ETL pipelines built in Databricks and ADF.

Validate Silver and Gold layer transformations.

Data Warehouse & API Testing

Test Synapse data models, views, and stored procedures.

Perform API testing for metadata, lineage, and reporting services.

Validate API responses, security, and performance.

Automation & CI Testing

Build and maintain automated test suites for ETL and APIs.

Integrate data and API tests into CI pipelines.

Use automation frameworks such as pytest, Selenium, or Tosca.

Lineage, Reconciliation & SLA Validation

Validate data lineage completeness and accuracy.

Perform source-to-target reconciliation.

Validate SLAs, data freshness, and pipeline execution windows.

Required Skills & Experience

Technical Skills

Strong experience in ETL testing and data validation.

Strong SQL skills for data validation.

Experience with API testing tools and frameworks.

Experience with test automation frameworks (pytest, Selenium, Tosca).

Knowledge of data quality checks and reconciliation techniques.

Experience integrating tests into CI pipelines.

Soft Skills

Strong analytical and attention-to-detail skills.

Ability to work across engineering and business teams.

Strong documentation and defect tracking skills.

Nice to Have

Experience testing cloud-based data platforms.

Exposure to data governance or lineage tools.

Familiarity with Azure DevOps pipelines.