Automation QA Tester

Core Requirements/Responsibilities: SQL Expertise: Strong knowledge of SQL, including usage of multiple joins and complex mapping. Selenium, Java: Java scripting for test automation is acceptable, do not need OOP experience Will be responsible for 30% web test automation and 70% back-end and ETL testing. It is ideal that a candidate does have experience in both web and ETL/database testing, but if they only have a web testing background with the required SQL expertise she will take sharp candidates who are able to pick up the ETL and database piece quickly. Data validation and understanding of data lineage mappings Experience with relational databases (Oracle, SQL Server, etc) Need Cucumber/BDD Core test automation experience neededdevelopment of test cases, test scripts to extend existing automation framework Nice to have: Python, experience in ETL tooling, CI/CD Notes with the Manager: New application, banking as a service. 6-8 years , senior level. ETL - experience on SQL and banking domain knowledge. Joints/Complex Mapping-SQL Level Selenium, Test NGG, Automation. Database on the back end. Added advantage if they have PowerBI and Python. NOT Required. ETL 70% vs UI/API 30% Data sources- Oracle DB, relational database experience Existing frameworks are already in place General understanding of CI/CD Testing Java knowledge for Automation Duties: Solves Complex Automation challenges spanning multiple technologies in a scalable & extensible manner with least amount of maintenance. Continuously improve the efficiency of the Automation using innovative technologies & thought process in specific performance testing areas. Develops testing plan scenarios for complex unit, process, function, integration, regression and acceptance testing. Assists in identifying and establishing goals for appropriate testing cycles and defines and manages software test environments, test standards and quality assurance tasks. May lead a small team of Test Analysts to ensure quality goals/schedules are met for the given project. Analyzes system requirements and design documents. Estimates hours and resources needed for projects under test. Develops detailed test cases, scenarios and scripts to ensure application quality. Writes test plans, collaborating with other QA and business teams. Designs and develops usability testing scenarios, and administers portions of the testing process, to include the use of testers from other teams. Uses testing tools to plan, execute and track quality assurance artifacts. Meets with PMO, Development and Business to remediate defects. Attends product definition and design meetings, functional and technical walkthroughs in order to provide input in the selection of testing tools and approaches. Identifies test data, test environment setup and test environment configurations needed to prepare for testing. Works with Development, DBAs and business to seed and setup the test environments. Recommends program improvements or corrections. Presents findings to management and project teams. Defines criteria for testing, analyzes results of testing sessions and makes recommendations and offers solutions to Quality Assurance leadership and other stakeholders on the project based on the findings. Identifies and documents software and systems defects across products, platforms, and releases. Analyzes complex systems requirements and design documents in order to verify that programs function according to actual requirements and established guidelines. Helps resolve moderately complex problems detected in testing. Provides Triage support to Development, Business and Test teams on internal and external issues. Informs management on resource requirements needed to complete software testing. To include but not limited to the number of testers, test tools, test data test environments and time needed to complete testing. Contributes to the achievement of related teams' objectives.