Initial Screening (30-45 mins): HR discusses your background, experience, and basic SQL concepts.
Technical Round (Online Test or Live Coding): Write SQL queries involving joins, aggregation, and optimization.
Final Round (System Design & Problem-Solving): Discuss database design, indexing strategies, and query optimization.
Interview questions [1]
Question 1
You have a table called Orders with the following structure. Write an SQL query to find the second highest order amount from the table.
How would you modify your query if there are duplicate order amounts and you still need the second highest unique amount?
I applied through college or university. I interviewed at MAQ Software in Jan 2021
Interview
Campus Placement
3 rounds - 2 Technical and 1 Technical + HR
It happened in 2 Days. One day for TR-1 and the other for rest two interviews.
The interviewer was friendly and guided me at one point.
Interview questions [1]
Question 1
TR-1
Basics of DBMS
SQL Queries
Basics about Data Structures
TR-2
1. Subset sum Problem.
2. Return Node address in a binary tree which has min difference b/w node value and given
value.
TR+HR-3
Why MAQ?
How do you develop yourself?
Coding Q : Given a sentence print all words in descending order of their length
I applied through college or university. The process took 2 days. I interviewed at MAQ Software in Dec 2020
Interview
1st technical round -
Coding question on a+b = k. Find all such pairs in array.
2nd technical round-
Coding question on find all combinations of a given array. Via backtracking.
3rd round -
General HR questions.