i
Iris Software
Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Normal questions about work exp
I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.
Stored procedure is a precompiled set of SQL statements that can be executed multiple times.
Stored procedure is stored in a database and can be called by applications.
It can accept input parameters and return output parameters.
It can be used to simplify complex SQL queries and improve performance.
It can be used to enforce security by granting permissions to execute the procedure instead of individual SQL statements.
Exa...
I applied via Recruitment Consultant
I applied via Approached by Company and was interviewed in Aug 2023. There was 1 interview round.
I appeared for an interview before Apr 2024, where I was asked the following questions.
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...
I applied via Campus Placement and was interviewed before Jul 2020. There were 5 interview rounds.
The telecom market in India is highly competitive and rapidly growing.
India has the second-largest telecom market in the world
The market is dominated by major players like Jio, Airtel, and Vodafone Idea
The introduction of 4G technology has led to a surge in data consumption and mobile internet usage
The government's Digital India initiative is driving growth in the sector
The market is expected to continue growing with t
GSM and CDMA are two different technologies used for mobile communication.
GSM stands for Global System for Mobile Communications and uses SIM cards for authentication.
CDMA stands for Code Division Multiple Access and uses spread spectrum technology for communication.
GSM uses time division multiplexing for sharing the frequency band while CDMA uses code division multiplexing.
GSM is widely used in Europe and Asia while C...
2G is a second-generation wireless technology while 3G is a third-generation wireless technology.
2G offers voice and text services while 3G offers voice, text, and data services.
3G has faster data transfer rates than 2G.
2G uses circuit-switched technology while 3G uses packet-switched technology.
3G allows for video calling and mobile internet access while 2G does not.
3G networks are more expensive to build and maintain
Basic skills of creating presentation and excel
For presentations, use a clear and concise structure with visual aids
For Excel, understand basic formulas and functions, and use formatting to make data easy to read
Practice using templates and experimenting with different design options
Learn keyboard shortcuts to save time and increase efficiency
Use charts and graphs to illustrate data in a visually appealing way
GPS works by using a network of satellites to triangulate the position of a receiver on Earth.
GPS satellites orbit the Earth and transmit signals to GPS receivers on the ground.
The receiver uses the signals from multiple satellites to determine its location through a process called trilateration.
GPS can provide accurate location information, speed, and direction.
GPS is used in navigation systems, tracking devices, and ...
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 5 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