i
Infosys
Work with us
Filter interviews by
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...
Infosys is a global leader in technology services and consulting, providing innovative solutions to clients worldwide.
Founded in 1981, Infosys is headquartered in Bangalore, India.
It offers services in IT consulting, application development, and maintenance.
Infosys has a strong focus on digital transformation, including AI and cloud services.
The company operates in over 50 countries, serving clients across various...
Static method testing in Java involves verifying the behavior of methods that belong to a class rather than instances of the class.
Use JUnit framework for testing static methods.
Example: @Test public void testStaticMethod() { assertEquals(expected, ClassName.staticMethod(args)); }
Mock static methods using PowerMockito for dependencies.
Example: PowerMockito.mockStatic(ClassName.class);
Ensure to test edge cases and ...
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....
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;
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
I appeared for an interview before Jun 2024, where I was asked the following questions.
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 integrati...
Adapters are devices that enable compatibility between different systems or components, facilitating communication and functionality.
Adapters can be hardware (like USB to HDMI) or software (like API adapters).
A USB-C to USB-A adapter allows newer devices to connect with older USB ports.
In software, an API adapter translates requests between different systems, like a payment gateway integration.
Network adapters enable d...
CTS transport mechanism refers to the process of cargo transport within cells, crucial for cellular function and communication.
CTS stands for Cargo Transport System, essential for moving proteins and organelles.
Utilizes vesicles to transport materials between organelles, e.g., ER to Golgi.
Involves motor proteins like kinesin and dynein for movement along microtubules.
Example: Neurotransmitter release at synapses involv...
AL11 is an SAP transaction code used to access the file directory on the application server.
AL11 allows users to view and manage files on the application server.
It displays the directory structure and file contents.
Commonly used for troubleshooting and monitoring file transfers.
Example: You can check log files or data files stored in specific directories.
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
Different types of AWS S3 buckets include Standard, Intelligent-Tiering, Glacier, and OneZone-IA.
Standard: Default storage class for general-purpose data
Intelligent-Tiering: Automatically moves data between two access tiers based on usage patterns
Glacier: Low-cost storage for data archiving and long-term backup
OneZone-IA: Lower-cost option for infrequently accessed data stored in a single Availability Zone
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).
My roles include analyzing data, creating reports, presenting findings, and providing recommendations to clients.
Analyze data to identify trends and insights
Create reports summarizing key findings
Present findings to clients in a clear and concise manner
Provide recommendations based on data analysis
I handle team by fostering open communication, setting clear goals, providing support, and recognizing achievements.
Foster open communication within the team to ensure everyone is on the same page
Set clear goals and expectations to guide team members towards success
Provide support and resources to help team members overcome challenges
Recognize and celebrate achievements to boost morale and motivation
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 and have made significant contributions to each.
Led a team in implementing a new software system for a client, resulting in a 20% increase in efficiency
Developed a marketing strategy that led to a 30% increase in sales for a product
Collaborated with cross-functional teams to successfully launch a new product in the market
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 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 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.
I appeared for an interview in Jul 2024.
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 250 interview experiences
Difficulty level
Duration
based on 1.2k reviews
Rating in categories
Technology Analyst
55.8k
salaries
| ₹3 L/yr - ₹11.6 L/yr |
Senior Systems Engineer
53.3k
salaries
| ₹2.5 L/yr - ₹8.6 L/yr |
Technical Lead
35k
salaries
| ₹7.3 L/yr - ₹20 L/yr |
System Engineer
32.4k
salaries
| ₹2.4 L/yr - ₹8 L/yr |
Senior Associate Consultant
30.8k
salaries
| ₹6.3 L/yr - ₹16.9 L/yr |
TCS
Wipro
Cognizant
Accenture