Coding Round

Two coding questions were given, and candidates were asked to explain their approach on paper.

Substring Problem Merge Intervals Problem

Technical Interview .NET Questions What is .NET? Difference between Value Type and Reference Type What is Span<T>? What is AutoMapper? What is Dependency Injection? Difference between Singleton, Scoped, and Transient services Difference between a Class and an Instance Explain the N+1 Query Problem How would you handle API security issues? SQL Questions What is SQL? What are Window Functions? Difference between RANK() and DENSE_RANK() What is a Cursor? What is a Stored Procedure? What is a View? Write a query to find the 4th highest salary using RANK() Azure Questions What is Azure? Explain or write an Azure Pipeline. How is storage allocated in Azure? Angular Questions Types of Components in Angular What are Directives? How is SPI used in Angular?

Overall: The interview focused on core .NET concepts, SQL fundamentals, Azure basics, Angular concepts, and problem-solving skills.