Capgemini Developer interview questions

First round was the aptitude round with moderate difficulty questions. Second round was the essay writing round. Third round was the Technical round where basics questions of the programming languages you have mentioned on your resume were asked, questions related to academic projects and seminars were asked and other few technical questions were asked. Last round was the HR round where general knowledge questions were asked. I have received the offer letter but didn't get my joining letter yet and it has been 6 months I am waiting for my joining.

On first day we had to give 2 tests, first one being more of non technical and students who cleared this had to give the technical test on the same day immediately after announcement of results. We got a mail mentioning the students shortlisted for interview rounds to be conducting the next day. There were two rounds of interview: technical and HR. Technical Round: the interviewer focuses mainly on your CV. He will ask questions on every possible thing you have mentioned in your CV, so be thorough with your CV. Apart from this, he asked me questions on SQL,oops, gave some hypothetical situations and asked my views on it, some puzzles. HR Round: The HR again asked me questions from my CV, and many other technical questions from networks and dbms. She then asked me about my family background and why capgemini.