i
Infosys
Work with us
Filter interviews by
Polymorphism allows methods to do different things based on the object type, enhancing flexibility in programming.
Polymorphism is a core concept in Object-Oriented Programming (OOP).
It allows methods to be defined in multiple forms.
There are two types: compile-time (method overloading) and runtime (method overriding).
Example of method overloading: a function 'add' can add integers or doubles.
Example of method over...
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 ...
An immutable class is a class whose instances cannot be modified after creation, ensuring data integrity and thread safety.
Immutable classes prevent changes to their state after creation, e.g., String in Java.
They often provide methods to return new instances with modified values, e.g., LocalDate in Java.
Immutable objects are inherently thread-safe, reducing synchronization issues.
Commonly used in functional progr...
Identify and resolve memory leaks through systematic analysis and debugging techniques.
Monitor memory usage over time using tools like VisualVM or JProfiler to identify abnormal growth patterns.
Use profiling tools to analyze heap dumps and identify objects that are not being released, such as in Java applications.
Review code for common memory leak patterns, such as static collections holding references to objects ...
Spring Boot simplifies Java application development with rapid setup, microservices support, and built-in features.
Rapid Development: Spring Boot reduces boilerplate code, allowing developers to create applications quickly. For example, using Spring Initializr.
Microservices Architecture: It supports building microservices, enabling scalable and maintainable applications. For instance, Netflix uses Spring Boot.
Embe...
Interfaces define contracts for classes, while abstract classes provide a base with shared code and can have implemented methods.
An interface can only declare methods, while an abstract class can declare methods and provide some implementation.
A class can implement multiple interfaces but can inherit from only one abstract class.
Interfaces are used for defining capabilities (e.g., Comparable), while abstract class...
A HashMap in Java uses a hash table to store key-value pairs, allowing for efficient data retrieval.
1. Structure: HashMap uses an array of buckets to store entries, where each bucket is a linked list or tree.
2. Hashing: Keys are hashed to determine their bucket index, using the hashCode() method.
3. Collision Handling: If two keys hash to the same index, they are stored in the same bucket, handled via chaining (lin...
OOP is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
Objects: Instances of classes that encapsulate data and behavior.
Classes: Blueprint for creating objects, defining their properties and methods.
Inheritance: Ability of a class to inherit properties and behavior from another class.
Polymorphism: Ability to present the same in...
Access modifiers in C# are keywords used to specify the accessibility of classes, methods, variables, etc.
There are five access modifiers in C#: public, private, protected, internal, and protected internal.
Public: accessible from any other code in the same assembly or another assembly.
Private: accessible only within the same class or struct.
Protected: accessible within the same class or by derived classes.
Internal...
I am open to any location that offers opportunities for growth and learning.
Open to relocation for the right opportunity
Prefer locations with strong tech industry presence
Interested in cities known for innovation and technology hubs
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
Types of classes include abstract classes, concrete classes, interface classes, and inner classes.
Abstract classes cannot be instantiated and may contain abstract methods.
Concrete classes can be instantiated and provide implementations for all methods.
Interface classes define a contract for classes to implement.
Inner classes are classes defined within another class.
I address difficult situations within a team by promoting open communication, seeking to understand all perspectives, and collaborating on solutions.
Promote open communication to address issues early on
Seek to understand all perspectives before making decisions
Collaborate with team members to find mutually beneficial solutions
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.
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
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.
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...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
POST is used to create a new resource, while PUT is used to update an existing resource.
POST is used to create a new resource on the server.
PUT is used to update an existing resource on the server.
POST requests are not idempotent, while PUT requests are idempotent.
POST requests do not require the client to specify the URI of the new resource, while PUT requests do.
Example: POST /users creates a new user, PUT /users/123...
Headers in HTTP are additional information sent with a request or response.
Headers contain metadata about the message being sent.
Examples of headers include Content-Type, User-Agent, and Authorization.
Headers are key-value pairs separated by a colon, such as 'Content-Type: application/json'.
The @Qualifier annotation is used in Spring framework to specify which bean should be autowired when multiple beans of the same type are present.
Used to resolve ambiguity when multiple beans of the same type are present
Can be used with @Autowired annotation to specify the bean to be injected
Helps in selecting the bean based on a specific qualifier value
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 2 interview rounds.
SCD 2 is a type of slowly changing dimension in data warehousing, and can be implemented in DataStage using various techniques.
SCD 2 stands for Slowly Changing Dimension Type 2, which tracks historical changes in data over time.
In DataStage, SCD 2 can be implemented using the Change Data Capture stage or custom SQL queries.
To implement SCD 2 in DataStage, you need to identify the key columns for tracking changes, defin...
To improve performance in Datastage, optimize job design, use efficient coding practices, utilize parallel processing, and monitor job performance.
Optimize job design by reducing unnecessary stages and transformations
Use efficient coding practices such as avoiding unnecessary data reads and writes
Utilize parallel processing to take advantage of multiple CPU cores
Monitor job performance using Datastage Director or other...
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
Quants, reasoning, english
With oops concepts, data structures
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
What people are saying about Infosys
Some of the top questions asked at the Infosys Technology Analyst interview for job -
The duration of Infosys Technology Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 98 interview experiences
Difficulty level
Duration
based on 4.6k reviews
Rating in categories
Technology Analyst
54.8k
salaries
| ₹3 L/yr - ₹11.5 L/yr |
Senior Systems Engineer
53.7k
salaries
| ₹2.5 L/yr - ₹8.1 L/yr |
Technical Lead
35k
salaries
| ₹7.3 L/yr - ₹20 L/yr |
System Engineer
32.5k
salaries
| ₹2.4 L/yr - ₹5.3 L/yr |
Senior Associate Consultant
31k
salaries
| ₹6.3 L/yr - ₹16.9 L/yr |
TCS
Wipro
Cognizant
Accenture