Dataford
Top 20
Prep plan
Updated weekly · Last refresh Aug 30

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 weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~54 min
Group By vs Partition ByMedium
Recently asked

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

Window FunctionsGroup ByAggregationsItc Infotech
Join Types and NULL HandlingMedium
Recently asked

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

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

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

Joinsperformancequery optimizationItc Infotech
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
Second Highest Without AggregatesHard
Practice
Recently asked
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
2
Behavioral & Leadership15 questions · ~120 min
Critical Report Under Tight DeadlineMedium

Tests prioritization under pressure, ownership, and stakeholder communication when delivering a high-stakes report on a compressed timeline.

pressure handlingdeadline managementreportingItc Infotech
Owning a Messy Data IssueEasy
Recently asked

Tests ownership and stakeholder communication when cleaning incomplete data under business pressure.

data cleaningData WranglingProblem SolvingItc Infotech
Prioritizing Under Sustained PressureEasy
Recently asked

Tests prioritization under pressure, ownership, and stakeholder communication when deadlines and competing demands create sustained stress.

CommunicationOwnershipDealing With AmbiguityItc Infotech
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
Define Supply Chain KPIsMedium
Recently asked

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

Stakeholder ManagementMetricsrequirementsItc Infotech
Investigate Weekly Active User DropHard
Recently asked

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 20 questions plus 3 hands-on drills to finish this plan.