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 Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 highest-value transactions for each client in our audit database, including ties.
#Window Functions
#DENSE_RANK
#Data Aggregation
Data Scientist
•
Coding
•
medium
Given a table of employee timesheets, write a SQL query to calculate the rolling 7-day average of billable hours per consultant.
#Window Functions
#Time Series
#Moving Averages
Data Scientist
•
Coding
•
medium
Write a SQL query to find the month-over-month percentage growth in revenue for each product category.
#LAG Function
#CTEs
#Percentage Calculation
Data Scientist
•
Coding
•
hard
Write a SQL query to identify 'island' periods of continuous active subscription for users, given a table of start and end dates that may overlap.
#Gaps and Islands
#Advanced SQL
#Self Joins
Data Scientist
•
Coding
•
hard
Write a SQL query to find the median salary of employees in each department without using the built-in MEDIAN() function.
#Percentiles
#Window Functions
#Math
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.