Amazon Business Intelligence Engineer interview questions

I was contacted by a recruiter on Linkedin. I was a great match for the job description that was posted. I had 1 phone interview set up with the Director, but at the last moment he could not make it so I had a rushed, unprepared interview with someone else on the team. Phone interview was mostly regular data warehousing concepts and SQL questions (types of joins, paritioning, etc). I did well enough in this conversation to make it to the on-site interview. The radical differences in expectations, questions and answers to my questions about the role/team between the 5 interviewers made me think that they were not on the same page about this role. The Data Engineer said that BI Engineers just build views that the users ask for; but then he quizzed me on data engineering concepts for the rest of the hour. At least in my interview with the BI Engineer who would be my peer, I actually wrote SQL for the first time in this process (on a worksheet they had printed out for me, during the last interview of the day in the final round on-site). But the BI Engineer said that they basically do everything and data engineering would only get involved in really complex situations; he then proceeded to also give me a vocab quiz on advanced data modeling and big data performance topics. Mind you, the job description only required "Experience with MS Excel, Access and SQL/SAS"... "MBA preferred"... I thought they were looking for someone to develop KPIs and help automate their customers' processes... not architect the whole Redshift cluster. On the plus side, if you read and memorize Kimball you can crack this interview with very, very little actual SQL skills.

I applied online on Amazon's website for a business intelligence position and in a month's time, I got an invitation for the phone interview. Although I had confirmed earlier from the recruiter about the type of interview as Behavioral one, It turned out to be technical mostly. I feel it entirely depends on the person to ask any type of question for the role. I should say, You should be prepared to answer all kinds of questions.