Wipro Senior Business System Analyst Interview Questions and Answers

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Add your answer
Q2. Can you describe the projects you have worked on?
Add your answer
Q3. Write a query to merge 2 tables?
Add your answer
Q4. Tell me about the internship that you have done?
Add your answer
Q5. Behavioural questions
Add your answer

A standardized exam that measure a person skill, abilities and potential to success in a particular role of fields

Q1. Problem solving and system administration
Add your answer
Q2. Critical thinking
Add your answer

Q1. Describe microservice architecture for an e-commerce platform
Ans. 
Microservice architecture for e-commerce platform involves breaking down the application into smaller, independent services.
• Each service is responsible for a specific business function, such as inventory management or payment processing.

• Services communicate with each other through APIs, allowing for flexibility and scalability.

• Each service can be developed, deployed, and scaled independently, making it easier to mainta...read more
Answered by AI
Add your answer
Q2. What is the SAGA pattern?
Ans. 
The SAGA pattern is a design pattern used in distributed systems for managing long-lived transactions.
• SAGA pattern breaks down a long transaction into a series of smaller, more manageable transactions.

• Each smaller transaction is executed independently and can be compensated if needed.

• SAGA pattern helps maintain consistency and reliability in distributed systems.

• Example: In an e-commerce system, the SAGA pattern can be ...read more
Answered by AI
Add your answer
Q3. How Apache Kafka can be used to across multiple producers and consumers across Kafka cluster ?
Ans. 
Apache Kafka can be used to enable communication between multiple producers and consumers across a Kafka cluster.
• Producers can publish messages to specific topics in the Kafka cluster.

• Consumers can subscribe to these topics and receive messages in real-time.

• Kafka ensures fault tolerance and scalability by distributing data partitions across multiple brokers.

• Producers and consumers can be distributed across different no...read more
Answered by AI
Add your answer
Q4. Core Java Questions like Streams API, few problems to solve with flat mapping
Add your answer
Q5. Core Spring Boot questions
Add your answer
Q6. DS questions : 2sum problems ,(solve using compliment method), mergesort pseudo code
Add your answer

Q1. Design patterns
Add your answer
Q2. Sql interview questions
Add your answer

Q1. Case study about the given requirement
Add your answer
Q2. Springboot basic questions
Add your answer

Q1. Explain about patch management in Linux
Add your answer
Q2. After patching what are the issues you faced. How did you troubleshoot those issues.
Add your answer

Q1. Technical regarding OS, M365, Software and Hardware troubleshooting.
Add your answer
Q2. Admin tools, ticketing tools, itsm
Add your answer

Q1. Vocabulary, communication skills, process knowledge
Add your answer
Q2. Roles and responsibilities, incident management
Add your answer

Q1. Salary discussion, job profile
Add your answer

Its moderate and nit that much difficult to attempt

Coding also moderate its not that much deep

Assignment is based on verbal communication

Q1. What is the 1st priority job or family?
Ans. 
Family should be the 1st priority as they provide emotional support and love.
• Family provides emotional support during tough times

• Family offers unconditional love and care

• Job can always be replaced, but family is irreplaceable
Answered by AI
Add your answer
Q2. What is the java?
Ans. 
Java is a high-level programming language known for its portability, security, and versatility.
• Java is an object-oriented language

• It is platform-independent, meaning code can run on any device with a Java Virtual Machine (JVM)

• Java is used for developing web applications, mobile apps, desktop applications, and more
Answered by AI
Add your answer
Q3. Tell me your personal details
Ans. 
I am a dedicated and experienced System Analyst with a strong background in IT and problem-solving skills.
• Experienced in analyzing and designing software systems

• Proficient in programming languages such as Java, C++, and SQL

• Strong communication and teamwork skills

• Detail-oriented and able to prioritize tasks effectively
Answered by AI
Add your answer
Q4. Regarding coding
Add your answer
Q5. Regarding gk questions
Add your answer

Q1. What is hash technology?
Ans. 
Hash technology is a method used to convert data into a fixed-size string of characters, typically used for data security and integrity.
• Hash technology uses algorithms to generate a unique fixed-size string of characters from input data.

• It is commonly used for data security, password storage, digital signatures, and data integrity verification.

• Examples of hash algorithms include MD5, SHA-1, and SHA-256.
Answered by AI
Add your answer
Q2. What is block chain?
Ans. 
Blockchain is a decentralized, distributed ledger technology used to securely record transactions across multiple computers.
• Decentralized database

• Consensus mechanism

• Immutable record of transactions

• Cryptographic security

• Smart contracts

• Examples: Bitcoin, Ethereum
Answered by AI
Add your answer
Q3. What is DML?
Ans. 
DML stands for Data Manipulation Language, used to manage data in a database.
• DML is a subset of SQL (Structured Query Language) used to insert, update, delete, and retrieve data in a database.

• Examples of DML commands include INSERT, UPDATE, DELETE, and SELECT.

• DML is essential for managing and manipulating data within a database system.
Answered by AI
Add your answer
Q4. Convert binay to decimal and viceversa.
Ans. 
Binary to decimal conversion involves multiplying each digit by 2 raised to the power of its position.
• To convert binary to decimal, start from the rightmost digit and multiply each digit by 2 raised to the power of its position.

• Add all the results together to get the decimal equivalent.

• For example, to convert binary 1011 to decimal: 1*2^3 + 0*2^2 + 1*2^1 + 1*2^0 = 11.
Answered by AI
Add your answer
Q5. Find max number in array?
Ans. 
Iterate through array and compare each element to find the maximum number.
• Iterate through the array using a loop.

• Compare each element to a variable storing the current maximum number.

• Update the variable if a larger number is found.

• Return the maximum number at the end.
Answered by AI
Add your answer
Q6. Write basic html , for inserting image and create table.
Ans. 
Basic HTML code for inserting image and creating a table
• Use <img> tag to insert an image with src attribute

• Use <table>, <tr>, <td> tags to create a table structure

• Specify image source and table content within respective tags
Answered by AI
Add your answer