Requirements/Skills:

· 5-6+ years’ experience in Software Quality Assurance

· 3-5+ yrs experience in ETL QA

· Thorough knowledge of SDLC and QA/Test methodologies

· High Proficiency in ETL Testing

· Advanced skills in manual testing and proficiency with backend automation test strategy

· High proficiency with use of all modules in HP QC or ALM (Application Lifecycle Management)

· Interpreting Physical Data Models with little to no assistance

· Interpreting Logical Data Models with little to no assistance

· Transactional SQL (SQL Server, etc.) and PL-SQL (Oracle, etc) knowledge

o Querying against source and target database objects

o Proficient with heterogeneous (aka “cross-connection”) queries and how to use them in ETL testing

o Highly proficient in building complex SQL statements involving all join variants to enable them to make robust comparisons of source versus target data loaded by the ETL

o Highly proficient with use of SQL inserts/Updates/Deletes to create “fabricated” and “negative” test data sets

· Excellent written and verbal communication skills

· Good to have - understanding of DW/ODS modeling approaches (STAR, Snowflake, etc)