The interviewers never talked about the company, did not seem motivated or passionate about the data & analytics effort. They started asking SQL questions that I got right, also ETL design pattern use cases that also got right, they asked me questions about SSRS, very old school way of asking where to click to create variables or right click to see properties, they were looking for someone with more data science skills, while I was not an expert on that, I have had 1 year of exposure to R and Python doing data science (decision trees, random forests, k-means and some deep learning) however they never asked me questions about it, looks like they did not know what they were looking for, the company itself looked old (my perception) and the interview was not well designed, they were expecting someone being expert at every requirement but failed to ask the questions. I am glad I did not end up there, if you are a fellow BI or data & analytics colleague, this would be your last option, ah and they never asked me anything about hadoop, hive, etc. I had experience on that as well and the requirements mentioned that. Anyway, my perception