Data Engineer applicants have rated the interview process at Meta with 4 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 100% positive. To compare, the company-average is 74.2% positive. This is according to Glassdoor user ratings.
Here are the most commonly searched roles for interview reports -
I applied through an employee referral. I interviewed at Meta (Menlo Park, CA) in Jun 2020
Interview
phone screen followed by onsite Database and SQL data modeling , product sense python coding dictionaries lists
product sense analytics, various kind of graphs SQL joins aggregations medium complex questions on python coder's pad
Interview questions [1]
Question 1
Python replace the none value with last non null value
I applied through a recruiter. I interviewed at Meta (Palo Alto, CA) in May 2021
Interview
Two technical rounds. First was SQL/pyhton which was 1 hour. 3-4 python questions and 3-4 SQL question. Next round was pure SQL and also past experience. Last round with hiring manager which was technical, 1 python and 1 SQL question.
Interview questions [1]
Question 1
SQL question: given a table find the most recent transaction in the table.
I applied through a recruiter. I interviewed at Meta in Aug 2021
Interview
Reached out by recruiter.
Technical screening, 1hr, 5 python, 5 SQL
You will be able to see the test cases as you're coding. For SQL questions you can query the database to check the data.
I got 9.5 out of 10 questions correct. The last SQL questions I got incorrect, but the interviewer said my logic looked right. Waiting for response.
Interview questions [10]
Question 1
Write a function to return the number of times a character appears in a string. The character can be the empty string.
Complete a function that returns a list containing mismatched words in two strings. The return list can be in any order. I used set to solve this question, but was also asked to verbally explain how I would solve it without using sets.
Given a dictionary, print the key for nth highest
value present in the dict. If there are more than
1 record present for nth highest value then sort
the key and print the first one (alphabetically). N can be higher than the number of elements in the dictionary.
Given a list of ints, balance the list so that each int appears equally in the list. Return a dictionary where the key is the int and the value is the count needed to balance the list.
[1, 1, 2] => {2: 1}
[1, 1, 1, 5, 3, 2, 2] => {5: 2, 3: 2, 2: 1}
What are the top five (ranked in decreasing order) single-channel media types that correspond to the most money the grocery chain had spent on its promotional campaigns? media_type can contain mutliple values seperated by a comma, so single channel is when media_type only has one value.
Percent of sales that had a valid promotion, the VP of marketing wants to know what percent of transactions occur on either the very first day or the very last day of a promotion campaign.