State Agency: Job Service North Dakota

Location: NA% Remote

Overview: Job Service North Dakota is seeking a skilled Unemployment Insurance Benefits QA Specialist with data migration experience to support the quality assurance efforts for our Unemployment Insurance Modernization (UI Mod) Project. This multi-year project aims to enhance the state's unemployment insurance system. The successful candidate will collaborate with the QA Manager to ensure the highest standards of quality assurance are met throughout the project lifecycle.

Primary Responsibilities:

• Data Migration
• Design and develop comprehensive test plans, scenarios, and scripts that are repeatable and adhere to established standards.
• Create and maintain QA artifacts to support testing activities.
• Execute various levels of testing, including functional, integration, acceptance, and regression testing.
• Document software defects and validate their resolution.
• Participate in product design reviews, providing input on functional requirements, schedules, issues, and risks.
• Evaluate and select QA testing tools and methodologies that best fit the project needs.
• Address QA testing-related issues within the project.
• Adhere to specific QA testing standards and guidelines.
• Assist in the development of QA testing plans and cases.
• Create, execute, and maintain test data and test scripts.
• Review test scripts for completeness and accuracy.
• Authors SQL queries, validates data by running queries in the database and verify that the results match the expectations.
• Conduct data verification tests in different environments and ensure successful data migration validation.
• Develop and implement automation scripts for iterative conversion cycles.

Key Qualifications:

• Proven experience in data migration QA processes.
• Proficiency in Control report validation and creating SQL scripts for validation.
• Background in conducting quality assurance for unemployment insurance system projects.
• Experience managing QA for large-scale projects with multiple stakeholders (budget of NA million or more).
• Managed QA for IT projects with a budget of at least NA million.
• Proficiency in Agile or hybrid Agile methodologies.
• Comprehensive understanding of the entire lifecycle process of quality management.

Skills and Abilities:

• Strong SQL skills, with the ability to write, optimize, and execute complex queries.
• Minimum of 2 years of RDBMS experience. SQL Server preferable.
• Strong written and oral communication skills.
• Ability to build and maintain solid working relationships.
• Demonstrated ability to develop and document processes clearly and effectively.
• Enjoys working with people in a collaborative environment.
• Quick learner in a rapidly changing technology landscape.
• Embodies the core values of Gratitude, Humility, Curiosity, and Courage.

Certification Education License Other Skill

5+ years of hands-on experience with Data Migration projects

Certification Education License Other Skill

Quality Assurance (QA) Expertise: At least 5-7 years of experience in quality assurance, particularly in unemployment insurance benefits or similar fields

Certification Education License Other Skill

Test Plan Development: Experience in designing and developing comprehensive test plans, scenarios, and scripts

Certification Education License Other Skill

Testing Execution: Proficiency in executing various levels of testing, including functional, integration, acceptance, and regression testing

Certification Education License Other Skill

Minimum of 2 years of experience in relational database management systems (RDBMS).

Certification Education License Other Skill

Defect Documentation: Experience in documenting software defects and validating their resolution

Certification Education License Other Skill

Project Collaboration: 3-5 years of experience working in collaborative project environments, including participation in product design reviews

Certification Education License Other Skill

Analytical Skills: Excellent analytical skills, including the ability to author SQL queries and validate data

Certification Education License Other Skill

Communication Skills: Strong verbal and written communication skills to effectively collaborate with team members and stakeholders

Preferred Skills

Skill Type

Skill Name

Certification Education License Other Skill

Technical proficiency and minimum 2 years experience with Relational Database Management System (RDBMS) with Microsoft SQL Server

Certification Education License Other Skill

Agile Methodologies: 3-5 years of experience with Agile or hybrid Agile methodologies

Certification Education License Other Skill

Unemployment Insurance Systems: Prior experience working with unemployment insurance systems or similar government programs

Certification Education License Other Skill

Automation Scripts: Experience in developing and implementing automation scripts for iterative conversion cycles

Certification Education License Other Skill

Certified ScrumMaster (CSM), Certified Agile Practitioner (PMI-ACP), or SAFe Agilist

Certification Education License Other Skill

Familiarity with Agile tools like Jira, Trello, Asana, or Azure DevOps

Certification Education License Other Skill

Bachelor's Degree in a relevant field such as Computer Science, IT, or Business Administration

Certification Education License Other Skill

Certified Software Tester (CSTE), Certified Software Quality Analyst (CSQA) ISTQB Certified Tester Foundation Level (CTFL) Certified Software Quality Engineer (CSQE) ISTQB Agile Tester Certification