I applied online. I interviewed at Meta (New York, NY) in Apr 2021
Interview
I applied to Facebook a while ago, and someone from Facebook reached out to me some time later. It wasn’t regarding the position I applied for, they had my information already in the system and reached out in case I was looking. It happened I was actively interviewing also with other companies. The first conversation went great, we talked about my background, what position entitles and some technical question. At the end of our conversation, the person that interviewed me told me he will speak with his team and get back to me “tomorrow”. Mid time I’ve received an email to sing up to Facebook recruiting website, I was sent test prep materials, and was asked to pick my availability dates for next interviews. The person that interviewed me didn’t get back to me the next day, week, or month. I received an email to provide my work authorization and nothing after that. No email, phonecall, note, on recruiting site still shows “your conversation took place recently, you should hear from ur shortly”. It’s been 3 months, I haven’t heard anything, not even an answer to follow up email I sent. It was the most unprofessional experience I’ve had. Every single company I interviewed with gave me an answer or some kind of follow up. Thankfully it didn’t work out, I landed position elsewhere with amazing company.
Interview questions [1]
Question 1
Some basic python and sql questions, it was just an into
I applied through a recruiter. The process took 3 months. I interviewed at Meta in May 2021
Interview
I was reached out by recruiter via email and scheduled phone call interview. Next I had on-site interview where they gave enough time to prepare and prep-calls are the best. They give you a very brief mock interview process for product-sense.
Interview questions [1]
Question 1
Main focus should be on Product sense, SQL and python basics like List and Dictionaries.
SQL - You should be well aware of aggregations, how to do one table scan and provide aggregated values.
Product sense is something which will be covered in all your rounds.
Data Modeling - Focus how you design your Dimension and Fact tables. Make sure to have denormalized fact tables. Go through Data models of Uber, Doordash, LinkedIn (not like graph database) but at higher level.
Because SQL questions would be based on how you design.
Python - Basic questions like calculating average, traversing and sorting lists and dictionaries would be enough.
Recruiter reached out. Setup a 1 hr screening interview.
This was my 2nd attempt at this position. Although, I could solve all the 4 SQL and 4 Python questions (passed all the test cases) with little help from the interviewer except the last one where the interviewer had to give me the idea to solve it, got an email the next day saying I didn't make it to the next round.
As they don't give feedback after the interview, it is very difficult to judge what went wrong. My understanding is, even though you have the option to run the code and see the output, don't do it until you are 100% sure that your code will pass all the test cases. Although the interviewer said that you can run queries and see data, every run you make is counted against you.
I would suggest don't put your heart and soul into preparing for the interview. It's ultimately a human interacting with another human. Even if you perform well in the interview, a lot of other factors can affect your candidacy.
Interview questions [1]
Question 1
SQL Data schema was provided. SQL to be written that used left joins, nulls in filter, count func., case stmt.
Python
create a histogram from a given list
flatten a list: [1,2,[3,4. [5],[6,7,[8,[9]]]]]
remove duplicates from a list
count words in a sentence