I applied online. I interviewed at Boston Consulting Group (Casablanca, Greater Casablanca) in Oct 2025
Interview
5 steps in total. All in English.
1st Step (online) : Apply on the website + online assessment : 4 questions, 2 pyspark, 1 SQL, 1 data ingestion. 90 minutes. threshold : 400/600.
2nd Step (online) : HR interview, 15 mins, Few technical questions + behavioral fit (they see if you are motivated enough)
3rd Step (online) : 1 hour technical interview with senior data engineer, 30 minutes CV walk through, technical assessment of your understanding of core data concepts, cloud ... 30 mins live coding session : SQL or CP problems (python) or Pyspark (on DataFrame).
4th & 5th step (onsite, same day): 30 minutes each with data principal and partner; CP problems + questions about core data engineering concepts and SQL or Pyspark.
Whole process took about 2 months.
Overall you need to prepare CP problems !!!, SQL and pyspark.
English Mandatory.
Interview questions [1]
Question 1
In an AWS architecture where a database instance is placed within a private subnet and protected by a security group, how can a developer securely connect to it from outside the VPC or from a different network segment?