TCS Data Analyst Interview Questions & Process

Cracking the TCS Data Analyst Interview

Tata Consultancy Services (TCS) is India's largest IT employer. Data Analyst roles at TCS (often tagged under Business Intelligence, Analytics & Insights, or Digital) are heavily focused on massive enterprise data migration, reporting, and ETL (Extract, Transform, Load) processes for global clients.

The Interview Stages

The process varies depending on whether you are applying as a fresher (via TCS NQT) or as an experienced lateral hire.

1. Aptitude Test: Standard numerical, verbal, and logical reasoning.
2. Technical Interview 1: Core SQL and BI tools.
3. Technical Interview 2 (Managerial): Project architecture and client scenarios.
4. HR Interview: Cultural fit and relocation readiness.

Round 1: Core SQL and Databases

TCS manages data for some of the world's largest banks and retailers. Your SQL basics must be rock solid.

• SQL Focus: You will be tested on JOINs, Subqueries, GROUP BY, and basic aggregate functions.
• Question: "What is the difference between TRUNCATE, DELETE, and DROP? Which one would you use to clear a temporary staging table?"
• Database Concepts: Expect questions on RDBMS basics, Primary/Foreign keys, and Normalization (1NF, 2NF, 3NF).

Round 2: BI Tools and ETL

TCS heavily utilizes enterprise Business Intelligence (BI) tools.

• The Tools: Be prepared for questions on Tableau, PowerBI, or QlikView. They might also ask about ETL tools like Informatica.
• Scenario Question: "If your client's PowerBI dashboard is taking 5 minutes to load, what steps would you take to optimize it?" (Focus on filtering data at the database level rather than inside the BI tool).

Round 3: Managerial and Project Round

• Focus: This round is less about coding and more about how you handle projects.
• Question: "Describe a time when the data provided by the client was incomplete or corrupted. How did you proceed?"
• Expectation: They want to see process adherence. Did you raise a ticket? Did you communicate the delay to stakeholders? Did you document the missing data points?

Round 4: The HR Round

TCS HR rounds are famous for being strict on hygiene factors.

• "Are you willing to relocate to any TCS office in India?" (Always say yes).
• "Are you comfortable working in different shifts to support UK/US clients?" (Always say yes).
• "Are you willing to sign the service agreement?"

Pro Tip: If you have any knowledge of Cloud Data Warehouses (like AWS Redshift, Snowflake, or Azure Synapse), mention it repeatedly. TCS is helping thousands of legacy clients migrate to the cloud, and cloud data skills are currently the most prized asset in the company.