1) Data Warehouse domain understanding
2) ETL/Report testing exposure using tools like informatical, Abinitio, Talend and reporting tools like Cognos, OBIEE, SSRS, MSBI, BO etc.
3) Exposure to test case design and execution (functional as well as technical)
4) Good in SQL scripting (at least at 6 out of 10). This means advanced query understanding and writing experience
5) Basic unix commands
6) Experience of 5 - 7 years in testing
7) Good to have: Any one of the scripting language exposure or automation tool.