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.
