WNS Group Manager Interview Questions and Answers

Normal Quants, logica and English easy one

Case study pertaining specific domain

Q1. Questions around fitment and salary negotiation
Add your answer
Q2. How did you resolve conflict with your manager
Add your answer

Q1. Design incremental load in Databricks.
Ans. 
Incremental load in Databricks involves updating only new or changed data since the last load.
• Use change data capture (CDC) to identify new or updated records.

• Leverage Databricks Delta for managing the incremental load process.

• Implement a merge operation to update existing records and insert new records efficiently.

• Utilize partitioning and clustering to optimize performance of incremental loads.
Answered by AI
Add your answer
Q2. Implement SCD2 in data warehouse
Ans. 
SCD2 is a type of slowly changing dimension in data warehousing to track historical data changes.
• Use effective dating to track changes over time

• Add new records for changes instead of updating existing ones

• Include attributes like start date, end date, and version number

• Maintain history of changes for auditing purposes
Answered by AI
Add your answer

Basically about mathematical understanding

Q1. About my expectation and experiences
Add your answer

Q1. Operations manager round about real time scenarios and my handling capabilities
Add your answer

For content, you are given a written and editing test

Q1. Regular questions..nothing interesting
Add your answer