Actually it is one of the nicest interviews that I had experienced. I really enjoyed the culture of people at Delta and they were really welcoming and kind.
In the first round, I was interviewed by my supervisor about the role and my background. They were looking for someone with data science and business background. Then they set up an interview on-site for me that it was 6 rounds planned. 4 of them were kind of behavioral and two of them were like programming and SQL which were straight forward. The Python question was a simple table that they want you to use groupby. The other round was to know the team members and they asked me about how would you calculate the number of coffees is being sold from Starbucks in Atlanta. They wanted me to think loudly basically! The data science position that I was being interviewed for was in price optimization so that's why they wanted me to have a good understanding of customers' needs. The last round was with the director of the department and he just wanted to know me better and asked me really simple questions of why you chose Delta, what are the challenges that you think you would have...