I applied through a recruiter. The process took 3 weeks. I interviewed at Capgemini (Bengaluru) in Aug 2025
Interview
It was held as per schedule. It showed the company's interest for assessment of candidate. However initially the interviewer just fired questions randomly. Seeing me answer well he seemed more interested and finally said that he was really happy to have interviewed me.The second round was more on data modelling and though the recruiter told me that it was a reject, the manager said that even me not knowing one or 2 questions was fine. The 3rd round was a highly generic one which needed considering a lot of aspects.
Interview questions [1]
Question 1
The recruiter asking me about how to handle table holding historical data in SCD type 2. He asked me whether the combination of ID with the flag indicating the recently added record would form the primary key
