An interview is focused on SQL, Python, and AWS data engineering services, including scenario-based questions on ETL pipelines, Redshift, Glue, Athena, and PySpark transformations Also round was more technical and included real-time data engineering use cases, optimization techniques, joins, window functions, and troubleshooting AWS workflows. The overall process was challenging but well-structured for experienced AWS Data Engineers.
Other AWS Data Engineer interview reviews for Capgemini
I applied online. The process took 1+ week. I interviewed at Capgemini (Calcutta) in Jan 2025
Interview
Good interview and smooth process and got good designation also.
Nice interview experience with all the formalities done within the time frame.
Would recommend everyone to join this company.
They have very good projects available.
Interview questions [1]
Question 1
python,pyspark,sql,aws glue,redshift,lambda,Athena asked programs as well as realtime questions.
I applied online. I interviewed at Capgemini (Bengaluru) in Oct 2023
Interview
The Amazon Data Engineering interview can be broadly divided into 3 rounds. After applying for the job, a screening round is conducted, which is a telephonic interview with a recruiter. Candidates then proceed to the second round, which is a technical phone interview, with questions focusing on SQL and Data Modeling.
Interview questions [1]
Question 1
Write a query to retrieve duplicate records from a table?
