i
Infosys
Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There was 1 interview round.
Slowly Changing Dimensions (SCD) are used in data warehousing to track changes to data over time. Types include Type 1, Type 2, and Type 3.
Type 1 SCD: Overwrites old data with new data, losing historical information.
Type 2 SCD: Creates a new record for each change, preserving historical data.
Type 3 SCD: Tracks changes by adding columns to the existing record, allowing for limited historical analysis.
Use the GROUP BY clause with COUNT() function to find duplicates in SQL.
Use GROUP BY clause with COUNT() function to group the records by the columns you want to check for duplicates
Filter the results by using HAVING clause to only show records with count greater than 1
Example: SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1;
Test Case is a detailed set of conditions and steps to be followed to validate a particular functionality, while Test Scenario is a high-level description of the functionality to be tested.
Test Case is detailed and specific, while Test Scenario is high-level and general.
Test Case includes steps, expected results, and test data, while Test Scenario is more of an overview.
Test Case is used for detailed testing, while Tes...
Bug life cycle is the process of a bug from identification to resolution in software testing.
Bug is identified by tester
Bug is reported in bug tracking tool
Bug is assigned to developer
Developer fixes the bug
Bug is retested by tester
Bug is closed if fixed or reopened if not
I applied via Company Website and was interviewed in Mar 2024. There was 1 interview round.
Subcon process refers to subcontracting process where a company outsources part of its manufacturing process to a third-party vendor.
Subcon process involves sending raw materials to a subcontractor for processing or assembly.
The subcontractor then returns the finished goods to the company.
The company pays the subcontractor for the services rendered.
Subcon process helps companies focus on core competencies and reduce co...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
To write a custom exception in Java, create a new class that extends Exception or a subclass of Exception.
Create a new class that extends Exception or a subclass of Exception.
Add a constructor to the custom exception class to pass a message to the superclass constructor.
Throw the custom exception using the 'throw' keyword in your code.
Handle the custom exception using try-catch blocks or propagate it up the call stack.
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
HashMap internally uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to find the index in the array where it will be stored.
If multiple keys hash to the same index, a linked list is used to handle collisions.
To retrieve a value, the key is hashed again to find th...
Infosys interview questions for popular designations
I applied via Referral and was interviewed in Mar 2024. There were 3 interview rounds.
Get interview-ready with Top Infosys Interview Questions
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
BTP stands for Business Technology Platform. It is a platform-as-a-service offering from SAP that provides tools and services for developing, integrating, and extending applications.
BTP offers services such as database and data management, analytics, machine learning, and IoT.
It allows businesses to build, run, and manage applications in the cloud.
Scope of work includes implementing security measures, configuring acces...
I applied via AmbitionBox and was interviewed in May 2024. There was 1 interview round.
Git merge combines changes from different branches, while Git rebase moves the entire branch to a new base commit.
Git merge creates a new commit with the combined changes of the branches being merged.
Git rebase moves the entire branch to a new base commit, resulting in a linear history.
Merge preserves the history of changes, while rebase rewrites the commit history.
Rebasing is useful for keeping a clean and linear hist...
Git fetch downloads changes from a remote repository, while Git merge combines changes from different branches.
Git fetch updates the remote tracking branches in your local repository without merging them with your current branch.
Git merge combines changes from a different branch into your current branch.
Git fetch is useful for reviewing changes before merging, while Git merge is used to integrate changes into your curr...
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.
Mandatory fields in Swift MT 103 message
Sender's Reference (20)
Sender's Account Number (50K)
Receiver's Account Number (59)
Amount (32A)
Currency (33B)
Value Date (32A)
Sender's Correspondent (53A)
Receiver's Correspondent (54A)
Serial method involves testing one sample at a time, while cover method involves testing multiple samples together.
Serial method tests samples individually in sequence
Cover method tests multiple samples simultaneously
Serial method is time-consuming but more accurate
Cover method is faster but may lead to false negatives
Example: Serial method used in PCR testing, cover method used in pool testing
ISO is a set of international standards for various industries, while Swift is a messaging network used by financial institutions.
ISO stands for International Organization for Standardization, which sets standards for various industries such as quality management (ISO 9001) and information security (ISO 27001).
Swift (Society for Worldwide Interbank Financial Telecommunication) is a messaging network used by financial i...
Waterfall is a linear sequential approach to software development, while Agile is an iterative and incremental approach.
Waterfall follows a sequential process, while Agile allows for flexibility and adaptability.
Waterfall requires all requirements to be defined upfront, while Agile allows for changes throughout the project.
Waterfall has a fixed timeline and budget, while Agile focuses on delivering value in short itera...
I applied via Approached by Company and was interviewed in Jan 2024. There was 1 interview round.
Securing a web API involves implementing authentication, authorization, and encryption.
Implement authentication to verify the identity of the client accessing the API
Implement authorization to control what actions the client can perform
Use HTTPS to encrypt the communication between the client and the API
Implement rate limiting to prevent abuse and protect against denial-of-service attacks
Apply input validation and outp...
Improving web API performance involves optimizing code, caching, using asynchronous programming, and scaling infrastructure.
Optimize code by reducing unnecessary database queries, using efficient algorithms, and minimizing network calls.
Implement caching to store frequently accessed data and reduce the load on the server.
Use asynchronous programming to handle multiple requests concurrently and improve responsiveness.
Sc...
Delegates are function pointers used to encapsulate methods, while generics are used to create reusable code for different data types.
Delegates are used to create callbacks and event handlers.
Generics allow the creation of classes, methods, and interfaces that can work with different data types.
Delegates can be used to define and invoke methods dynamically at runtime.
Generics provide type safety and eliminate the need ...
Generics can be used in projects to create reusable code that can work with different types.
Generics can be used in data structures like lists, dictionaries, and queues to store and retrieve different types of data.
Generics can be used in algorithms and functions to work with different types of inputs and outputs.
Generics can be used in database operations to handle different types of data.
Generics can be used in user ...
Delegates are used to create references to methods, allowing methods to be passed as parameters or stored as variables.
Delegates provide a way to achieve callback functionality in C#.
Delegates can be used to implement event handling.
Delegates enable loose coupling and separation of concerns.
Delegates can be used to create and invoke anonymous methods.
Delegates can be used to implement the observer pattern.
Join query using Entity Framework
Use the LINQ query syntax to perform joins in Entity Framework
Use the 'join' keyword to specify the join condition
Use 'into' keyword to create a group join
Use 'on' keyword to specify the join condition
Use 'equals' keyword to define the equality condition
Dependency injection is a design pattern that allows objects to be loosely coupled by providing their dependencies externally.
Dependency injection is a way to achieve inversion of control in software development.
It helps in creating loosely coupled and modular code.
In dependency injection, the dependencies of a class are provided externally rather than being created within the class itself.
This allows for easier testin...
To handle large number of records in a web API, you can use pagination, streaming, or compression techniques.
Implement pagination to retrieve records in smaller chunks
Use streaming to process and return records in real-time
Apply compression techniques like GZIP to reduce the size of the response
Consider caching strategies to improve performance
The project structure in Dot Net Core typically consists of folders for source code, configuration files, and dependencies.
The source code is usually organized into folders based on the application's modules or layers, such as Controllers, Models, and Views.
Configuration files like appsettings.json store application settings and connection strings.
Dependencies are managed using a package manager like NuGet, and their v...
Entity Framework provides a higher level of abstraction, simplifies database operations, improves productivity, and reduces code complexity.
Entity Framework abstracts away the underlying database, allowing developers to work with a higher level of abstraction.
It simplifies database operations by providing an object-oriented approach to data access.
Entity Framework improves productivity by reducing the amount of code ne...
What people are saying about Infosys
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.
based on 1.2k interviews
Interview experience
based on 38.4k reviews
Rating in categories
Technology Analyst
56k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50.2k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
System Engineer
39.4k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.7k
salaries
| ₹5.2 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.5k
salaries
| ₹6.2 L/yr - ₹17.1 L/yr |
TCS
Wipro
Cognizant
Accenture