Asked some SQL related questions eg- table containing OrderId CustomerId Date Region, Revenue Now tell me sum of Top 3 revenue by region Rank vs Dense Rank What are the various ways to optimize a query What is indexing What is data structure used in Indexing Python questions- Conversion of different currencies into INT or USD in a dataframe Date time function etc.

2 rounds, first one was technical and the second one was managerial round. They asked excel, sql and dashboarding question. There were 2 scenario based questions too. The experience was good the questions were not very tough and the people were also nice.