I applied through a recruiter. The process took 2 weeks. I interviewed at Capgemini (Bengaluru) in Nov 2020
Interview
The interview process was quite smooth. There were two rounds of technical interview followed by one HR round. The process completed in a week. I got good hike according to my current Ctc. Basically they covered good shorts of data engineering questions followed by cloud expertise. Just waiting to join and explore more about the organisation.
Interview questions [1]
Question 1
Aws Redshift, Data warehousing principles, spark and some SQL problems
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.
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?