Highcloud Solutions - Saint Paul, MN

posted 4 months ago

Full-time
Saint Paul, MN
Professional, Scientific, and Technical Services

About the position

The Quality Assurance (QA) Data Management Analyst position is a critical role within our organization, focusing on ensuring the integrity and quality of data across various systems. This position is hybrid, based in Saint Paul, MN, and is designed for a long-term engagement. The successful candidate will be responsible for writing and executing complex SQL queries, performing extensive database and data warehouse testing, and validating business intelligence reports. The role requires a deep understanding of data management principles and the ability to analyze and interpret data effectively. In this role, you will engage in various testing methodologies, including functional, regression, system integration, and negative testing. You will be tasked with identifying and analyzing test data and results, ensuring that all business requirements and data mapping documents are thoroughly reviewed and approved. The QA Data Management Analyst will create comprehensive testing documentation, including test strategies, test cases, test plans, and defect work items, to support data testing initiatives. Additionally, you will be responsible for testing mainframe applications, which includes reading Job Control Language (JCL) and Time Sharing Option (TSO) datasets. You will create bug and defect work items, conduct defect triage meetings, and retest defects as necessary. Effective communication is essential, as you will need to provide status updates and escalate issues to the appropriate resources in a timely manner. You will also be involved in capacity planning and providing estimations for work assignments and change requests, ensuring that all tasks are completed efficiently and effectively.

Responsibilities

  • 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.

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.
  • Five (5) years' experience with ETL (Extract, Transfer, Load).
  • Five (5) years' experience with Data Warehouse testing.
  • Five (5) years' experience with Tableau.
  • Five (5) years' experience with Teradata Structured Query Language (SQL) Assistant.
  • Five (5) years' experience with Oracle.
  • Experience with 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service