Choosing a data warehouse server system

puzzled_decoy writes: The company I work has decided to get in on this "big data" thing. We are trying to find a good data warehouse system to hour and run analytics on, you guessed it, a bunch of data. Right now we are looking into MSSQL, a company called Domo, and Oracle contacted us. Google BigQuery may be another option. At it's core, we need to be able to query huge amounts of data in sometime rather odd ways. We need a strong ETLlayer, and hopefully we can put some nice visual reporting service on top of wherever the data is stored. So, what is your experience with "big data" servers and services? What would you recommend, and what are the pitfalls you've encountered?