Worley India Data Consultant Interview: Rounds, Questions and Preparation

What the job involves

Data Consultants in GCCs, consulting firms, and Big 4 outfits help clients turn messy operational and financial data into clean, decision-ready insights. Day to day you might write SQL to pull project cost data, build Power BI dashboards for a client's capital projects team, or document data quality issues before a migration. The work mixes technical delivery with client communication, so you need to explain findings to non-technical stakeholders clearly.

Role and Technical Knowledge

1. 1

   What does a Data Consultant do differently from a Data Analyst in a GCC or consulting setup?

   Highlight client-facing work, problem framing, and translating data into business recommendations. Mention that consultants often work across multiple clients and need strong communication.

2. 2

   How would you explain a SQL JOIN to a client who has never written code?

   Use a simple analogy like matching two lists by a common ID, such as combining employee names with their department codes. Avoid jargon and focus on the outcome.

3. 3

   What steps do you take to clean a dataset before analysis?

   Cover checking for missing values, duplicates, inconsistent formats, and outliers. Mention documenting your changes so the client can trust the numbers.

4. 4

   Which Excel functions do you use most for data consulting work, and why?

   Name VLOOKUP or XLOOKUP, INDEX-MATCH, SUMIFS, and pivot tables. Explain that they help merge data, summarise by category, and spot trends quickly.

Practical Scenarios

1. 5

   A client's project cost report shows total spend 20 percent higher than the budget file. How would you investigate the discrepancy?

   Start by checking date ranges, currency units, and whether both files include the same projects. Then look for duplicate entries, missing change orders, or misclassified cost categories.

2. 6

   You are asked to build a dashboard for a project manager who only wants to see three numbers. What do you do?

   Ask clarifying questions about which three metrics matter most and how often they need updating. Build a simple, clean view and resist adding extra charts that distract.

3. 7

   You receive a dataset with 30 percent missing values in a key column. How do you proceed?

   First understand why data is missing and whether it can be recovered from another source. If not, discuss with the client whether to exclude those rows or use a reasonable imputation method, and document the impact.

4. 8

   A senior consultant asks you to present your analysis in tomorrow's client meeting. How do you prepare?

   Focus on the top three findings, prepare a one-page summary, and anticipate questions about data sources and assumptions. Rehearse a two-minute verbal walkthrough.

Behavioural and Situational

1. 9

   Tell me about a time you had to explain a technical concept to someone with no technical background.

   Use the STAR method and pick a real example from college projects or internships. Emphasise how you simplified the idea and checked for understanding.

2. 10

   Describe a situation where you found an error in your own work after submitting it. What did you do?

   Show ownership by explaining how you caught it, informed the right person, and fixed it. Mention what process you put in place to avoid repeating the mistake.

3. 11

   How would you handle a client who insists on a dashboard design that you know is confusing?

   Acknowledge their preference, then offer a quick prototype of both versions and let the data guide the decision. Stay respectful and focus on the client's goal.

4. 12

   Give an example of a time you had to learn a new tool or skill quickly for a project.

   Pick a concrete example like learning Power Query or a new SQL dialect. Describe your learning approach and how you applied it under a deadline.

HR and Motivation

1. 13

   Why do you want to work as a Data Consultant in a GCC or consulting environment rather than a pure product company?

   Talk about variety of clients, exposure to different industries, and the consulting skill set you want to build. Connect it to your interest in solving business problems, not just coding.

2. 14

   How do you handle working on multiple client requests with tight deadlines?

   Mention prioritisation based on impact and urgency, clear communication with your manager, and using simple tools like a to-do list or calendar blocking. Give a brief real example if possible.

3. 15

   Where do you see yourself in three years within this role?

   Show ambition to grow into a senior consultant or subject matter expert while staying hands-on with data. Mention learning client industries and mentoring juniors.

4. 16

   Are you comfortable travelling to client sites or working in different time zones if required?

   Be honest but positive. If you are flexible, say so and give an example of adapting to a new schedule or environment. If not, explain how you would manage communication asynchronously.