CES Family of Companies

QA Engineer – Data

CES Family of Companies

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLSQL

About the role

  • Ensure data quality and integrity across the enterprise HCM data platform by designing and executing comprehensive test strategies for data pipelines, transformations, and reporting layers.
  • Validate data accuracy from source to target across Bronze/Silver/Gold layers and ensure data meets business requirements and quality standards.
  • Design and execute data validation test cases for ETL/ELT pipelines from source (SQL Server) to target (Snowflake).
  • Validate data transformations across medallion architecture layers (Bronze → Silver → Gold).
  • Perform source-to-target reconciliation testing including record counts, aggregations, and data accuracy checks.
  • Test CT (Change Tracking) and incremental load scenarios for data completeness and correctness.
  • Validate SCD Type 1 and Type 2 implementations for historical data tracking.
  • Test Row-Level Security (RLS) implementations to ensure proper data access controls per persona.
  • Create and maintain SQL-based test scripts for automated data validation.
  • Perform regression testing when pipeline changes are deployed.
  • Validate data quality rules including null checks, referential integrity, duplicate detection, and business rule validations.
  • Test data lineage and ensure traceability from source to reporting layer.
  • Document test cases, test results, and defects in tracking tools.
  • Collaborate with data engineers to identify root causes and verify bug fixes.
  • Support UAT by preparing test data and validating business scenarios.

Requirements

  • 4-5 years of experience in data quality and integrity.
  • SQL: Strong SQL skills for writing complex queries, data comparison scripts, and validation logic (joins, aggregations, window functions, CTEs).
  • Data Warehouse Concepts: Understanding of dimensional modeling, fact/dimension tables, star schema, and slowly changing dimensions.
  • ETL/ELT Testing: 2+ years of experience testing data pipelines, transformations, and data loads.
  • Data Quality Testing: Experience with source-to-target validation, data profiling, and reconciliation.
  • Snowflake: 1+ years hands-on experience querying and validating data in Snowflake.
  • Test Documentation: Experience creating test plans, test cases, and defect reports.
Benefits
  • Flexible working hours to create a work-life balance.
  • Opportunity to work on advanced tools and technologies.
  • Global exposure to not only collaborate with the team, but also to connect with the client portfolio and build professional relationships.
  • Highly encouraged for any innovative ideas & thoughts and we support in executing the same.
  • Periodical and on-spot rewards and recognitions on your performance.
  • Provides a better platform for enhancing skills via many different L&D programs.
  • Enabling and empowering atmosphere to work along.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLETLELTdata validationdata quality testingdata profilingreconciliation testingtest documentationdata transformationsdata lineage
Soft Skills
collaborationproblem-solvingattention to detailcommunication