I applied online. The process took 4 weeks. I interviewed at Capgemini
Interview
- Face to Face interviews scheduled by capgemini.
- Approx 10 panel was there for different technology SQL, Spark, ADF, Databricks, Scala, Snowflake, etc
- Approx 250 + candidate attend interviews in whole day.
Interview questions [1]
Question 1
How to connect Databricks to the ADLS?
What is mount points, how to setup?
What is the unity Catalog?
What is the SQL windows functions?
How to use utilities in the Databricks Notebook?
The interview process was fairly standard, though not particularly memorable. The initial communication was prompt, but there were moments where the scheduling and expectations weren’t very clear. The interviewer seemed knowledgeable, but the conversation felt a bit rigid and lacked a natural flow.
Some of the questions were relevant and gave a decent insight into the role, while others felt a bit generic or disconnected from the job description. I appreciated the chance to ask questions at the end, though the responses were somewhat vague and didn’t fully clarify the company’s direction or team dynamics.
Overall, it wasn’t a bad experience, but it didn’t leave a strong impression either.
Interview questions [1]
Question 1
One of the main things they asked me was about how to register a DataFrame as a temporary SQL view using createOrReplaceTempView, and then how to run SQL queries on top of that. It was pretty straightforward, but they wanted to see if I understood how to combine PySpark with SQL for more flexible querying.
Not clear the interview process and they don’t know what they need.
So I expected that the work with them will not clear so I declined the offer, so any one should ask about the team where you will work with