i
Infosys
Work with us
Filter interviews by
I have experience working with various databases including SQL Server, Oracle, and MySQL.
I have worked with SQL Server extensively and have experience in writing complex queries and stored procedures.
I have also worked with Oracle and have experience in creating and managing tables, indexes, and views.
I have used MySQL for smaller projects and have experience in designing and implementing databases.
I am familiar w...
Interfaces are a way to define a contract between classes, specifying methods and properties that must be implemented.
Interfaces allow for polymorphism and loose coupling
Classes can implement multiple interfaces
Interfaces can inherit from other interfaces
Examples include IDisposable, IEnumerable, and IComparable
The components of .NET Framework include Common Language Runtime, Class Library, and ASP.NET.
Common Language Runtime (CLR) - manages memory, security, and execution of code
Class Library - provides a set of reusable classes and types for building applications
ASP.NET - a web application framework for building dynamic web pages and web services
Other components include ADO.NET, Windows Communication Foundation (WCF), ...
Windows app dev is for desktops, web dev is for browsers.
Windows app dev is for desktop operating systems like Windows, macOS, and Linux.
Web dev is for browsers and can be accessed from any device with an internet connection.
Windows app dev uses GUI frameworks like Windows Forms or WPF.
Web dev uses web technologies like HTML, CSS, and JavaScript.
Examples of Windows apps include Microsoft Word and Adobe Photoshop.
E...
Stored procedures are precompiled SQL queries stored in the database, while functions are reusable code blocks that return a value.
Stored procedures are used for performing specific tasks or operations in the database.
Functions are used to encapsulate logic and can be called from SQL queries or other functions.
Stored procedures can return multiple result sets, while functions return a single value.
Stored procedure...
Application pool is a group of one or more worker processes, IIS is a web server, hosting app in dev env involves setting up IIS, abstraction focuses on hiding implementation details, encapsulation bundles data and methods together, optimizing database involves indexing and query optimization, check for application crashes in event logs or monitoring tools.
Application pool is a group of one or more worker processe...
Procedures are used to perform an action, while functions return a value.
Procedures do not return a value, functions do.
Procedures can have input and output parameters, functions only have input parameters.
Functions can be called from within SQL queries, procedures cannot.
Oops concepts in C# include inheritance, polymorphism, encapsulation, and abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Polymorphism allows objects to be treated as instances of their parent class.
Encapsulation hides the internal state of an object and only exposes necessary functionality.
Abstraction allows classes to define abstract methods that must be implemented b...
I appeared for an interview in Jan 2025.
Handling challenging situations requires effective communication, problem-solving, and adaptability to ensure successful outcomes.
Stay calm and assess the situation before reacting.
Communicate clearly with all stakeholders involved.
Identify the root cause of the issue to address it effectively.
Develop a plan of action and involve team members for input.
Be adaptable and open to feedback to improve the solution.
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Extension methods allow adding new methods to existing types without modifying the original type
Extension methods are static methods that can be called as if they were instance methods of the extended type
They are defined in static classes and must be in the same namespace as the extended type
They are commonly used to add functionality to existing types or interfaces without modifying them directly
Union combines and removes duplicates, Union All combines without removing duplicates.
Union removes duplicates from the result set, while Union All does not.
Union is slower than Union All because it has to perform an additional step to remove duplicates.
Union is used when you want to combine two result sets and remove duplicates, while Union All is used when you want to combine two result sets without removing duplicat...
Constructor chaining is the process of calling one constructor from another constructor within the same class.
Allows for reusing code and avoiding duplication
Can be achieved using 'this' keyword in the constructor
Example: public MyClass(int x) : this(x, 0) {}
CTE stands for Common Table Expressions, which is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
CTEs are defined using the WITH keyword in SQL.
They help improve readability and maintainability of complex queries.
CTEs can be recursive, allowing for hierarchical data querying.
Example: WITH CTE AS (SELECT * FROM table_name) SELECT * FROM CTE;
Example: WITH RECURSIVE CTE ...
A constructor is a special method in a class that is automatically called when an object of that class is created.
Constructors have the same name as the class they belong to.
They are used to initialize the object's state.
Constructors can be parameterized or default (no parameters).
Example: public class Person { public Person(string name) { this.Name = name; } }
Use bulk insert or batch processing to send large amounts of data through the database.
Use bulk insert operations provided by the database management system.
Consider using batch processing techniques to optimize performance.
Use stored procedures or parameterized queries for efficient data transfer.
I have used the MVC (Model-View-Controller) design pattern in my project.
Separates the application into three main components: Model, View, and Controller
Promotes code reusability, modularity, and maintainability
Example: ASP.NET MVC framework
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Characteristics include private constructor, static instance variable, static method to access instance, lazy initialization, and thread safety.
Example: public class Singleton { private static Singleton instance; private Singleton() {} public static Singleton getInstance() { if (instance == null) { instance = new Singlet...
Use LINQ to fetch data from the 'students' table in ascending order of 'studentid'.
Use LINQ query syntax or method syntax to retrieve data from the 'students' table.
Order the data by 'studentid' in ascending order using the 'OrderBy' or 'OrderByDescending' method.
Ensure that the LINQ query is executed against the database to fetch the data.
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
OOPs (Object-Oriented Programming) is a programming paradigm based on the concept of objects, which can contain data and code.
OOPs focuses on creating reusable code and organizing it into classes and objects.
Key concepts include encapsulation, inheritance, polymorphism, and abstraction.
Encapsulation involves bundling data and methods that operate on the data into a single unit.
Inheritance allows a class to inherit prop...
Routing is the process of selecting a path for network traffic to travel from source to destination.
Routing determines the best path for data packets to travel on a network
It involves making decisions based on routing algorithms and network protocols
Examples include IP routing in the internet and routing tables in routers
Clustered index physically orders the data in the table, while non-clustered index does not.
Clustered index determines the physical order of data in the table, while non-clustered index does not.
Clustered index is faster for retrieval of data, while non-clustered index is faster for retrieval of specific data.
Clustered index can only have one per table, while non-clustered index can have multiple per table.
Apti, reasoning and verbal communication
CLR stands for Common Language Runtime, it is the virtual machine component of Microsoft's .NET framework.
CLR is responsible for managing the execution of .NET programs.
It provides services such as memory management, exception handling, and security.
CLR compiles the intermediate language code into native code using Just-In-Time (JIT) compilation.
It allows different languages to be used within the .NET framework, as lon...
Kestrel is a cross-platform web server while IIS is a Windows-only web server.
Kestrel is a lightweight, open-source web server developed by Microsoft and optimized for ASP.NET Core applications.
IIS (Internet Information Services) is a full-featured web server developed by Microsoft for Windows servers.
Kestrel can be used as a standalone server or behind a reverse proxy like IIS or Nginx.
IIS provides additional features...
Oops concepts in C# include inheritance, polymorphism, encapsulation, and abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Polymorphism allows objects to be treated as instances of their parent class.
Encapsulation hides the internal state of an object and only exposes necessary functionality.
Abstraction allows classes to define abstract methods that must be implemented by sub...
The main difference between .NET and .NET Core is that .NET Core is a cross-platform, open-source framework while .NET is a Windows-only framework.
NET Core is cross-platform and can run on Windows, macOS, and Linux, while .NET is limited to Windows.
.NET Core is open-source and has a more modular design compared to the monolithic .NET framework.
.NET Core is optimized for microservices and containerized applications.
Both...
I applied via Referral and was interviewed in Jul 2024. There were 2 interview rounds.
I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.
Application pool is a group of one or more worker processes, IIS is a web server, hosting app in dev env involves setting up IIS, abstraction focuses on hiding implementation details, encapsulation bundles data and methods together, optimizing database involves indexing and query optimization, check for application crashes in event logs or monitoring tools.
Application pool is a group of one or more worker processes tha...
I appeared for an interview in Mar 2025, where I was asked the following questions.
SOLID principles are five design principles aimed at making software designs more understandable, flexible, and maintainable.
S - Single Responsibility Principle: A class should have one reason to change. Example: A class handling user data should not also handle logging.
O - Open/Closed Principle: Software entities should be open for extension but closed for modification. Example: Use interfaces to add new functionaliti...
In .NET, object data types include value types, reference types, and special types like dynamic and nullable.
Value Types: Includes primitive types like int, float, and struct. Example: int age = 30;
Reference Types: Includes classes, arrays, and strings. Example: string name = 'John';
Dynamic Type: Allows for dynamic typing. Example: dynamic obj = 10; obj = 'Hello';
Nullable Types: Allows value types to be null. Example: ...
Dependency Injection (DI) is a design pattern that promotes loose coupling and enhances testability in software development.
DI allows a class to receive its dependencies from an external source rather than creating them internally.
It improves code maintainability by reducing the dependency between components.
Example: Instead of a class instantiating a database connection, it receives the connection through its construc...
100% abstraction is theoretically unattainable in programming due to the need for some level of implementation detail.
Abstraction in programming allows hiding complex implementation details.
In .NET, interfaces and abstract classes provide abstraction but require some implementation.
Example: An interface 'IVehicle' defines methods like 'Drive()' without specifying how they work.
Complete abstraction would mean no impleme...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
The function of an object is to store data and behavior related to a specific entity in a program.
Objects store data in the form of properties
Objects can have methods which define behavior
Objects can be used to model real-world entities like cars, employees, etc.
Objects can be instantiated from classes or created dynamically
Procedure is a set of instructions that performs a specific task, while function returns a value.
Procedure does not return a value, while function does.
Functions can be called from within SQL statements, while procedures cannot.
Functions can be used in SELECT, WHERE, and HAVING clauses, while procedures cannot.
Example: CREATE PROCEDURE myProcedure AS ... vs CREATE FUNCTION myFunction() RETURNS ...
Example: EXECUTE myPro...
Aggregate functions perform a calculation on a set of values and return a single value.
Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.
They are commonly used in SQL queries to perform calculations on groups of rows.
For example, you can use the SUM function to calculate the total sales amount for a group of products.
readonly keyword is used in C# to declare that a field can only be assigned a value during initialization or in a constructor.
readonly keyword can only be used on fields, not properties.
The value of a readonly field can only be changed in the constructor of the class.
Using readonly fields can help ensure that certain values remain constant throughout the lifetime of an object.
What people are saying about Infosys
The duration of Infosys DOT NET Developer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 31 interview experiences
Difficulty level
Duration
based on 19 reviews
Rating in categories
Hyderabad / Secunderabad,
Chennai
+14-9 Yrs
Not Disclosed
Technology Analyst
55.8k
salaries
| ₹4.8 L/yr - ₹11.2 L/yr |
Senior Systems Engineer
53.7k
salaries
| ₹2.5 L/yr - ₹6.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