Premium Employer
i
This company page is being actively managed by
Publicis Sapient Team. If you also belong to the team, you
can get access from
here
Publicis Sapient
Compare
Filter interviews by
Publicis Sapient Senior Data Engineer Interview Questions, Process, and Tips
Updated
22 Dec 2024
Top Publicis Sapient Senior Data Engineer Interview Questions and Answers
- Q1. What are the common file formats used in data storages? Which one is best for compression?
- Q2. Given the list of words, write the Python program to print the most repeating substring out of all words.
- Q3. What is Application Master in Spark
9 Publicis Sapient Senior Data Engineer Interview Experiences
19 questions found
Sort by:
Popular
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Sep 2024.
2 Interview Rounds
1
Coding Test Round
Platform - Hackerank
Duration - 2 Hours
Topics - Spark and SQL
2
Technical Round (3 Questions)
- Q1. What are the common file formats used in data storages? Which one is best for compression? View Answers (1)
- Q2. SQL Problem - Given the empoyee attendance table, write a query to print the employees who is abscent for more than cosecutive 10 days in their tenure. Add Answer
- Q3. Given the list of words, write the Python program to print the most repeating substring out of all words. View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare well in SQL, Spark and Python coding problems.
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Hard
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Jun 2024.
2 Interview Rounds
1
One-on-one Round (2 Questions)
- Q1. Past projects in detail Add Answer
- Q2. Questions on pyspark Add Answer
2
Behavioral Round (2 Questions)
- Q1. Leadership base question Add Answer
- Q2. Situation base questions like what you will do if someone from your team is not performing well? Add Answer
Get interview-ready with top interview questions
Akashdeep Jassal
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
One question on pysaprk
2
One-on-one Round (2 Questions)
- Q1. Solve the query for the dataset Add Answer
- Q2. Solve it without using spark-sql Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via LinkedIn and was interviewed in Jun 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What is Application Master in Spark View Answers (1)
- Q2. Architecture of Spark View Answers (1)
Skills evaluated in this interview
Publicis Sapient interview questions for designations
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. Gcp services, data governance, data quality, data modeling, warehousing etc Add Answer
2
One-on-one Round (1 Question)
- Q1. End to end data pipeline execution, encryption, ci/ cd, version control Add Answer
souvik chattopadhyay
Interview experience
Good
Difficulty level
-
Duration
-
Result
Not Selected
I was interviewed in Apr 2024.
2 Interview Rounds
1
Coding Test Round
Coding test on Pyspark and SQL
2
One-on-one Round (2 Questions)
- Q1. Optimization on spark View Answers (1)
- Q2. Azure services experience View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Coding Test Round
Hackerearth Coding round
2
Technical Round (1 Question)
- Q1. Spark, big data around question Add Answer
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. Transformations in spark
In depth questions on spark Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Asked indepth questions about spark
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via LinkedIn and was interviewed before Apr 2022.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Coding Test Round
It consisted of 3 questions for spark programming
3
Technical Round (2 Questions)
- Q1. Spark optimization texhnique Add Answer
- Q2. Project architecture Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Thoroughly go through spark and python complete. Python,SQL,spark,snowflake and any ofthe cloud you should know.
What people are saying about Publicis Sapient
View All
happyshrike
works at
Bitwise Solutions
Need advice
I want to know about the company Capco.
Current domain: Data Engg
YOE: 4.7
CCTC: 16.4
Offer: 23(fixed)+1 JB
Post: Sr Consultant 2 grade M2.
I want to know about the company culture,WLB,job security,bench policy.Also,I am a bit confused.The role offered is for a consultant,but the questions were more oriented toward arch. There were no questions on PySpark.The manager said the work is on ETL migration for Barclays using AWS Glue and Spark,but no related questions.Should I take the offer or continue rounds with EPAM,UST,EY?
There are other offers.
Yash Tech:22LAP(fixed)
Publicis Sapient: 25(fixed)
Quantiphi: 25(quoted from my side,no offer yet)
But the thing is that here the work is unclear. Also there are other company rounds going like EPAM,UST.
Got a question about Publicis Sapient?
Ask anonymously on communities.
Interview questions from similar companies
Swati Gawali
Interview experience
Excellent
Difficulty level
Hard
Duration
2-4 weeks
Result
-
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
One-on-one Round (2 Questions)
- Q1. What is scd type 2? View Answers (1)
- Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location. Add Answer
Skills evaluated in this interview
Publicis Sapient Interview FAQs
How many rounds are there in Publicis Sapient Senior Data Engineer interview?
Publicis Sapient interview process usually has 1-2 rounds. The most common rounds in the Publicis Sapient interview process are Coding Test, Technical and One-on-one Round.
How to prepare for Publicis Sapient Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Publicis Sapient. The most common topics and skills that interviewers at Publicis Sapient expect are Big Data, Hadoop, Data Integration, Python and SCALA.
What are the top questions asked in Publicis Sapient Senior Data Engineer interview?
Some of the top questions asked at the Publicis Sapient Senior Data Engineer interview -
Tell us how to improve this page.
Publicis Sapient Interviews By Designations
- Publicis Sapient Senior Associate Interview Questions
- Publicis Sapient Associate Technology L2 Interview Questions
- Publicis Sapient Senior Software Engineer Interview Questions
- Publicis Sapient Senior Associate Technology L1 Interview Questions
- Publicis Sapient Software Developer Interview Questions
- Publicis Sapient Software Engineer Interview Questions
- Publicis Sapient Data Engineer Interview Questions
- Publicis Sapient Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Interview Process at Publicis Sapient Senior Data Engineer
based on 8 interviews in last 1 year
2 Interview rounds
- Coding Test Round
- One-on-one Round
View more
People are getting interviews through
based on 4 Publicis Sapient interviews
Job Portal
Company Website
75%
25%
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join Publicis Sapient Let's imagine the future together.
Senior Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
37%
more
than the average Senior Data Engineer Salary in India
View more details
Publicis Sapient Senior Data Engineer Reviews and Ratings
based on 17 reviews
Rating in categories
|
Senior Associate
2.2k
salaries
|  ₹10.6 L/yr - ₹37.5 L/yr |
|
Associate Technology L2
1.5k
salaries
| ₹4.8 L/yr - ₹20 L/yr |
|
Senior Associate Technology L1
1.2k
salaries
| ₹10.1 L/yr - ₹32 L/yr |
|
Senior Software Engineer
720
salaries
| ₹9.2 L/yr - ₹36 L/yr |
|
Senior Associate 2
598
salaries
| ₹14 L/yr - ₹41 L/yr |
Explore more salaries
Compare Publicis Sapient with
Accenture
Compare
IBM
Compare
TCS
Compare
Infosys
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Publicis Sapient Interview Questions >
- Publicis Sapient Senior Data Engineer Interview Questions
Share an Interview