Dataford
Dataford
Top 29
Prep plan
Updated weekly · Last refresh Oct 17

Itc Infotech Data Analyst Interview Questions

The questions to prepare for a Itc Infotech Data Analyst interview. Questions from real interview reports rank first. Updated daily.

29questions
~4htotal time
Track your progressSign up free to work through all 29 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~24 min
Troubleshoot a Data Mapping IssueMedium

Troubleshoot a data mapping or migration issue in a pipeline and explain how you would fix it.

DependenciesData ModelingQualityItc Infotech
Data Modeling Tools and ArchitectureEasy

Preferred tools and patterns for data modeling and pipeline architecture in a modern data platform.

InfrastructureToolsData ModelingItc Infotech
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityItc Infotech
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Group By vs Partition ByMedium

Tests window function knowledge and ability to choose the right aggregation approach.

Window FunctionsGroup ByAggregationsItc Infotech
Join Types and NULL HandlingMedium

Tests understanding of SQL join semantics and NULL behavior for accurate data analysis.

null handlingJoinsmany-to-oneItc Infotech
Optimize Slow Multi-Join QueryHard

Tests query optimization skills for performance and scalability on large datasets.

Joinsperformancequery optimizationItc Infotech
Database Architecture and End-to-End DesignMedium
Practice
Practice drill

Summarize project architecture decisions and approved reviews to demonstrate end-to-end database design ownership.

Joinsdatabase designAggregationsItc Infotech
SQL Window Functions Moving AverageMedium
Practice
Practice drill

Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.

Window FunctionsData AnalysissqlEEvalueserveSShyena Tech YarnsAATB Financial
SQL Window Functions Rolling AverageMedium
Practice
Practice drill

Calculate three-day rolling average sales by region using aggregation, joins, and PostgreSQL window functions.

Window FunctionssqlAAreteSSweetwaterRRichemont
3
Behavioral & Leadership21 questions · ~168 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Define Supply Chain KPIsMedium

Tests product sense and stakeholder facilitation to translate needs into measurable KPIs.

Stakeholder ManagementMetricsrequirementsItc Infotech
Investigate Weekly Active User DropHard

Tests metrics investigation, hypothesis-driven analysis, and root-cause identification.

root causeDiagnosisItc Infotech

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 29 questions plus 3 hands-on drills to finish this plan.