Solicité el puesto a través de un captador. El proceso duró 6 meses. Acudí a una entrevista en Meta (Menlo Park, CA) en ago 2021
Entrevista
7 rounds of interview for a L6(senior)/L7 level lead data generalist data engineer interview. The recruiters were very helpful. This was for a senior level lead role for a couple of new initiative (they said confidential), the interview was rescheduled because they said it's a senior level interview and they need to get senior level interviewers for this call.
Preguntas de entrevista [1]
Pregunta 1
1) Initial one round full of leadership related questions. Didn't expect a one hour full of leadership questions. This round was unexpected as recruiter didn't tell me that it's a leadership round. I was told this is a hiring manager screen where they wanted to check the fit. There were 2 hiring managers (of the 2 teams who were looking for a lead). 2) Initial coding screening - 2 Python coding questions - same as the ones that others mentioned in the Glassdoor. 1- data modeling question (social media site) and set of SQL questions against the data model. 3) Data pipeline system design interview. Asked high-level and low-level details of high data volume real-time pipeline. 4) Behavioral questions with cross-team based questions. 5) Technical round with ETL related question with SQL coding applied. One Python coding to build a grouping based ETL using Python. The output can be easily provided using SQL script. The challenge was to build the same using Python. Should be manageable somebody who's very hands-on. Unfortunately, I wasn't. Though I could write the pseudocode and think through the solution, I couldn't write the actual code within the time. 6) Design the data model for a ridesharing app and answer a set of questions using SQL. I underestimated the complexity of a couple of SQL questions in this round.
Some recuireter spoke to me on phone and gave me the position's details and the interview details. She told me the following interview will have questions in Python and Sql.
Preguntas de entrevista [1]
Pregunta 1
I will speak about the technical first step where I needed solving questions in Python (half an hour) and in Sql(half an hour).
I succeeded solving 2 SQL questions and 1 in Python.
Sql Part:
I was given 5 tables presented a library. But the main 2 and only tables I needed to use in the following questions were: copies and checkouts.
copies table : book_id,copy_id,condition.
checkouts table: copy_id,checkout_date,returned_date,renwed_count.
First Q:
Calculate the total number of books their condition is good and havent returned yet (it should be called "numbers_of_returned_books"). Take this total and return the books' precentage that their renewed > 2 (this should be called "pct_renewed").
The output should be - numbers_of_returned_books and pct_renewed.
Second Q:
They defined a value - lifetime_value. This value is calculated as : numbers of days since the day they were taken and returned. I was asked to bring the book ids their lifetime_value in top 3 books and pay attention their number of copies <=10 and their returned_Date is not null.
Python Part:
You are given a books list which cotains tuples. Each book in books list contains the book name and its score. For example:
list books = [("Agr",3),("bsa",2),("Agr",4),("mas",7)]
You need to return the highest score sum were given to the top 3 books in the list. You are not allowed sum the score number for a book twice.
Recruiter reached out on LinkedIn, followed by 1 technical interview, then 3 more rounds of technical interviews and 1 round of behavior questions interview. All technical interviews are sql and python questions, which starts with the easiest and getting harder and harder.
Acudí a una entrevista en Meta (Mountain View, CA)
Entrevista
Very stressing, some interviewers were nice, some were like robots, everything about the process makes you feel like your in a chase, not a pleasant experience.
If working for the company is like that that's a bad place to work at.
Preguntas de entrevista [1]
Pregunta 1
Product sense questions, 4 in each interview of 1 hour
