LTIMindtree Data Analyst Interview Questions and Process 2026

Cracking the LTIMindtree Data Analyst Interview

LTIMindtree's Data & Analytics practice helps global clients turn raw data into actionable insights, particularly in their strong BFSI vertical. The interview process for a Data Analyst role tests your ability to query databases efficiently, visualize data effectively, and understand the underlying business context.

Phase 1: The SQL and Database Round (Core Technical)

This is the most critical round. If you cannot write complex SQL, you will not pass.

• Complex Queries: "Write a query to find the 2nd highest salary in each department." Expect questions on Window Functions (RANK(), DENSE_RANK(), ROW_NUMBER()), Common Table Expressions (CTEs), and Subqueries.
• Performance Optimization: "You have a query that takes 10 minutes to run. How do you optimize it?" Be prepared to discuss indexing (Clustered vs. Non-Clustered), avoiding SELECT *, and analyzing execution plans.
• Data Warehousing Concepts: You must understand the difference between an OLTP and OLAP system. Expect questions on Star Schema, Snowflake Schema, Fact tables, and Dimension tables.

Phase 2: Business Intelligence and Visualization

Data is useless if it cannot be understood by business stakeholders.

• Tool Expertise (Power BI / Tableau): If you claim Power BI expertise, expect questions on DAX (Data Analysis Expressions). "What is the difference between CALCULATE and FILTER in DAX?" For Tableau, expect questions on Level of Detail (LOD) expressions and the difference between discrete and continuous data.
• Dashboard Design: "How would you design a dashboard for a banking client to track daily loan approvals?" They are evaluating your ability to choose the right charts (e.g., line charts for trends, bar charts for comparisons) and avoid visual clutter.

Phase 3: Python and Scenario-Based Round

For mid-to-senior roles, scripting and problem-solving are tested.

• Python for Data Analysis: "How do you handle missing values in a Pandas DataFrame?" You may be asked to write a short Python script to clean a messy dataset or merge two datasets.
• The Scenario: "A client notices a sudden 15% drop in credit card applications over the weekend. Walk me through your analytical process to find the root cause." They want to see a structured approach: isolating the issue, checking for data anomalies, and analyzing external factors.

Top 3 Technical Questions to Prepare

1. Explain the difference between WHERE and HAVING clauses in SQL. Write a query that uses both.
2. What is a Star Schema? Draw a basic Star Schema for a banking transaction database.
3. Explain how you would use Python (Pandas) to identify and remove duplicate records in a massive dataset.