LTIMindtree
Global technology consulting and digital solutions company.
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 Scientist
•
Coding
•
medium
Write a SQL query to find all customers who purchased a product in three consecutive months.
#SQL
#Window Functions
#Date Functions
Data Scientist
•
Coding
•
medium
Calculate the cumulative sum of revenue partitioned by geographic region and ordered by transaction date.
#SQL
#Window Functions
#Aggregations
Data Scientist
•
Coding
•
hard
Identify duplicate records in a massive transaction table and write a query to delete them, keeping only the row with the lowest ID, without using a temporary table.
#SQL
#Data Cleaning
#CTEs
Data Scientist
•
Coding
•
medium
Write a SQL query to find the top 3 highest-grossing products per category. Assume a 'sales' table and a 'products' table.
#SQL
#Window Functions
#Joins
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.