> Markdown version of [/jobs/ext/1421139-senior-automation-test-lead-etl-dw-automation](https://www.wearedevelopers.com/jobs/ext/1421139-senior-automation-test-lead-etl-dw-automation). 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 Automation Test Lead - ETL, DW Automation - **Company:** HCL America Inc. - **Location:** Dallas, TX, United States - **Experience:** Expert - **Salary:** $160,000.0 - **Contract:** Permanent contract - **Skills:** Software Applications, Automation of Tests, Software Bug Management, Cloud Computing, Cloud Database, Cloud Testing, Data Validation, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Apache JMeter, Selenium, Software Deployment, SQL Databases, Tableau (Software), Test Case, Strategies of Testing, Cloud Platform System, Looker Analytics - **Published:** July 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=5df1fe4910467d78 ## About the Role Business & Validation BI Report Testing Data Reconciliation SQL Validation UAT Coordination Stakeholder Skills Business Communication Defect Management Report Certification Nice to Have Tableau Report Consumption Experience Looker User Experience Experience 5+ years in BI validation, analytics testing, or reporting QA. Experience validating enterprise dashboards and reports. 1. Proven experience in cloud automation testing, etl, and data warehouse automation. 2. Strong knowledge of testing methodologies, tools, and best practices in cloud environments. 3. Proficiency in creating and executing automation scripts using tools like selenium, jmeter, or similar. 4. Familiarity with etl processes, data validation, and data reconciliation techniques. 5. Excellent analytical and problem-solving skills to identify and address testing gaps effectively. 6. Ability to lead a team, prioritize tasks, and communicate effectively with stakeholders. 7. Certifications in cloud testing, automation testing, or related fields would be a plus., 1.Relevant certifications in Cloud Testing, Automation Testing, or ETL/DW Automation are beneficial. ## Description The Senior Test Lead in Cloud Automation Testing focuses on leading the testing efforts in the cloud environment, automation testing, ETL (Extract, Transform, Load), and data warehouse automation. The role involves ensuring the quality and reliability of software applications developed within the cloud ecosystem and data warehousing processes. Key Responsibilities Work with report owners and business users. Execute Tableau versus Looker comparison testing. Validate metric outputs, calculations, filters, and drill-down behavior. Create and maintain test scenarios. Coordinate SIT and UAT. Log and manage defects. Obtain business sign-offs. Certify report readiness for production deployment. 1. Plan, design, and execute test strategies for cloud applications, ensuring comprehensive testing coverage. 2. Implement and maintain automated testing frameworks for efficient and reliable testing processes. 3. Lead and mentor the testing team to deliver high-quality results within the stipulated timelines. 4. Collaborate with cross functional teams to identify testing requirements and priorities. 5. Perform etl testing and ensure data accuracy and integrity in data warehouse automation projects. 6. Develop test cases, scenarios, and scripts to validate data transformations and load processes. 7. Monitor test results, identify defects, and work with development teams to resolve issues promptly. 8. Stay updated on industry best practices, tools, and technologies related to cloud testing and data automation processes. ## Related Videos - [Proactive monitoring and smoke testing in your production environment](https://www.wearedevelopers.com/videos/139-proactive-monitoring-and-smoke-testing-in-your-production-environment) - [AIQSpecFlow: Improves and automates your agile process of specification and creation of testcases.](https://www.wearedevelopers.com/videos/100084-aiqspecflow-improves-and-automates-your-agile-process-of-specification-and-creation-of-testcases) - [Continuous testing - run automated tests for every change!](https://www.wearedevelopers.com/videos/190-continuous-testing-run-automated-tests-for-every-change) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [AI as a Test Designer: Transforming Experience into Automated Testing](https://www.wearedevelopers.com/videos/1984-ai-as-a-test-designer-transforming-experience-into-automated-testing) - [SMART Test Automation - the experience of legacy transformation](https://www.wearedevelopers.com/videos/100215-smart-test-automation-the-experience-of-legacy-transformation) ## Related Articles - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [Integration And E2E Testing: Are They Complementary or Interchangeable?](https://www.wearedevelopers.com/magazine/86-integration-and-e2e-testing-are-they-complementary-or-interchangeable) - [What is a Test Plan: Guide to Test Planning](https://www.wearedevelopers.com/magazine/191-what-is-a-test-plan-guide-to-test-planning) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)