The Tech Mahindra Data Analyst Interview Guide
Tech Mahindra is globally renowned for its deep expertise in the Telecommunications sector. If you are interviewing for a Data Analyst role here, there is a very high probability you will be dealing with telecom data: call detail records (CDRs), network latency logs, and customer churn metrics.
Use the recruiter’s invitation to confirm the actual stages, timing, and permitted tools. The questions below are practice prompts, not a verified question bank.
The Interview Stages
The process is standard for IT services but places a slightly higher emphasis on domain understanding (especially if you are being hired for a specific telecom or manufacturing account).
Round 1: SQL and Data Extraction
Telecom databases are arguably the largest in the world. Your SQL must be optimized.
- SQL Question: “Write a query to find customers who made more than 50 international calls in the last 30 days.”
- Database Concepts: They will ask about indexing, partitioning, and how to handle massive datasets without locking the database table.
Round 2: Data Manipulation (Excel & Python)
- Excel: You will be tested on advanced VLOOKUPs (or XLOOKUP), nested IF statements, and Pivot Tables.
- Python (If applicable): How to read a massive CSV in chunks using Pandas to avoid memory overflow errors.
Round 3: The Domain Scenario Round
If you are interviewing for a Telecom project, expect telecom scenarios.
- The Scenario: “The client (a major telecom provider) is seeing a 5% increase in postpaid customer churn. What metrics would you analyze to find the cause?”
- The Approach: Discuss network quality (dropped calls in specific areas), billing anomalies (sudden spikes in bills), competitor pricing analysis, and customer service interaction logs.
Round 4: Managerial and HR
- “How do you handle repetitive reporting tasks?” (This is a trick question to see if you automate your work using macros, Python scripts, or scheduled SQL jobs).
- “Are you open to working in a 24/7 support project?”
Final Advice: Emphasize any experience you have with Automation. IT service companies love analysts who can take a manual Excel report that takes 4 hours a day and automate it using a Python script or a PowerBI scheduled refresh. A relevant automation example can make your contribution easier to assess; explain what changed and how you measured it.