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.
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. Mentioning automation in your resume guarantees interview callbacks at Tech Mahindra.
