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 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
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
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
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
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.