PwC
PricewaterhouseCoopers, a multinational professional services network.
4 Rounds
~21 Days
Medium
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Data Engineer
•
Coding
•
medium
Write PySpark code to read a CSV file from Azure Data Lake, filter out records where the 'amount' column is null, and write the output back as Parquet, partitioned by 'transaction_date'.
#PySpark
#Data I/O
#Partitioning
Data Engineer
•
Technical
•
medium
Explain the difference between transformations and actions in PySpark. Why is this distinction important for performance?
#PySpark
#Lazy Evaluation
#DAG
Data Engineer
•
Technical
•
hard
You are joining a massive transaction table with a smaller client table in PySpark, and the job is failing due to OutOfMemory errors. How do you handle this data skewness?
#PySpark
#Optimization
#Broadcast Joins
#Salting
Data Engineer
•
Technical
•
medium
What is the difference between repartition() and coalesce() in Spark? When would you use each in a data pipeline?
#PySpark
#Data Shuffling
#Partitioning
Data Engineer
•
Technical
•
hard
Explain Spark's Catalyst Optimizer. How does it improve query execution plans?
#PySpark
#Catalyst Optimizer
#Under the Hood
Data Scientist
•
Coding
•
medium
Write a Python script using PySpark to read a 10TB CSV file from an S3 bucket, filter out invalid records, and aggregate total sales by region.
#PySpark
#Distributed Computing
#Data Aggregation
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.