Back End Test - PL/SQL/T-SQL Developer

  • TrustedQA,
  • Washington, DC
T-SQL Developer, T-SQL Scripting, Backend Test dataset generation, Stored Procedures, Optimizing/Tuning SQLServer, data validation, data verification
Full Time, Contract W2, C2H W2
Depends On Experience
Telecommuting not available Travel not required

Job Description

Job Title:         T-SQL Developer - Back End Testing Support

Location:          Washington, DC

Duration:          Long Term

 

Skills:

  • Advanced SQL / T-SQL and Stored Procedures to QC data layer of the application.
  • Parsing, loading, transforming data

Qualifications

  • At least a Bachelor’s degree (CS, EE, IT related fields) and 4-7 years of proven manual software testing experience in a functional QA team performing Black Box testing of in the GUI and Data Layer
  • Strong T-SQL experience is required
  • Experience in Back-end testing (majority of testing will be on the Data Layer)
  • Nice to have: cross browsers/ platforms / mobile / Windows, Macs, Ubuntu

 Duties

  • Write advanced SQL and Stored Procs to QC data layer of the application.
  • Write and execute scripts for parsing, loading, transforming data from large files of different formats to compare with their source or destination.
  • Analyze file upload/download specs, application’s configs, Prod Data etc to script the creation of Test Data Files.
  • Understanding DB, SQL, file parsing/loading/transformation scripting
  • File parsing and scripting techniques/languages/tools (any language or tools to achieve this).
  • Optimizing/Tuning SQL queries or file processing scripts for better performance and efficiency due to large data sets and short testing windows.
  • Defining Test Bed for several backend jobs building on sample data and proper analysis of existing prod data or specs analysis.

***This requirement is not open to subcontracting / agency candidates.***

About Us: Established in 1988, TrustedQA is a test engineering organization providing trusted, confidential, independent testing, quality assurance, verification, and validation services to software and systems development organizations. TrustedQA's mission is to help our customers get the highest quality software possible to market quickly and efficiently. We bring the latest relevant software life-cycle process methodologies, test/QA methodologies, tools and industry best-practice testing knowledge to our customers. 

EOE, M/F/Disabled/Vet

To view other opportunities please click here: TrustedQA Careers 

 

TrustedQA
1800 Michael Faraday Drive, Suite 100 
Reston, VA 20190

 

Keywords: T-SQL, SQLServer, Data Test Set generation, data layer, parsing,  stored procedures, ETL, Loading, transforming data, Stored Procs, SQL, Optimizing, tuning, queries, test bed

Dice Id : 10117486
Position Id : BUPTSQLDC
Have a Job? Post it

Similar Positions

SQL Developer
  • Robert Half Technology
  • Linthicum, MD
Senior T-SQL Application Developer
  • Advance Digital Systems
  • Washington, DC
Database/Business Intelligence (BI) Developer 3
  • NORTHROP GRUMMAN
  • Washington, DC
T-SQL Developer/Data Analyst
  • Reliable Software Resources
  • Reston, VA
Mid-Level Report Developer
  • FEi Systems
  • Columbia, MD
Senior SQL Developer
  • Starpoint Solutions LLC
  • Washington, DC
SQL Database Development
  • APN Consulting Inc
  • Arlington, VA
Microsoft Senior Consultant - SQL Server
  • Chenega Corporation
  • Arlington, VA
SQL Server Developer
  • Apex Systems, Inc
  • Bethesda, MD
Senior Database Developer
  • I4DM
  • Millersville, MD
Data Warehouse Architect / SQL Server
  • Technocrafts, Inc.
  • Washington, DC