> Markdown version of [/jobs/ext/1348066-senior-test-lead](https://www.wearedevelopers.com/jobs/ext/1348066-senior-test-lead). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Test Lead - **Company:** HCL America Inc. - **Location:** King, NC, United States - **Experience:** Expert - **Salary:** $148,000.0 - **Contract:** Permanent contract - **Skills:** Airflow, Amazon Web Services, Amazon S3, Continuous Integration, Directed Acyclic Graph (Directed Graphs), Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Profiling, Database Testing, Identity and Access Management, Python (Programming Language), Reliability Engineering, Test Case, Strategies of Testing, Data Processing, Performance Testing, Sql Optimization, Delivery Pipeline, Git, Data Lakes, AWS Glue, AWS Data Analytics, Data Pipelines, Amazon Redshift - **Published:** July 19, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=dfb8af927a3a550d ## About the Role SQL-Advanced - window functions, CTEs, set comparisons, complex joins, data profiling queries AWS Data Services-Hands-on experience querying and validating data in Amazon Redshift, AWS Lake Formation, Athena, and S3-based data lakes Python (or equivalent scripting) - Validation scripts, data comparison tools, automation frameworks ETL/ELT Concepts-Deep understanding of extraction, transformation, and loading patterns, including common failure modes QA Methodology-Test planning, test case design, acceptance criteria definition, defect lifecycle management Data Profiling-Statistical profiling, distribution analysis, completeness and uniqueness checks Validation Frameworks-Hands-on experience with at least one: Great Expectations, dbt tests, Soda Core, or equivalent custom frameworks Version Control-Git - managing test suites alongside pipeline code Experience 6-10 years of combined experience in data engineering, data QA, or analytics engineering Has owned data quality for at least one production system end-to-end (not just contributed) Has defined acceptance criteria and quality gates that blocked defective releases Has built automated validation suites that caught real production issues Comfortable reading and reasoning about pipeline code (transformation logic, orchestration DAGs) Experience working with curated/aggregated datasets that serve application UIs Familiarity with AWS Glue, Redshift Spectrum, and AWS data pipeline services Preferred Experience Experience with BDD-style data testing (Given/When/Then for data transformations) CI/CD integration for data quality - automated gates in deployment pipelines Experience defining and tracking data SLAs/SLOs Knowledge of regulatory or compliance data requirements Performance testing for pipelines - verifying latency and throughput Exposure to chaos engineering for data - intentionally injecting bad data to test resilience Experience with pipeline orchestration tools (Glue Orchestrator, Step Functions, Airflow) Experience with IAM permissions and Lake Formation access controls for data governance ## Description Validate transformation logic against business rules and documented specifications Perform source-to-target data reconciliation - verifying completeness, accuracy, and consistency Identify data anomalies, silent failures, and drift in pipeline outputs Build and maintain automated data validation suites that execute as part of pipeline runs Conduct periodic data audits beyond automated checks QA Process Definition & Governance Define acceptance criteria for each ETL pipeline and transformation step Define Definition of Done (DoD) Create and maintain data quality test plans covering functional correctness, edge cases, regression, and performance Design test cases for new transformations Establish data quality SLAs Define entry and exit criteria for pipeline releases Maintain a defect taxonomy - categorizing data issues (schema drift, logic errors, source issues, timing issues) for root cause tracking and trend analysis Define sign-off workflows Test Strategy & Frameworks, Documentation & Traceability, Monitoring, Observability & Reporting, Collaboration Key Responsibilities Data Validation & Verification Validate transformation logic against business rules and documented specifications Perform source-to-target data reconciliation - verifying completeness, accuracy, and consistency Identify data anomalies, silent failures, and drift in pipeline outputs Build and maintain automated data validation suites that execute as part of pipeline runs Conduct periodic data audits beyond automated checks QA Process Definition & Governance Define acceptance criteria for each ETL pipeline and transformation step Define Definition of Done (DoD) Create and maintain data quality test plans covering functional correctness, edge cases, regression, and performance Design test cases for new transformations Establish data quality SLAs Define entry and exit criteria for pipeline releases Maintain a defect taxonomy - categorizing data issues (schema drift, logic errors, source issues, timing issues) for root cause tracking and trend analysis Define sign-off workflows Test Strategy & Frameworks, Documentation & Traceability, Monitoring, Observability & Reporting, Collaboration ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Continuous testing - run automated tests for every change!](https://www.wearedevelopers.com/videos/190-continuous-testing-run-automated-tests-for-every-change) - [How we built an AI-powered code reviewer in 80 hours](https://www.wearedevelopers.com/videos/1511-how-we-built-an-ai-powered-code-reviewer-in-80-hours) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Tips, Techniques, and Common Pitfalls Debugging Kafka](https://www.wearedevelopers.com/videos/838-tips-techniques-and-common-pitfalls-debugging-kafka) ## Related Articles - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence) - [Should senior developers refuse interview coding challenges?](https://www.wearedevelopers.com/magazine/29-should-senior-developers-refuse-interview-coding-challenges) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What is a Test Plan: Guide to Test Planning](https://www.wearedevelopers.com/magazine/191-what-is-a-test-plan-guide-to-test-planning)