So first of all interview process is very lengthy as they took time to take the interview.
First round : A technical round held by the database team member and he came with a set of 17 questions which includes the query questions as well as the apptitude questions such as time questions, Work done questions , puzzles , and some questions were from logical reasoning.
Second round : After waitinh for 15 min in lobby another guy came and took my second round and this was also a technical one where he asked mainly from Joins. This round took 30 min.
Third round : Team lead of database support came and asked some nonsense questions which was not at all relayed to database and he asked 2 puzzles ( A thing about puzzle is i can also ask many puzzle which many of cannot be able to answer so similarly puzzles can be answer and cannot be) anyways he took 35min
Now here's the hard part comes "Waiting period" TL came and told me that i meed to wait as HR went for lunch ( First of all they should inform or tell me atleast because if someone is waiting in the lobby since 1 hr and he passed by infront of me with a smile but he didn't informed.
So i called him and asked "should i leave for the day or to wait "
He told me to wait.
He came after 40 min (it becomes 1.40min of waiting) asked some basic hr questions.
After that he told me to leave and told me to come tomorrow for manager round.