Job Description :
Role: Quality Assurance Analyst
Location: Des Moines, Iowa
Duration: 12 months  

This Position is for a Quality Assurance Analyst who can develop and execute testplans for data ETL processes in a Data Warehouse environment (staging tables,enrichment tables, current view tables, history tables, facts, dimensions.Strong DB2 and SQL knowledge required. Must have strong communication skills!Must be able to work independently without hand holding. Must be driven andwilling to take initiative. Will be working on a scrum team so Agile experiencepreferred. This position doesn''t require Informatica experience but preferencewill be given to those who haveit.                
RISData Squad team info:
? Agile/Scrum shop
? Work for Retirement (401k, Defined Benefit) business (approx. 450 ITfolks in RIS business unit
? 6 Scrum teams (4 Data Integration (Informatica) and 2 Reporting (WebFocus & Business Objects)
? 6 – 8 per scrum team made up of Scrum Master, IT BA, Bus Product owner,Data Engineers, QA’s & BA’s
? Plan work in 4 week increments (Two 2 week sprints)
? Squad Backlog kept in Jira
? Teams/responsibilities divided up by data subject (Member level data,Plan level Data, Advisor level data, Investment level Data, etcSkillsets/Technicalknowledge:
? Strong understanding of Data Warehouse environment (all layers; OperMart/staging, enrichment, Data Mart/consumption (facts & dimensions
? Data Modeling techniques (relational vs dimensional, historical vscurrent view)
? Good understanding of data acquisition methods
? Strong Informatica skills (for developers, bonus for QA/BA)
? Strong understanding of ETL processes in DW environment.  Need tounderstand relationship between different DW layers/constructs
? Experience writing business requirements for data centric(analytic/reporting) needs (required for BA, bonus for BA/Dev)
? Experience creating test plans for ETL processes in a DW environmentplus strong understanding of regression testing methods (required for QA, bonusfor BA/Dev)
? Developers will be expected to assist with QA testing when needed
? Expected to assist with on-call responsibilities and production support