Infosys
Global leader in next-generation digital services and consulting.
3 Rounds
~14 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
Write a SQL query to find the 3rd highest salary from an Employee table without using the LIMIT keyword.
#Window Functions
#Subqueries
#DENSE_RANK
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
Data Engineer
•
Coding
•
easy
Write a SQL query to find employees who earn more than their direct managers.
#Self Join
#Filtering
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
Data Engineer
•
Coding
•
medium
Write a SQL query to find the top 3 selling products in each category.
#Window Functions
#RANK()
#PARTITION BY
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.