I had a 60 mins screening interview. 5 min introduction, 25 min for coding, 25 min sql, 5 for Q/A. The majority of the questions were from leetcode. The interviewer was very supportive and helped me when I got stuck with something.
I applied through an employee referral. I interviewed at Meta (San Francisco, CA) in Aug 2024
Interview
The interview process consisted of three rounds: the first round was a telephone interview where general questions were discussed. The second round involved a coding assessment, and the third round was an onsite interview where technical and behavioral questions were asked, along with problem-solving tasks.
I applied through a recruiter. The process took 2 months. I interviewed at Meta in Mar 2025
Interview
Contacted via phone, talked with recruiter, standard phone screen. Final round interview was 6 separate questions and a culture fit interview. Overall, standard interview. Their recruiters are very professional. Did not get an offer
Interview questions [1]
Question 1
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| product_id | int |
| low_fats | enum |
| recyclable | enum |
+-------------+---------+
product_id is the primary key (column with unique values) for this table.
low_fats is an ENUM (category) of type ('Y', 'N') where 'Y' means this product is low fat and 'N' means it is not.
recyclable is an ENUM (category) of types ('Y', 'N') where 'Y' means this product is recyclable and 'N' means it is not.
Write a solution to find the ids of products that are both low fat and recyclable.
Return the result table in any order.