Infosys

Global leader in next-generation digital services and consulting.

3 Rounds ~14 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

All Roles Cloud Engineer 1 Data Engineer 5 Data Scientist 4 Machine Learning Engineer 2 Software Engineer 3

All Topics Algorithms 19 System Design 19 SQL 15 Big Data 12 Culture Fit 10 Machine Learning 8 Core Java 6 Deep Learning 5

Cloud Engineer • Coding • easy

Write a SQL query to find the second highest salary from an 'Employee' table. (A common Infosys baseline data question).

#SQL #Database Queries

Practice

Data Engineer • Coding • medium

Write a SQL query to find the top 3 selling products in each category.

#Window Functions #RANK() #PARTITION BY

Practice

Data Engineer • Coding • medium

Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT keyword.

#Window Functions #Subqueries #DENSE_RANK

Practice

Data Engineer • Coding • medium

Write a SQL query to delete duplicate rows from a table, keeping only the record with the lowest ID.

#CTEs #ROW_NUMBER() #Data Cleansing

Practice

Data Engineer • Coding • easy

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

#Self Join #Filtering

Practice

Data Engineer • Coding • medium

Write a SQL query to calculate the cumulative sum of sales per region, ordered by date.

#Window Functions #SUM() OVER #Aggregations

Practice

Data Scientist • Coding • medium

Write a SQL query to find the top 3 products by revenue in each region. The table contains product_id, region, and revenue.

#Window Functions #RANK() #DENSE_RANK() #Aggregation

Practice

Data Scientist • Coding • medium

Write a SQL query to calculate the month-over-month growth rate of active users from a daily activity log.

#Window Functions #CTEs #Aggregation

Practice

Data Scientist • Coding • hard

Given a table of user logins (user_id, login_date), write a SQL query to find users who logged in on 3 consecutive days.

#Self Joins #Window Functions #Date/Time Functions

Practice

Data Scientist • Technical • medium

How do you optimize a slow-running SQL query that joins multiple large tables in a client's database?

#Query Optimization #Indexing #Execution Plan

Practice

Machine Learning Engineer • Coding • medium

Write a SQL query using window functions to calculate the 7-day rolling average of transaction volumes for a banking client.

#SQL #Time Series #Window Functions

Practice

Machine Learning Engineer • Coding • medium

Write a SQL query to find the nth highest salary from an Employee table. How would you handle ties?

#SQL #Window Functions

Practice

Software Engineer • Coding • easy

What are the different types of JOINs in SQL? Write a query using a LEFT JOIN to find all customers who have not placed any orders.

#Joins #Data Retrieval

Practice

Software Engineer • Coding • medium

Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT keyword.

#SQL Queries #Subqueries #Window Functions

Practice

Software Engineer • Technical • easy

Explain the differences between TRUNCATE, DELETE, and DROP commands in SQL.

#DDL #DML

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