I applied online. I interviewed at Meta in May 2021
Interview
applied via linkedin. recruiter reached out to me schedule Initial round , explained the process and then technical round was 2 weeks later. They provided links of different websites for preparation as well.
Interview questions [1]
Question 1
sql: already present in glassdoor.
1)ratio of is_fat and is_someother among total products
2)top 5 single channel companies that spent max amount on promotion. take into account of the ones that have only single entry
company , channel;
1 food, water
2 food
3) percentage of sales on first day and last day
python: occurrences of a letter in a string, replace none with previous value in a list, from a dictionary get the keys corresponding to nth highest value.
Initial phone screening and 2nd round tech interview were pretty easy and pleasant.
Final round consisted of 4 1-hour slots with various team members. First 2 interviews were just OK, the last two were just terrible - 1 interviewer was extremely disinterested and didn't really explain the task I was supposed to be doing- The last interviewer just talked way too much and interrupted a ton, he seemed to have forgotten that I'm the one being interviewed and not him. He also went 45 minutes over the scheduled timeslot. Exhausting.
Got ghosted after the final round. My recruiter also ignored a follow-up email from me (despite being specifically told to write an e-mail if I don't hear back after 2 days).