i
Iris Software
Filter interviews by
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Deep dive into .NET Core and Angular
NET Core is a cross-platform, open-source framework for building modern, cloud-based, internet-connected applications.
Angular is a popular front-end framework for building dynamic web applications.
Understanding the architecture, features, and best practices of both .NET Core and Angular is essential for developing robust and scalable applications.
Integration of .NET Core backend with...
I appeared for an interview before Feb 2024.
What people are saying about Iris Software
I applied via Job Portal and was interviewed before Aug 2023. There were 2 interview rounds.
Iris Software interview questions for designations
I applied via Naukri.com and was interviewed in Jul 2021. There were 3 interview rounds.
ACID properties are a set of properties that ensure database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single, indivisible unit of work.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent transactions do not interfere with each other.
Du...
Index is a database structure that improves the speed of data retrieval. Types include clustered, non-clustered, and full-text.
Index is a data structure that improves query performance by allowing faster data retrieval.
Clustered index determines the physical order of data in a table.
Non-clustered index is a separate structure that stores a copy of the indexed columns and a pointer to the actual data.
Full-text index is ...
Temp tables are used to store temporary data during a session. There are two types: local and global.
Local temp tables are only accessible within the session that created them.
Global temp tables are accessible to all sessions and are prefixed with ##.
Temp tables are automatically dropped when the session that created them ends.
Temp tables can improve performance by reducing the need for expensive queries or joins.
Query optimization involves identifying and improving the performance of database queries.
Identify slow queries using profiling tools
Analyze query execution plans to identify bottlenecks
Optimize queries by rewriting them or adding indexes
Use caching to reduce the number of queries
Regularly monitor and tune the database for optimal performance
I applied via Naukri.com and was interviewed in Sep 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Feb 2021. There were 5 interview rounds.
Design patterns are reusable solutions to common software design problems. They include creational, structural, and behavioral patterns.
Design patterns are reusable solutions to common software design problems.
They provide proven solutions to recurring design problems.
Design patterns can be categorized into creational, structural, and behavioral patterns.
Creational patterns deal with object creation mechanisms.
Structur...
CTE and temp tables are used to store intermediate results in SQL queries.
CTE stands for Common Table Expression and is defined within a query.
Temp tables are created in the tempdb database and can be accessed across sessions.
CTEs are generally faster and more readable than temp tables.
Temp tables are useful for complex queries with multiple steps or when data needs to be manipulated.
CTEs are useful for recursive queri
Asynchronous programming in .NET allows for non-blocking execution of code, improving performance and responsiveness.
Async and Await keywords used to implement asynchronous programming
Allows for parallel execution of multiple tasks
Improves performance and responsiveness of applications
Examples include web applications, file I/O operations, and database queries
Threading in .NET allows for concurrent execution of code, improving performance and responsiveness.
Threading allows for multiple threads of execution to run concurrently
Thread class is used to create and manage threads
Thread synchronization is important to prevent race conditions and deadlocks
Async/await is a newer approach to concurrency in .NET
TPL (Task Parallel Library) provides higher-level abstractions for concur
Performance tuning of SQL stored procedure involves optimizing query execution time and reducing resource usage.
Identify and optimize the most resource-intensive queries
Use appropriate indexing and partitioning techniques
Minimize network round trips and data transfers
Avoid using cursors and temporary tables
Use query hints and plan guides to influence query execution plan
Regularly monitor and analyze query performance u...
based on 5 interviews
1 Interview rounds
based on 86 reviews
Rating in categories
Senior Software Engineer
599
salaries
| ₹10 L/yr - ₹32 L/yr |
Technical Lead
597
salaries
| ₹15 L/yr - ₹36.5 L/yr |
Senior Engineer
415
salaries
| ₹9.5 L/yr - ₹32 L/yr |
Senior Technology Engineer
322
salaries
| ₹11.2 L/yr - ₹33 L/yr |
Senior Technical Consultant
250
salaries
| ₹10.6 L/yr - ₹30 L/yr |
Xoriant
Photon Interactive
CitiusTech
HTC Global Services