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.

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.