EY
Ernst & Young Global Limited, a multinational professional services partnership.
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
Backend Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary from an Employee table.
#SQL
#Subqueries
#Aggregation
Backend Engineer
•
Coding
•
medium
Write a SQL query using window functions to calculate a running total of transaction amounts per client, ordered by transaction date.
#SQL
#Window Functions
#Data Analysis
Data Engineer
•
Coding
•
medium
Write a SQL query using window functions to calculate the 7-day rolling average of daily transaction volumes for our financial audit clients.
#Window Functions
#Data Aggregation
#Time Series
Data Engineer
•
Coding
•
medium
Write a SQL query to find the second highest salary in each department. If a department has less than two employees, return null for that department.
#Window Functions
#CTEs
#Aggregations
Data Engineer
•
Coding
•
medium
Write a SQL query to identify and delete duplicate records in a massive transaction table without using the DISTINCT keyword.
#Data Cleansing
#CTEs
#Window Functions
Data Engineer
•
Coding
•
hard
Given a table of user logins, write a SQL query to find the maximum number of consecutive days each user logged in.
#Advanced SQL
#Gaps and Islands Problem
#CTEs
Data Engineer
•
Technical
•
easy
Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER(). Provide a scenario in a client reporting dashboard where you would choose DENSE_RANK() over RANK().
#Window Functions
#Data Ranking
Data Scientist
•
Coding
•
medium
Write a SQL query using window functions to find the top 3 clients by revenue in each of EY's global service lines (Assurance, Consulting, Tax, Strategy and Transactions) for the last fiscal year.
#SQL
#Window Functions
#Data Aggregation
Data Scientist
•
Coding
•
medium
Write a SQL query to calculate the month-over-month percentage growth in billable hours for each consultant.
#SQL
#Window Functions
#Time Series Data
Data Scientist
•
Coding
•
medium
You have a table of employee project assignments with start and end dates. Write a SQL query to find any overlapping project assignments for the same employee.
#SQL
#Self Joins
#Date Functions
Data Scientist
•
Coding
•
easy
Write a SQL query to find the 3rd highest salary from an Employee table. If there is no 3rd highest salary, return null.
#SQL
#Subqueries
#LIMIT/OFFSET
Full Stack Engineer
•
Coding
•
medium
Write a SQL query using window functions to calculate a running total of expenses per department, ordered by the date of the expense.
#Databases
#Window Functions
Full Stack Engineer
•
Coding
•
medium
Write a SQL query to find the second highest transaction amount from a 'Transactions' table. If there is no second highest amount, return null.
#Databases
#Queries
Machine Learning Engineer
•
Coding
•
medium
Write a SQL query using window functions to calculate the 7-day rolling average of daily transaction volumes for our banking clients.
#Window Functions
#Data Aggregation
Software Engineer
•
Technical
•
medium
Write a SQL query to find the second highest salary of an employee from an Employee table. How would you scale this to find the Nth highest?
#SQL
#Window Functions
Software Engineer
•
Technical
•
medium
What is the difference between clustered and non-clustered indexes in SQL? How would you optimize a slow-running query on a table with 10 million transaction records?
#Databases
#SQL
#Performance Tuning
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.