Meta Data Engineer I interview questions

I got the call via employee referral. HR contacted me through phone for initial screening. General interview like my background and interest. Then a few weeks later, SQL Coding and Python Coding rounds was conducted. Each coding round were of 45 minutes each back to back with 15 minutes break. The coding was conducted on coder pad. I was able complete the 5 SQL coding questions but could only complete 1 Python coding question. I found the python questions difficult.

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.