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