Seagate India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

A Data Consultant in a GCC or Big 4 setting works with client teams to translate business problems into data-driven solutions, often involving data cleaning, analysis, dashboarding, and reporting. Day to day, you might gather requirements, write SQL queries, build Power BI or Tableau dashboards, and present insights to stakeholders. You also support data quality checks, documentation, and process automation for consulting engagements.

Role and Technical Knowledge

1. 1

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

   Explain uniqueness and referential integrity, and give a simple example like CustomerID in Orders table.

2. 2

   How would you handle missing values in a dataset before analysis?

   Discuss deletion, imputation (mean, median, mode), or model-based methods, and mention when each is appropriate.

3. 3

   Explain the difference between WHERE and HAVING in SQL.

   Clarify that WHERE filters rows before aggregation, while HAVING filters after GROUP BY.

4. 4

   What are the key steps in a data cleaning process?

   Cover profiling, handling duplicates, outliers, inconsistent formats, and validation against business rules.

Practical Scenarios

1. 5

   A client complains that their monthly sales report shows a sudden drop. How would you investigate?

   Outline checking data pipelines, comparing with previous months, validating with source systems, and ruling out reporting errors.

2. 6

   You are asked to build a dashboard for a retail client to track store performance. What metrics would you include?

   Suggest sales, footfall, conversion rate, average transaction value, and inventory turnover, and explain why they matter.

3. 7

   How would you prioritize multiple data requests from different stakeholders?

   Discuss impact, urgency, effort, and alignment with business goals, and mention communicating trade-offs.

4. 8

   You find that a dataset has duplicate customer records. How would you deduplicate and ensure accuracy?

   Explain using unique identifiers, fuzzy matching, and business rules, and validating with stakeholders.

Behavioural and HR

1. 9

   Why do you want to work as a Data Consultant in a GCC or Big 4 environment?

   Show awareness of client-facing work, exposure to multiple industries, and structured problem-solving.

2. 10

   Describe a time you used data to convince someone of a different viewpoint.

   Use STAR format, highlight data analysis, visualization, and the outcome.

3. 11

   How do you handle tight deadlines when working on multiple data requests?

   Mention prioritization, time management, and proactive communication with stakeholders.

4. 12

   Tell me about a project where you had to learn a new tool or technology quickly.

   Focus on self-learning, resourcefulness, and applying the new skill to deliver results.

Consulting and Business Acumen

1. 13

   How would you estimate the market size for a new product in India using data?

   Use a top-down or bottom-up approach, state assumptions clearly, and mention data sources.

2. 14

   What is the difference between descriptive, predictive, and prescriptive analytics?

   Define each and give a consulting example, like dashboards, forecasting, and optimization.

3. 15

   A client wants to reduce customer churn. What data would you analyze and what approach would you take?

   Discuss churn definition, historical data, segmentation, and potential predictive modeling.

4. 16

   How would you explain a complex data insight to a non-technical client?

   Emphasize storytelling, simple visuals, and focusing on business impact rather than technical details.