Capgemini interview questions

I recently interviewed with Capgemini for a Data Engineer / [your role] position. The process spanned two rounds over about 2–3 weeks and was conducted via Microsoft Teams. The first round was technical + coding. The interviewer asked questions on SQL (joins, window functions, data types), basic Python (functions, list/dict operations, error handling), and ETL concepts (staging area, SCD, incremental loading). There was also a simple coding problem on arrays/strings (e.g., counting frequency or removing duplicates) which I solved in Python. I also explained a project where I built a data pipeline on GCP / AWS using Cloud Storage → Cloud Dataflow/Spark → BigQuery. The second round was managerial + HR. The manager asked about my recent projects, challenges faced, how I handle production issues, and collaboration with stakeholders. The HR part covered notice period, location preference, compensation expectations, and career goals. They also asked behavioral questions like “Describe a time you missed a deadline” and “How do you handle conflicts with a teammate?”

There are two technical rounds of half an hour. Difficulty level is easy. The HR do not respond quickly that's the only drawback here. They sometimes cancel the interview in the middle after scheduling.