Capgemini Sr. Consultant interview questions

Interview process was good. And I have managed to give answers in a correct way. Interviewer also found good. But only thing I feel is, timeframe taken for the 1st round & 2nd round of interview was more. That can be little short.

The technical interview process primarily focused on evaluating my hands-on experience in ETL testing, SQL, and data validation. It usually started with a deep dive into my previous project work—especially around the data migration and transformation scenarios I handled. I was asked to explain end-to-end ETL flow, how I validate source-to-target mappings, and how I handle incremental loads. SQL questions were quite detailed — involving joins, window functions, aggregations, and writing queries to troubleshoot mismatches between staging and target layers. There were also scenarios around data quality, data profiling, and how I handle nulls, duplicates, or truncation issues.