Data QA Analyst

Data QA Analyst
Paradigm Information Services, United States

Experience
1 Year
Salary
0 - 0
Job Type
Job Shift
Job Category
Traveling
No
Career Level
Telecommute
No
Qualification
As mentioned in job details
Total Vacancies
1 Job
Posted on
Mar 5, 2021
Last Date
Apr 5, 2021
Location(s)

Job Description

Paradigm is seeking a Data QA Analyst to support our clients a global leader in the legal services space. This role will confirm the accuracy of initial import of data involving thousands of records. As well as verify the accuracy of various data updates and extracts.

Type: 2-year contract
Location: Remote (Oregon)
Pay Rate: DOE
Benefits: Medical, Dental, Vision, PTO, 401K, and more

As a Data QA Analyst, you will

  • Understand the logic of complex queries/stored procedures based on requirements, writing appropriate test queries, and executing them to verify the logic and data
  • Work closely with business partners and the application development team in eliciting project requirements to create test cases
  • Review requirements specifications and identify gaps and inconsistencies
  • Work closely with development engineers, business analysts, and other QA team members to identify, report, and troubleshoot defects; verify problem fixes in a detailed, efficient, and timely manner

Requirements

  • 2+ years’ of very strong experience in database testing with the ability to understand, write, and execute very complex SQL queries, and understand the logic of stored procedures
  • 1 + years experience working with T-SQL, or ANSI-89 / ANSI-92
  • 3 + years experience in a Software QA role understanding the entire software life cycle and various QA/testing methodologies/techniques
  • Expert level T-SQL to include thorough understanding of the following concepts:
    • Aggregates: COUNT, SUM, MAX/MIN, DISTINCT, GROUP BY, HAVING
    • JOINs, ANSI-89 and ANSI-92 syntax.
    • UNION vs UNION ALL
    • NULL handling
    • Sub queries: IN, EXISTS, and inline views, Correlated Subqueries
    • Constraints, Primary keys, foreign keys, defaults
    • Error trapping
    • Transactions
    • BCP, BULK INSERT
    • Indexing Advanced stored procedures and user defined functions programming
    • Triggers

Benefits

Paradigm offers medical, dental, vision, life, 401K, PTO, and sick days.

About Us, Paradigm

Want to love Mondays? It's possible when you love what you do. Paradigm is a staffing solutions firm dedicated to finding the perfect job for candidates. We're connected with some of the most innovative tech companies around, giving our employees that competitive edge needed in today's job market.

We are proud to offer a work environment free of harassment and discrimination. We value diversity and promote respect in the workplace. We are an equal opportunity employer.

--

Only local candidates able to work directly for Paradigm as W-2 employees can be considered for this position. No agents, please.

Job Specification

Job Rewards and Benefits

Paradigm Information Services

Information Technology and Services - Lake Oswego, United States
© Copyright 2004-2024 Mustakbil.com All Right Reserved.