ETL/DWH Tester (Strong SQL Skiils)

Complex SQL queries and SSIS, data warehouse testing, ETL testing,ETL, Healthcare data, Test cases and test plans
Full Time, Contract Corp-To-Corp, Contract W2, C2H Corp-To-Corp, 6 Months
Telecommuting not available Travel not required

Job Description

DIRECT CLIENT REQUIREMENT (In - Person Interview Mandatory)

Job Title:       ETL/DWH Tester (Must have Healtcare Experience)

Location:       Arlington VA

Duration:       Long Term ( C2C or W2)

 Scope of Work:

  • The ETL/DWH Tester/Data Quality Analyst will be responsible for ensuring and maintaining the quality of the client and vendor data received as part of each assigned data on boarding initiative.
  • The ETL/DWH Tester/Data Quality Analyst will work closely with the client, carrier & PBM vendor(s) and internal/UPMC Data.
  • Technical Leads to understand the client / vendor data and develop the appropriate test plan, test cases and test schedule in support of data on boarding and all necessary data quality assurance tasks.

 Job Responsibilities: 

  • Resolve data quality problems. Activities include: Identify, assess, fix, document, and communicate potential quality issues in the way data is collected, stored, processed, or used.
  • This may involve interacting with business users to resolve data quality problems using techniques such as root cause analysis as well as collecting user requirements.
  • Fixing the data problem may require the DQA to recommend, design, implement and monitor quality procedures for use in the data production process.
  • It may also include data cleansing operations like removing duplicate records.
  • Measure data quality. Activities include: Design, collect, analyze, and report on data quality assurance / production performance metrics.
  • Additionally, develop and execute data quality test cases, scripts and procedures (manual and automated) to support the data quality metrics.
  • Manage data quality documentation. Activities include: Define and maintain data standards, definitions, and models (e.g. data dictionary, organizational data model.
  • This may also include any DQA documents such as checklists, guidelines, manuals, templates, forms, etc.)
  • Participate in cross-functional teams and development or improvement task forces.
  • Assist other groups in database setup, design of edit checks, test plans, DQ policy decisions, etc. to ensure data quality objectives are met.
  • Track defects to resolution

 Required Skills:

  • Requires BS/BA degree and 5 years’ quality assurance experience.
  • 3+ years of advanced SQL skills to write queries & view/test data in relational database


  • Experience with ETL processes using ETL tool like Informatica, SSIS
  • Knowledge of BI tools like Micro Strategy
  • Must possess strong written and verbal communications skills to present findings and recommendations.
  • Should be detail oriented, have strong problem solving skills and understand benefits of data quality.
  • Knowledge of healthcare data and industry is must require.
  • Experience in converting mapping documents and transformation requirements into a testing strategy, test cases and test data required
  • Experience with creating QA checks to test data integration and data transformation required


 About us:

Since 2002, APN Consulting has been inspiring success in IT through meaningful connections between employers and candidates.  We are trusted by a vast array of companies, from small enterprises to some of the world’s most trusted brands to present the best talent for their contract, contract to hire and full time positions.  To learn more, please visit us online at

Dice Id : 10123488
Position Id : 17-00001
Have a Job? Post it

Similar Positions

ETL Tester / ETL Quality Analyst
  • iMetrics Consulting
  • Greenbelt, MD
ETL Administrator
  • ALTEK Information Technology, Inc
  • Washington, DC
ETL Engineer 3/4 (mid/sr.) - TS/SCI
  • Reston, VA
Pentaho ETL, Data Warehouse Developer
  • H & R Computer Consulting Services
  • Washington, DC
ETL Developer with Active MBI Clearance
  • Ariel Partners
  • Lanham, MD
Sr. ETL Developer
  • JSL Computer Services, Inc.
  • Lanham, MD
ETL Developer
  • Mastech
  • Washington, DC
Sr. ETL Developer
  • Softcom, Inc.
  • Lanham, MD
ETL Developer
  • Newgen Technologies, Inc.
  • Annapolis Junction, MD
ETL Developer
  • The Squires Group
  • Annapolis Junction, MD
ETL Developer- Polygraph
  • General Dynamics IT Corporate
  • Herndon, VA
ETL Production Support
  • InScope International, Inc.
  • Reston, VA
Junior Developer - ETL
  • Meridian Technologies, Inc.
  • Arlington, VA
ETL Developer/Senior/Mid Senior
  • Comtech LLC
  • Lanham, MD