QA Test Automation Lead - Data Warehouse & ETL

0101 The Huntington National Bank; United States; On-site; USD 70,000 - 140,000; Full time

Benefits offered by this job

Health insurance

Wellness program

Life and disability insurance

Retirement savings plan

Paid leave

Paid holidays and PTO

Job summary

Huntington National Bank is seeking a hands-on QA Test Automation Lead to support Enterprise Data Warehouse and Data Lake initiatives. You will lead QA efforts, define test strategies, and drive automation across ETL pipelines, data validation, and data mappings.

On a cross-functional team, you will coordinate testing activities, oversee regression and data reconciliation, and mentor QA staff. Strong SQL, Snowflake, AWS, Python, and CI/CD experience are essential.

Qualifications

• 5+ years of ETL testing in a Data Warehouse or Data Lake environment.
• 5+ years of SQL experience.
• 2+ years coordinating QA activities as a lead.
• 1+ year hands-on test automation experience.

Responsibilities

• 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 for data comparison and validation.

Skills

ETL testing

SQL

QA leadership

Test automation

Data validation

Agile teams

Education

Bachelor's degree or equivalent experience

Tools

Snowflake

AWS

Python

PyTest

Selenium

Azure DevOps

CI/CD tools

Job description

Description Summary 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.

Key Responsibilities

• 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.

Basic Qualifications

• 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.

Exempt Status: Yes

Workplace Type: Office

Our Approach to Office Workplace Type

Certain positions outside our branch network may be eligible for a flexible work arrangement. We’re combining the best of both worlds: in-office and work from home. Our approach enables our teams to deepen connections, maintain a strong community, and do their best work. Remote roles will also have the opportunity to come together in our offices for moments that matter. Specific work arrangements will be provided by the hiring team.

Compensation Range: 70,000.00 - 140,000.00 USD Annual

The compensation range represents the anticipated low and high end of the base compensation range for this position. Actual compensation will vary based on various factors including but not limited to location, experience, and education.

Benefits

• Health insurance coverage
• Wellness program
• Life and disability insurance
• Retirement savings plan
• Paid leave programs
• Paid holidays and paid time off (PTO)

Huntington is an Equal Opportunity Employer.

Company Culture

Welcome to Huntington! At Huntington, we look out for people. From reinventing banking with game-changing innovations to building an internal culture that creates lifelong bonds, together, we can make people’s lives better. And amazing things happen when we look out for each other. We prove it every day. Whether it’s helping a colleague or collaborating on a new tool that will revolutionize the way people save money, our actions can have a huge impact. Our colleagues look out for people with a Can-Do Attitude, Service Heart and Forward Thinking. Those are our values—simple but powerful. Each of them pushes us do the right thing, to do right by people. Because people are what matter.

Accessibility

We endeavor to make this site accessible to any and all users. If you would like to contact us regarding the accessibility of this site or if you require a reasonable accommodation to apply for a job or to perform the essential functions of the job, please send an email to [e-mail].

Reasonable Accommodations

Various methods will be used throughout the recruitment process to verify candidate authenticity. Any interviews conducted virtually must be joined from a distraction-free environment, with the candidate on camera and without the use of virtual backgrounds.

EEOC Disclaimer

Know Your Rights CA Data Privacy CA Data Privacy Rights Tobacco Disclaimer Tobacco-Free Hiring Practice.