PwC

PwC

PricewaterhouseCoopers, a multinational professional services network.

4 Rounds ~21 Days Medium
Start Mock Interview

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

Backend Engineer • Coding • medium

Write a SQL query to find all departments that have less than 3 employees.

#SQL #Aggregation #Joins
Practice
Backend Engineer • Coding • medium

Write a SQL query to find the second highest salary from an Employee table.

#SQL #Database Queries
Practice
Data Engineer • Coding • medium

Write a SQL query to find the second highest salary in an employee table without using the LIMIT, TOP, or FETCH keywords.

#Subqueries #Aggregation #Max Function
Practice
Data Engineer • Coding • hard

Given a table of client project assignments with start and end dates, write a SQL query to identify any overlapping date ranges for the same consultant.

#Self Joins #Date Functions #Complex Logic
Practice
Data Engineer • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily sales for a retail company.

#Window Functions #Moving Average #Date Functions
Practice
Data Engineer • Coding • medium

Write a SQL query to find the top 3 highest paid employees in each department. If there is a tie, they should have the same rank.

#Window Functions #DENSE_RANK #Joins
Practice
Data Engineer • Technical • easy

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with a practical data engineering example.

#Window Functions #Analytical Functions
Practice
Data Engineer • Technical • hard

How would you approach optimizing a slow-running SQL query in a distributed data warehouse like Snowflake or Azure Synapse?

#Performance Tuning #Execution Plans #Indexing #Partitioning
Practice
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
Practice
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
Practice
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
Practice
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
Practice
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
Practice
Full Stack Engineer • Coding • easy

Write a SQL query to find the second highest salary from an Employee table.

#Queries #Aggregation
Practice
Full Stack Engineer • Technical • medium

Explain the difference between clustered and non-clustered indexes in SQL Server or PostgreSQL.

#Databases #Indexing #Performance
Practice
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
Practice
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
Practice
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
Practice
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
Practice
Product Manager • Coding • medium

Write a SQL query to find the average time spent on an audit task, grouped by the auditor's seniority level.

#Joins #Aggregation #Data Analysis
Practice
Product Manager • Coding • easy

Write a SQL query to find the top 5 enterprise clients by total revenue generated in the last fiscal year from a `client_transactions` table.

#Data Analysis #Aggregation #Sorting
Practice
Product Manager • Coding • medium

Given a dataset of user login events, write a SQL query to calculate the Daily Active Users (DAU) for the past 30 days.

#Metrics #Date Functions #Distinct Counts
Practice
Software Engineer • Coding • medium

Write a SQL query to find the Nth highest salary from an Employee table. How would you optimize it for a table with millions of rows?

#Subqueries #Performance
Practice
Software Engineer • Coding • medium

Write a SQL query to find the top 3 departments with the highest average transaction volume over the last quarter.

#Aggregations #Joins #Window Functions
Practice

Difficulty Radar

Based on recent AI-sourced data.

Meet Your Interviewers

The "Standard" Interviewer

Senior Engineer

Focuses on core competencies, system constraints, and clear communication.

Simulate

Unwritten Rules

Think Out Loud

Always explain your thought process before writing code or drawing architecture.

Practice Now