J'ai postulé via un recruteur. J'ai passé un entretien chez Meta en déc. 2024
Entretien
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,
Questions d'entretien [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.
Starts with a screen, followed by leetcode style SQL+Python questions, Full loop of SQL, Python, SQL plus Python and lastly behavioural round. Every round is also an architecture round in some sense.
Begins with an application review and recruiter screening, followed by a technical phone interview that assesses SQL, data modeling, data warehousing, ETL processes, and coding skills in languages such as Python or Java. Successful candidates then proceed to onsite or virtual interviews, which include multiple rounds covering coding, system design, data architecture, problem solving, and behavioral questions.
Questions d'entretien [1]
Question 1
Tell us about yourself and why you want to work for us
J'ai postulé en ligne. J'ai passé un entretien chez Meta (New York, NY)
Entretien
Prepare technical concepts, and practice previously asked questions as much as you can find online. 4 rounds in the total process. It's easy as long as you just practice a LOT.