Backend SQL Tester

***W2 only***

Position: Backend SQL Tester

Work Authorization: All Work Authorizations

Location: 100% Remote

Contract: 12mos

Top Skills:

• Create complex SQL queries, design SQL queries for database testing, execute SQL queries. (Oracle)
• End-to-End testing of data as it flows out of Oracle.
• Work within a collaborative team environment to support test case creation, execution, defect tracking, and reporting
• Capture all testing artifacts in validation workbook and review with Product Owner and upload approved validation workbook to JIRA story / feature

Requirements:

• Has a 3-5 years of experience in quality assurance testing of software applications; including analyzing and understanding business and technical requirements, building positive/negative test data
• Previous experience and knowledge of PRISM and Workday required.
• Strong analytical skills and technical expertise can collaborate with business and technical teams to perform deep dive analysis of any identified issues found during testing
• Prior experience working in the Secondary Mortgage Market or financial services with a focus on fund accounting a plus
• Can write complex SQL statements. Experience with Prism/Workday
• Previous experience with JIRA

Job Description:

• Seeking candidate with STRONG SQL skills and Oracle for backend testing and validating data as it flows from downstream system to upstream.

Tester:

• Experience in Software Development Life Cycle (SDLC): analyzing requirements, building test cases, validating and interpreting results
• 3-5 years of hands on software testing experience
• Demonstrates strong organizational, problem solving, and analytical skills as it pertains to testing software and providing operational support Must have strong SQL query creation and manipulation skills
• Must have strong XML generation and manipulation skills
• Must have strong experience with JSON and/or XML files validate documents.
• Experience testing Tableau, BI or Workday Reports (or similar tooling)
• Attention to detail is critical for this role.

Nice to Have:

• Prior Fannie Mae, Freddie Mac or Mortgage industry experience
• Familiarity with Agile methodology