AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Infosys
Work with us 
Compare
Filter interviews by
Infosys Interview Questions and Answers for Experienced
1.6k Interview questions
HashMap stores key-value pairs for fast retrieval, while LinkedList maintains an ordered collection of elements.
HashMap allows null values and one null key, while LinkedList allows multiple null elements.
HashMap provides O(1) average time complexity for get and put operations, whereas LinkedList has O(n) for accessing elements.
LinkedList maintains the order of insertion, while HashMap does not guarantee any order.
...
OOP is based on four main principles: Encapsulation, Abstraction, Inheritance, and Polymorphism, each with real-life analogies.
Encapsulation: A car's engine is hidden from the driver; they only interact with the steering wheel and pedals.
Abstraction: A TV remote allows users to control the TV without needing to understand its internal workings.
Inheritance: A child inherits traits from their parents, like eye color...
Abstract classes can have both abstract and concrete methods, while interfaces can only have abstract methods (Java 8+ allows default methods).
Abstract classes can have instance variables; interfaces cannot.
A class can extend only one abstract class but can implement multiple interfaces.
Abstract classes can provide default behavior, while interfaces require implementing classes to define behavior.
Example: 'abstrac...
CSS (Cascading Style Sheets) is a stylesheet language used to describe the presentation of HTML documents.
CSS controls layout, colors, fonts, and overall visual appearance of web pages.
It separates content (HTML) from design, making maintenance easier.
CSS rules consist of selectors and declarations, e.g., 'h1 { color: blue; }'.
Styles can be applied inline, internally (within <style> tags), or externally (via...
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 (or LEFT OUTER 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 (or R...
A primary key uniquely identifies a record in a table, while a foreign key links records between two tables.
Primary Key: Uniquely identifies each record in a table. Example: 'user_id' in a 'Users' table.
Foreign Key: A field in one table that links to the primary key of another table. Example: 'user_id' in 'Orders' table referencing 'Users'.
Primary keys cannot contain NULL values, while foreign keys can.
A table can...
A string is a sequence of characters used to represent text in Java, immutable and widely used in programming.
Strings in Java are objects of the String class.
They are immutable, meaning once created, their values cannot be changed. Example: String str = "Hello"; str = str + " World!"; // creates a new string.
Strings can be created using string literals or the 'new' keyword. Example: String str1 = "Hello"; String s...
The transient keyword in Java prevents serialization of certain class fields, ensuring sensitive data isn't saved.
Used in serialization to indicate that a field should not be serialized.
Example: If a class has a field marked as transient, its value won't be saved when the object is serialized.
Commonly used for sensitive information like passwords or temporary data.
Syntax: 'transient int tempValue;' prevents 'tempV...
Delivery challenges include scope changes, resource constraints, and stakeholder communication issues.
Scope Creep: Unexpected changes in project requirements can derail timelines. For example, a client may request additional features mid-project.
Resource Constraints: Limited availability of team members can impact delivery. For instance, a key developer may fall ill, delaying progress.
Stakeholder Communication: Mi...
Yes, I was engaged in Sprint 0 tasks, focusing on project setup and team alignment.
Defined project scope and objectives to ensure clarity.
Established team roles and responsibilities for effective collaboration.
Created a high-level project roadmap to guide future sprints.
Set up the development environment and tools for the team.
Conducted initial stakeholder meetings to gather requirements.
Infosys Interview Experiences for Experienced
2.4k interviews found
mkay_ here
I appeared for an interview in Jan 2025.
(5 Questions)
- Q1. How snowflake differs from industry competetors? What is the extra edge?
- Ans.
Snowflake offers a unique architecture that separates storage and compute, providing scalability, flexibility, and cost-effectiveness.
Snowflake's architecture separates storage and compute, allowing for independent scaling of each component.
Snowflake uses virtual warehouses to allocate compute resources on-demand, optimizing performance and cost.
Snowflake's multi-cluster shared data architecture enables seamless collab...
- Q2. 3 Sql problem statements with basic problem statement. Concepts like view table, window function, sequence generation, Rank transformation.
- Q3. Difference between time travel and fail safe.
- Ans.
Time travel refers to the ability to query historical data in Snowflake, while fail safe refers to the system's ability to maintain data integrity and availability in case of failures.
Time travel allows users to query data as it existed at a specific point in the past, using the TIMESTAMP parameter in queries.
Fail safe mechanisms in Snowflake ensure data integrity and availability by automatically handling system failu...
- Q4. Difference between live feed and extract.
- Ans.
Live feed is real-time data while extract is historical data.
Live feed is data that is constantly updated in real-time.
Extract is historical data that is extracted at a specific point in time.
Live feed is commonly used for monitoring real-time events, while extract is used for analysis of past data.
Examples: Twitter feed is live data, while a monthly sales report is an extract.
- Q5. Difference between Join and data Blending
- Ans.
Join combines data from two or more tables based on a related column, while data blending combines data from different sources without a direct relationship.
Join is used to combine data from multiple tables based on a common column.
Data blending is used to combine data from different sources without a direct relationship.
Join requires a common column to match records, while data blending does not require a common colum...
Interview Preparation Tips
So better be prepared.
Anonymous
I appeared for an interview in Feb 2025, where I was asked the following questions.
- Q1. My name is arya s naik.i am 23 years old,i am from dandeli .i have completed the schooling education from st michael convent high school .and completed pre university from bangur nagar junior college dande...
- Q2. Bpo business process outsourcing it offers diverse opportunity,and helps in improving the communication skill and it has better opportunity working in team management,and it is open to work in that field w...
- Q3. I am hardworker and i have the ability to work in this field
- Q4. My hobbies are macrame art,cooking
- Q5. My weakness afraid to say the answers if it is correct also
- Ans.
I struggle with expressing my answers confidently, even when I know them to be correct.
I often second-guess my responses during discussions, fearing they may be incorrect.
In team meetings, I hesitate to share my ideas, even when I have valuable insights.
For example, during a recent project, I had a solution but didn't voice it, leading to delays.
I am working on this by practicing assertiveness and seeking feedback from...
Interview Preparation Tips
I appeared for an interview in Jan 2025.
(4 Questions)
- Q1. Difference between HF vs Uf
- Ans.
HF stands for Heavy Forwarder, used for data forwarding and processing. UF stands for Universal Forwarder, used for lightweight data forwarding only.
HF is used for data forwarding, processing, and indexing, while UF is used for lightweight data forwarding only
HF can parse and index data locally, while UF can only forward data to indexers
HF requires more resources and is typically deployed on dedicated hardware, while U...
- Q2. What is DS in splunk
- Ans.
DS in Splunk stands for Data Source.
DS refers to the source of data that is being indexed and analyzed in Splunk.
Common data sources in Splunk include log files, metrics, and events from various systems and applications.
DS can also refer to the Data Summary feature in Splunk, which provides a summary of indexed data.
- Q3. Difference between stats eventstats streamstats and tstats
- Ans.
stats, eventstats, streamstats, and tstats are different Splunk commands used for statistical analysis.
stats: used to calculate statistics on the events in the search results.
eventstats: used to calculate statistics on the events in the search results, but the results are added as new fields to each event.
streamstats: used to calculate statistics on the events in the search results, but the results are added as new fie...
- Q4. Priority of files in splunk
- Ans.
In Splunk, the priority of files is determined by the order in which they are indexed.
Files are indexed based on the inputs.conf configuration file.
Priority can be set using the 'disabled' attribute in inputs.conf.
Files with higher priority are indexed first.
Priority can also be influenced by the order of stanzas in inputs.conf.
I applied via Job Portal and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Diff bw CCW and DIS CCW
- Ans.
CCW stands for Counterclockwise while DIS CCW stands for Disconnected Counterclockwise.
CCW refers to a direction of rotation that is opposite to the clockwise direction.
DIS CCW refers to a situation where something is disconnected from its counterclockwise rotation.
Example: Turning a screw counterclockwise is CCW, while a disconnected counterclockwise rotation could refer to a malfunctioning gear.
Example: In a motor, C...
- Q2. Diff bw PECI and PICOF
- Ans.
PECI stands for Problem, Etiology, Context, and Intervention, while PICOF stands for Population, Intervention, Comparison, Outcome, and Timeframe.
PECI is used in problem-solving to identify and address issues, while PICOF is used in research to formulate a research question.
PECI focuses on the problem, its causes, the context in which it occurs, and potential interventions to address it.
PICOF focuses on defining the po...
(2 Questions)
- Q1. Previous experience
- Q2. Role in current project in details
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There were 2 interview rounds.
(1 Question)
- Q1. Dot net related questions and sql questions
(1 Question)
- Q1. 1.Why you left your previous organisation that too without any offer ? 2.Assumption questions about recursive pattern 3.Cloud related question’s 4.Deployment related questions in deep 5.Have you used Do...
- Ans.
Docker images provide a lightweight, portable, and consistent environment for running applications.
Docker images encapsulate all dependencies and configurations needed for an application to run
They can be easily shared and deployed across different environments
Docker images are immutable, ensuring consistency and reproducibility
Containers based on Docker images are isolated from the host system, enhancing security
Docke...
(1 Question)
- Q1. No question as interview cancelled
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
(1 Question)
- Q1. Project based Question
(3 Questions)
- Q1. Why are you changing job?
- Ans.
Seeking new challenges and growth opportunities in a more innovative environment.
Looking for new challenges and opportunities for growth
Interested in working in a more innovative environment
Seeking a better work-life balance
- Q2. How is your usual workday like?
- Ans.
My workday as a Snowflake Developer involves data modeling, ETL processes, and collaborating with teams to optimize data solutions.
Start the day by reviewing project requirements and prioritizing tasks.
Collaborate with data engineers to design and implement ETL pipelines.
Monitor Snowflake performance and optimize queries for efficiency.
Conduct code reviews and provide feedback to team members.
Participate in daily stand...
- Q3. What work you did for project? What was your specific contribution to project?
- Ans.
I worked on developing data pipelines for ingesting and processing large volumes of data in Snowflake.
Designed and implemented ETL processes using Snowflake's features like Snowpipe and tasks.
Optimized SQL queries for performance and scalability.
Collaborated with data engineers and analysts to understand requirements and deliver solutions.
Implemented data quality checks and monitoring processes to ensure data integrity...
(2 Questions)
- Q1. Salary discussion
- Q2. Location related
Bodke Venkatesh
Selected
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
(2 Questions)
- Q1. About my self and Azure experience
- Q2. Technical questions on Azure Integration Services
(2 Questions)
- Q1. Not much technical but test your real time experience
- Q2. About previous projects and roles
(2 Questions)
- Q1. Salary negotiation
- Q2. Location and salary discussion
Interview Preparation Tips
I appeared for an interview in Nov 2024.
(4 Questions)
- Q1. Types of partition in sql
- Q2. Can we edit data in complex views, will the underlying table be effected?
- Ans.
Editing data in complex views can affect underlying tables, but it depends on the view's structure and rules.
Complex views often involve joins, aggregations, or groupings, making them non-updatable.
If a view is updatable, changes made to it will reflect in the underlying tables.
Example: A simple view on a single table can be updated directly.
Example: A view that aggregates data (e.g., SUM, COUNT) cannot be updated dire...
- Q3. How do you do performance tuning?
- Ans.
Performance tuning involves optimizing database queries and configurations for improved efficiency and speed.
Analyze execution plans to identify slow queries. For example, use EXPLAIN PLAN to see how Oracle executes a query.
Use indexing strategically. For instance, create indexes on columns frequently used in WHERE clauses to speed up data retrieval.
Optimize SQL queries by avoiding SELECT *, using WHERE clauses effecti...
- Q4. Tell about regex
- Ans.
Regular expressions (regex) are sequences of characters that define search patterns for strings, used for pattern matching and manipulation.
Regex is used for validating input formats, e.g., email addresses: ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$
It can extract specific patterns from text, such as phone numbers: \d{3}-\d{3}-\d{4}
Regex supports various metacharacters like '.', '*', and '+', which have special me...
(4 Questions)
- Q1. Scheduling margin key
- Q2. Control key what is its importance
- Ans.
Control key in SAP is important for defining the behavior of a particular operation or transaction in the system.
Control key determines how a particular operation or transaction will be executed in SAP PP.
It helps in defining the scheduling parameters, lead time, and other relevant details for a specific task.
Examples of control keys include PP01 for standard production order, PP02 for production order with project sto...
- Q3. Different MRP types
- Ans.
Different types of MRP in SAP include MRP, MRP Live, and MRP Areas.
MRP (Material Requirements Planning) is the traditional MRP functionality in SAP.
MRP Live is the new MRP functionality introduced in SAP S/4HANA.
MRP Areas allow for planning at a more detailed level within a plant or storage location.
- Q4. Important configurations in SAP PP
- Ans.
Important configurations in SAP PP include work centers, routing, production versions, and material master data.
Work centers: Define where and how production operations are carried out.
Routing: Specifies the sequence of operations in production.
Production versions: Used to manage different versions of a product's BOM and routing.
Material master data: Contains all the information about materials used in production.
Skills evaluated in this interview
What people are saying about Infosys
Infosys Interview FAQs
Some of the top questions asked at the Infosys interview for experienced candidates -
The duration of Infosys interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Infosys Interviews By Designations
- Infosys System Engineer Interview Questions
- Infosys Software Engineer Interview Questions
- Infosys Technology Analyst Interview Questions
- Infosys Associate Consultant Interview Questions
- Infosys Senior Systems Engineer Interview Questions
- Infosys Software Developer Interview Questions
- Infosys Business Analyst Interview Questions
- Infosys Senior Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- System Engineer Interview Questions
- Software Engineer Interview Questions
- Technology Analyst Interview Questions
- Associate Consultant Interview Questions
- Senior Systems Engineer Interview Questions
- Software Developer Interview Questions
- Business Analyst Interview Questions
- Senior Associate Consultant Interview Questions
- Show more
Overall Interview Experience Rating
based on 1.4k interview experiences
Difficulty level
Duration
Explore Interview Questions and Answers for Top Skills at Infosys
Interview Questions from Similar Companies
Infosys Reviews and Ratings
based on 43.2k reviews
Rating in categories
|
Technology Analyst
54.7k
salaries
|  ₹4.8 L/yr - ₹10 L/yr |
|
Senior Systems Engineer
53.8k
salaries
| ₹2.5 L/yr - ₹6.3 L/yr |
|
Technical Lead
35.1k
salaries
| ₹9.4 L/yr - ₹16.4 L/yr |
|
System Engineer
32.5k
salaries
| ₹2.4 L/yr - ₹5.3 L/yr |
|
Senior Associate Consultant
31.3k
salaries
| ₹8.2 L/yr - ₹15 L/yr |
TCS
Wipro
Cognizant
Accenture
- Home >
- Interviews >
- Infosys Interview Questions >
- Infosys Interview Questions for Experienced
