ETL Test Engineer

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

What’s in it for you

At Schwab, you’re empowered to shape your future. We champion your growth through meaningful work, continuous learning, and a culture of trust and collaboration—so you can build the skills to make a lasting impact. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.

We offer a competitive benefits package that takes care of the whole you – both today and in the future:

• 401(k) with company match and Employee stock purchase plan

• Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions

• Paid parental leave and family building benefits

• Tuition reimbursement

• Health, dental, and vision insurance

What’s in it for you:

At Schwab, we’re committed to empowering our employees’ personal and professional success. Our purpose-driven, supportive culture, and focus on your development means you’ll get the tools you need to make a positive difference in the finance industry. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.

We offer a competitive benefits package that takes care of the whole you – both today and in the future:

401(k) with company match and Employee stock purchase plan

Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions

Paid parental leave and family building benefits

Tuition reimbursement

Health, dental, and vision insurance

Schwab is an affirmative action employer, focused on employing and advancing in employment, qualified women, racial and ethnic minorities, protected veterans, and individuals with disabilities in the workplace. If you have a disability and require reasonable accommodations in the application process, contact Human Resources at View email address on click.appcast.io or call View phone number on click.appcast.io.