Data QA Engineer - Washington, DC - Georgia IT Inc.
Washington, DC
About the Job
Job Title : Data QA Engineer
Location : Washington, DC
Rate : DOE
Position Type : Contract
(US Citizens/ GC/GC-EAD preferred)
No Third party C2C
Job Description
The Data QA Engineer will:
Requirements and General Skills:
Technical Skills:
Location : Washington, DC
Rate : DOE
Position Type : Contract
(US Citizens/ GC/GC-EAD preferred)
No Third party C2C
Job Description
The Data QA Engineer will:
- Review project deliverables (for example, Business Requirements, Functional Requirements, Technical Designs) as they relate to a given test stage.
- Review and provide input to test deliverables.
- Define test plan / strategy and identify risks related to testing efforts.
- Create test cases based on requirement & technical design specifications for data validation.
- Understand ETL logic & write complex SQL queries for data and Report Validation
- Understand Cognos Report logic and develop SQL queries for report data quality validation
- Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity.
- Ensure issues are identified, tracked, reported on and resolved in a timely manner
- Works across various groups & effectively drive testing of cross-team solutions that have complex dependencies and requirements.
- Inform the Project Test Lead of issues that may affect the schedule, budget, or quality of the solution or the testing process.
- Minimum Qualifications:
- Bachelor's Degree in Information Technology or related field, or equivalent work experience
- 5 to 8 years' experience in QA analyst roles in BI (Data warehouse & Report) environments.
Requirements and General Skills:
- Strong interpersonal skills.
- Demonstrated keen sense of detail and accuracy.
- Strong analytical and quantitative problem solving skills
- Excellent verbal and written communication skills
Technical Skills:
- Background with traditional databases such as Oracle, Teradata, SQL Server, ETL tools / processes and data warehousing architectures.
- Experience in using tools such as Informatica, job scheduling and Unix scripting
- Extensive testing experience in Data warehouse, DataMart, Stored procedure, ETL jobs, Report ,Cube
- Experience in Test data management
- Strong knowledge of data structures, algorithms, enterprise systems, and asynchronous architectures.
- Experience with raw, unstructured data.
- Strong quantitative, data tabulation and analytic skills.
- Ability to investigate discrepancies in data by writing queries and comparative analysis.
- Ability to develop and use test plans, test cases, test scripts, test results
- Experience using technical documents such as business requirements, functional requirements, database design representations, data and systems flow diagrams.
- Streaming data validation experience is plus
Source : Georgia IT Inc.
