WNS Interview Questions, Process, and Tips

Aptitude test as first round of interview

Q1. Tell me about your self?
Add your answer

Q1. What is Reconciliation in accounts?
Ans. 
Reconciliation in accounts is the process of comparing two sets of records to ensure they are in agreement.
• Reconciliation involves comparing financial records, such as bank statements and general ledger accounts.

• It helps identify discrepancies and errors in the records.

• Common types of reconciliations include bank reconciliation, accounts receivable reconciliation, and accounts payable reconciliation.

• Reconciliation is i...read more
Answered by AI
Add your answer

Versant interview, HR interview, operations interview.

Q1. Tell me something about ypurself
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

Accounting, Logical Resoning and Personality Questions

Q1. Give your Introduction
Ans. 
I am a highly motivated and detail-oriented individual with a strong background in project management and team leadership.
• Experienced in project management and team leadership

• Highly motivated and detail-oriented

• Strong communication and interpersonal skills
Answered by AI
Add your answer

Accounting basis , IFRS , Ind-AS,

Q1. Need Accounting basic, IFRS, Ind-AS
Add your answer
Q2. Basic accounting knowledge
Add your answer