Note: The job is a remote job and is open to candidates in USA. CES is a company with over 26 years of experience in delivering software product development and quality engineering services. They are seeking a QA Engineer (Data) to ensure data quality and integrity across their enterprise HCM data platform by designing and executing test strategies for data pipelines and transformations.
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
Skills
• 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
• 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
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.
Company Overview
• CES is an information technology and business process management company. It was founded in 1996, and is headquartered in Bolingbrook, Illinois, USA, with a workforce of 1001-5000 employees. Its website is https://cesltd.com.
Company H1B Sponsorship
• CES has a track record of offering H1B sponsorships, with 14 in 2025, 10 in 2024, 7 in 2023, 13 in 2022, 11 in 2021, 15 in 2020. Please note that this does not guarantee sponsorship for this specific role.