I applied through a recruiter. I interviewed at Meta (Tel Aviv-Yafo) in May 2020
Interview
The process is always the same. I had a phone call with HR and then a screening interview which I did not pass.
The woman that interviewed me gave me the feeling that I did a good job, then they told me I failed :(
Interview questions [2]
Question 1
SQL: there is a table of time,post id, action and content. the action can be reported and the content is spam.
another table of time,post id, user - of all posts were removed manually
the question: What percent of yesterday's content views were on content that has been reported for spam and removed yesterday?
I applied through an employee referral. The process took 3 weeks. I interviewed at Meta (Tel Aviv-Yafo) in May 2020
Interview
HR sent me a mail asking to descibe my experience, my skills and some additionnals informations.
After, we scheduled a call. Asked me some questions and planed the technical interview. Sent a mail to help to prepare it the best way.
During the technical interview , we used a whiteboard by visio
After some day, I received the response (I would prefer it to be more explained but I knew I failed the interview)
Interview questions [3]
Question 1
Given a table of date, user_id, stuatus_id, action (like, comment, viewm, report) and extra (absurd, violent...) , provide the number of different reports from yesterday.
I had a video interview with a Data Scientist. The interview lasted about 45 minutes and consisted of one technical coding (SQL) question and a product question. The team member gave me time to ask questions at the end.
Interview questions [1]
Question 1
Given a database of posts and a database of comments on those posts, how do you determine how many conversations are happening in the comments per post on average.