Key skills
PythonSQLETLELTBITableauSnowflakedbtAzureAzure DevOpsSQL ServerGitVersion ControlJira
About this role
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/
Job Title: QA Engineer - Data
Experience: 4-5 Years
Location: Chennai
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.
You can learn more about us at: http://www.cesltd.com/
Job Title: QA Engineer - Data
Experience: 4-5 Years
Location: Chennai
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.