
Wipro


Wipro Senior Analyst Interview Questions and Answers
Q1. Where do you rate your communication between 0 to 10?
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.
Q2. Write a query to find duplicate value Write a query to find the highest salary of the employee Generate report by using multiple tables
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
Q3. What is PEP, Sanction and Explain type of sanction.
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
Q4. What is self join give an example
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
Q5. Why we need KYC check
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
Q6. Explain ipsec parameters
IPsec parameters are settings used to secure internet protocol (IP) communications.
IPsec parameters include authentication methods like HMAC, encryption algorithms like AES, key exchange protocols like IKE, and security associations.
Authentication methods can include MD5 or SHA-1.
Encryption algorithms can include AES, 3DES, or Blowfish.
Key exchange protocols can include IKEv1 or IKEv2.
Security associations define the security parameters for IPsec communication, such as encryp...read more
Top HR Questions asked in Wipro Senior Analyst
Interview Process at Wipro Senior Analyst

Top Senior Analyst Interview Questions from Similar Companies








Reviews
Interviews
Salaries
Users/Month

