Premium Employer

i

This company page is being actively managed by Infosys Team. If you also belong to the team, you can get access from here

Infosys Verified Tick Work with us arrow

Compare button icon Compare button icon Compare

Filter interviews by

Infosys Associate Consultant Interview Questions and Answers

Updated 27 Jul 2025

191 Interview questions

An Associate Consultant was asked 1mo ago
Q. Describe your experience with one end-to-end implementation in SAP PO.
Ans. 

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...

An Associate Consultant was asked 2mo ago
Q. What are the different types of joins in SQL?
Ans. 

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 ...

Associate Consultant Interview Questions Asked at Other Companies

asked in IQVIA
Q1. There are 2 cricket teams, A and B, with 11 players each. If ever ... read more
asked in KPMG India
Q2. While working late at night, you realize that the data you've bee ... read more
asked in Capgemini
Q3. Which tools have you used in test management and defect tracking?
Q4. Reverse the String Problem Statement You are given a string STR w ... read more
asked in Mastek
Q5. If we include all Header Files in a Java Code, will it increase t ... read more
An Associate Consultant was asked 2mo ago
Q. What are two ways to call a microservice from another microservice?
Ans. 

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...

An Associate Consultant was asked 2mo ago
Q. Explain window functions in PySpark.
Ans. 

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...

An Associate Consultant was asked 5mo ago
Q. How would you create a REST endpoint?
Ans. 

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

An Associate Consultant was asked 5mo ago
Q. How have you managed disagreements with colleagues and superiors?
Ans. 

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

Infosys HR Interview Questions

754 questions and answers

Q. What aspects of your resume would you like to highlight?
Q. Can you provide a self-introduction?
Q. What is your overall experience?
An Associate Consultant was asked 5mo ago
Q. Write a simple program to demonstrate streams and lambda functions.
Ans. 

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....

Are these interview questions helpful?
An Associate Consultant was asked 6mo ago
Q. How would you read a CSV file using the pandas library?
Ans. 

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

An Associate Consultant was asked 6mo ago
Q. How would you count the unique values in a specific column while excluding null values?
Ans. 

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;

🔥 Asked by recruiter 2 times
An Associate Consultant was asked 6mo ago
Q. How do you handle exceptions in Spring Boot?
Ans. 

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

Infosys Associate Consultant Interview Experiences

290 interviews found

Associate Consultant Interview Questions & Answers

user image Mahesh Madhukar Suryavanshi

posted on 27 Jul 2025

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Jul 2024, where I was asked the following questions.

  • Q1. Related To EHS
  • Q2. Related to Enablon Tool

Interview Preparation Tips

Interview preparation tips for other job seekers - Good Organization prepare well and you will succeed
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are different aws s3 bucket types
  • Q2. What is the maximum number of subnets that can be created in a Virtual Private Cloud (VPC)?
  • Ans. 

    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).

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. What are your roles
  • Q2. How yoi handle team

Associate Consultant Interview Questions & Answers

user image Bodke Venkatesh

posted on 28 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. About my self and Azure experience
  • Q2. Technical questions on Azure Integration Services
Round 2 - Behavioral 

(2 Questions)

  • Q1. Not much technical but test your real time experience
  • Q2. About previous projects and roles
Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. Location and salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice experience with Infosys as a immediate joinee the process to only 12 days from first round to offer release.

Associate Consultant Interview Questions & Answers

user image Aakash Choudhary

posted on 7 Oct 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Fail fast and Non fail Fast
  • Q2. Difference between PUT and PATCH
Round 2 - Technical 

(2 Questions)

  • Q1. LLD of simple web application
  • Q2. Multithreading related questions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. .NET basic Questions
  • Q2. Angular basic questions
Round 2 - Behavioral 

(2 Questions)

  • Q1. Scenario based questions
  • Q2. Current Project based questions
Round 3 - HR 

(1 Question)

  • Q1. Salary Discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(8 Questions)

  • Q1. Explain multithreading and stages of multithreading
  • Ans. 

    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.

  • Answered by AI
  • Q2. If there are 5 tasks, how to write a code so that the 5 tasks are run simultaneously
  • Ans. 

    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...

  • Answered by AI
  • Q3. Questions about REST API(difference between @RequestParam and @PathVariable). Tell some annotations which were used in my project
  • Q4. Exception Handling in spring boot
  • Q5. Deployment process in my project
  • Ans. 

    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 ...

  • Answered by AI
  • Q6. Object class in java(name some methods and follow up questions on that. Difference between == and equals())
  • Q7. DDL and DML commands in SQL
  • Ans. 

    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.

  • Answered by AI
  • Q8. Microservices question(communication between microservices)

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through your project very nicely. Also please cover basics of java, spring boot , microservices in detail.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Aug 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. Java 8 features.
  • Ans. 

    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...

  • Answered by AI
  • Q2. Some simple program to demonstrate streams and lambda functions
  • Ans. 

    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...

  • Answered by AI
  • Q3. My project experience and contributions
  • Q4. Spring boot annotations
  • Q5. Create a rest endpoint
Round 2 - Technical 

(3 Questions)

  • Q1. My overall project experience
  • Ans. 

    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

  • Answered by AI
  • Q2. My contributions
  • Q3. How I managed contradiction with collegues and superiors
  • Ans. 

    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

  • Answered by AI

Associate Consultant Interview Questions & Answers

user image Puvvala Santosh Gowri

posted on 26 Jul 2025

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Jul 2024, where I was asked the following questions.

  • Q1. Why do we hire you?
  • Ans. 

    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...

  • Answered by AI
  • Q2. Explain you real time scenario about your last project. If you have one production related issue how can you troubleshooting the issue.
  • Ans. 

    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 ...

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Coding round. General coding questions like count the number of capital and small letters in a sentence. Pandas basic coding questions were there.
  • Q2. How will you read a CSV file using pandas library?
  • Q3. Count the unique values of a particular column. Remove the null values, etc ,
  • Ans. 

    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;

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Managerial round. Asked questions about sprint, Agile workflow processes. Git related questions like what is the difference between git rebase and git merge? SQL questions, etc.,
Round 3 - HR 

(1 Question)

  • Q1. Negotiated the salary and discussed about the offer.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is react? Explain react life cycle
  • Ans. 

    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.

  • Answered by AI
  • Q2. What is hooks explain different hooks
  • Ans. 

    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.

  • Answered by AI

What people are saying about Infosys

View All
a system engineer
1w
I've only ever heard two types of opinions on this, what about yours?
So I'm working at a company that has an app for 'applying' attendance in case of WFH. You get 'WFH balance' in days. For ex: let's say I have 3 days WFH balance, which means I get to do WFH for 3 days. It will NOT count if I'm actually working on my work laptop or not. It all depends on me applying for WFH through the app. They give out limited WFH balance so that employees are forced to come to the office for the remaining days, which is okay since they have switched to hybrid model. But, if I'm not able to go to office and I don't have any more WFH balance, I will not be able to apply attendance. Instead, the app will force me to put leaves for that day. AND here's the million dollar question: if I had to put leave for that day then technically I shouldn't be working, right? But guess what? I have to work even though it counts as a leave! Wouldn't it be better to pre-apply the leaves and not work at all? But that's just how it is! I want to know your opinion on this.
Got a question about Infosys?
Ask anonymously on communities.

Infosys Interview FAQs

How many rounds are there in Infosys Associate Consultant interview?
Infosys interview process usually has 2-3 rounds. The most common rounds in the Infosys interview process are Technical, HR and One-on-one Round.
How to prepare for Infosys Associate Consultant interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Infosys. The most common topics and skills that interviewers at Infosys expect are Java, SQL, AWS, Cloud Computing and Jenkins.
What are the top questions asked in Infosys Associate Consultant interview?

Some of the top questions asked at the Infosys Associate Consultant interview -

  1. What are the services you have used in AWS? What are the types of storage in S3...read more
  2. What do you mean by Git stash? what are the different ways of git merge? Can...read more
  3. What are the different types of Jobs in Jenkins, name at least 2, and their us...read more
What are the most common questions asked in Infosys Associate Consultant HR round?

The most common HR questions asked in Infosys Associate Consultant interview are -

  1. What are your salary expectatio...read more
  2. Why are you looking for a chan...read more
  3. Share details of your previous j...read more
How long is the Infosys Associate Consultant interview process?

The duration of Infosys Associate Consultant interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Overall Interview Experience Rating

4.2/5

based on 254 interview experiences

Difficulty level

Easy 18%
Moderate 77%
Hard 5%

Duration

Less than 2 weeks 47%
2-4 weeks 32%
4-6 weeks 12%
6-8 weeks 6%
More than 8 weeks 3%
View more
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys Associate Consultant Salary
based on 20.8k salaries
₹6.8 L/yr - ₹14 L/yr
12% less than the average Associate Consultant Salary in India
View more details

Infosys Associate Consultant Reviews and Ratings

based on 1.2k reviews

3.5/5

Rating in categories

3.5

Skill development

3.6

Work-life balance

2.8

Salary

4.0

Job security

3.5

Company culture

2.6

Promotions

3.1

Work satisfaction

Explore 1.2k Reviews and Ratings
Google Cloud/Kafka/Kong/Apigee_Associate Consultant

Bangalore / Bengaluru

2-5 Yrs

₹ 3.7-16 LPA

Google Cloud/Kafka/Kong/Apigee_Associate Consultant

Hyderabad / Secunderabad

5-9 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
54.8k salaries
unlock blur

₹4.8 L/yr - ₹10 L/yr

Senior Systems Engineer
54.2k salaries
unlock blur

₹2.5 L/yr - ₹6.3 L/yr

Technical Lead
35.3k salaries
unlock blur

₹9.6 L/yr - ₹16.5 L/yr

System Engineer
32.6k salaries
unlock blur

₹2.4 L/yr - ₹5.5 L/yr

Senior Associate Consultant
32k salaries
unlock blur

₹8.2 L/yr - ₹15 L/yr

Explore more salaries
Compare Infosys with

TCS

3.6
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Accenture

3.7
Compare
write
Share an Interview