Logo for Knack Solutions

Backend SQL Tester

Knack Solutions

Role overview

Qualifications

  • 3-5 years of experience in quality assurance testing of software applications
  • Previous experience and knowledge of PRISM and Workday
  • Strong analytical skills and technical expertise
  • Prior experience working in the Secondary Mortgage Market or financial services

Responsibilities

  • Create complex SQL queries and design SQL queries for database testing
  • Execute SQL queries and perform end-to-end testing of data flowing from Oracle
  • Collaborate within a team to support test case creation, execution, defect tracking, and reporting
  • Capture all testing artifacts in the validation workbook and review with the Product Owner

Key facts

  • Remote from: Texas (USA)
  • Freelance
  • Mid-level (2-5 years)
  • English

Hard skills

Other skills

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

About the company

Knack Solutions logo

Knack Solutions

No-Code / Low-Code Platforms

Knack Solutions is a growth partner. We’re a nimble, hungry, results-driven firm. We execute with purpose and focus on measurable, actionable results.Knack Solutions offer the most up-to-date computer science tracks in the world because we work with top employers and update them every 90 days.Our courses are designed to teach you through deep hands-on learning to get you into the job market in the career of your dreams, with the help you need to understand and stay motivated every step of the way.We win big.Our results get recognized.

Company details

Company typeStartup
IndustryNo-Code / Low-Code Platforms
Company size11 - 50

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Related jobs

Texas (USA)

Other jobs at Knack Solutions

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.