Genesis Consulting has an immediate opportunity for an experienced, forward thinking Quality Assurance Data Management Tester with a passion for growth and business transformation for a public sector client in St. Paul, MN. Join our team and work on challenging, complex solutions that are driving innovation and technology advancement in the local community. Work with teams that are rapidly delivering value to their customers leveraging concepts of Lean, Agile, Kanban and SAFe. Our clients are some of the world s leading companies and the candidate will be a part of challenging projects to build and support technical solutions for their needs.

Duties and Responsibilities:

The Minnesota Department of Human Services is seeking one full-time resource to work on assisting in additional development of the DHS/MNsure modernization projects (SysMod) as required by State and Federal grant requirements.

At a high level, the resource is a Quality Assurance Data Management Tester must have strong data management/data warehouse experience testing in large and complex systems development projects. This Quality Assurance Data Management Tester is needed to bring several active, high visibility projects to successful completion, to enable the DHS System Modernization technical solutions to be deployed and fully operational. The Quality Assurance Data Management Tester will be responsible for performing all testing activities for DHS Systems Modernization projects such as MnCHOICES and METS, as determined by the State s Project Manager and/or Product Owner. These will include several cross-agency projects with key collaborators from MMIS, MNIT @ DHS: MNsure (Department of Human Services and MNsure). Duties and responsibilities include but are not limited to:

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

Requirements

Minimum Qualifications/Experience:

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
IBM Rational CLM (Collaborative Lifecycle Management)
IBM RTC (Rational Team Concert)
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

Minimum Education:

Bachelor s Degree in Required

Required Certifications:

None Required

Other:

Local candidates preferred as work will be on-site in St. Paul, MN

Candidate must be able to pass a full background check including:
Criminal History Check (including County or State, MN BCA, and National Sex Offender Registry)
Social Security Number and Address Verification
Other legally required or Governmental Entity requested checks (drug tests, Mantoux tests, fingerprints, tax records, etc.)

Minimum Qualifications/Experience: 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 IBM Rational CLM (Collaborative Lifecycle Management) IBM RTC (Rational Team Concert) 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 Minimum Education: Bachelor s Degree in Required Required Certifications: None Required Other: Local candidates preferred as work will be on-site in St. Paul, MN Candidate must be able to pass a full background check including: Criminal History Check (including County or State, MN BCA, and National Sex Offender Registry) Social Security Number and Address Verification Other legally required or Governmental Entity requested checks (drug tests, Mantoux tests, fingerprints, tax records, etc.)

Operations Manager Embassy Suites Hotel Branch in Makkah