I applied through a recruiter. The process took 4 weeks. I interviewed at Publicis Sapient (Mumbai) in Oct 2023
Interview
1st interview was a coding assignment with intermediate difficulty.
2nd was an online technical discussion which was to the point with specific data engineering related questions mainly based on SQL and Pyspark.
Interview questions [1]
Question 1
Based on pyspark dataframe manipulations (withColumn, conditions, explode, etc)
Be interactive.
The interview was 2 rounds followed by manager round. The first was a coding test where I need to write a code virtually. But they will be monitoring us. And the second was technical + basic coding for 2 hrs and manager round taken in person
I applied online. I interviewed at Publicis Sapient (Bengaluru) in Oct 2024
Interview
technical round 1 (virtual)
asked about Spark, Scala, AWS and MySQL query and coding from Scala. Asked about Project and detail explanation about spark architecture and spark submit. Given 2 coding realated scenario and asked to write in spark with scala.
Interview questions [1]
Question 1
How you are going to deploy spark scala application in AWS EMR cluster?
I applied online. I interviewed at Publicis Sapient (Gurgaon, Haryana)
Interview
Multiple rounds -3
Coding round
Technical managerial
Hadoop, aws, sql, python, Data warehouse, data lake, s3, Glue etl, athena, data governence, data domains, snowflake, star schema snowflake schema, pyspark, hive, HA cluster