Vacancy expired!
Description: The work is expected to be done on site at: Saint Paul, MN. Interviews will be conducted via Microsoft Teams Project Schedule Anticipated Project Start Date: April 27, 2023 Anticipated End Date: April 26, 2024 Sample Tasks Write complex SQL queries/writing SQL scripts Perform Database/Data Warehouse Testing/BI Reports Testing Perform Data/Functional/Regression/System Integration/Backend/Negative Testing Identify and analyze test data; test results Read and analyze Business Requirements documents to gather technical information Create all types of testing documents in support of Data testing: Estimations, Test Strategy, Test Case/Scripts, Test Plan, Test Data, Test Closure, Test Reports Test Mainframe Applications, Reading JCL and TSO Datasets Create Bug/Defect work items, conduct defect triage meetings and retest defects Provide estimations and capacity planning for work assignments and change requests Provide knowledge transfer to State staff Minimum Qualifications Seven (7) years' experience in Quality Assurance Analyst role Four (4) years' experience creating, modifying, and executing complex SQL queries. Complex SQL queries contain JOINS (Inner, Outer Left, Right, and Full JOINS) and Sub-Queries (Nested with WHERE clauses). Three (3) years' experience with ETL (Extract, Transfer, Load) Tester/Developer, Data/Report Analyst Three (3) years' experience with Teradata Three (3) years' experience with Tableau Software Desired Skills Five years' experience with RDMS/DMS (Relational Database Management System/Database Management System Five years' experience with Business Intelligence (BI) Analytics and Reporting tool Five years' experience with Testing Tools Five years' experience with ETL (Extract, Transfer Five years' experience with Data Warehouse testing Five years' experience with Tableau Five years' experience with Teradata SQL Assistant Five years' experience with Oracle Five years' experience with IBM Defect Management tools o IBM Rational CLM (Collaborative Lifecycle Management) o IBM RTC (Rational Team Concert) o IBM RQM (Rational Quality Manager) Three years' experience using Agile methodology to ensure risks are mitigated as soon as they occur Three years' experience with SQL Developer Experience working with Normalized and Denormalized tables Experience with Beyond Compare Pay range - $57 to $64 per hour on W2.