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.

Recruiter reached out via Nuakri.com , one of the worst experience so far, unprofessional folks who're taking interviews and wasting time for fun. Interviewers doesn't seem to have knowledge on what they're asking just took some questions from google and expected the same inline answers, were late in both of the interviews and then stretched the interview from 1 hr to 2 hrs even though I said I've some office work and don't have this much time, entire team was taking the interview in the same call. Pathetic !!!! Then never bothered to provide the feedback.