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

All Roles Backend Engineer 6 Data Engineer 7 Data Scientist 4 Full Stack Engineer 3 Machine Learning Engineer 1 Product Manager 4

All Topics Big Data 10 SQL 7 System Design 4 Python 4 Data Modeling 3 Data Warehousing 2 Cloud Data Engineering 2

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

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