ETL TesterLocation: Schaumburg, ILDuration: 12 MonthsRate: DOEJob Description:Extensive experience in ETL/Datawarehouse testingStrong working experience in building complex SQL queries, perform Data Analysis, Data Testing in BI/DW environment.Experience in UNIX commands, Autosys & ETL concepts like, Dimensions, Facts, Factls tables, SCD 1, SCD 2, joins, surrogate & primary keys, 3NFHands on experience in any ETL tools like Informatica / DataStageDevelop ETL Test Plan / Strategy/ Test Scenarios/ Test Cases/ Test Data Management/ Defect ManagementProviding estimation for the testing efforts.Experience in Client ALM & JiraAutomation experience on ETL using Python/Selenium etc will be big advantage Strong knowledge of Agile methodologyGood Communication and problem solving skillsWilling to work on onshore-offshore model with Individual Contribution Experience in full SDLC (Agile, Scrum) cycle in general and specific to user requirements gathering, user stories, narratives, product/scrum backlog, sprint planning, backlog grooming, Use Case design and analysis, Scenarios, Business processes, MS Visio, Power Point presentation, process flows, wireframes, technical documentation, QA, QC and UAT activities.