Quality Engineer (Data)

CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services to Global SMEs & Large Enterprises. CES has been delivering services to some of the leading Fortune 500 Companies including Automotive, AgTech, Bio Science, EdTech, FinTech, Manufacturing, Online Retailers, and Investment Banks. These are long-term relationships of more than 10 years and are nurtured by not only our commitment to timely delivery of quality services but also due to our investments and innovations in their technology roadmap. As an organization, we are in an exponential growth phase with a consistent focus on continuous improvement, process-oriented culture, and a true partnership mindset with our customers. We are looking for the right qualified and committed individuals to play an exceptional role as well as to support our accelerated growth.

You can learn more about us at: http://www.cesltd.com/

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. You will validate data accuracy from source to target across Bronze/Silver/Gold layers and ensure data meets business requirements and quality standards.

Key Responsibilities:

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

Required Skills & Qualifications:

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

Nice to Have:

Test automation frameworks for data validation (Python, Great Expectations, dbt tests)

Experience with CDC/Change Tracking based data ingestion testing

BI Testing: Basic validation of reports/dashboards (Tableau)

Git: Version control for test scripts

Jira/Azure DevOps: Defect tracking and test management

Performance testing for data pipelines

Why CES :

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.