I applied online. I interviewed at Capgemini (Bengaluru) in Mar 2024
Interview
it was good they asked about sql theory and query part .clusterd index and non clusterd index, triggers ,sps and optimzation methods and how to optimze teh sps without rewriting the queries?which index is faster
I applied online. The process took 2 weeks. I interviewed at Capgemini (Pune) in Oct 2024
Interview
Virtual interview with easy to moderate questions by interviewers and anyone who is having real experience can crack interview.be confident and go for interview you can do better. Also basic knowledge of SQL and ssis needed.
I applied online. I interviewed at Capgemini (Bengaluru) in Jan 2022
Interview
Its good, But asked many questions and covered almost all the topics and written 8-10 queries in the interview. Its really good process of asking many questions. I have completed 2 rounds of interview successfully.
Interview questions [1]
Question 1
They asked me to write queries.
Asked questions on performance tunning ,windows functions, joins related, Indexes related, Execution plan related etc
