Top 35
Prep plan
Updated weekly · Last refresh Aug 30

Coforge Data Analyst Interview Questions

The questions to prepare for a Coforge Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

35questions
~5htotal time
Track your progressSign up free to work through all 35 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 16 questions + 3 drills · ~158 min
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberCoforge
Group By vs Having in ReportingEasy

Explain how GROUP BY forms aggregates and HAVING filters aggregated results in a reporting scenario.

Group ByHavingAggregationsCoforge
Normalization and IndexingMedium

Tests your ability to design efficient relational schemas and improve query performance.

performanceindexesdata integrityCoforge
Optimize Slow SQL at ScaleHard

Tests your ability to diagnose and improve query performance on large datasets.

performanceindexesquery optimizationCoforge
Join Three Tables PerformanceMedium

Tests SQL join logic and your understanding of performance tradeoffs.

Joinsperformancedata integrityCoforge
SQL Window Functions RankingEasy
Practice
Practice drill

Use PostgreSQL CTEs and ROW_NUMBER to return the top three products by monthly revenue within each category.

Window FunctionsRankingGroup ByEdgeverveCareer Soft Solutions Pvt.Keystone Strategy
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 Employee SalaryEasy
Practice
Practice drill

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

SubqueriesRankingAggregationsCoforgeDXC Technology
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership17 questions · ~136 min
Making Analytics Dashboards IntuitiveMedium

Tests communication and stakeholder management through a dashboard project, with emphasis on simplifying complexity for non-technical users.

Stakeholder ManagementCommunicationdashboardingCoforge
More Behavioral & Leadership questions with a free account
3
More topics2 questions · ~16 min
KPIs for Automation ProjectsMedium

Tests your ability to define measurable outcomes and align analytics to automation impact.

KPIDiagnosisAutomationCoforge
Anomaly and Trend Shift DetectionMedium

Tests your statistical toolkit for detecting unusual behavior and changes over time.

anomaly detectionCoforge

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