data consultancy Data Analyst Interview Questions
The questions to prepare for a data consultancy Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
Tests your ability to translate business needs into effective BI reporting and insights.
Tests your data quality practices to ensure reliable analysis outcomes.
Tests your SQL join knowledge and ability to apply it correctly in complex analytical models.
Tests your query optimization skills and practical troubleshooting approach.
Identify duplicate active Finacle transactions using a CTE, grouped business keys, and a customer lookup.
Finacleddata consultancyDDXCCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AITests prioritization under pressure across multiple projects, including time management, stakeholder communication, and ownership of trade-offs.
Evaluates your approach to root-cause analysis using data to drive business decisions.
Evaluates quantitative reasoning and ability to interpret compensation-related scenarios.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.