Software Developer

You are given an array of integers 'ARR' of length 'N' and an integer Target. Your task is to return all pairs of elements such that they add up to Target.

Note:

We cannot use the element at a given index twice.

Follow Up:

Try to do this problem in O(N) time complexity. 

Write a query to find the second-highest salary from the Employee table.

Explain the difference between method overloading and method overriding. (Learn)

How is dependency injection implemented in ASP.NET Core?

How is dependency injection implemented in ASP.NET Core?

How does dependency injection work internally in ASP.NET Core? Can you implement a basic IoC container? 

What is the difference between a clustered and a non-clustered index? How many of each can a table have? (Learn)

How would you design a high-traffic REST API that handles millions of requests per day?

Write a SQL query to retrieve the top 3 highest-paid employees in each department using ROW_NUMBER() or RANK() with PARTITION BY.

Explain the difference between Task, Thread, and ThreadPool.

Given a string input of length n, find the length of the longest substring without repeating characters i.e return a substring that does not have any repeating characters.

Substring is the continuous sub-part of the string formed by removing zero or more characters from both ends.

Design a mini URL shortener.

• Tell me about yourself beyond what's mentioned in your resume.
• If we hire you, how will you contribute to our company’s vision?
• Have you ever taken a technical risk or made an independent decision? What was the outcome?
• What motivates you to work—money, learning, growth, or the team environment?
• Do you understand how billing or project costing works in software services or product companies?