Infosys Interview Questions, Process, and Tips for Experienced

Q1. Tell me yourself
Ans. 
I am a technology analyst with a strong background in data analysis and software development.
• I have a Bachelor's degree in Computer Science from XYZ University

• I have 5 years of experience working as a technology analyst at ABC Company

• I specialize in data visualization tools such as Tableau and Power BI

• I have led successful projects in implementing new software solutions for clients
Answered by AI
Add your answer
Q2. What is your skillset and based on your skill set some straight forward question in round 1 and scenario based question in round 2.
Add your answer
Q3. Tell me some analytic function of sql
Ans. 
Analytic functions in SQL are used to perform calculations across a set of rows related to the current row.
• Common analytic functions include ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG.

• They can be used to calculate running totals, moving averages, and identify duplicates in a dataset.

• Analytic functions are typically used with the OVER() clause to define the window of rows to be used in the calculation.
Answered by AI
Add your answer
Q4. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.
• Rank leaves gaps between ranks if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each distinct row, while dense rank function is used to assign consecutive ranks to each distinct row

• Example: If we have values 10, 20, 20, 30 - Rank would assign ranks as 1, 2, 2, 4...read more
Answered by AI
Add your answer

Q1. I have Oracle EBS APPS.. so I faced questions on PLSQL tuning, exception handling, XML publisher report, P2P cycle with associative table
Add your answer
Q2. Bulk Binding, Bulk collect, cursor, dynamic SQL,DML/DDL Trigger
Add your answer

Q1. SDC 1,2,3 and joines,sql
Add your answer
Q2. About your project and your self
Add your answer

Q1. What is postman
Ans. 
Postman is a popular API testing tool used for testing and debugging APIs.
• Postman allows users to send requests to APIs and receive responses

• It provides a user-friendly interface for creating and managing API requests

• Postman can be used for automated testing of APIs

• It supports various request types such as GET, POST, PUT, DELETE, etc.
Answered by AI
Add your answer
Q2. How postman helps for api testing
Ans. 
Postman helps in API testing by providing a user-friendly interface to send requests, automate testing, and analyze responses.
• Postman allows testers to easily send requests to APIs and view responses in a user-friendly interface.

• It provides features for automating API testing, such as creating test scripts and running collections of tests.

• Postman also offers tools for analyzing responses, including detailed logs and te...read more
Answered by AI
Add your answer
Q3. Method Overloading and overriding
Add your answer
Q4. Locators in Selenium
Ans. 
Locators in Selenium are used to identify web elements on a webpage for automation testing purposes.
• Locators include ID, class name, name, tag name, link text, partial link text, and xpath.

• ID is the most efficient locator as it is unique for each element.

• Xpath is powerful but can be slow and brittle if not used correctly.

• Using CSS selectors is preferred over xpath for better performance.

• Locators can be used with findEl
Answered by AI
Add your answer
Q5. SQL scenario based question
Add your answer
Q6. Smoke And Sanity
Add your answer
Q7. Many project based scenario question
Add your answer
Q8. Describe Your Framework
Ans. 
My framework is a data-driven framework using Selenium WebDriver and TestNG for automated testing.
• Data-driven approach for test data management

• Integration of Selenium WebDriver for web automation

• Utilization of TestNG for test case management and reporting
Answered by AI
Add your answer
Q9. Jenkins and Maven
Add your answer

There were 3 question. 2 medium and 1 hard.

Q1. What is binary search?
Ans. 
Binary search is a search algorithm that finds the position of a target value within a sorted array.
• Divide the array in half and compare the target value with the middle element

• If the target value is smaller, search the left half. If larger, search the right half

• Repeat the process until the target value is found or the subarray is empty
Answered by AI
Add your answer
Q2. What is rest api?
Ans. 
REST API is a type of web service that allows communication between different systems over HTTP using standard methods like GET, POST, PUT, DELETE.
• REST stands for Representational State Transfer

• Uses standard HTTP methods like GET, POST, PUT, DELETE for communication

• Data is transferred in JSON or XML format

• Stateless communication between client and server

• Example: GET request to retrieve user data from a server
Answered by AI
Add your answer