Publicis Sapient Software Engineer interview experience

No offer

Easy

Positive

IndiaPosted Aug 2025 · Candidate report, summarized by Dataford

My interview preparation covered a very specific set of topics, spanning both PySpark basics and SQL.

On the PySpark side, I focused on core concepts like RDDs and DataFrames, the difference between transformations and actions, and common functions such as map, flatMap, filter, groupBy, join, withColumn, select, and agg.

The Spark architecture topics were a big part too—driver and executors, the cluster manager—and optimization ideas like the Catalyst optimizer, DAG execution, RDD lineage, and broadcast joins. I also worked through partitioning, including why partitions matter and the trade-offs of repartition versus coalesce.

For SQL, I drilled join types like inner, left, right, full, and

Create a free Dataford account to unlock the full round-by-round breakdown, the questions asked and the outcome.

Read the full report Read the full report

Preparing for this interview?

Publicis Sapient Software Engineer interview guideThe full process, round by round, with the question bank Practice Software Engineer interview questionsReal questions from this role across companies All Publicis Sapient interview guidesEvery role we cover at this company