i
Infosys
Work with us
Filter interviews by
An end-to-end implementation in SAP PO involves integration, configuration, and deployment of processes across systems.
Define project scope and objectives, including business requirements.
Design integration scenarios using SAP PO tools like Integration Designer.
Configure adapters (e.g., IDoc, SOAP, REST) for communication between systems.
Develop and test mappings to transform data formats as needed.
Deploy the inte...
SQL joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from ...
Microservices can communicate via REST APIs or messaging queues, enabling efficient and scalable interactions between services.
REST API: Microservices can expose RESTful endpoints, allowing other services to make HTTP requests to interact with them. Example: Service A calls Service B's endpoint using GET/POST methods.
Messaging Queues: Services can communicate asynchronously using message brokers like RabbitMQ or K...
Window functions in PySpark allow for advanced data analysis by performing calculations across a set of rows related to the current row.
Definition: Window functions perform calculations across a specified range of rows, providing insights without collapsing the result set.
Syntax: The basic syntax includes 'windowSpec' to define the partitioning and ordering of data, followed by the function, e.g., 'avg', 'sum'.
Exa...
Creating a REST endpoint for a web application
Define the endpoint URL and HTTP method (e.g. GET, POST)
Implement the logic to handle requests and responses
Use frameworks like Spring Boot for Java or Express for Node.js
Secure the endpoint with authentication and authorization
Document the endpoint with Swagger or OpenAPI
I address contradictions by actively listening, seeking common ground, and proposing solutions collaboratively.
Listen actively to understand the perspectives of colleagues and superiors
Seek common ground by focusing on shared goals and interests
Propose solutions collaboratively by involving all parties in the decision-making process
Demonstrating Java Streams and Lambda functions with a simple example of filtering and mapping a list of integers.
Streams allow processing sequences of elements (e.g., collections) in a functional style.
Lambda functions provide a concise way to represent a single method interface.
Example: Filtering even numbers from a list: List<Integer> evens = numbers.stream().filter(n -> n % 2 == 0).collect(Collectors....
Use pandas library to read a CSV file in Python.
Import the pandas library: import pandas as pd
Use the read_csv() function to read the CSV file into a DataFrame: df = pd.read_csv('file.csv')
Specify additional parameters like delimiter, header, etc. if needed
Count unique values of a column, excluding null values.
Use SQL query with COUNT(DISTINCT column_name) to count unique values.
Filter out null values using WHERE clause.
Example: SELECT COUNT(DISTINCT column_name) FROM table_name WHERE column_name IS NOT NULL;
Exception handling in Spring Boot allows developers to handle errors gracefully and provide custom responses.
Use @ControllerAdvice to handle exceptions globally
Use @ExceptionHandler to handle specific exceptions
Return ResponseEntity with appropriate status codes and error messages
Use @ResponseStatus to customize HTTP status codes
posted on 27 Jul 2025
I appeared for an interview before Jul 2024, where I was asked the following questions.
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
The maximum number of subnets that can be created in a VPC depends on the CIDR block size chosen for the VPC.
The maximum number of subnets in a VPC is determined by the number of available IP addresses in the CIDR block.
Each subnet in a VPC must be associated with a unique CIDR block within the VPC's CIDR range.
For example, if a VPC is created with a CIDR block of 10.0.0.0/16, it can have up to 65,536 subnets (2^16).
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There was 1 interview round.
Multithreading is the ability of a CPU to execute multiple threads concurrently, improving performance and responsiveness.
Multithreading allows multiple threads to run concurrently within the same process.
Stages of multithreading include thread creation, thread scheduling, and thread execution.
Example: A web server handling multiple client requests simultaneously using multithreading.
To run 5 tasks simultaneously, use multithreading or multiprocessing in the code.
Use multithreading or multiprocessing to create separate threads/processes for each task.
Ensure proper synchronization and communication between the threads/processes if needed.
Consider using a thread pool or multiprocessing pool for better resource management.
Example: In Python, you can use the 'threading' or 'multiprocessing' module to a...
Our deployment process involves continuous integration and automated testing before releasing to production.
We use Jenkins for continuous integration to automatically build and test code changes.
Before deployment, code changes are reviewed by team members to ensure quality.
We have different environments for testing such as development, staging, and production.
Deployment to production is done using automated scripts to ...
DDL commands are used to define or modify the structure of database objects, while DML commands are used to manage data within those objects.
DDL commands include CREATE, ALTER, DROP, TRUNCATE, etc.
DML commands include INSERT, UPDATE, DELETE, SELECT, etc.
DDL commands are used to create or modify tables, indexes, views, etc.
DML commands are used to insert, update, delete, or retrieve data from tables.
I appeared for an interview in Aug 2024.
Java 8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.
Lambda expressions allow you to pass functionality as an argument to a method.
Functional interfaces have a single abstract method and can be used with lambda expressions.
Streams provide a way to process collections of objects in a functional style.
Default methods allow interfaces to have method imple...
Demonstrating Java Streams and Lambda functions with a simple example of filtering and mapping a list of integers.
Streams allow processing sequences of elements (e.g., collections) in a functional style.
Lambda functions provide a concise way to represent a single method interface.
Example: Filtering even numbers from a list: List<Integer> evens = numbers.stream().filter(n -> n % 2 == 0).collect(Collectors.toLis...
I have experience working on various projects in different industries.
Managed a team to implement a new software system for a retail company
Led a market research project for a healthcare organization
Developed a marketing strategy for a tech startup
Collaborated with cross-functional teams on a product launch for a consumer goods company
I address contradictions by actively listening, seeking common ground, and proposing solutions collaboratively.
Listen actively to understand the perspectives of colleagues and superiors
Seek common ground by focusing on shared goals and interests
Propose solutions collaboratively by involving all parties in the decision-making process
I appeared for an interview before Jul 2024, where I was asked the following questions.
I bring a unique blend of analytical skills, industry knowledge, and a passion for problem-solving that aligns with your team's goals.
Strong analytical skills: I excel in data analysis, demonstrated by my project where I improved efficiency by 20% through data-driven decisions.
Industry knowledge: My experience in consulting has equipped me with insights into market trends, allowing me to provide valuable recommendation...
In my last project, I resolved a critical production issue by systematically identifying and addressing the root cause.
Identified the issue by monitoring system logs and user reports, which indicated a sudden spike in error rates.
Conducted a root cause analysis using tools like JIRA to track the issue's history and related changes.
Collaborated with the development team to review recent code deployments that could have ...
I applied via Company Website and was interviewed in Jul 2024. There were 3 interview rounds.
Count unique values of a column, excluding null values.
Use SQL query with COUNT(DISTINCT column_name) to count unique values.
Filter out null values using WHERE clause.
Example: SELECT COUNT(DISTINCT column_name) FROM table_name WHERE column_name IS NOT NULL;
React is a JavaScript library for building user interfaces.
React is used for creating interactive UI components.
It uses a virtual DOM for efficient rendering.
React components have a lifecycle which includes mounting, updating, and unmounting.
Some of the lifecycle methods include componentDidMount, componentDidUpdate, and componentWillUnmount.
Hooks in programming are functions that allow developers to execute code at specific points in the application's lifecycle.
Hooks are used in React to add functionality to functional components.
useState is a hook used to add state to functional components.
useEffect is a hook used to perform side effects in functional components.
Custom hooks can be created to reuse logic across multiple components.
What people are saying about Infosys
Some of the top questions asked at the Infosys Associate Consultant interview -
The duration of Infosys Associate Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 254 interview experiences
Difficulty level
Duration
based on 1.2k reviews
Rating in categories
Technology Analyst
54.8k
salaries
| ₹4.8 L/yr - ₹10 L/yr |
Senior Systems Engineer
54.2k
salaries
| ₹2.5 L/yr - ₹6.3 L/yr |
Technical Lead
35.3k
salaries
| ₹9.6 L/yr - ₹16.5 L/yr |
System Engineer
32.6k
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Senior Associate Consultant
32k
salaries
| ₹8.2 L/yr - ₹15 L/yr |
TCS
Wipro
Cognizant
Accenture