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
Product Manager
•
Coding
•
hard
Write a SQL query to identify users who have logged in every day for the past consecutive 7 days.
#Advanced SQL
#Gaps and Islands
#User Activity
Product Manager
•
Coding
•
easy
Write a SQL query to find the top 3 most used features in our product over the last 30 days based on an event_logs table.
#Data Extraction
#Aggregation
Product Manager
•
Coding
•
hard
Write a SQL query to calculate the month-over-month retention rate of users on a platform.
#Cohort Analysis
#Advanced SQL
#Retention
Product Manager
•
Coding
•
medium
Given a table of user sessions (user_id, login_time, logout_time), write a SQL query to find the average session duration per user.
#Date Functions
#Aggregation
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.