Job ID :
2255
Company :
DC Government
Location :
washington, DC
Type :
Hire
Duration :
6 Months
Status :
Active
Openings :
2
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

 

Skills: 7+ years of experience in IT Quality Assurance Engineer with experience in large database conversion projects involving 10+ years of Legacy data

 

Complete Description:

This is a hands-on position that requires multiple cycles of data analysis using complex SQL queries in SQL server and/or Oracle databases as needed. The candidate must be able to extract data dumps from databases where a direct comparison is not possible and then compare them for violations of business rules. The candidate must have working knowledge of how to compare records between databases using SQL queries, and leverage tools like Exam Diff, Beyond Compare, Edit Plus to compare data file dumps. The candidate must pay close attention to meticulous details in the data validation process in an iterative fashion to be 100% compliant with data quality standards set forth by the business requirements. Previous experience with automation of similar tasks will give the candidate a strong advantage. The candidate must write test plans and track/document results of each test cycle that is performed. The candidate will also work with the ETL team to resolve all identified data quality issues. After identifying violations of business rules the candidate will also be required to assist in the manual correction of errors in the source systems where needed. The candidate must have strong verbal skills and must be able to communicate with non-technical people. He/she must be able to write clear explanations of complex topics, as much of MPD’s correspondence is handled through e-mail. Candidates must be pro-active, follow written instructions and work independently.

 

Behavior Characteristics:

Strong verbal skills and ability to communicate with non-technical people. Able to write clear explanations of complex topics, as much of MPD’s correspondence is handled through e-mail. Ability to work on a team and handle complex SQL issues.

 

Skills:

SQL querying knowledge of SQL Server 2005 and above.

Required 6 Years 2 - Proficient

 

SQL querying knowledge of Oracle 10g and above.

Required 6 Years 2 - Proficient

 

Ability to write complex SQL scripts to accomplish data conversion/validation testing

Required 6 Years 3 - Expert

 

Complete working knowledge of SDLC and STLC lifecycle model

Required 6 Years 2 - Proficient

 

Basic knowledge of performance tuning of long-running SQL queries with Oracle & SQL Server

Required 3 Years 1 - Basic

 

Experience developing and documenting analyses of business needs

Required 3 Years 2 - Proficient

 

Experience with test plans and test cases.

Required 6 Years 2 - Proficient

 

Produce reports of testing results.

Required 3 Years 2 - Proficient

 

Development of recommendations for fixes and database performance and tuning optimizations to programmers

Required 6 Years 2 - Proficient

 

Development and execution of automated test scripts for regression testing and retesting as required

Required 6 Years 2 - Proficient

 

Experience in Windows or Linux

Desired 3 Years 2 - Proficient

 

Experience in automating data validation processes in similar data conversion projects

Desired 3 Years 2 - Proficient

 

Experience with SharePoint desired

Desired 3 Years 2 - Proficient

 

Experience with Microsoft Project

Desired 3 Years 2 - Proficient

 

Experience with scripting procedures/languages to automate and speed up project tasks

Desired 3 Years 2 - Proficient