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
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query to find the second highest transaction amount for each client department. If there is no second highest, return null.
#SQL
#Window Functions
Machine Learning Engineer
•
Coding
•
hard
Write a SQL query to calculate the month-over-month churn rate for our SaaS product.
#SQL
#Aggregations
#Time Series
Machine Learning Engineer
•
Coding
•
medium
We have a table of client records with potential duplicates due to slight spelling variations. Write a SQL query to identify potential duplicate records based on matching email domains and similar names.
#SQL
#String Manipulation
#Self Joins
Machine Learning Engineer
•
Coding
•
easy
Write a SQL query to find all clients who have purchased 'Consulting Service A' but have never purchased 'Audit Service B'.
#SQL
#Joins
#Filtering
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.