Capgemini Data Engineer interview questions

1 round of Technical interview for 30 mins. Questions based on spark theory , 1 SQL code , 1 Pyspark code , 1 python code. 1. Basics of Apache spark 2. SQL code to find 2nd highest salary dept wise 3. pyspark code for the 2nd highest salary 4. Python code to find duplicates in a list

it consists two technical rounds followed by one hr round.the first round deals with few theratical and some sql questions.And the second round mainly has basic questions and questions on project.