I applied through an employee referral. The process took 4 weeks. I interviewed at Meta (Menlo Park, CA) in Sep 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)
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Interview questions [1]
Question 1
Tell us about yourself and why you want to work for us
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.
