I have attended Capgemini interviews twice.

During the phone screening for the first interview, the HR representative stated the position was for SSIS and SQL. I informed her that I do not have experience with SSRS and SSAS, and she confirmed they were only looking for SSIS and SQL expertise. The first round was scheduled and went well; I cleared it.

After one week, I received a call indicating I had cleared the first round and that the second round would be scheduled. In the second round, a technical manager interviewed me, and I answered approximately 90% of the technical questions. He asked why I hadn't learned SSRS, SSAS, or any other ETL tools. I explained that my projects had not required those technologies, but I had received training. I also mentioned that without hands-on experience, I might not be able to answer questions on those specific technologies. He then questioned my comfort zone, given I had been with the same organization for eight years, and asked what felt like irrelevant questions. Following this, I did not hear back from the Capgemini team and assumed I had not cleared the second round.

In June, I received another call from HR regarding an SSIS developer role, which I accepted. An interview was scheduled, and the interviewer asked me to introduce myself and explain SSIS transformations, types of constraints, and one question on triggers. I answered all these questions. After my responses, he stated he was finished and that HR would be in touch. This interview lasted only about 10 minutes.

The next day, I received another call from a different HR representative about an opening. When I mentioned I had already interviewed the previous day, they checked the database and informed me I had been rejected. They then explained that this new opening was for a different account and asked if I was still interested. I declined.

Since then, I have been receiving daily calls from Capgemini for the SSIS developer position, and I have been saying no to each offer.

Introduction

SSIS Transformation

Difference between Union All and Merge

Difference between Conditional Split and Multicast

Scenario-based questions

Query to delete duplicate records