Senior Quality Assurance (QA) Analyst/Lead – Manual

Sr. Quality Assurance analyst/Lead. MUST BE LOCAL TO MINNESOTA Write and execute complex Structured Query Language (SQL) queries/writing SQL scripts. Perform Database/Data Warehouse Testing/Business Intelligence (BI) Reports Testing. Perform Data/Functional/Regression/System Integration/Backend/Negative Testing. Identify and analyze test data; test results. Review, analyze, and approve Business Requirements and Data Mapping documents to gather technical information. Create all types of testing documents in support of Data testing: Test Strategy, Test Case/Scripts, Test Plan, Test Data, Defect work items, Test Closure, Test Reports. Test Mainframe Applications, Reading Job Control Language (JCL) and Time Sharing Option (TSO) Datasets. Create Bug/Defect work items, conduct Defect Triage meetings and retest defects. Communicate effectively, provide statuses, and escalate issues to the appropriate resource(s) in a timely manner. Provide estimations and capacity planning for work assignments and change requests. Perform other related duties as assigned. Sample Skills/Requirements Seven (7) years’ experience in Quality Assurance (QA) Analyst role with emphasis in data management. Five (5) years’ experience with RDMS/DMS (Relational Database Management System/Database Management System). Five (5) years’ experience with: Business Intelligence (BI) Analytics and Reporting tool ETL (Extract, Transfer, Load) Data Warehouse testing Tableau Teradata Structured Query Language (SQL) Assistant Oracle Requirements, Testing, and Defect Management Tools. Three (3) years’ experience with SQL Developer: Create, modify, and execute complex SQL queries. Experience with Tester/Developer, Data/Report Analyst. Experience working with Normalized and Denormalized tables. Experience with Beyond Compare.