Add office photos
Filter interviews by
PwC Data Engineer Interview Questions, Process, and Tips
Top PwC Data Engineer Interview Questions and Answers
- Q1. What is data flow? Difference with ADF pipeline and data flow
- Q2. What is the difference between reparation and coalesce? What is the difference between persist and cache?
- Q3. What is afd? build dynamic pipeline spark arcticture sql data flow
PwC Data Engineer Interview Experiences
19 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. What is the SQL query to find the third highest salary from a given table?
- Q2. What is the difference between reparation and coalesce? What is the difference between persist and cache?
Selected
I applied via LinkedIn and was interviewed in Sep 2024. There were 2 interview rounds.
(5 Questions)
- Q1. Spark architecture
- Q2. Difference between coalesce and reparation
- Ans.
Coalesce is used to return the first non-null value among its arguments, while reparation is not a standard function in SQL.
Coalesce is a standard SQL function, while reparation is not.
Coalesce returns the first non-null value among its arguments.
Reparation is not a standard SQL function and may refer to a custom function or process specific to a certain system or application.
- Q3. SQL question using Lag window function
- Q4. Same question in Pyspark
- Q5. Project and day to day activities
(2 Questions)
- Q1. Scenario based questions
- Q2. Gave details about work
Interview Preparation Tips
- Spark
- SQL
- Pyspark
- Project
- Soft Skills
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Brief Explain about SCD Type II
What people are saying about PwC
I applied via Naukri.com and was interviewed in Jul 2024. There were 4 interview rounds.
Aptitude was Okay. Time given was less.
(2 Questions)
- Q1. Project architecture
- Q2. Dataframes in Pyspark
- Ans.
Dataframes in Pyspark are distributed collections of data organized into named columns.
Dataframes are similar to tables in a relational database.
They can be created from various data sources like CSV, JSON, Parquet, etc.
Dataframes support SQL queries and transformations using PySpark functions.
(2 Questions)
- Q1. Python Question for 2nd highest salary
- Q2. Pyspark scenario based question
(2 Questions)
- Q1. Ready to travel on site
- Ans.
Yes, I am ready to travel on site for data engineering projects.
I am willing to travel for client meetings, project kick-offs, and on-site troubleshooting.
I understand the importance of face-to-face interactions in project delivery.
I have previous experience traveling for work, such as attending conferences or training sessions.
I am flexible with my schedule and can accommodate last-minute travel if needed.
- Q2. Salary negotiation
Skills evaluated in this interview
PwC interview questions for designations
(2 Questions)
- Q1. Sql question of rank sumover and partion by kinda question
- Q2. Roles n responsibility
Get interview-ready with Top PwC Interview Questions
I applied via AmbitionBox and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Write code to print reverse of string.
- Ans.
Code to print reverse of string
Use a loop to iterate through the characters of the string in reverse order
Append each character to a new string to build the reversed string
Return the reversed string
Data Engineer Jobs at PwC
Sourav Raj
Selected
I applied via Referral and was interviewed before Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Sql questions using row_num and rank
- Q2. How to delete duplicate from a database
- Ans.
To delete duplicates from a database, you can use SQL queries to identify and remove duplicate records.
Use the DISTINCT keyword in a SELECT query to retrieve unique records
Identify duplicate records using GROUP BY and HAVING clauses
Delete duplicate records using DELETE statement with subquery to keep only one instance
(2 Questions)
- Q1. Why do I want to join PWC
- Q2. What are qualities I bring to my job
Skills evaluated in this interview
I applied via Job Portal
(1 Question)
- Q1. Pyspark related questions.
(2 Questions)
- Q1. Repartition vs coalease
- Ans.
Repartition is used to increase or decrease the number of partitions in a DataFrame, while coalesce is used to decrease the number of partitions without shuffling data.
Repartition involves shuffling data across the network, which can be expensive in terms of performance and resources.
Coalesce is a more efficient operation as it minimizes data movement by only creating new partitions if necessary.
Example: Repartition(10...
- Q2. Copy Activity in ADF
- Ans.
Copy Activity in ADF is used to move data between supported data stores
Copy Activity is a built-in activity in Azure Data Factory (ADF)
It can be used to move data between supported data stores such as Azure Blob Storage, SQL Database, etc.
It supports various data movement methods like copy, transform, and load (ETL)
You can define source and sink datasets, mapping, and settings in Copy Activity
Example: Copying data from...
Skills evaluated in this interview
I applied via Recruitment Consulltant
(1 Question)
- Q1. Technical questions, related to pySpark and Sql, moderate level.
I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.
(1 Question)
- Q1. SQL ,Python,pyspark,ETL
PwC Interview FAQs
Some of the top questions asked at the PwC Data Engineer interview -
The duration of PwC Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
PwC Interviews By Designations
- PwC Associate Interview Questions
- PwC Senior Associate Interview Questions
- PwC Consultant Interview Questions
- PwC Associate2 Interview Questions
- PwC Associate Consultant Interview Questions
- PwC Manager Interview Questions
- PwC Senior Consultant Interview Questions
- PwC Technology Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior 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
PwC Data Engineer Interview Process
based on 14 interviews in last 1 year
1 Interview rounds
- Technical Round
People are getting interviews through
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
PwC Data Engineer Reviews and Ratings
based on 18 reviews
Rating in categories
Bangalore / Bengaluru
1-3 Yrs
₹ 5-20 LPA
Bangalore / Bengaluru
1-5 Yrs
₹ 6-23.2583 LPA
|
Senior Associate
14.7k
salaries
|  ₹8 L/yr - ₹30 L/yr |
|
Associate
12.7k
salaries
| ₹4.7 L/yr - ₹16 L/yr |
|
Manager
6.6k
salaries
| ₹13.5 L/yr - ₹50 L/yr |
|
Senior Consultant
4.4k
salaries
| ₹9 L/yr - ₹32 L/yr |
|
Associate2
4.1k
salaries
| ₹4.5 L/yr - ₹16.6 L/yr |
Deloitte
Ernst & Young
Accenture
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- PwC Interview Questions >
- PwC Data Engineer Interview Questions
