The process was smooth, yet bit lengthy. It took almost 1.5 months for the complete process to finish. Screening call: A recruiter called to understand my experience and explain about the role. Discussion around my availability for next rounds First Round: (Scheduled almost 15 days later) Technical round, Interviewer asked questions from resume (project related, system architecture, data warehouse related) 2 SQL Query: one easy, which was basically to filter out some records based on multiple conditions. Here interviewer tried to understand if I can make the query run faster using other methods 2nd SQL: Calculate total sales and average sales per region. Python/ Pyspark: 2 Ques 1. given a dataframe, find duplicates based on certain conditions, remove duplicates from this df and move to another df. 2. Given a list, reverse it. some slicing ques on same list. Few other Descriptive questions on Data warehousing, data normalization and Architecture. scenario based ques, when to use star/ snowflake schema? 2nd Round: Technical + Managerial Mostly questions on previous experience and project. Interviewer tried to understand why did we choose a particular architecture for the project i worked on in prev org. Some scenario based ques - how do you handle changes that has to be made on a production level table that might have impact on downstream pipelines. How did you handle failures in production level pipelines what are you looking for in your next role Final Round: HR Discussion

Half of the interview was standard behavioural questions, such as tell me about yourself. The other half was simple technical Pandas questions, SQL questions and git questions. No leetcode style questions