WNS Interview Questions, Process, and Tips

SQL Server Architecture includes components like Query Processor, Storage Engine, Buffer Manager, and Security.

• SQL Server consists of Query Processor, Storage Engine, Buffer Manager, and Security components.

• Query Processor handles query optimization and execution.

• Storage Engine manages data storage and retrieval.

• Buffer Manager caches data pages in memory for quicker access.

• Security ensures data protection and access co

I will address the conflict by listening to all parties involved, identifying the root cause, and facilitating a resolution through open communication and compromise.

• Listen to all parties involved to understand their perspectives

• Identify the root cause of the conflict

• Facilitate open communication and encourage compromise

• Implement a solution that addresses the needs of all parties

P2P Cycle stands for Procure-to-Pay Cycle, which is the process of obtaining and paying for goods and services.

• P2P Cycle starts with the need for goods or services, followed by requisition, approval, purchase order creation, receipt of goods/services, invoice processing, and payment.

• It involves multiple steps such as vendor selection, negotiation, purchase order issuance, goods receipt, invoice verification, and paymen...read more

Types of invoices include proforma, commercial, utility, and credit invoices.

• Proforma invoice: issued before the actual sale takes place, used for customs purposes

• Commercial invoice: issued after the sale, includes details of the transaction

• Utility invoice: bill for services like electricity, water, or gas

• Credit invoice: issued to correct errors on a previous invoice

Types of AP challenges include invoice processing errors, duplicate payments, and missing discounts.

• Invoice processing errors

• Duplicate payments

• Missing discounts

I am responsible for conducting market research, identifying potential buyers, building relationships, and negotiating contracts.

• Conducting market research to identify potential buyers

• Building relationships with buyers through regular communication

• Negotiating contracts and terms with buyers

• Analyzing buyer behavior and trends to inform sales strategies

Sourcing is the process of finding, evaluating, and selecting suppliers for goods and services.

• Identifying potential suppliers through research and networking

• Evaluating suppliers based on criteria such as quality, price, and reliability

• Negotiating contracts and terms with selected suppliers

• Managing relationships with suppliers to ensure timely delivery and quality

• Monitoring supplier performance and making improvements

Contracts creation in SCM involves drafting, negotiating, and finalizing agreements with suppliers or vendors.

• Contracts creation starts with identifying the need for a contract with a supplier or vendor.

• The next step involves drafting the terms and conditions of the contract, including pricing, delivery schedules, and quality standards.

• Negotiation with the supplier or vendor may be necessary to reach mutually agreeable...read more

I am a dedicated and experienced professional with a strong background in leadership and team management.

• Over 5 years of experience in retail management

• Proven track record of increasing sales and improving customer satisfaction

• Strong communication and problem-solving skills

• Led a team of 20 employees to exceed sales targets by 15% last quarter

Shrinkage and attrition are terms used in business to describe loss of resources and employees respectively. Shrinkage is calculated as a percentage of lost inventory, while attrition is calculated as a percentage of employees leaving the company.

• Shrinkage refers to the loss of inventory or assets due to theft, damage, errors, or other factors.

• Shrinkage can be calculated by dividing the value of lost inventory by the t...read more

SUM calculates the total of a column, while SUMX calculates the total of an expression evaluated for each row.

• SUM is used to calculate the total of a column in a table

• SUMX is used to calculate the total of an expression evaluated for each row in a table

• SUMX is often used with iterators like FILTER or RELATEDTABLE to perform calculations on a row-by-row basis

Group By in Power Query is used to aggregate data based on a specific column or columns.

• Select the column(s) you want to group by

• Go to the 'Transform' tab and click on 'Group By'

• Choose the aggregation type and column to aggregate on

• Rename the new column if needed