Upload Button Icon Add office photos

Publicis

Compare button icon Compare button icon Compare

Filter interviews by

Publicis Data Engineer Interview Questions, Process, and Tips

Updated 17 Jun 2024

Top Publicis Data Engineer Interview Questions and Answers

Publicis Data Engineer Interview Experiences

2 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 17 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL and tableau
Round 2 - Coding Test 

Online test on sql join sub query

Round 3 - One-on-one 

(1 Question)

  • Q1. Final tech round

Interview Preparation Tips

Interview preparation tips for other job seekers - Good over all
Round 1 - Technical 

(5 Questions)

  • Q1. Spark Context vs Spark Session
  • Ans. 

    Spark Context is the entry point to any Spark functionality while Spark Session is a unified entry point for Spark 2.0+.

    • Spark Context is the old entry point to Spark functionality.

    • Spark Session is a unified entry point for Spark 2.0+.

    • Spark Context is used to create RDDs, accumulators and broadcast variables.

    • Spark Session is used to create DataFrames, execute SQL queries and read data from external sources.

  • Answered by AI
  • Q2. Repartitioning vs Coalesce
  • Ans. 

    Repartitioning increases partitions while Coalesce reduces partitions.

    • Repartitioning shuffles data across the cluster and can be used to increase parallelism.

    • Coalesce merges partitions without shuffling data and can be used to reduce overhead.

    • Repartitioning is expensive and should be used sparingly.

    • Coalesce is faster but may not be as effective as repartitioning in increasing parallelism.

    • Both can be used to optimize da

  • Answered by AI
  • Q3. Sql query to find Second Highest Salary
  • Ans. 

    Sql query to find Second Highest Salary

    • Use ORDER BY and LIMIT to select the second highest salary

    • Use subquery to select the maximum salary and exclude it from the result set

    • Handle cases where there are ties for the highest salary

  • Answered by AI
  • Q4. Internal Working of Spark
  • Ans. 

    Spark is a distributed computing engine that processes large datasets in parallel across a cluster of computers.

    • Spark uses a master-slave architecture with a driver program that coordinates tasks across worker nodes.

    • Data is stored in Resilient Distributed Datasets (RDDs) that can be cached in memory for faster processing.

    • Spark supports multiple programming languages including Java, Scala, and Python.

    • Spark can be used f...

  • Answered by AI
  • Q5. What is Braodcast Join
  • Ans. 

    Broadcast Join is a technique used in distributed computing to optimize join operations.

    • Broadcast Join is used when one table is small enough to fit in memory of all nodes in a cluster.

    • The smaller table is broadcasted to all nodes in the cluster, reducing network traffic.

    • Broadcast Join is faster than other join techniques when used appropriately.

    • Example: Joining a small reference table with a large fact table in a data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Prepaired with Big data concepts

Skills evaluated in this interview

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, python, pyspark
Round 2 - Technical 

(2 Questions)

  • Q1. SQL, PYSPARK, PYTHON
  • Q2. Sql, python, pyspark
Round 3 - Technical 

(1 Question)

  • Q1. Sql, python, pyspark
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion, NP
Round 1 - One-on-one 

(1 Question)

  • Q1. Design level questions. Hive questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Have knowledge on cloud and hive. Design level and debugging skills.

Interview Questionnaire 

1 Question

  • Q1. SQL queries, basic questions on python programming, statistical concepts and basic questions on machine learning algorithms.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - Case Study 

They gave me case study in interview based on that I had provide the solution.

Round 3 - Technical 

(1 Question)

  • Q1. They asked question regarding SQL, statistics and some project related questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

It consited of apti as well as coding questions

Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of coding were asked like arrays,strings
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
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
Round 2 - Technical 

(2 Questions)

  • Q1. C# oops polymorphism extension methods
  • Ans. 

    Polymorphism is a key feature of OOP in C#. Extension methods allow adding new functionality to existing types.

    • Polymorphism allows objects of different classes to be treated as if they are of the same type.

    • Extension methods are static methods that can be called as if they were instance methods of the extended type.

    • Polymorphism and extension methods can be used together to add new behavior to existing types without modi

  • Answered by AI
  • Q2. Angular javascript vs typescript services components
  • Ans. 

    Angular is a framework for building web applications using TypeScript, which is a superset of JavaScript.

    • Angular provides a structure for building web applications using components, services, and modules.

    • TypeScript is a statically typed language that provides better tooling and error checking than JavaScript.

    • Services in Angular are used for sharing data and functionality across components.

    • Components in Angular are the ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - practical questions. easy interview. learn c# oops, ref, out, extension methods,

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. They are asking technical questions what is their in the resume
Round 2 - Technical 

(1 Question)

  • Q1. They will technical questions as per your resume what you mentioned

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident when you say the answers in the interviewer
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.

    • 5 years of experience in software development

    • Proficient in Java, Spring Boot, and Angular

    • Strong problem-solving skills

  • Answered by AI
  • Q2. DS/Ago problem - dynamic programming

Interview Preparation Tips

Interview preparation tips for other job seekers - nothing

Publicis Interview FAQs

How many rounds are there in Publicis Data Engineer interview?
Publicis interview process usually has 2 rounds. The most common rounds in the Publicis interview process are Technical, Coding Test and One-on-one Round.
How to prepare for Publicis 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. The most common topics and skills that interviewers at Publicis expect are SQL, Data Architecture, Agile, Consulting and Informatica.
What are the top questions asked in Publicis Data Engineer interview?

Some of the top questions asked at the Publicis Data Engineer interview -

  1. Sql query to find Second Highest Sal...read more
  2. What is Braodcast J...read more
  3. Spark Context vs Spark Sess...read more

Tell us how to improve this page.

Publicis Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Accenture Interview Questions
3.8
 • 8.2k Interviews
R.R. Donnelley Interview Questions
3.9
 • 101 Interviews
Regalix Interview Questions
2.9
 • 45 Interviews
Xdbs Interview Questions
3.2
 • 39 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
Smollan Group Interview Questions
4.1
 • 34 Interviews
Mediamint Interview Questions
3.4
 • 32 Interviews
Merkle Sokrati Interview Questions
3.8
 • 31 Interviews
View all
Publicis Data Engineer Salary
based on 7 salaries
₹7 L/yr - ₹14 L/yr
15% less than the average Data Engineer Salary in India
View more details

Publicis Data Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Associate Manager
238 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Business Manager
149 salaries
unlock blur

₹6.8 L/yr - ₹18 L/yr

Senior Associate
137 salaries
unlock blur

₹7.8 L/yr - ₹26 L/yr

Analyst
117 salaries
unlock blur

₹3 L/yr - ₹8.2 L/yr

Associate
110 salaries
unlock blur

₹3.2 L/yr - ₹12.3 L/yr

Explore more salaries
Compare Publicis with

R.R. Donnelley

3.9
Compare

Epsilon

4.0
Compare

Smollan Group

4.1
Compare

ChannelPlay

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview