Test Analyst - Retail Lending

job summary: Role Overview - Testing Analyst

Migration project: moving Home Equity Mortgage (HEM) reporting app from SQL Server to enterprise risk/regulatory data warehouse

Two roles open, primarily focused on testing

100% remote, two-step virtual interview (technical + behavioral, 30 min each)

Core Responsibilities

Field-to-field data warehouse testing against specifications

Write and execute test cases, document pass/fail results

Triage data issues when test cases fail, work with tech teams to resolve

Secondary (nice to have): business analysis, requirements gathering, report specifications

Required Skills and Experience

Oracle SQL: advanced/expert level, base SQL only (no PL/SQL, no ETL, no Informatica)

8-10 years preferred, but flexible down to 4-6 years for strong SQL candidates

Data warehouse testing background essential

Nice to have: retail lending data experience (home equity, mortgage, credit cards, auto finance)

SQL Server migration experience not required; general SQL proficiency sufficient

location: Telecommute job type: Contract salary: $62 - 68 per hour work hours: 8am to 5pm education: Bachelors

responsibilities: Core Responsibilities

• Field-to-field data warehouse testing against specifications
• Write and execute test cases, document pass/fail results
• Triage data issues when test cases fail, work with tech teams to resolve
• Secondary (nice to have): business analysis, requirements gathering, report specifications

qualifications: Required Skills and Experience

Oracle SQL: advanced/expert level, base SQL only (no PL/SQL, no ETL, no Informatica)

8-10 years preferred, but flexible down to 4-6 years for strong SQL candidates

Data warehouse testing background essential

Nice to have: retail lending data experience (home equity, mortgage, credit cards, auto finance)

SQL Server migration experience not required; general SQL proficiency sufficient

DISQUALIFIERS

1.) Multiple short contracts

2.) Someone that has not consistently worked in the same industry

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

,

Core Responsibilities

• Field-to-field data warehouse testing against specifications
• Write and execute test cases, document pass/fail results
• Triage data issues when test cases fail, work with tech teams to resolve
• Secondary (nice to have): business analysis, requirements gathering, report specifications

Required Skills and Experience Oracle SQL: advanced/expert level, base SQL only (no PL/SQL, no ETL, no Informatica) 8-10 years preferred, but flexible down to 4-6 years for strong SQL candidates Data warehouse testing background essential Nice to have: retail lending data experience (home equity, mortgage, credit cards, auto finance) SQL Server migration experience not required; general SQL proficiency sufficient DISQUALIFIERS 1.) Multiple short contracts 2.) Someone that has not consistently worked in the same industry