QA Test Automation Lead - Data Warehouse & ETL (Snowflake/AWS)

Location: Easton Ops, Columbus, Ohio, United States; office workplace

Salary: $70,000–$140,000 annual base compensation

Company

hirify.global is a financial services company providing banking products and services.

What you will do

• Lead QA activities across Data Warehouse and Data Lake projects.
• Create test strategies, test plans, and testing status reports.
• Coordinate testing 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, data quality testing, and SQL-based troubleshooting.
• Support and expand automated testing solutions while improving testing processes, documentation, and reporting.

Requirements

• 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 experience with Snowflake, AWS, Python, and QA Lead responsibilities.
• At least 1 year of hands-on test automation experience.
• Experience validating data mappings, transformation logic, business requirements, and data quality.

Nice to have

• Experience with DataStage, Informatica, AWS Glue, or similar ETL tools.
• Experience with PyTest, Selenium, DBT tests, Azure DevOps, and CI/CD processes.
• Banking or financial services experience and familiarity with Agile teams.
• Knowledge of star schemas, fact tables, dimension tables, and data lineage.
• Strong Excel skills, including formulas, pivot tables, and macros.

Culture & Benefits

• Office-based workplace with specific work arrangements provided by the hiring team.
• Health insurance, wellness programs, life and disability insurance, and retirement savings plans.
• Paid leave, paid holidays, and paid time off.
• Eligibility to participate in an applicable incentive compensation plan.