Database Developer (Freshers) Interview Experience At Media.net (Mumbai)
Summary
I completed three rounds of interviews for a Database Developer fresher position at Media.net in Mumbai, passing the online assessment and technical interview but not being selected after the final on‑site interview.
Full Experience
Media.net Database Developer Interview Experience (Fresher)
Interview Process
Round 1: Online Assessment
The online assessment consisted of DSA, SQL, and MCQs. Time : 45 Minutes and one laptop camera (which is usual) and one phone covering you and laptop has to be on all the time .
- DSA: One Heap/Max-Heap based problem.
- SQL: One query involving joins and data matching.
- MCQs: 15 questions covering:
- DBMS concepts
- SQL concepts
- Computer Science fundamentals
- DSA concepts
Result (after ~2 weeks): Passed
Round 2: Technical Interview
The interview started with a brief introduction, followed by questions on DBMS and SQL concepts and Resume questions .After that
-
SQL Questions:
- Find the employee with the highest salary along with the employee's name.
- Given redundant names and data, find the person X who has worked for the highest amount of time.
-
DSA Questions:
- Check whether a string is a palindrome.
- Find the first repeated character in a string.
Only pseudocode was expected for the DSA questions.
Result (after ~1 week): Positive Feedback - Passed
Round 3: Final Interview (Face-to-Face)
The company arranged the travel for the on-site interview.
The discussion included:
- Resume walkthrough
- Database normalization
- Database schema design
The main design question was to create a database schema for an Amazon-like application, including entities such as:
- Users
- Products
- Cart
- Orders
- User Settings
Final Result: Not Selected
Interview Questions (5)
Find Employee with Highest Salary
Given an employee table, retrieve the employee name and salary of the employee who has the highest salary.
Find Person with Maximum Work Duration
From a dataset containing redundant names and work history, identify the person (X) who has worked for the greatest total amount of time.
Palindrome Check
Determine whether a given string reads the same forward and backward.
First Repeated Character in String
Find the first character that appears more than once in the given string.
Database Schema Design for E‑Commerce Application
Design a relational database schema for an Amazon‑like application that includes entities such as Users, Products, Cart, Orders, and User Settings, describing primary keys, relationships, and necessary tables.