Did a phone interview with the manager. Explained my strengths and weakness and what I can bring to the position. Wasn't very clear on what exactly the job requires. Was asked to come onsite

Had three interviews a)2i QA engineers quizzed me on various SQL questions(one of my weaknesses..so didn't do that well) b)2 developers quizzed on various Junit related questions and API related questions.At this point I realized the job position didn't meet my qualification and I kind of lost interest. Also one interviewer was extremely rude when I didn't answer some basic question from his view point.I had made it clear in my phone interview what I was bringing to the table. Guess the manager should have communicated to the interviewer. c)1:1 interview with the same person whom I had phone interview with.I kind of explained him that this position only needs 20% of my strengths and other things I will have to pick up on the job.

Overall,the interview experience was bad-I expect the interviewers to be humble about the questions they ask and if the interviewee is not meeting their expectations,it's not end of the world and should be treated as such.

The questions were SQL-related.