Tapestry India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

A Data Consultant in a GCC, consulting firm, or Big 4 environment helps clients turn raw data into business decisions. Day to day, this involves gathering requirements from stakeholders, writing SQL to pull and clean data, building dashboards or models, and presenting findings to non-technical audiences. Freshers typically support senior consultants on client engagements, often across multiple industries and data platforms.

Role and Technical Knowledge

1. 1

   What is the difference between a primary key and a foreign key in a client database?

   Explain uniqueness versus referential integrity, and give a simple example like customer_id in orders table.

2. 2

   How would you handle missing values in a dataset before building a dashboard?

   Mention options like deletion, imputation with mean or median, or flagging missingness, and say when each is appropriate.

3. 3

   Explain the difference between a star schema and a snowflake schema in data warehousing.

   Focus on normalization levels and query performance, and why a consultant might choose one for a client.

4. 4

   What is the purpose of a KPI in a business dashboard? Give one example.

   Define KPI as a measurable value tied to a business goal, and give a concrete example like monthly active users or customer churn rate.

Practical Scenarios

1. 5

   A client says their sales report is showing duplicate rows. How would you debug this?

   Walk through checking join keys, aggregation logic, and source data quality, and mention communicating findings clearly.

2. 6

   You have one day to prepare a dashboard for a client meeting. What do you prioritize?

   Show you would clarify the key question, use a clean template, and focus on one or two actionable metrics rather than everything.

3. 7

   How would you explain a low p-value to a non-technical client stakeholder?

   Avoid jargon and say it means the result is unlikely due to chance alone, then connect it to a business decision.

4. 8

   Your SQL query is running slowly on a large table. What steps would you take?

   Mention checking indexes, avoiding SELECT *, filtering early, and reviewing join order or partitioning.

Case and Guesstimate

1. 9

   Estimate the number of food delivery orders placed in a mid-sized Indian city per day.

   Structure by population, smartphone penetration, ordering frequency, and segment by age or income, and state assumptions clearly.

2. 10

   A retail client wants to increase repeat purchases. How would you use data to help them?

   Suggest cohort analysis, RFM segmentation, and A/B testing, and tie recommendations to measurable outcomes.

3. 11

   How would you decide whether a new feature on a client app improved user engagement?

   Propose a controlled experiment, define a primary metric like session length, and mention statistical significance and guardrail metrics.

Behavioural and HR

1. 12

   Tell me about a time you had to learn a new tool or skill quickly for a project.

   Use STAR format, highlight the learning approach, and end with the outcome and what you would do differently.

2. 13

   How would you handle a client who disagrees with your data findings?

   Show empathy, ask clarifying questions, re-check your analysis, and present evidence calmly without being defensive.

3. 14

   Why do you want to work as a data consultant in a GCC or consulting environment?

   Connect your interest in solving varied business problems, working with clients, and learning across industries.

4. 15

   Describe a time you worked in a team under a tight deadline.

   Focus on your specific role, how you prioritized, and how you communicated to keep the team aligned.