LTIMindtree Data Analyst Interview Questions (2026)

The LTIMindtree interview process usually runs in this order: online assessment, technical interview, then managerial and HR round.

1. Q1

   For LTIMindtree's telecom client's churn reporting, when would an INNER JOIN silently drop rows a LEFT JOIN would keep? Show the row counts you would check.

   MediumSQL roundjoinsLTIMindtree-specific

   Context:

   LTIMindtree telecom client's churn reporting

   How to answer:

   Explain join semantics with unmatched keys, and the count-before/count-after habit. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

2. Q2

   Your monthly GROUP BY summary for LTIMindtree's insurance client's claims data mart does not match the source system's total. How do you reconcile them?

   HardSQL roundaggregation and reconciliationLTIMindtree-specific

   Context:

   LTIMindtree insurance client's claims data mart

   How to answer:

   Compare grain, filters, timezone/date boundaries, late-arriving rows, and duplicates. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

3. Q3

   Which results change when key columns in LTIMindtree's e-commerce client's returns analysis contain NULLs — filters, joins, COUNT vs COUNT(col), averages?

   MediumSQL roundNULL handlingLTIMindtree-specific

   Context:

   LTIMindtree e-commerce client's returns analysis

   How to answer:

   Walk NULL semantics through WHERE, JOIN keys, aggregates, and COALESCE defaults. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

4. Q4

   After adding a join, revenue in LTIMindtree's healthcare client's appointment no-show reporting doubled. Debug the query and prove the fix.

   HardSQL roundjoin fan-out debuggingLTIMindtree-specific

   Context:

   LTIMindtree healthcare client's appointment no-show reporting

   How to answer:

   Detect one-to-many fan-out, pre-aggregate or dedupe the many side, verify with row counts. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

5. Q5

   When would you restructure a nested-subquery report for LTIMindtree's logistics client's delivery SLA tracking into CTEs, and what does it cost?

   MediumSQL roundCTEs and subqueriesLTIMindtree-specific

   Context:

   LTIMindtree logistics client's delivery SLA tracking

   How to answer:

   Readability, reuse, debugging layer by layer; note optimizer behavior differences. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

6. Q6

   Find the top 3 products per region by revenue in LTIMindtree's credit-card client's spend-category dashboard, handling ties explicitly.

   MediumSQL roundranking problemsLTIMindtree-specific

   Context:

   LTIMindtree credit-card client's spend-category dashboard

   How to answer:

   ROW_NUMBER vs RANK vs DENSE_RANK, and which tie behavior the business actually wants. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

7. Q7

   List the cleaning steps you would run on a raw extract for LTIMindtree's telecom client's churn reporting before any analysis.

   MediumExcel and BI rounddata cleaning in ExcelLTIMindtree-specific

   Context:

   LTIMindtree telecom client's churn reporting

   How to answer:

   Duplicates, blanks, types, date formats, merged cells, and a repeatable order of operations. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

8. Q8

   A key metric in LTIMindtree's credit-card client's spend-category dashboard fell 15% week over week. Walk through your investigation before you alert the client.

   HardAnalytics case roundmetric drop investigationLTIMindtree-specific

   Context:

   LTIMindtree credit-card client's spend-category dashboard

   How to answer:

   Data issue first, then mix shift, seasonality, one-segment vs broad, and a finding the client can act on. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

9. Q9

   The client sees that customers using feature X in LTIMindtree's banking client's loan-portfolio reporting churn less and wants to force-enroll everyone. What do you say?

   MediumAnalytics case roundcorrelation vs causationLTIMindtree-specific

   Context:

   LTIMindtree banking client's loan-portfolio reporting

   How to answer:

   Selection bias, confounders, and what evidence would actually support the rollout. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

10. Q10

    The client ran a promotion in two regions for LTIMindtree's retail client's daily sales dashboard. How do you judge whether it worked?

    MediumAnalytics case roundcampaign evaluationLTIMindtree-specific

    Context:

    LTIMindtree retail client's daily sales dashboard

    How to answer:

    Comparable baseline, control regions, pre/post windows, and honest uncertainty. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

11. Q11

    Present your findings on LTIMindtree's insurance client's claims data mart to a client stakeholder who does not read SQL. Structure the 10 minutes.

    MediumAnalytics case rounddata storytellingLTIMindtree-specific

    Context:

    LTIMindtree insurance client's claims data mart

    How to answer:

    Answer first, three supporting views, caveats in plain words, and a clear ask. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

12. Q12

    How do you detect and treat outliers in LTIMindtree's healthcare client's appointment no-show reporting without hiding real events?

    MediumStatistics and metrics roundoutlier treatmentLTIMindtree-specific

    Context:

    LTIMindtree healthcare client's appointment no-show reporting

    How to answer:

    IQR/z-score detection, investigate before excluding, and document every exclusion. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

13. Q13

    Define the primary KPI and two guardrail metrics for LTIMindtree's credit-card client's spend-category dashboard, with exact formulas.

    MediumStatistics and metrics rounddefining KPIsLTIMindtree-specific

    Context:

    LTIMindtree credit-card client's spend-category dashboard

    How to answer:

    Numerator, denominator, grain, and the gaming behavior each guardrail prevents. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

14. Q14

    The client escalates: their internal report disagrees with your dashboard for LTIMindtree's telecom client's churn reporting. How do you close the gap?

    HardData quality rounddashboard mismatch escalationLTIMindtree-specific

    Context:

    LTIMindtree telecom client's churn reporting

    How to answer:

    Reproduce both numbers, diff definitions and filters, agree one source of truth in writing. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

15. Q15

    Tell me about an analysis project similar to LTIMindtree's insurance client's claims data mart. What did you build, what went wrong, and what changed because of it?

    EasyBehavioral/project discussionproject deep diveLTIMindtree-specific

    Context:

    LTIMindtree insurance client's claims data mart

    How to answer:

    Concrete project, your ownership, one failure honestly told, and the decision your work drove. State the business question, the data you would pull, and the checks that make the number trustworthy. Walk through the query or steps concretely, naming tables, joins, filters, and edge cases. Close with how you would validate the result and explain it to the stakeholder.

Practice these with instant AI feedback in a live mock interview → Start a LTIMindtree Data Analyst mock

Revise programming, basic DSA and SQL; prepare project deep-dives and HR answers

Other roles at LTIMindtree

Data Analyst interviews at other companies