There were 4 rounds Online aptitude test + Technical Interview + Director round(Tech round 2) + HR round
The online round was kind of easy we had to do basic 20 aptitudes (quant + logical) questions in 25mins, I cleared it.
2nd round was technical in which interviewer asked in one basic puzzle and 2 SQL queries, cleared it too.
3rd round: They named it, Director round sounds like an HR but was also technical involving questions from the puzzle, SQL, DBMS, Coding. I was asked three questions in which 2 puzzles, and one normalization question. I got rejected on this round! :-<
4th & final round was HR typical Q&A: If you'd be able to make it up to Director round than 98% chances you are going to clear this HR round too.
1st tech round was good, the interviewer was very cool, trying to understand your way of solving the questions first instead of sticking to his own way!! Genuine
On 2nd technical/director round, I gave 2/3 questions right but still, they rejected me!
I don't know what were they exactly looking for?
I wasn't able to solve the 3NF question, and the interviewer was laughing at me like he is the only smart guy in the room and everyone is dumb. Irritating!
Literally rejection with no reason is like they don't want more candidates to select.
Worst experience ever!!