i
Infosys
Work with us
Filter interviews by
I am familiar with a wide range of technologies including programming languages, databases, cloud computing, and cybersecurity.
Programming languages (e.g. Java, Python, C++)
Databases (e.g. SQL, MongoDB)
Cloud computing platforms (e.g. AWS, Azure)
Cybersecurity tools and practices
Machine learning and AI technologies
I used Java version X.X.X
I used Java version X.X.X for the project
The Java version used was X.X.X
The project was developed using Java X.X.X
Oops concepts are fundamental to object-oriented programming. They include inheritance, encapsulation, polymorphism, and abstraction.
Inheritance allows a class to inherit properties and methods from a parent class.
Encapsulation is the practice of hiding implementation details from the user.
Polymorphism allows objects to take on multiple forms or behaviors.
Abstraction is the process of simplifying complex systems b...
Search is a specific query for a particular item, while search all is a broader search for all items.
Search is used to find a specific item or information within a limited scope.
Search all is used to find all items or information within a broader scope.
Search is more targeted and precise, while search all is more general and comprehensive.
For example, searching for a specific product on a website is a search, whil...
Goto is an unconditional transfer of control while perform is a conditional transfer of control.
Goto is considered harmful as it can lead to spaghetti code.
Perform is used to execute a set of statements based on a condition.
Perform can be used with varying levels of granularity such as perform until, perform varying, etc.
Goto is rarely used in modern programming languages.
Example: perform until condition is met, g...
Creating a Spring Boot application for web and database operations
Create a new Spring Boot project using Spring Initializr
Add necessary dependencies for web and database operations in pom.xml
Create a database schema and configure database connection in application.properties
Create entity classes and corresponding repositories
Create REST controllers for web operations
Test the application using Postman or any other ...
The @primary annotation is used to mark a primary key in a database table.
It is used in database design to indicate the primary key of a table
It is often used in conjunction with other annotations such as @Entity and @Id
It can be used to specify the name of the primary key column
Example: @Entity @Table(name = "users") public class User { @Id @GeneratedValue @Column(name = "user_id") private Long id; }
To write a REST API for updating and creating a new resource, follow these pointers.
Define the API endpoint and HTTP method for creating and updating resources
Validate the input data and handle errors appropriately
Update or create the resource in the database
Return a response with the updated or created resource and a status code indicating success
Designing a database for a parking lot and creating relationships between tables.
Create a table for parking spots with a unique ID
Create a table for vehicles with a unique ID
Create a table for parking transactions with a unique ID, parking spot ID, and vehicle ID
Establish a one-to-many relationship between parking spots and parking transactions
Establish a one-to-many relationship between vehicles and parking trans...
Creating relationships between tables in JPA using entities
Use annotations such as @ManyToOne, @OneToMany, @OneToOne, and @ManyToMany to define relationships
Specify the target entity and the mapping column using @JoinColumn
Use the mappedBy attribute to specify the inverse side of the relationship
Example: @ManyToOne(targetEntity = Author.class) @JoinColumn(name = "author_id") private Author author;
Example: @OneToMa...
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 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 Referral
An interface is a point of interaction between components, allowing them to communicate and interact with each other.
Interfaces define a set of methods that a class must implement.
They provide a way to achieve abstraction and multiple inheritance in programming.
Interfaces are used to establish communication between different software components.
Examples include Java interfaces, which define a contract that implementing...
A self join is when a table is joined with itself to compare rows within the same table.
Self join is used to compare rows within the same table.
It is useful when you want to compare data in the same table.
You need to use table aliases to distinguish between the two instances of the same table.
I applied via Job Portal and was interviewed in Nov 2023. There were 3 interview rounds.
I applied via Walk-in and was interviewed in Jan 2024. There were 4 interview rounds.
Event Loop is a mechanism in programming that allows for asynchronous execution of code by continuously checking for and executing tasks in a queue.
Event Loop is a key component of JavaScript's runtime environment.
It allows for non-blocking I/O operations, making it possible to handle multiple tasks simultaneously.
Tasks are added to the event queue and executed in the order they were added.
Event Loop ensures that the m...
Async await is syntactic sugar for promises, making asynchronous code easier to read and write.
Async await allows writing asynchronous code that looks synchronous, making it easier to understand.
Promises are objects that represent the eventual completion or failure of an asynchronous operation.
Async await is built on top of promises and provides a more concise and readable way to work with asynchronous code.
Async funct...
Callback hell is a situation in asynchronous programming where multiple nested callbacks make the code difficult to read and maintain.
Occurs when multiple asynchronous operations are nested within each other
Can lead to deeply nested code structure which is hard to understand
Can be mitigated by using promises, async/await, or libraries like async.js
I appeared for an interview in Oct 2024, where I was asked the following questions.
What people are saying about Infosys
Some of the top questions asked at the Infosys Technology Analyst interview for experienced candidates -
The duration of Infosys Technology Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 53 interview experiences
Difficulty level
Duration
based on 4.6k reviews
Rating in categories
Technology Analyst
55.8k
salaries
| ₹3 L/yr - ₹11.5 L/yr |
Senior Systems Engineer
53.7k
salaries
| ₹2.5 L/yr - ₹8.3 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 - ₹17 L/yr |
TCS
Wipro
Cognizant
Accenture