Process
The phone screen round was a smooth process. It included SQL and Python sections. You could choose which one you wanted to tackle first.
Python:
- Q1. Write a function that returns the smallest non-negative number that can be generated using all the digits with odd values from a given number.
- Q2. A bookstore gathered a list of customer comments from each shop location and wants to find the most common comment across all locations (ignoring duplicates from the same location). If multiple comments appear the same number of times, return any one of them.
Questions
For the SQL questions, the schema had four tables: author, transaction, customer, and payment.
Q1. What was the total value of sales and the number of unique paying customers, grouped and sorted in descending order by payment type?
Q2. Find the IDs of the top 5 customers, ordered by average payment per book made by the people they invited.
Q3. Find the total number of authors registered with the bookstore. What percentage of them have a website URL that contains ".com", and what percentage never made a sale?
Was this helpful?
Interview Statistics
The following metrics were computed from 347 interview experiences for the Meta Data Engineer role in United States.
Success Rate
15%
Pass Rate
Meta's interview process for their Data Engineer roles in the United States is extremely selective, failing the vast majority of engineers.
Experience Rating
Positive63%
Neutral24%
Negative13%
Candidates reported having very good feelings for Meta's Data Engineer interview process in United States.
Meta Work Experiences
5.0
Incredible Place to Work
Data Engineer • Current Employee
London, England, United Kingdom
March 2, 2020
Pros: You get to work with the smartest people, the best tools, and the most amount of data whilst influencing billions of people. Also, the perks like free food and travel are pretty good!
Cons: It's so fast-paced that it's always intense. The documentation gets left behind, and there's a focus on getting things done reasonably well, but not always perfectly.
4.0
Good compensation, long hours, smart coworkers
Data Engineer • Current Employee
July 13, 2023
Pros: Smart colleagues, good benefits, perks, and salary.
Cons: A 6-month assessment cycle is too short.
4.0
Just about the best workplace I can imagine
Data Engineer • Current Employee
Menlo Park, California, United States
July 8, 2019
Pros: Facebook, as a company, takes care of its employees.
The benefits are outstanding, featuring all the health-related perks you can imagine: free, healthy food, gyms and other physical activities, and a wellness center complete with doctors of all kinds.
The work itself is generally very good, with teams that empower their employees to come up with their own roadmaps every quarter, allowing for lots of creativity and innovation.
Cons: Like most tech companies, there is an element of top-down decision-making which can make employees feel like they're not always working on what they want to work on. And while I believe Facebook can be a force for good, they are also occasionally a force for bad things in the world, and I don't want my legacy to be that I worked here forever. Luckily, with how great things are around here, it'll take a truly amazing opportunity to get me to leave.
- 5.0Incredible Place to WorkData Engineer • Current EmployeeLondon, England, United KingdomMarch 2, 2020Pros: You get to work with the smartest people, the best tools, and the most amount of data whilst influencing billions of people. Also, the perks like free food and travel are pretty good!Cons: It's so fast-paced that it's always intense. The documentation gets left behind, and there's a focus on getting things done reasonably well, but not always perfectly.
- 4.0Good compensation, long hours, smart coworkersData Engineer • Current EmployeeJuly 13, 2023Pros: Smart colleagues, good benefits, perks, and salary.Cons: A 6-month assessment cycle is too short.
- 4.0Just about the best workplace I can imagineData Engineer • Current EmployeeMenlo Park, California, United StatesJuly 8, 2019Pros: Facebook, as a company, takes care of its employees. The benefits are outstanding, featuring all the health-related perks you can imagine: free, healthy food, gyms and other physical activities, and a wellness center complete with doctors of all kinds. The work itself is generally very good, with teams that empower their employees to come up with their own roadmaps every quarter, allowing for lots of creativity and innovation.Cons: Like most tech companies, there is an element of top-down decision-making which can make employees feel like they're not always working on what they want to work on. And while I believe Facebook can be a force for good, they are also occasionally a force for bad things in the world, and I don't want my legacy to be that I worked here forever. Luckily, with how great things are around here, it'll take a truly amazing opportunity to get me to leave.
Meta Interview Questions
Explore Interview QuestionsTaro 75Google Interview QuestionsMeta Interview QuestionsAmazon Interview QuestionsApple Interview QuestionsNetflix Interview Questions
Explore Interview ExperiencesOpenAI Interview ExperiencesAnthropic Interview ExperiencesPerplexity Interview ExperiencesWindsurf Interview ExperiencesMistral AI Interview Experiences
