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 daily.
Explain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
Tests your SQL join knowledge and ability to apply it correctly in complex analytical models.
Tests your data quality practices to ensure reliable analysis outcomes.
Tests your ability to translate business needs into effective BI reporting and insights.
Tests your query optimization skills and practical troubleshooting approach.
Tests SQL performance tuning skills and practical troubleshooting approach.
Optimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Capgemini
NomuraIdentify common SQL join types and explain when each is appropriate.
Ntt Data Europe & Latamddata consultancy
NTT DATADemonstrate window functions by ranking active employees by salary within each department.
Johnson & Johnson
CRIF
RegionsTests how you receive and act on feedback about your analysis, including communication, stakeholder management, and self-awareness.
Evaluates your approach to root-cause analysis using data to drive business decisions.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.