Interview Experience
The interview started with a standard “Tell me about yourself.” Based on my introduction, the discussion moved into Django, followed by an in-depth focus on Python, which formed the major part of the interview.
The Python section covered core concepts thoroughly, including:
Mutable vs immutable data types
Lambda functions
map, filter, and reduce with examples
Public, protected, and private variables (with examples and runtime behavior)
Difference between @staticmethod and @classmethod
Difference between == and is in Python
Global Interpreter Lock (GIL) and whether Python supports multithreading
Whether a list can be used as a key in a dictionary and why
The interview then moved to Pandas, where I was asked about:
Difference between loc and iloc
apply vs map
merge vs join
Finally, there was a SQL round, which included:
Types of joins
Explanation and example of a self join
What a stored procedure is
Overall, the interview was concept-heavy and technical, focusing on fundamentals and real understanding rather than superficial answers. Being thorough with Python basics, Pandas, and SQL concepts is key to doing well.