SDET II - ETL Testing

Location: Vasanthanagar

About Quince
Founded in 2018, Quince was built to challenge the idea that premium quality must come with a high price tag. Our mission is simple: to deliver high-quality essentials at radically low prices, produced in a fair and sustainable way.
We operate on a direct-to-consumer (DTC) model, eliminating middlemen and leveraging just-in-time manufacturing to reduce waste and maximize value. By combining craftsmanship, transparency, and innovation, we make timeless products accessible to everyone.
Quince is also a technology-driven company, using AI, analytics, and automation to disrupt the traditional retail industry.
Our Values
Customer First  – Every decision starts with the customer.
High Quality  – Premium materials and rigorous production standards.
Essential Design  – Timeless, functional products over fleeting trends.
Always a Better Deal  – Transparency and innovation drive value.
Social & Environmental Responsibility  – Ethical production and sustainability are at the core of what we do.
We partner with world-class manufacturers globally and serve millions of customers, backed by strong investors and a focus on sustainable growth.

Our Team & Culture
At Quince, you’ll join a high-performing team redefining quality, value, and sustainability in modern retail. We are builders, innovators, and operators united by a bold ambition:  to democratize luxury .

We’re creating a new category and customer experience—one that demands excellence, ownership, and continuous improvement. If you’re driven by impact, growth, and purpose, you’ll find a strong sense of belonging here.

About the Role
We are looking for a highly skilled  SDET 2 – ETL Tester  to join our Data Engineering team.
In this role, you will validate data pipelines, ETL processes, and data warehouse systems through scalable automation frameworks. You will work closely with Data Engineers, Backend Engineers, and Analytics teams to ensure data accuracy, integrity, and reliability across large-scale data systems.

Key Responsibilities
ETL & Data Validation
Validate data transformations across ETL/ELT pipelines.
Perform source-to-target data validation.
Write complex SQL queries for reconciliation and data analysis.
Validate large datasets across data warehouses and data lakes.
Perform data quality checks, including nulls, duplicates, schema validation, and referential integrity.
Automation & Framework Development
Build and maintain automated data validation frameworks.
Automate regression testing for data pipelines.
Integrate ETL test suites into CI/CD pipelines.
Develop reusable testing utilities to reduce manual validation efforts.
Pipeline & Workflow Testing
Test batch and real-time data pipelines.
Validate workflows in orchestration tools such as Airflow.
Perform incremental load and Change Data Capture (CDC) validation.
Ensure API-to-database data consistency.
Quality & Performance
Perform performance testing on large datasets.
Identify data inconsistencies and conduct root cause analysis.
Ensure adherence to data governance and compliance standards.
Maintain test documentation, reports, and quality dashboards.

Required Qualifications
2–6 years of experience in ETL/Data Testing or a related SDET role.
Strong SQL skills, including joins, aggregations, and window functions.
Experience working with data warehouses such as Snowflake, Redshift, or Big Query.
Hands-on experience with ETL tools such as Informatica, Talend, or dbt.
Programming experience in Python or Java.

Experience with CI/CD tools such as Jenkins, Git Hub Actions, or Git Lab CI.
Strong understanding of data modeling concepts, including fact/dimension models and star schemas.
Experience testing large-scale datasets with millions or more records.

Preferred Qualifications

Experience with cloud platforms such as AWS, Azure, or GCP.
Knowledge of big data technologies such as Spark or Hadoop.

Experience with orchestration tools such as Airflow.
Familiarity with data quality tools such as Great Expectations or Deequ.
Exposure to BI tools such as Tableau or Power BI and experience validating BI data.