What are the responsibilities and job description for the Sr. QA Engineer Lead position at Charles Schwab Inc.?
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 are looking for a Sr. QA Lead (individual contributor) with strong DW/ETL testing experience. This role requires 15 years of overall experience with at least 10 years as a Quality Engineer in Data warehouse and ETL.
The ETL QA Lead role is a high visibility role to lead a team of 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 QA Lead 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
- Create high level test scenarios and socialize the same with all stake holders
- Ensure that team catalogs and maintain test scenario/test case 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
- 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
- Socialize QA process across all ETL development teams and lead the road shows and knowledge sharing sessions on QA process
- Monitor DevOps process and procedures and ensure that all scrum teams are adhering to the set DevOps process
- Create audits and ensure that all development teams are following QA process
What you have
Required Qualifications:
- 15 years of overall experience with at least 10 years as a Quality Engineer in Data warehouse and ETL
- Well documented leadership experience
- 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 complex SQL queries/scripts to test data flow and perform data analysis.
- Experienced in Unix and knowledgeable in writing shell scripts
- Experience in creating testing strategies and engineering best practices related to software test engineering, 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
- Performance Testing expertise and using Performance Testing/monitoring tools such as JMeter, AppDynamics etc.
