ETL QA Engineer

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.

We believe in the importance of in-office collaboration and fully intend for the selected candidate for this role to work on site in the specified location(s).

Applicants must be currently authorized to work in the United States on a full time basis without employer sponsorship.

We are looking for an ETL QA Engineer with strong DW/ETL testing experience.

This role requires 10+ years of overall experience with at least 8 years as a Quality Engineer in Data warehouse and ETL.

The ETL QA Engineer (individual contributor) role is a high visibility role to collaborate with junior quality engineers that are collectively responsible for creating test plans, and execute functional, regression and automated testing for all new development and critical enhancement projects in Schwab Data.

Core responsibilities include creating test strategy, effort estimation, planning and coordinating functional and end to end testing activities across all impacted teams.

The ETL QA Engineer will also ensure that quality issues and defects are appropriately identified, documented, tracked and resolved.

**What you'll do:**

+ Participate in PI planning, review requirements specifications and technical design documents to provide timely and meaningful feedback to Product Owners and DEV teams
+ Estimate, prioritize, plan and coordinate testing activities for the assigned portfolio
+ Forward Plan the release test windows/cycles across a portfolio
+ Create Test strategy and update the strategy for each scheduled new development projects, enhancement projects and break fixes
+ Review high level test scenarios and socialize the same with all stake holders and collaborate with the junior QA team members to create detailed, comprehensive and well-structured test plans and test cases for the assigned projects
+ Ensure that team catalogs and maintain test scenario library
+ Drive the team to create detailed, comprehensive and well-structured test plans and test cases for the assigned projects
+ Ensure that the team runs all planned functional test cases for new projects/enhancements projects and performs thorough regression testing when bugs are resolved
+ Identify, record, document thoroughly and track/triage defects and resolve all open defects
+ Design, develop and execute test automation scripts
+ Identify/manage risks and resolves issues that affect release scope, schedule and quality
+ Monitor UAT/Prod defect leakage and ensure that UAT defect validations in QA region are planned/prioritized and ensure that critical project timelines are not impacted
+ Present testing results and progress to all stake holders and provide QA signoff
+ Be an SME for automation tools used by QA team for all DEV teams and respond to any consultation request raised by anyone from DEV teams

**What you have**

**Required Qualifications:**

+ 10+ years of overall experience with at least 8 years as a Quality Engineer in Data warehouse and ETL
+ Expert level knowledge and hands-on experience writing/understanding advanced SQL queries/scripts to test data flow and perform data analysis
+ Experience in working on large scale data engineering projects
+ Experience in testing Data Warehouse ETL applications specifically using IDMC/PowerCenter
+ Experience in cloud technologies specifically in GCP
+ Experience in python scripting
+ Experienced in Unix/Linux and have basic knowledge in writing and analyzing shell scripts
+ Experience in reviewing testing strategies and engineering best practices related to software test engineering, and implementing the same for both manual and automated testing
+ Experience in root cause analysis and defect diagnosis techniques
+ Experience with implementation of test automation for data warehouse testing
+ Documented experience working in Agile
+ Advanced knowledge of software development life cycle
+ Demonstrated ability to coordinate cross-functional work teams toward task completion
+ Demonstrated effective collaboration, negotiation and analytical skills
+ Advanced written and verbal communication skills
+ Strong troubleshooting skills
+ Ability to work independently within a quickly changing environment with strict deadlines; to effectively prioritize and execute tasks in a high-pressure environment
+ Ability to summarize and present test results and progress to key stake holders
+ Exceptional customer service orientation and able to build relationships across the organization

**Preferred Qualifications:**

+ Experience in using Agile tools such as Jira, Rally etc.
+ Highly knowledgeable in DevOps Concepts and hands on experience in using CI/CD tools such as Jenkins, Bitbucket etc.
+ General knowledge including Microsoft Office products such as MS Word, MS Excel, Excel macros etc.
+ Working experience in Control M
+ Experience performance testing expertise and using Performance Testing/monitoring tools such as JMeter, AppDynamics etc.

In addition to the salary range, this role is also eligible for bonus or incentive opportunities.

**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 applicantaccessibility@schwab.com or call 800-275-1281.

Required Skill Profession

Other General