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?”