QUESTIONS SEGREGATED BY COMPANY/ORGANIZATION


QATAR AIRWAYS (CTK Project)
Description: Internal system for managing customer incentive programs (FAM trips, flight tickets)
Total Questions: 7
1. Project architecture with Azure, Angular, .NET Core
2. RESTful API development with .NET Framework 4.5 and ASP.NET Core
3. Angular UI implementation (v11-15)
4. SQL Server and stored procedures
5. Azure DevOps for tracking and CI/CD
6. Repository pattern with DI
7. GitHub Copilot usage for accelerated development

TCS (20+ LPA)
Description: Full Stack .NET + AI Interview
Total Questions: 27
1. Explain Singleton lifetime in Dependency Injection with a real-time example.
2. Explain SOLID principles.
3. Difference between Hashtable and Dictionary.
4. Primary vs Secondary Constructor in C#.
5. Convert.ToString() vs ToString()
6. First(), FirstOrDefault(), Single(), SingleOrDefault() differences
7. Middleware + write custom middleware
8. GET vs POST - which is better and why
9. API performance optimization
10. Pagination in .NET Core
11. Filters in MVC
12. IActionResult vs ActionResult
13. Why API is slow and how to fix it
14. Explain Al integration in your project
15. How to call an Al API in .NET
16. What is Prompt Engineering
17. Design Al-powered chatbot in .NET
18. Chatbot giving wrong answers - how to fix
19. You already have authorization applied to an API, but inside the API method, you need to bypass authorization for a specific condition. How will you implement it in real-time?
20. You have int a = 1. At runtime, you want to assign dynamically like var e = a. Which data type would you use and why?
21. Your MVC API returns JSON like { 'id': 1, 'name': null, 'age': 25}. How will you ignore null values in the response?
22. SELECT * INTO newtable FROM oldtable WHERE 1 = 0;
23. SELECT * INTO newtable FROM oldtable WHERE 1 = 1;
24. Can you write pagination in SQL?
25. Insert values like Male = 'M', Female = 'F', Other = 'O'. Write SQL query.
26. While creating a UserDetails table, set default age = 18. Write SQL query.
27. Find the 3rd highest tanker level of water and also find duplicate tanker names.

QBURST
Description: Microservices architecture focus
Total Questions: 22
1. Brief your technical exposure and recent projects at a high level.
2. How many microservices do you have and what does each one handle?
3. Does each microservice have its own database or do they share one?
4. How do your services share data across service boundaries — APIs or events?
5. Why are you directly querying the DB instead of calling the API of that service?
6. Could you replicate or cache the master data in the dependent service to avoid cross-DB joins?
7. What about using Redis cache for master data instead of direct DB joins?
8. Which message broker are you using for inter-service communication?
9. Explain how Azure Service Bus works — publisher, consumer, retry, and dead-letter queue.
10. Do you have experience with other message brokers like RabbitMQ or Kafka?
11. What authentication mechanism does your application use?
12. What is your experience working directly with Azure AD / Entra ID?
13. Walk through the authentication flow — how does a user log in and get a token?
14. Do you have an API Gateway in place for cross-cutting concerns like auth, routing, and rate limiting?
15. What is a DDOS attack and how would you mitigate it at the API level?
16. How is your application deployed — AKS, App Service, or something else?
17. Do you understand how Kubernetes works — pods, nodes, services, ingress controller?
18. In a Kubernetes deployment how does service discovery work?
19. Do you know the OAuth 2.0 Authorization Code Flow and PKCE Flow — what is the difference?
20. What are the minimum configurations needed to register a client application with Azure AD?
21. What are the 3 parts of a JWT token and what is the role of each part?
22. From the API side how do you validate a JWT token — what specific claims do you check?

ENVESTNET
Description: Senior .NET Developer Interview - Design Focus
Total Questions: 9
1. Self Intro
2. Describe current project + architecture.
3. Design parking lot system: Multiple regions, 2-wheeler + 4-wheeler spot types, Pluggable allocation strategies
4. What is middleware in .NET Core? Built custom middleware in project?
5. How DI works? Three lifetimes — explain each.
6. Why use Singleton instead of Static class? What's difference?
7. Website load time very high. Steps to investigate + fix?
8. Design FileUploader class: Support JSON + CSV now, Extensible for future formats, Upload to Azure Blob
9. Which SOLID principles does your FileUploader design follow? Explain each.

DBIZ.AI
Description: Factory Pattern and DI Deep Dive
Total Questions: 15
1. File Upload Progress: Frontend wants to show processing progress as percentage. How achieve it?
2. Is polling every 15–20 seconds efficient for task that takes ~15 minutes?
3. Factory Pattern Output: What is output you expecting when you call factory class?
4. DI Constructor Output: You request IEmployeeService in constructor-based DI. What do you get back?
5. Factory vs DI: Why would you choose DI over Factory? They both do same thing
6. Parameterized DI: Have you heard of parameterized dependency injection? Doesn't that make factory pattern redundant?
7. EF Core Fetch by PK: DbContext, table Employees. Want employee with Id = 5. How do you do it?
8. Select vs Where: What is difference between Select and Where in LINQ?
9. Find Method: What is Find method? When use Find vs Where?
10. EF Core Isolation Levels: What are isolation levels supported?
11. AsNoTracking: What does AsNoTracking() mean?
12. DI Lifetimes: What are lifetimes of object in DI? When would you use which one?
13. LINQ GroupBy: Write LINQ query to get employee count grouped by department.
14. Race Condition: What is race condition? How do you prevent it?
15. Unit Testing Fundamentals: What is most fundamental thing in unit testing?

VIRTUSA
Description: Lead Software Engineer (10+ YOE) - Multiple Rounds
Total Questions: 38
1. SQL: Find employees who have worked on at least 2 projects
2. SQL: Identify the longest duration project
3. SQL: Return employee names along with the longest project they worked on
4. SQL: Find CustId, CustName, OrderCount for customers having more than 3 orders
5. SQL: Brand, TotalQuantity sold (include brands with zero sales)
6. C#: Generate all combinations and permutations of 'ABC'
7. C#: Output of overriding vs virtual methods
8. C#: Sort array {4,0,7,5,2,8,0,0,0}
9. C#: Find duplicate characters in a string
10. C#: What is Concurrent Programming?
11. C#: What is GraphQL and why is it used?
12. .NET 6 vs .NET 8 differences
13. var vs dynamic differences
14. Task vs Thread differences
15. async vs await differences
16. Explain static class
17. Explain middleware (ASP.NET)
18. Explain temp table usage
19. Can temp tables be used in functions?
20. Can temp tables be used in triggers?
21. Exception handling in C#, React, SQL
22. REST API vs traditional API
23. API versioning implementation
24. ASP.NET Filters
25. Custom middleware creation
26. Alternative for useEffect in React
27. public static string MergeStrings(string s1, string s2) - implementation
28. const object = { who: 'World', greet() { return `Hello, ${this.who}!`; }, ... } - output
29. (function immediateA(a) { ... })(); - output
30. const fruits=['jackfruit','mango','apple']; - modify array
31. a= 10; var a; console.log(a); - output?
32. Write a function to convert camelCase to snake_case
33. Flatten nested array
34. let a = '3' + 3 + 3 = ?
35. let b = 3 + '3' + 3 = ?
36. let c = 3 + 3 + '3' = ?
37. let d = '3' + 3 - 3 = ?
38. let e = 3 + 3 + 3 = ?

EPAM
Description: Technical Interview - Core .NET Focus
Total Questions: 28
1. .NET Core and .NET Framework differences, runtime, hosting model, performance implications
2. Dependency Injection concepts and practical implementation patterns
3. ILogger interface and recommended logging practices
4. ASP.NET middleware pipeline behavior
5. Short-circuiting behavior in middleware
6. JWT authentication, token validation, middleware configuration
7. Model binding and model validation
8. IDisposable pattern and resource management
9. Async/await and Task vs Thread concepts
10. Parallel.ForEach and multithreading scenarios
11. ref vs out semantics and use cases
12. Exception handling with try-catch-finally
13. LINQ-based grouping and projection
14. DRY, clean coding guidelines, maintainable design
15. Decorator pattern with practical examples
16. Singleton and Factory patterns
17. Code First approach and Code First Migrations
18. EF's tracking vs no-tracking queries
19. WHERE vs HAVING and SQL query execution order
20. SQL NULL values, comparisons and function behavior
21. UPDATE query using CASE expression
22. AAA (Arrange, Act, Assert) pattern
23. Mocking frameworks and isolating dependencies
24. Unit tests vs integration tests
25. Azure Functions, serverless execution, triggers, bindings
26. Azure Key Vault, secrets management
27. Application Insights for observability
28. Azure Application Gateway fundamentals

CAPGEMINI (5 YOE)
Description: Fundamentals Focus
Total Questions: 21
1. Explain D from SOLID with written example
2. Any design pattern which you have implemented. (Singleton explained)
3. How to pass data between controllers
4. Automapper
5. Bundles.config
6. How to implement caching
7. Difference between list and dictionary
8. How to implement security
9. JWT token
10. Return type in API
11. How to handle exception on application level
12. SQL query for 2nd highest salary
13. SQL query for deletion of one of the duplicate records
14. How can we optimize query performance?
15. How to create directory in C#?
16. Angular interpolation binding
17. Pipes, impure and pure pipes
18. Give duplicates from a list using LINQ
19. SQL Joins
20. select * from Employees where 1=0. What is the output?
21. Abstract class vs Interface

PWC (3.6 YOE)
Description: Fundamentals and Practical Experience
Total Questions: 30
1. How can you implement synchronous functionality to the application?
2. What is DI?
3. What is middleware?
4. What is the difference between http and https?
5. What are the different types of logs?
6. Where will you save your log file in server?
7. How will memory management handle in dot net?
8. When you trying to hit the Api, it is unable it hit what are the steps you will follow to resolve the issue?
9. How will you provide security to your application?
10. What are the design patterns you used in your application?
11. What is singleton and how will you implement?
12. What are the steps you will follow to achieve single ton class?
13. How can you access from two different servers?
14. How do you handle performance optimization in APIs?
15. How will pass data from parent to child component? (React)
16. What is state and props?
17. If UI page is loading very slowly what are steps you will take to increase page loading speed?
18. What is code splitting?
19. What is redux?
20. What is Context Api?
21. What is clustered and non-clustered indexes?
22. What are joins what is self join?
23. What is ACID properties?
24. What is the use of Clustered and Non-clustered indexes?
25. How to do see the sql profiling do you have any experience?
26. How will be the code review standards happening in your project?
27. What is the deployment process you are following?
28. How you performing code coverage check?
29. What is service bus?
30. What is function app?

EY (4+ YOE)
Description: Technical and Architectural Assessment
Total Questions: 31
1. Tell me about yourself, your project, and your roles & responsibilities
2. Have you worked on any web application in .NET Core?
3. What is IoC (Inversion of Control)?
4. Types of Dependency Injection
5. Difference between IoC and Dependency Injection
6. What happens if you register wrong lifetime?
7. Scoped inside Singleton issue
8. Why do we use Dependency Injection? What problem does it solve?
9. What are Extension Methods? Have you used them?
10. Difference between abstract and virtual keyword
11. What is Early Binding and Late Binding?
12. What is Content Negotiation in Web API?
13. JSON vs XML response for different clients
14. What is Partial View in MVC? Types of Partial View? Can we directly load it?
15. What is View Component?
16. Difference between Model and ViewModel
17. How do you authenticate and authorize Web API?
18. What is Filter in MVC and why use it instead of controller?
19. Why use Action Filter when we already have controller methods?
20. Conventional Routing vs Attribute Routing
21. How do you validate input in Web API?
22. What is Middleware and why do we use it?
23. What is Custom Middleware and why did you use it in your project?
24. Difference between UNION and UNION ALL
25. What is CTE? Have you used it?
26. What is 'Transition' in SQL?
27. What are ACID properties?
28. What is Trigger in SQL?
29. Difference between INSERTED and DELETED
30. Transaction scenario (partial insert of 500 records)
31. What is COMMIT and ROLLBACK?

SOLERA (Senior Position)
Description: Advanced System Design
Total Questions: 6
1. How would you design and build a TinyURL/ShortURL application in a pure on-premise environment?
2. Explain overall architecture, database design, scalability, security for Short URL generation
3. Interviewer asked about RAG (Retrieval-Augmented Generation)
4. AI/ML algorithms used in enterprise applications
5. embedding models, vector search, similarity algorithms
6. on-premise RAG architecture

LTM (7+ YOE, Azure + .NET)
Description: Azure and .NET Deep Dive
Total Questions: 8
1. Deployment step to deploy legacy application in azure
2. Triggers of Azure function
3. Types of blob storage
4. What is host.json in function apps and its usage?
5. Storage of logs in Application Insights
6. Middleware vs filters
7. Fat controller
8. How to validate data model and error code when model validation

Generic Interview Questions (Multiple Companies)
Description: Questions asked across multiple interview rounds
Total Questions: 16
1. Tell me about a time when you handled a conflict in your team
2. How do you manage multiple projects at the same time and ensure deadlines are met?
3. What would you do if your team member is not performing?
4. Decision making and trade-offs
5. Scalability thinking
6. Debugging mindset
7. Could you share your experience working with RESTful APIs?
8. How did you ensure the quality and reliability of API development?
9. Could you enlighten me on the strategies for inter-service communication in microservices?
10. Can you describe the process of query tuning in SQL Server?
11. How would you approach partitioning of large tables?
12. Dependency Injection - Types
13. How will you handle the CORS Issues?
14. API End point consumed by Multiple Applications (APIM)
15. I don't want to write code but I want to validate each request
16. Did you work on Middleware - Explain me the scenario


This was part of Interview Preparation With Bipin — Let’s Crack It!

Comments

Popular posts from this blog

Angular Architecture

Why should I learn Angular?

Solid Principle