
Backend SQL Tester
Knack Solutions
Applications are made on Knack Solutions's own site. We never sit in the middle.
Job description
About the job 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 Or refer someone • • • • • • •