ETL Tester

Role: ETL Tester

Location: Washington, DC (REMOTE) (Only Local Candidates Preferred)

Duration: 12 Months Contract

Position on C2C

Only Preferably USC/GC

Experience: 10+ Years

Resource must be well versed with SSIS ETL process, writing complex queries.

Preferably with Healthcare background

Function and Scope:

This is a hands-on position with a primary focus on leading and executing testing in conjunction with the project team and project business owner. This position will be responsible for performing all facets of data testing: quality standards, controls, and procedures. The Quality Assurance Senior Specialist will have the technical knowledge to support quality assurance aspects of all ETL (extract, transform, load) platforms and coding in registry data projects. The position selectee must function as a team member, and work to maintain a positive work environment.

Major Duties and Responsibilities:

Create and execute test plans and scripts that will validate the projects data quality and data integrity as the data is transitioned through the ETL data warehouse process.

Analyze documentation and technical specifications to ensure that quality assurance activities allow the ETL process to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues

Test the compliance of information flows and data stores against data quality standards.

Provide risk assessment during project planning and development

Create and maintain test documentation and test plans, plus work with the project team to create a suite of test data to exercise data validation and ETL functionality

Create and execute SQL queries as needed to validate that test results match expected results

Identify and log defects and when necessary, use SQL to narrow down the root cause of the defect issue

Be responsible for ETL build validation process and for the validation of any additions/modifications to reports before release to production

Work closely with the project team to analyze, debug and resolve any issues

Effectively communicate test progress, test results, and other relevant information to project stakeholders and management

Enforce and monitor adherence to quality standards

Create and execute regression test scenarios

Other duties as assigned

Required Qualifications:

Bachelor's Degree in information technology, computer science, statistics or similar technical degree

Three + years of testing/development experience using SQL Server (2005 and 2008) with the following highly desired

Database design and database structures

Entity relationship diagram (ERD) knowledge

Data warehousing and data modeling

Strong knowledge of aspects of Data validation testing

Strong experience testing data exchanges with XML

Strong knowledge of aspects of ETL program testing

Experience writing and executing complex SQL queries using views/tables

Five + years of experience on a quality assurance team testing ETL systems, data management and warehousing systems

Detail-oriented, with excellent organizational skills and able to manage multiple issues simultaneously

Excellent diagnostic, problem-solving and debugging skills.

Thorough understanding of platforms such as Windows 2003/Windows 7 and Internet Information Server.

Solid working knowledge of current Internet technologies, including .Net Framework, AJAX, and web services.

Knowledge of applicable data privacy practices and laws a plus.

Background experience with ETL and database development

Experience with the Altova Suite of products

Cognos or other business intelligence experience

Strong SSIS (SQL Server Integration Services) development and testing experience

Experience testing mobile interfaces and responsive web design

Exposure to and experience using automated data test tools

Strong written and oral communication skills; strong interpersonal skills.

Self-directed and proactive; thinks beyond the immediate problem.

Flexibility, ability to change priorities quickly, and capacity to handle multiple tasks.

Experience working both independently and in a team-oriented, collaborative environment.

Experience in Healthcare IT or Support environment a plus