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

For content, you are given a written and editing test

Q1. Regular questions..nothing interesting
Add your answer

Q1. Question related to statistics and ML algorithms
Add your answer
Q2. Question related to python and R coding
Add your answer

Q1. What is the toughest decision you have taken as a leader
Add your answer