Pathetic interview experience. I received a mail to book slot on Elevator/Superset portal for an interview over the weekend. The talent acquisition team called 4 hours before the interview and asked me to be online to call immediately. I was online for two hours and finally received the call. During the interview process, I can barely hear the questions that the interviewer was asking. There was a lot of background noise on the interviewer's side, and he seems to be disconnected and uninterested. He asked a couple of questions and ended the 1 hour scheduled interview in 10mins.

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