Candidates must be located in the midwest. Position can be hybrid or 100% on-site
Description:
Our client is looking for a Quality Assurance Data Management Analyst to bring high visibility complex projects to successful completion, to enable Operational and System Modernization technical solutions to be deployed and fully operational.
Tasks
- 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.
Skills Required
- 7 years - experience in Quality Assurance (QA) Analyst role with emphasis in data management.
- 5 years - experience with RDMS/DMS (Relational Database Management System/Database Management System).
- 5 years - experience in 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.
- 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.