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

WNS Business Analyst Interview Questions

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

31questions
~4htotal time
Track your progressSign up free to work through all 31 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 2 drills · ~62 min
Second Highest Without AggregatesHard
Practice

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

SubqueriesRankingSelf-JoinsWNS
Handling Missing and Dirty SQL DataMedium

Explain how to profile, clean, and standardize missing or dirty data before analysis.

Data WranglingCase WhenQualityWNS
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
Handling Missing DataMedium
Practice
Practice drill

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningEversource EnergyCincinnati Children's HospitalAdtalem Global Education
More SQL & Data Manipulation questions with a free account
2
Strategy4 questions · ~34 min
Tell Me About YourselfEasy

Craft a concise self-introduction that highlights fit, communication style, and relevance for an Account Executive role.

brand cultureBusiness AcumenCompetitive AnalysisWNS
More Strategy questions with a free account

Sign up to see every question

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

Get my prep plan
3
Statistics & Probability4 questions · ~34 min
Favorite ML Algorithm ImplementationMedium

Evaluates your practical ML understanding and ability to explain implementation choices.

Machine LearningimplementationWNS
More Statistics & Probability questions with a free account
4
Behavioral & Leadership14 questions · ~117 min
More Behavioral & Leadership questions with a free account
5
More topics4 questions · ~34 min
Journal Entry BasicsEasy

Assesses your accounting fundamentals for business reporting contexts.

AccountingWNS
WNS FAMUS Product PurposeMedium

Assesses your understanding of WNS FAMUS and its intended business value.

WNS
Correcting a Project That Went WrongMedium

Evaluates your troubleshooting, accountability, and recovery planning.

experienceprojectsWNS
Cash Flow Statement and Financial Statements LinkMedium

Evaluates your finance fundamentals and ability to connect financial statements.

Financial Statementscash flowWNS
The finish line: interview-readyComplete all 31 questions plus 2 hands-on drills to finish this plan.