Accenture

Accenture

Global professional services company with leading capabilities in digital, cloud and security.

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 rank employees within their respective departments based on their salaries.

#Database #Window Functions
Practice
Backend Engineer • Coding • easy

Write a SQL query to find the second highest salary from an Employee table. If there is no second highest salary, return null.

#Database #Queries #Aggregation
Practice
Data Engineer • Coding • easy

Write a SQL query to find all employees who earn more than their direct managers.

#Self Joins #SQL Queries
Practice
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
Practice
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
Practice
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
Practice
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
Practice
Data Scientist • Coding • medium

Write a SQL query to calculate the 7-day rolling average of daily transaction volumes for a specific client account.

#Window Functions #Time Series #Data Aggregation
Practice
Data Scientist • Coding • medium

Write a SQL query using window functions to find the top 3 highest-paid employees in each department of a client's organization.

#Window Functions #DENSE_RANK #Joins
Practice
Data Scientist • Coding • medium

Write a SQL query to identify customers who have made a purchase in every single month of the year 2023.

#Aggregation #Date Functions #HAVING Clause
Practice
Machine Learning Engineer • Coding • easy

Write a SQL query to find all clients who have purchased product A but never purchased product B. Assume a 'clients' table and an 'orders' table.

#Joins #Subqueries #Filtering
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query using window functions to rank the top 3 highest-spending customers per region from a 'sales' table.

#Window Functions #Ranking #Aggregations
Practice
Product Manager • Coding • easy

Write a SQL query to find the top 3 clients by revenue in the last quarter from a 'transactions' and 'clients' table.

#Joins #Aggregation #Date Functions
Practice
Product Manager • Coding • medium

Write a SQL query to calculate the month-over-month retention rate of users on a newly launched SaaS platform.

#Self Joins #Cohort Analysis #Advanced SQL
Practice
Software Engineer • Coding • medium

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

#SQL #Aggregation #Subqueries
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