First round:- SQL Assessment and LP multiple choice question Second round with hiring manager:- Two Medium level SQL Questions and 1 LP Question. 1) Top 3 items in each warehouse based on revenue 2) Number of customers whose last transaction was higher than the previous transaction. LP:- Something related to metric (Improved the performance which impacted the team/customer) Interviewer was nice and I was confident that I answered all his questions correctly. Don't know why I wasn't selected .

Interview focused on analytical thinking and case studies. Main focus was on the leadership principles. First interview was a phone interview that covered a few basic questions and SQL coding. The loop had 4 rounds.