The interview process consisted of 4 rounds in total. The first round focused mainly on Python and SQL with a mix of tricky and conceptual questions. Python questions included topics like global vs local variables, understanding list operations, and predicting outputs of small code snippets or functions. SQL questions were more on the analytical side, such as handling NULL values in joins, solving sequence gap problems, and creating pivot tables.