Top 34
Prep plan
Updated weekly · Last refresh Oct 17

Coforge Data Analyst Interview Questions

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

34questions
~5htotal time
Track your progressSign up free to work through all 34 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 16 questions + 3 drills · ~158 min
Group By vs Having in ReportingEasy

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

Group ByHavingAggregationsCoforge
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
Identify Odd Ball Using BalanceHard

Assesses logical reasoning and strategy design for ambiguous measurement problems.

logicProblem SolvingCoforge
Squares of First 10 Odd NumbersEasy

Tests arithmetic reasoning and ability to derive a correct sequence result.

Coforge
Square Root Without Built-insHard

Tests algorithmic thinking and ability to implement core math logic from scratch.

Coforge
Optimize a Slow SQL QueryHard
Practice
Practice drill

Rewrite a slow PostgreSQL loan payment query to reduce scanned rows while preserving the required aggregated results.

database optimizationJoinsData WranglingAmeripriseEEltro Cyberchrome PrivateEnergyHub
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.

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership16 questions · ~128 min
Correcting a High-Stakes MisrequestEasy

Tests how you handle misinformation or flawed requests with tact, ownership, and stakeholder management in a data analyst context.

self assessmentgeneral awarenesscurrent affairsCoforge
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 34 questions plus 3 hands-on drills to finish this plan.