LTIMindtree

LTIMindtree

Global technology consulting and digital solutions company.

4 Rounds ~21 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

Backend Engineer • Coding • medium

Write an SQL query to find employees who earn more than their managers. Assume an Employee table with Id, Name, Salary, and ManagerId.

#SQL #Self Join
Practice
Backend Engineer • Technical • easy

Write a SQL query to find the second highest salary from an Employee table without using the LIMIT or TOP keywords.

#SQL Queries #Aggregations
Practice
Backend Engineer • Technical • medium

What are ACID properties, and how does a relational database ensure the Isolation property?

#Database Theory #Transactions
Practice
Backend Engineer • Technical • hard

How do you optimize a slow-running SQL query in a production environment?

#Performance Tuning #Query Optimization
Practice
Backend Engineer • Technical • easy

Explain the different types of JOINs in SQL. What is the difference between a LEFT JOIN and an INNER JOIN?

#SQL #Joins
Practice
Backend Engineer • Technical • medium

Explain the difference between clustered and non-clustered indexes in a relational database.

#Database Indexing #Performance
Practice
Data Engineer • Coding • hard

Write a SQL query to calculate the cumulative sum of revenue by month, but reset the sum at the start of each financial year (April).

#Window Functions #Cumulative Sum #PARTITION BY
Practice
Data Engineer • Coding • hard

Write a SQL query to find consecutive days where daily sales exceeded $10,000 (Gaps and Islands problem).

#Advanced SQL #Window Functions #Gaps and Islands
Practice
Data Engineer • Coding • easy

Given a table of employee logins, write a query to find the first and last login time for each employee per day.

#Aggregation #GROUP BY #Date Functions
Practice
Data Engineer • Coding • hard

Write a SQL query to find the top 3 selling products in each category, along with their percentage contribution to the category's total sales.

#Window Functions #CTEs #Math Operations
Practice
Data Engineer • Coding • medium

Write a SQL query to find the second highest salary per department without using the LIMIT keyword.

#Window Functions #DENSE_RANK #Subqueries
Practice
Data Engineer • Technical • medium

Write a SQL query to find the 3rd highest salary in each department using window functions. What happens if there are ties?

#Window Functions #DENSE_RANK() #CTEs
Practice
Data Engineer • Technical • medium

Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() with an example.

#Window Functions #Ranking
Practice
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
Practice
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
Practice
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
Practice
Data Scientist • Coding • medium

Calculate the cumulative sum of revenue partitioned by geographic region and ordered by transaction date.

#SQL #Window Functions #Aggregations
Practice
Full Stack Engineer • Coding • easy

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

#Databases #SQL Joins
Practice
Full Stack Engineer • Coding • medium

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

#Databases #SQL Queries
Practice
Full Stack Engineer • Technical • medium

What are ACID properties in a database? Explain Isolation levels and how they prevent dirty reads.

#Databases #Transactions #ACID
Practice
Machine Learning Engineer • Coding • medium

Write a SQL query using window functions to find the top 3 highest-spending customers in each region from a 'transactions' table.

#SQL #Window Functions #Data Aggregation
Practice
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
Practice
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
Practice
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
Practice
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
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