QA Engineer
Job Description
Your opportunity
At Schwab, youre 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 are looking for a 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 QA Engineer 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 Sr. 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
Experience in working on large scale data engineering projects
Experience in testing Data Warehouse ETL applications specifically using IICS/PowerCenter
Experience in cloud technologies specifically in GCP
Experience in python scripting
Experience writing/understanding SQL queries/scripts to test data flow and perform data analysis.
Experienced in Unix and have basic knowledge in writing 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.
Whats in it for you
At Schwab, were committed to empowering our employees personal and professional success. Our purpose-driven, supportive culture, and focus on your development means youll 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