1st Round(Group Discussion):

• It was an online group discussion round and the eligible students were divided into groups with each group having 4-5 students.
• For each group, there was a different topic provided by the interviewer.
• At a time only one group was asked to join the meeting for group discussion. After that, the interviewer provided the topic for group discussion.
• The topic for our group was “Pune or Pimpri-Chinchwad, which is better ?”. The interviewer was given 5 minutes to think about the topic and one by one students had to put their thoughts on the topic.
• The students who cleared this round were selected for 2nd round.

2nd Round(Technical Round-1):

• It was an online technical round and the interviewer was so polite.
• He asked me to introduce yourself
• Technical Questions asked:
  • Write down a code to find the second maximum element in the array.
  • Basic Questions on SQL
  • Do you know about OOPS? Give me HLD for your society.
  • 4 pillars of OOPS.
  • What is DSA?
  • Explain Stack, Queue, Linked List, Tree. (Basics only).
• This interview went for 25-30 minutes and the students who cleared this interview were selected for 3rd round.

3rd Round(Technical Round-2):

• It was also an online technical round and the interviewer was strict.
• Technical Questions asked:
  • Create a table for students, teachers, and courses for college and explain the relationship between them.
  • How will you choose primary key and foreign key in student table.
  • What are the various types of relationships in SQL ?
  • I was unable to answer the most of the questions from SQL, then the interviewer told me a good developer should have a command on SQL.
  • Then he asked me one puzzle (pattern in number series).
  • At last he asked me 2 easy coding questions and I was able to solve both of them.

Result: Not Selected

Suggestions:

• Prepare SQL in depth and practice queries on joins.