data consultancy Interview Questions
The questions to prepare for data consultancy interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Identify duplicate active Finacle transactions using a CTE, grouped business keys, and a customer lookup.
Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPDetermine whether a string reads the same forward and backward using a two-pointer scan.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Approach for maintaining data quality and integrity across ETL pipelines.
Explain how supervised and unsupervised learning differ, and ground the distinction in a practical ML example.
Explain how you would manage scope creep without damaging stakeholder trust or putting delivery at risk.
Set a clear north star, supporting KPIs, leading indicators, and guardrails for a new product feature.
A framework for prioritizing AI product features based on user value, feasibility, evaluation quality, and trade-offs.
Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.