ETL QA 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.

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).

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 Google Cloud Platform
• 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.

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