ETL Test Engineer

Charles Schwab Corporation; Southlake (TX); On-site; USD 110,000 - 170,000; Full time

Job summary

Charles Schwab Corporation's Schwab Technology Services is seeking a senior QA engineer to lead quality efforts for data engineering initiatives. You will partner with Product Owners and development teams from PI planning through release to ensure high-quality deliverables and scalable test automation.

This role focuses on defining test strategies, overseeing testing cycles, and driving continuous quality improvements across data warehouse projects.

Qualifications

• 10+ years of overall experience with at least 8 years in Quality Engineering for data warehouse/ETL projects.

Responsibilities

• Participate in PI planning and review requirements and technical design documents to provide feedback to Product Owners and development teams.
• Estimate, prioritize, plan, and coordinate testing activities across an assigned portfolio.
• Plan and manage release testing cycles and timelines across multiple initiatives.
• Define, maintain, and update test strategies for new development, enhancements, and defect fixes.
• Review high-level test scenarios and collaborate with QA team members to create detailed test plans and cases.
• Lead the execution of functional testing for new/enhanced features and regression testing for defects.
• Identify, document, track, and triage defects; ensure timely resolution and closure.
• Design, develop, and execute test automation scripts.
• Identify and manage risks impacting release scope, schedule, and quality.
• Monitor UAT and production defect leakage; validate and prioritize UAT defects without delaying timelines.
• Communicate testing progress, results, and risks to stakeholders; provide QA sign-off.
• Serve as SME for QA automation tools and guidance to development teams.

Skills

Data warehouse testing

ETL testing

Python scripting

SQL data validation

Unix shell

Test automation

Agile methodologies

Cloud platforms

Data engineering

Tools

IICS

PowerCenter

Google Cloud Platform (GCP)

CI/CD tools (Bamboo, Bitbucket, GitHub, GitHub Actions)

Jira

Rally

JMeter

AppDynamics

Control-M

Job description

Your Opportunity

At Schwab, you’re empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us challenge the status quo and transform the finance industry together.

Schwab Technology Services enables the future of how clients manage their money by providing innovative and reliable technology products and services, as part of our ongoing commitment to democratize access to investing and financial planning.Join a high-impact QA organization where you will lead quality engineering efforts across a portfolio of data engineering initiatives. In this role, you will partner closely with Product Owners and development teams from PI planning through release to ensure high-quality deliverables. You will define and execute test strategies, oversee testing cycles, and drive continuous quality improvements through automation. This is an opportunity to influence product quality at scale while serving as a subject matter expert in test automation and quality engineering best practices.

Key Responsibilities

• Participate in PI planning and review requirements and technical design documents to provide timely, meaningful feedback to Product Owners and development teams
• Estimate, prioritize, plan, and coordinate testing activities across an assigned portfolio
• Plan and manage release testing cycles and timelines across multiple initiatives
• Define, maintain, and update test strategies for new development, enhancements, and defect fixes
• Review high-level test scenarios and collaborate with QA team members (including offshore teams) to create detailed, comprehensive, and well-structured test plans and test cases
• Ensure the creation and maintenance of a robust test scenario library
• Lead the execution of functional testing for new and enhanced features, as well as regression testing for defect resolution
• Identify, document, track, and triage defects; ensure timely resolution and closure
• Design, develop, and execute test automation scripts
• Identify and manage risks and resolve issues impacting release scope, schedule, and quality
• Monitor UAT and production defect leakage; ensure validation and prioritization of UAT defects without impacting critical timelines
• Communicate testing progress, results, and risks to stakeholders; provide QA sign-off
• Serve as a subject matter expert (SME) for QA automation tools, providing consultation and guidance to development teams

What you have

Required Qualifications

• 10+ years of overall experience, including at least 8 years as a Quality Engineer supporting data warehouse and ETL projects
• Experience working on large-scale data engineering initiatives
• Hands-on experience testing data warehouse ETL applications, specifically using IICS or PowerCenter
• Experience with cloud technologies, preferably Google Cloud Platform (GCP)
• Experience with Python scripting
• Strong proficiency in SQL for data validation, data flow testing, and data analysis
• Experience working in Unix environments, including basic shell scripting
• Strong understanding of DevOps concepts with hands-on experience using CI/CD tools such as Bamboo, Bitbucket, GitHub, and GitHub Actions
• Experience implementing and improving testing strategies, including both manual and automated approaches
• Expertise in root cause analysis and defect diagnosis
• Experience implementing test automation within data warehouse environments
• Experience working in Agile frameworks using tools such as Jira or Rally
• Advanced knowledge of the software development lifecycle (SDLC)
• Demonstrated ability to collaborate across cross-functional teams to achieve shared objectives
• Strong analytical, problem-solving, negotiation, and troubleshooting skills
• Excellent written and verbal communication skills
• Ability to work independently in a fast-paced environment with competing priorities and strict deadlines
• Ability to clearly summarize and present testing results to stakeholders
• Strong customer service mindset with the ability to build relationships across the organization

Preferred Qualifications

• Experience with Microsoft Office tools, including Excel (macros), Word, and related applications
• Experience working with Control-M
• Performance testing experience, including tools such as JMeter, AppDynamics, or similar