ETL QA Engineer
| Company | Charles Schwab |
|---|---|
| Location | Southlake, TX, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior, Expert or higher |
Requirements
- 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
Responsibilities
- 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
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.