Match score not available

Backend SQL Tester

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

3-5 years of experience in quality assurance testing of software applications., Strong SQL skills and experience with Oracle for backend testing., Knowledge of PRISM and Workday is required., Strong analytical skills and ability to collaborate with technical teams..

Key responsabilities:

  • Create and execute complex SQL queries for database testing.
  • Perform end-to-end testing of data as it flows from Oracle.
  • Capture testing artifacts and review with the Product Owner.
  • Support test case creation, execution, defect tracking, and reporting.

Knack Solutions logo
Knack Solutions Startup https://www.knackyou.com/
11 - 50 Employees
See all jobs

Job description

***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

Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Analytical Skills
  • Quality Assurance
  • Organizational Skills
  • Detail Oriented
  • Problem Solving

Related jobs