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.