I applied through an employee referral. The process took 4 weeks. I interviewed at Meta (Menlo Park, CA) in Sept 2018
Interview
I was referred by one of the FB employee. One of the HR connected to me in a week and asked me about my experience. He was very happy with me and then came the online coding round using coderpad. I was asked 4 SQL and 3 Python questions. I think they have 5 SQL and 5 python question but depending on time bandwidth they ask you as much as possible. I did very well in SQL. I struggled with Python. But I cleared the interview. The reason I was sent to the next round was I shared my thought process at each level. For example. When they showed me the ERD I mentioned what are the facts and dimensions. I also mentioned that there should one more dimension for promotions. Basically gave my views on what could be better. Then with SQL I always started giving answers logically. by always giving the business context. Example-- One question was to find percentage increase in revenue due to promotions. I didnt even look at ERD and directly said promo_id should be in fact - 'sales'. Price of the product should be in dimensions. Ask the interviewer what exactly does she mean by revenue. Like are there any additional earning you get for a product.
I will be travelling for onsite interview soon. Will update my comment once it is done.
Interview questions [1]
Question 1
SQL:
1. Percentage increase in revenue compared to promoted and non-promoted products.
2. Products classes that has the highest transactions
3. Count of Customers who bought 2 items type (A,B)
4. Don't remember
Python:
1. Average length of letters to words.
2. Parse an ip address (This is a favourite FB question)
3. [[A],[A,B],[A,C],[B,D],[C,A]] -- Find the alphabet with highest neighbors? -- (Wasnt able to solve because of time limit but the interviewer was like I get what I want to convey.. I gave her an algo of what I would I have done)
I applied online. I interviewed at Meta (New York, NY)
Interview
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.
I had Python and SQL round for 30 minutes each. The interview was for 1 hour 30 minutes for SQL and 30 mins for python coding.
Completed 5 questions each but still got rejection email the next day.
