Capgemini Software Developer interview questions

The interview was 3 rounds of coding questions with some behavioral questions. Some of the interviews were with managers and some were with team leads or senior developers. It was overall a ok experience.

I was selected for the interview after clearing the online assessment test, and the technical+gamified rounds. It was online interview, on Superset website. The interview lasted for good 20minutes. Interviewer first asked me to introduce myself, then asked me to explain the project I had done, tech stack used. I explained it nicely. Then I was asked about what I know. I answered SQL, Python, ML etc. Then the interviewer started with SQL questions, it was intermediate queries using denserank, rownumber, then some theoretical database questions like schemas and fact tables. I could not answer a few questions but it didnt create any obstruction, the interviewer asked another question.