Job Title: T-SQL Developer - Back End Testing Support
Location: Washington, DC
Duration: Long Term
- Advanced SQL / T-SQL and Stored Procedures to QC data layer of the application.
- Parsing, loading, transforming data
- 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
- 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.
To view other opportunities please click here: TrustedQA Careers
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