
Candidates describe TCS Data Analyst interviews as resume-driven, with SQL and Python basics, project walkthroughs, and HR questions on relocation or shifts. Round counts and formats vary by hiring route.
$100K
Avg. Base Comp
$110K
Avg. Total Comp
2-3 rounds
Typical Rounds
Not reported
Process Length
The most consistent theme in candidate reports for the TCS Data Analyst interview is that the conversation starts from your resume. Several candidates say interviewers dug into projects, internships and the tools listed, especially SQL and Python. They also checked whether candidates really knew the skills they claimed.
SQL is the most commonly reported technical topic. Candidates mention SQL coding questions, a live query task and situation-based SQL questions. One was asked to write join queries rather than just define them. Python, data visualization, statistics and database concepts also come up, generally at a basic level, along with a few data structures and algorithms basics. One candidate was asked how they would approach a dataset. Another reports Java OOP, threads and exception handling, so some openings may lean toward general IT knowledge.
The format differs by route. A campus candidate reports an online assessment before technical, managerial and HR discussions, with several interviewers in the room. Other candidates describe a phone screen followed by a manager discussion, or an assignment plus a single interview covering technical and behavioral topics. One describes an HR screen on Microsoft Teams, a roughly 30-minute technical screen and a hiring-manager round. HR-style questions about relocation, shift flexibility, availability and notice period come up in several accounts. Some candidates were also asked why TCS and where they see themselves in five years. Candidates generally describe difficulty as easy to moderate.
Prepare a clean self-introduction and be ready to explain every project on your resume in detail. Revise SQL joins and Python fundamentals, and have honest answers on availability and mobility. If you do not know something, candidates suggest saying so rather than guessing.
Synthesized from 13 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Tata Consultancy Services process.
The technical round opened with a short introduction and then turned into a long discussion of my projects. The interviewer cared less about what I had built and more about why I chose each approach and how I implemented it, so be ready to defend your decisions, not just describe them. From there we moved into SQL theory: the types of joins and when each one applies, the difference between primary and foreign keys (including whether a foreign key can also serve as a primary key), aggregate functions, and whether a foreign key can span multiple columns. The most hands-on question was a query to find the second minimum salary, followed by a discussion of several approaches ordered from worst to best time complexity. Because my resume lists over 200 LeetCode problems, I was also asked to write Two Sum using the best approach and explain its time and space complexity.
The managerial round focused on how clearly I could explain database fundamentals. I was asked to go through DDL, DML, and DQL commands with examples, compare LEFT JOIN and RIGHT JOIN in detail, and explain the difference between CHAR and VARCHAR, including size limits and when to use each. We also covered SQL triggers: the types, their use cases, and I was asked to write trigger code.
I did not receive an offer. If you are preparing for this role, treat the conceptual SQL questions with the same seriousness as the queries, because explaining your reasoning clearly seemed to matter as much as getting the right answer.
Prep tip from this candidate
Be ready to write the second-minimum-salary query and explain several solutions ranked by time complexity, since that was the most hands-on SQL task. Also review the theory behind keys, join types, CHAR versus VARCHAR, and triggers, because the managerial round went deep on explanations.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Tata Consultancy Services
Get the top 3 highest employee salaries by department
| Question | |
|---|---|
| Paired Products | |
| Top 3 Users | |
| Largest Salary by Department | |
| Duplicate Rows | |
| Prime to N | |
| Size of Joins | |
| Manager Team Sizes | |
| Assumptions of Linear Regression | |
| Bagging vs Boosting | |
| KNN From Scratch | |
| Bias vs. Variance Tradeoff | |
| Sort Strings | |
| Missing Housing Data | |
| Random Forest from Scratch | |
| Implementing the Fibonacci Sequence in Three Different Methods | |
| Singly Linked List | |
| Area Under the ROC Curve | |
| Decision Tree Evaluation | |
| Slow SQL Query | |
| Hurdles In Data Projects | |
| Overfit Avoidance | |
| Find Duplicate Numbers in a List | |
| Relational Migration | |
| Swap Variables | |
| Justify a Neural Network | |
| Prime Numbers Identification | |
| Data Preparation for Imbalanced Data | |
| Bias Variance Tradeoff | |
| Clustering Basketball Players |
Synthesized from candidate reports. Individual experiences may vary.
A campus candidate reports an online assessment before the interviews. Referral and online applicants describe starting with HR contact or a phone screen instead. Another candidate reports completing an assignment before the interview.
Some candidates report a brief phone or Microsoft Teams screening. It typically covers background, the skills on your resume, availability and behavioral questions such as prioritizing tasks or working with difficult teammates. One phone screen mixed HR questions with a technical check. Candidates describe these screens as relaxed.
Candidates report a technical conversation, about 30 minutes in one account. It starts with a self-introduction and project walkthrough, then moves to SQL such as joins and live queries, plus Python, statistics or data visualization basics. One candidate also reports Java OOP and exception handling. Difficulty is described as basic to moderate.
Several candidates report a managerial round or a manager-led final conversation. It may cover role expectations, team fit, real-world scenarios and in-depth questions on projects and internship work. Some candidates describe a calm, conversational tone.
Candidates report HR questions on relocation, shift flexibility, notice period, why TCS and where you see yourself in five years. Some describe this as a separate round, while one candidate had a single interview covering technical, behavioral and availability topics. Prepare short, honest answers on availability and mobility.