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

I have completed the T1 and T2 interview rounds, along with all the required assessments, and was then asked to upload my documents — including pay slips, offer letters, expected CTC, PF UAN card, and others. I submitted everything as requested. However, I haven’t received any communication regarding the offer letter yet. It’s been quite some time, and this delay without any update has been disappointing, especially considering that most organizations usually issue the offer letter before requesting such detailed documentation.