Wipro Senior Analyst Interview Questions and Answers

I rate my communication skills at an 8 out of 10.

• I am confident in my ability to clearly convey information to others.

• I actively listen and ask clarifying questions to ensure understanding.

• I have experience presenting complex data in a simple and understandable manner.

• I am comfortable communicating with individuals at all levels of an organization.

Query to find duplicate value, highest salary, and generate report using multiple tables

• To find duplicate values, use a query with GROUP BY and HAVING clause

• To find the highest salary, use the MAX() function on the salary column

• To generate a report using multiple tables, use JOIN clauses to combine data from different tables

PEP stands for Politically Exposed Person. Sanctions are penalties imposed on individuals or entities. Types of sanctions include financial, trade, and diplomatic sanctions.

• PEP refers to individuals who are or have been entrusted with prominent public functions, such as heads of state or government officials.

• Sanctions are penalties imposed on individuals or entities to enforce international law, maintain peace, or protect national security.

• Types of sanctions include financial...read more

A self join is a type of join where a table is joined with itself.

• It is used to combine rows from the same table based on a related column.

• It requires the use of table aliases to differentiate between the two instances of the table.

• Self joins are useful when working with hierarchical data or when comparing records within the same table.

• Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.employee_id

KYC checks are necessary to verify the identity of customers and prevent fraud and money laundering.

• KYC checks help in verifying the identity of customers to ensure they are who they claim to be.

• It helps in preventing fraud by identifying suspicious activities or individuals.

• KYC checks also assist in complying with regulatory requirements and preventing money laundering.

• By conducting KYC checks, businesses can build trust with their customers and protect their reputation.

• Exam...read more