Accenture
Global professional services company with leading capabilities in digital, cloud and security.
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
Explain the difference between ROW_NUMBER(), RANK(), and DENSE_RANK() in SQL. Can you write a query to find the 3rd highest salary in each department using one of these?
#Window Functions
#Data Aggregation
#SQL Queries
Data Engineer
•
Coding
•
easy
Write a SQL query to find all employees who earn more than their direct managers.
#Self Joins
#SQL Queries
Data Engineer
•
Coding
•
medium
Write a SQL query to calculate the rolling 7-day average of sales for each product.
#Window Functions
#Time Series
#SQL Queries
Data Engineer
•
Coding
•
medium
Write a SQL query to delete duplicate rows from a table without using a temporary table, keeping only the row with the lowest ID.
#Data Cleansing
#SQL Queries
Data Engineer
•
Coding
•
medium
Write a SQL query to pivot rows into columns. For example, turning a table of 'Employee, Month, Salary' into 'Employee, Jan_Salary, Feb_Salary, etc.'
#Data Transformation
#SQL Queries
#Pivot
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.