Lead QA Test Analyst, Data Warehouse

0101 The Huntington National Bank - Columbus, OH

Full-time

Hybrid - Columbus, OH

About the position

The Lead QA Test Analyst at Huntington Bank will play a crucial role in ensuring the quality of data across the Enterprise Data Warehouse (EDW). This position involves developing test strategies and plans for Data Warehouse projects, executing test cases, and collaborating with various technology teams to uphold IT SDLC processes. The ideal candidate will have a strong background in ETL testing and a passion for data quality and continuous improvement.

Responsibilities

• Actively participate in the review of project requirements, data mappings, and technical design specifications.
• Create test strategies and test plans for Data Warehouse projects, ensuring proper test coverage.
• Execute test cases using manual and/or automated test processes.
• Execute database queries to support test execution in Azure DevOps.
• Perform ETL validation according to data mapping, execute data profiling, and reconciliation of data.
• Analyze data, troubleshoot data issues, and create action plans to address data quality issues.
• Coordinate test execution with other application teams and UAT partners.
• Create and communicate test status with project team members and stakeholders.
• Identify, document, and communicate testing defects.
• Collaborate with project team on defect analysis and triage.
• Support continuous improvement by identifying and solving opportunities to enhance QA processes.
• Perform functional, regression, negative, and migration testing for Data Warehouse projects.

Requirements

• Bachelor's degree
• 5+ years of ETL testing experience in a data warehouse environment.
• 5+ years of experience analyzing data, troubleshooting data issues, and creating action plans to address data quality issues.
• 5+ years of experience writing SQL queries.
• 2+ years of experience with Snowflake and AWS Cloud.
• 2+ years of experience leading QA Analysts on a project team.

Nice-to-haves

• Experience in the financial services (banking) industry.
• Experience testing on Snowflake and AWS S3/EC2/EMR.

Benefits

• Equal employment opportunities regardless of race, color, religion, sex, national origin, age, disability, sexual orientation, veteran status, gender identity and expression, genetic information, or any other basis protected by law.