Tester IV

The IE Project has an urgent need for a tester to support data conversion on site in Salem Oregon.

The Office of Information Services (OIS) is a shared service provider for the Oregon Health Authority (OHA) and Department of Human Services (DHS). OIS provides the technology systems and services that support more than 11,000 OHA and DHS agency staff at local offices and facilities around the state. These systems and services help the two agencies determine client service program eligibility; provide medical, housing, food and job assistance; provide addiction, mental health, vocational and rehabilitative services; protect children, seniors and people with physical and/or developmental disabilities; process claims and benefits; manage provider licensing and state hospital facilities; and promote and protect the state public health.

OIS provides management support for OHA and DHS IT projects, systems architecture, databases, IT asset and change management. OIS also coordinates network and computing operations with the Oregon State Data Center.

The Integrated Eligibility (IE) Project and associated sub-projects (Legacy, Disaster Recovery, Data Conversion) are large bodies of work and are collectively Oregon's largest active IT project. These projects utilize staff from multiple agencies, as well as multiple contractors. Further, there are overlapping priorities from other DHS and Oregon Health Authority (OHA) projects, and ongoing maintenance and operations work.

IE is an expansion of Oregon's Affordable Care Act Compliant Modified Adjusted Gross Income (MAGI) Medicaid eligibility determination system, called OregONEligibility (or ONE) for the Oregon Health Authority (OHA). The IE Project goal is to have a single system where an Oregonian can express information about themselves and members of their household and be determined eligible for multiple health and human service programs - both DHS and OHA programs. At the end of the IE Project, Oregonians should be able to apply online for benefits seven days a week and caseworkers should be able to focus on the care coordination activities for clients rather than on data entry across multiple systems.

The IE Project Office has identified gaps in needed expertise to successfully implement the Project. Time is of the essence to meet tight deadlines on an aggressive schedule. We need support with comprehensive side by side testing of the data converted from legacy applications to the IE system.

The testing specialist will provide much needed collaboration and coordination of testing efforts with team leads and other OIS staff.

REQUIRED:
Meets minimum requirements as defined in the MSP rate card:
Responsibilities include developing and executing software tests and documenting results in order to ensure software runs smoothly and effectively. May involve troubleshooting issues and debugging software. May require a bachelor's degree and at least nine years or equivalent experience in a related area. Familiarity with standard concepts, practices, and technologies in the field.

Plus:
Bachelor's Degree or higher in Computer Science, or related discipline
OR
equivalent work experience.

> Heightened attention to detail, strong technical problem solving skills. Customer focused and exceptional oral/written communication skills. Positive, proactive and take charge attitude.
> Willing to jump into a new data domain and quickly develop data and application expertise - not shy about asking questions to fill in gaps and improve expertise.
> High competency in data mapping and transformation.
> Experience in TFS.
> SQL query writing experience required , with experience using SQL to validate data conversion preferred.
> Ability to parse/manipulate data using Excel.
> Ability to interpret customer requirements, data mapping/transformation logic, business rules and document edits to testing side by side (Legacy to Web App) testing guides.
> Ability to meet deadlines and perform under pressure.
> Data Conversion and/or Dept of Human Services (DHS)/ Oregon Health Authority/Medicare/Medicaid/CMS industry experience preferred.
> Experience with State/Federal benefits eligibility systems preferred.
> Mainframe application/navigation experience preferred.


Duties


Perform side by side testing of state legacy eligibility systems with the state's new Integrated Eligibility system for all data conversion related processes including:
a. Discuss and interpret client eligibility business practices and data mapping
b. Update side by side testing guide, mapping current to future state screens and data transformations
c. Develop a comprehensive test scenarios for all data subject areas
d. Write SQL/pseudo SQL queries to identity client cases for side by side comparison
e. Compare both legacy and Integrated Eligibility data, based on mapping, transformation logic, precedence logic and document defects in TFS
f. Produce reports to track test scenarios/cases completed
g. Work with conversion lead(s) on customer side to research and resolve issues, leading to fixes to conversion programs as needed.
h. Learn Integrated Eligibility data model both from a technical and business process perspective.
i. Acquire working knowledge or familiarity of the workflows associated with the Integrate Eligibility software and its various different modules.
j. Develop a close working relationship with Project Managers and each business area's primary conversion contact to ensure project timelines and deliverables are met and a proper communication foundation is in place to resolve ongoing conversion issues.
k. Develop good working relationship with Systems & Software Conversion and Engineering staff in order to troubleshoot technical and functional issues that may arise during an implementation.
l. Monitor, prioritize and follow up on open data conversion defects associated with the implementation.

Interviews to be conducted via Skype or on site in Salem Oregon.
All interviews will be scheduled in Pacific time.

New MSP rate card description for Tester IV:
Responsibilities include developing and executing software tests and documenting results in order to ensure software runs smoothly and effectively. May involve troubleshooting issues and debugging software. May require a bachelor's degree and at least nine years or equivalent experience in a related area. Familiarity with standard concepts, practices, and technologies in the field.

New MSP rate card rates for Tester IV:
Minimum $$$.$$
Maximum $$$.$$

Background Verification
Minimum Verification Requirements

Please have the candidate complete the required form upon selection. The form is located on the dashboard.
Type Qualification Description Competency Experience Required Skills Communication skills both verbal and written Advanced 6-7 yrs Yes Skills Data Analysis No Skills Data conversion Data conversion Advanced Yes Skills Data mapping and transformation Data mapping and transformation Advanced Yes Skills HTML No Skills Mainframe application navigation experience Mainframe application navigation experience Proficient No Skills Microsoft Team Foundation Server TFS Microsoft Team Foundation Server TFS Advanced Yes Skills MicrosoftOffice Advanced 5-6 yrs Yes Skills SQL Proficient Yes