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 Verified Tick

Compare button icon Compare button icon Compare
3.5

based on 3k Reviews

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
View all 6 questions

9 Publicis Sapient Senior Data Engineer Interview Experiences

19 questions found

Sort by: Popular

Senior Data Engineer Interview Questions

user image Anonymous

posted on 18 Oct 2024

Interview experience
4
 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?
  • 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.
  • Q3. Given the list of words, write the Python program to print the most repeating substring out of all words.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well in SQL, Spark and Python coding problems.

Skills evaluated in this interview

Senior Data Engineer Interview Questions

user image Anonymous

posted on 22 Dec 2024

Interview experience
4
 Good
Difficulty level
 Hard
Duration
 Less than 2 weeks
Result
Selected  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
  • Q2. Questions on pyspark
2

Behavioral Round (2 Questions)

  • Q1. Leadership base question
  • Q2. Situation base questions like what you will do if someone from your team is not performing well?

Get interview-ready with top interview questions

Senior Data Engineer Interview Questions

user image Akashdeep Jassal

posted on 26 Aug 2024

Interview experience
3
 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
  • Q2. Solve it without using spark-sql

Senior Data Engineer Interview Questions

user image Anonymous

posted on 4 Jul 2024

Interview experience
5
 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
  • Q2. Architecture of Spark

Skills evaluated in this interview

Publicis Sapient interview questions for designations

 Data Engineer

 (12)

 Data Architect

 (1)

 Senior Data Analyst

 (2)

 Senior Data Scientist

 (1)

 Senior Software Engineer

 (20)

 Senior Automation Engineer

 (5)

 Senior Devops Engineer

 (3)

 Senior Test Engineer

 (3)

Senior Data Engineer Interview Questions

user image Anonymous

posted on 20 Apr 2024

Interview experience
4
 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
2

One-on-one Round (1 Question)

  • Q1. End to end data pipeline execution, encryption, ci/ cd, version control

Senior Data Engineer Interview Questions

user image souvik chattopadhyay

posted on 24 May 2024

Interview experience
4
 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
  • Q2. Azure services experience

Skills evaluated in this interview

Senior Data Engineer Interview Questions

user image Anonymous

posted on 2 Apr 2024

Interview experience
5
 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

Senior Data Engineer Interview Questions

user image Anonymous

posted on 16 Feb 2024

Interview experience
3
 Average
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (1 Question)

  • Q1. Transformations in spark In depth questions on spark

Interview Preparation Tips

Interview preparation tips for other job seekers - Asked indepth questions about spark

Senior Data Engineer Interview Questions

user image Anonymous

posted on 1 Apr 2023

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  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
  • Q2. Project architecture

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.

Interview questions from similar companies

Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Nov 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. How do you utilize the enhanced optimization option in AWS Glue?
  • Q2. What are the best practices for optimizing querying in Amazon Redshift?

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 -

  1. What are the common file formats used in data storages? Which one is best for c...read more
  2. Given the list of words, write the Python program to print the most repeating s...read more
  3. What is Application Master in Sp...read more

Tell us how to improve this page.

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.
Publicis Sapient Senior Data Engineer Salary
based on 160 salaries
₹13 L/yr - ₹35.5 L/yr
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

3.8/5

Rating in categories

4.3

Skill development

3.9

Work-Life balance

3.7

Salary & Benefits

3.6

Job Security

3.8

Company culture

2.8

Promotions/Appraisal

3.8

Work Satisfaction

Explore 17 Reviews and Ratings
Senior Associate
2.2k salaries
unlock blur

₹10.6 L/yr - ₹37.5 L/yr

Associate Technology L2
1.5k salaries
unlock blur

₹4.8 L/yr - ₹20 L/yr

Senior Associate Technology L1
1.2k salaries
unlock blur

₹10.1 L/yr - ₹32 L/yr

Senior Software Engineer
720 salaries
unlock blur

₹9.2 L/yr - ₹36 L/yr

Senior Associate 2
598 salaries
unlock blur

₹14 L/yr - ₹41 L/yr

Explore more salaries
Compare Publicis Sapient with

Accenture

3.9
Compare

IBM

4.1
Compare

TCS

3.7
Compare

Infosys

3.7
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
write
Share an Interview