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

I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

In this round we have aptitude plus coding mcq questions

Round 2 - Coding Test 

Here we have to write full fledge code 2 questions were there and are easy

Round 3 - HR 

(1 Question)

  • Q1. Here we have hr plus technical interview

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep working hard and the placement round is easy overall

I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Describe your projects?
  • Q2. What are the technologies you have worked on?
  • Ans. 

    I have worked on various technologies including Hadoop, Spark, SQL, Python, and AWS.

    • Experience with Hadoop and Spark for big data processing

    • Proficient in SQL for data querying and manipulation

    • Skilled in Python for data analysis and scripting

    • Familiarity with AWS services such as S3, EC2, and EMR

    • Knowledge of data warehousing and ETL processes

  • Answered by AI
  • Q3. Behavioral Questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and prepare your resume well.

I applied via Referral and was interviewed before Jun 2021. There were 2 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 - Technical 

(3 Questions)

  • Q1. SQL based scenario mostly windows functions
  • Q2. Basic data warehouse concepts
  • Q3. Basic ETL and data modelling issues

Interview Preparation Tips

Topics to prepare for Accenture Data Engineer interview:
  • ETL
  • SQL
  • Data Warehousing
  • Data Modeling
  • Python
Interview preparation tips for other job seekers - Mostly they asked about SQL, mostly windows functions.
I have work experience on talend ETL they asked basic concepts of ETL, Data warehouse and data modelling.
Basic questions about
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Round 2 - HR 

(1 Question)

  • Q1. How much package are you expecting
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Remove duplicate characters from string
  • Ans. 

    Remove duplicate characters from a string

    • Iterate through the string and keep track of characters seen

    • Use a set to store unique characters and remove duplicates

    • Reconstruct the string without duplicates

  • Answered by AI
  • Q2. Write a sql query to get second highest salary from table
  • Ans. 

    SQL query to retrieve second highest salary from a table

    • Use the ORDER BY clause to sort salaries in descending order

    • Use the LIMIT clause to retrieve the second row

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, happy and answer with confidence

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What does select count(0) mean?
  • Ans. 

    Select count(0) returns the count of rows in a table, regardless of the values in the specified column.

    • Select count(0) counts all rows in a table, ignoring the values in the specified column.

    • It is equivalent to select count(*) or select count(1).

    • Example: SELECT COUNT(0) FROM table_name;

  • Answered by AI
  • Q2. What is sharding?
  • Ans. 

    Sharding is a database partitioning technique where large databases are divided into smaller, more manageable parts called shards.

    • Sharding helps distribute data across multiple servers to improve performance and scalability.

    • Each shard contains a subset of the data, allowing for parallel processing and faster query execution.

    • Common sharding strategies include range-based sharding, hash-based sharding, and list-based sha...

  • Answered by AI
  • Q3. What are slots in Bigquery?
  • Ans. 

    Slots in Bigquery are virtual partitions that allow users to control the amount of data processed by a query.

    • Slots help in managing query resources and controlling costs

    • Users can purchase additional slots to increase query capacity

    • Slots are used to allocate processing power for queries based on the amount purchased

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was Intermediate level for Google cloud

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Serverless computing in databricks
  • Ans. 

    Serverless computing in Databricks allows users to run code without managing servers, scaling automatically based on workload.

    • Serverless computing in Databricks enables users to focus on writing code without worrying about server management.

    • It automatically scales resources based on workload, reducing costs and improving efficiency.

    • Users can run code in Databricks without provisioning or managing servers, making it eas...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Azure tech stack used in the current project
  • Ans. 

    Azure tech stack used in the current project includes Azure Data Factory, Azure Databricks, and Azure SQL Database.

    • Azure Data Factory for data integration and orchestration

    • Azure Databricks for big data processing and analytics

    • Azure SQL Database for storing and querying structured data

  • Answered by AI
  • Q2. Spark architecture

Skills evaluated in this interview

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.1k Interviews
R.R. Donnelley Interview Questions
3.9
 • 100 Interviews
Regalix Interview Questions
2.9
 • 44 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
13% 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
235 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Manager
153 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
137 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
118 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
110 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Publicis with

WPP

3.0
Compare

Interpublic Group

3.5
Compare

Accenture

3.8
Compare

M&C Saatchi Performance

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