Only SQL qns with joins, groupBy etc and knowledge of rdbms and dbms sql should be strong and very important along with pyspark and all all the best everyone !!!!

The interview process consisted of multiple rounds focusing on core fundamentals and problem-solving ability. In the initial round, the interviewer assessed my understanding of Python basics. Questions were focused on concepts like data types, functions, and basic syntax, along with some small coding tasks to check practical understanding. This was followed by a puzzle-solving segment, where I was given logical and analytical problems to evaluate my thinking approach and problem-solving skills rather than just coding. The next part involved SQL, where I was asked queries related to aggregation, joins, and filtering. The focus was on writing correct and optimized queries and explaining the logic behind them. Finally, there was a discussion on Object-Oriented Programming concepts. I was asked to explain core principles such as encapsulation, inheritance, polymorphism, and abstraction, along with real-life examples and some basic implementation logic. Overall, the interview focused on strong fundamentals, clarity of concepts, and the ability to think through problems rather than rote memorization.