Meta Data Engineer interview questions

I interviewed with the Business Intelligence team. The process involved one phone interview (coding + SQL) followed by 4 rounds of interviews at onsite. Phone interview was easy with medium level SQL and coding questions. The interviewer stressed a lot on running times for the coding questions. I had to offer three different solutions and implement the optimal version of the code. At onsite, there was one SQL interview, followed by 2 coding interviews. After lunch, a manager conducted an ETL design and metrics interview. The interviewer, who asked me the map-reduce question was doing some work on his laptop. He hardly paid any attention to the code I was writing on the wall. I had to try hard to get his attention to my code and explain how it works. The best part of the interview was meeting Guy Bayes, the Data Engineering Director at Facebook. He is such a cool people manager. Instead of interviewing me in the interview room, he took me out for a walk along side the bay next to Facebook's office in MenloPark. He is so awesome. Guy Bayes is one reason why you should consider joining Facebook. All the best for your interviews.

Two technical interviews on me and both came from managers. First round was on SQL and everything was straight forward. The interviewer was highly professional and he also introduced what his team was doing. Second round was focused on algorithm and codings and the interviewer with strong accent seemed inpatient and unwilling to explain the question. He told me to look at the test cases to figure out myself. I was told the SQL part was fine but the coding part was not positive.