> Markdown version of [/jobs/ext/1237786-qa-test-automation-lead-data-warehouse-etl](https://www.wearedevelopers.com/jobs/ext/1237786-qa-test-automation-lead-data-warehouse-etl). 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). --- # QA Test Automation Lead - Data Warehouse & ETL - **Company:** Huntington Bancshares - **Location:** South Houston, United States (Remote available) - **Experience:** Expert - **Salary:** $70,000.0 - $140,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Agile Methodology, Amazon Web Services, Application Testing, Automation of Tests, Microsoft Azure, Data Validation, Data Integration, Extract Transform Load (ETL), Data Warehousing, IBM InfoSphere DataStage, Python (Programming Language), Pivot Tables, Selenium, SQL Databases, Systems Integration, Strategies of Testing, Data Processing, Macros, Informatica Powercenter, Snowflake, Pytest, Data Lakes, Data Lineage, AWS Glue - **Published:** July 11, 2026 - **Apply:** https://huntington.wd12.myworkdayjobs.com/HNBcareers/job/Easton-Ops-Cols-C-Oh/QA-Test-Automation-Lead--Data-Warehouse_R0068802 ## About the Role * Bachelor's degree or equivalent experience. * 5+ years of ETL testing experience in a Data Warehouse or Data Lake environment. * 5+ years of SQL experience. * 2+ years of Snowflake experience. * 2+ years of AWS experience. * 2+ years of Python experience. * 2+ years of QA Lead experience coordinating testing activities. * 1+ year of hands-on test automation experience. Preferred Qualifications * Experience with source-to-target validation, data reconciliation, and data quality testing. * Strong Excel skills, including formulas, pivot tables, and macros. * Experience working in Agile teams. * Banking or financial services experience. * Experience with DataStage, Informatica, AWS Glue, or similar ETL tools. * Experience designing, implementing, or expanding automated testing frameworks. * Experience establishing a test automation suite for a team or application. * Experience with PyTest, Selenium, DBT tests, or similar automation tools. * Experience with Azure DevOps and CI/CD processes. * Knowledge of data warehouse concepts, including star schemas, fact tables, dimension tables, and data lineage. * Demonstrated ability to improve processes, documentation, and team efficiency. #LI-MH1 #LI-BM1 ## Description Huntington Bank is seeking a hands-on QA Test Automation Lead to support Enterprise Data Warehouse and Data Lake initiatives. This role combines QA leadership, ETL testing, SQL-based data validation, and test automation. The ideal candidate has deep experience testing data pipelines and integrations, leading QA efforts, and driving process improvements through automation and innovation. This is primarily a Data Warehouse QA role, not a traditional UAT, Salesforce, or application testing position. Candidates should demonstrate strong ETL testing, SQL, Snowflake, AWS, Python, and data validation experience, along with prior QA leadership and test automation experience., * Lead QA activities across Data Warehouse and Data Lake projects. * Create test strategies, test plans, and testing status reporting. * Coordinate testing efforts across QA resources and project teams. * Execute and oversee ETL, data integration, system integration, regression, and UAT testing. * Perform source-to-target validation, data reconciliation, and data quality testing. * Analyze and troubleshoot data issues using SQL. * Validate data mappings, transformation logic, and business requirements. * Support and expand test automation solutions. * Utilize Excel, including formulas, pivot tables, and macros, for data comparison and validation. * Identify opportunities to streamline testing processes, documentation, and reporting. ## Related Videos - [SMART Test Automation - the experience of legacy transformation](https://www.wearedevelopers.com/videos/100215-smart-test-automation-the-experience-of-legacy-transformation) - [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) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [pytest: Simple, rapid and fun testing with Python](https://www.wearedevelopers.com/videos/213-pytest-simple-rapid-and-fun-testing-with-python) - [Tips, Techniques, and Common Pitfalls Debugging Kafka](https://www.wearedevelopers.com/videos/838-tips-techniques-and-common-pitfalls-debugging-kafka) - [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper) ## Related Articles - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools) - [Should senior developers refuse interview coding challenges?](https://www.wearedevelopers.com/magazine/29-should-senior-developers-refuse-interview-coding-challenges) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Integration And E2E Testing: Are They Complementary or Interchangeable?](https://www.wearedevelopers.com/magazine/86-integration-and-e2e-testing-are-they-complementary-or-interchangeable) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What is a Test Plan: Guide to Test Planning](https://www.wearedevelopers.com/magazine/191-what-is-a-test-plan-guide-to-test-planning)