WNS Interview Questions, Process, and Tips

Q1. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot

• List is defined using square brackets [], tuple using parentheses ()

• Example: list - [1, 2, 3], tuple - (1, 2, 3)
Answered by AI
Add your answer
Q2. Nth highest salary
Ans. 
To find the Nth highest salary in a dataset, you can use SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY and LIMIT to sort the salaries in descending order and select the Nth row.

• For example, to find the 3rd highest salary in a table 'employees', you can use: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2, 1
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated professional with over 5 years of experience in project management and team leadership.
• Experienced in leading cross-functional teams to successfully deliver projects on time and within budget

• Skilled in developing and implementing strategic plans to achieve business objectives

• Strong communication and interpersonal skills, able to effectively collaborate with stakeholders at all levels
Answered by AI
Add your answer

Q1. What is bank reconciliation
Ans. 
Bank reconciliation is the process of comparing a company's records with those of its bank to ensure they match.
• Bank reconciliation involves comparing the company's internal financial records with the bank statement to identify any discrepancies.

• Common reasons for discrepancies include outstanding checks, deposits in transit, bank fees, and errors in recording transactions.

• The goal of bank reconciliation is to ensure t...read more
Answered by AI
Add your answer

Day to day activities in previous company

Q1. Will you be able to travel considering the distance between your location and the office?
Ans. 
Yes, I am willing and able to travel to the office despite the distance.
• I am willing to relocate closer to the office if necessary.

• I am open to commuting long distances if needed.

• I have experience with remote work and traveling for business purposes.

• I am flexible with my schedule to accommodate travel requirements.
Answered by AI
Add your answer
Q2. Are you prepared to adapt to the work culture at WNS, considering your background in a more comfortable work environment?
Ans. 
Yes, I am prepared to adapt to the work culture at WNS.
• I am open to learning and adapting to new work environments.

• I have successfully adapted to different work cultures in the past.

• I believe in the importance of flexibility and teamwork in any work setting.
Answered by AI
Add your answer

Q1. Complex Sql Questions and problems
Add your answer
Q2. Case study about segmentation and dashboarding
Add your answer

Q1. Difference betwen joins
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join: Returns all rows from the left table, and the matched rows from the right table.

• Right Join: Returns all rows from the right table, and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one ...read more
Answered by AI
Add your answer
Q2. Filter functions in DAX
Ans. 
Filter functions in DAX are used to manipulate data by applying filters based on specified conditions.
• FILTER function is used to return a table that contains only the rows that meet specified criteria.

• CALCULATE function is used to apply filters to a calculation.

• ALL function is used to remove filters from a column or table.

• RELATED function is used to retrieve related values from another table based on a specified relati
Answered by AI
Add your answer

Psychologic and reasoning test

Q1. Technical questions related to patent and databases used.
Add your answer
Q2. Situation based questions
Add your answer

Marker insights after reading patents

Q1. Summation of all the rounds
Add your answer