I applied online. The process took 2 months. I interviewed at Meta (Warschau, Masowien) in Dec 2024
Interview
I have mixed feelings about this recruitment process, specifically screening.
The recruiter was very nice, the atmosphere was great and the interview was not stressful.
On the other hand, the screening lasts only an hour, and the time for the interview itself is maybe 45 minutes, without the introduction and the recruiter's explanation of the tasks.
My recruiter gave me tips, even though I said I wanted a moment to think about the task. I wonder if these tips have negative impact on the final score of the interview.
In the end, I solved all the tasks (3 Python and 3 SQL), but 2 of them with the recruiter's help, which I didn't ask for at all.
And I was rejected.
I wonder if I had solved 5 of the 6 tasks completely on my own, would that have get me a better result than 6 of the 6, but with the help of the recruiter.
In summary, the tasks were not very difficult, but the time to solve them is very very limited.
Interview questions [1]
Question 1
As for the tasks themselves, from Python there are dictionaries, arrays, sets, quite simple, but you have to be careful with edge cases.
As for SQL, it's mostly JOINS and aggregation functions.
One task I had could be solved window function, but the recruiter said to do it in a different way (GROUP BY, HAVING and LIMIT).
Hope that helps you guys :)
I applied through a recruiter. I interviewed at Meta in Dec 2024
Interview
I was contacted by the recruiter, and the initial interview was based on basic questions about experience and then for SQL- UNION vs UNION ALL, Window functions, HAVING & GROUP BY; for Python- basic questions on Lists, Maps, Linked List, Sets, etc. (like what are they about and can they have duplicate values). Moving on to the phone screening round. It was 60 mins round with 5 SQL & 5 Python. I was able to solve 3 of each, but I went 5-7 minutes of overtime. The questions are time-consuming, so practice is the major key here. The recruiter was helpful. Also, try to explain your code as you go,
Interview questions [6]
Question 1
SQL - Q1. Find the IDs of the top 5 customers, ordered by average payment per book made by the people they invited.
Q2. 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?
Python- Q1. Write a function that returns the smallest non-negative number which can be generated by using all the digits with odd values of a given number.
Q2. The 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.
Q3. Given a list of workshops, return the largest number of classes that were hosted in total across any 2 consecutive years that had at least one workshop each.
It was smooth and interviewers were kind. All the rounds went well but i was not selected. Please prepare well for the initial technical screening round as we do not find enough time to solve all the problems