Interview experience

Media.net · Data Engineer · New Grad

Community-sourced A factual summary of an interview experience shared publicly outside interviewd.

Sep 28

Rejected

Overall Experience

The process had an online assessment, a technical interview, and a final in-person discussion. The candidate passed the first two rounds before receiving a final not-selected decision.

3 rounds

Posted by interviewd

Interview Process (3 rounds)

Round 1 of 3: Online Assessment

45 min

Question 1

Medium

Solve a heap or max-heap problem.

Experience

The assessment also included one SQL query involving joins and data matching, plus 15 multiple-choice questions on DBMS, SQL, computer science fundamentals, and DSA. The candidate passed this round.

Question 2

Medium

Write a SQL query involving joins and data matching.

Experience

The exact data and expected query were not provided.

Question 3

Medium

Answer 15 multiple-choice questions on DBMS, SQL, computer science fundamentals, and DSA.

Experience

The candidate passed the assessment; individual questions were not listed.

60 min

Question 1

Medium

Find the employee with the highest salary and return the employee's name.

Experience

The round included DBMS and SQL concepts and resume questions. The candidate passed and received positive feedback.

Question 2

Medium

Given redundant names and data, identify the person who had worked for the longest time.

Experience

The specific data representation was not provided.

Question 3

Medium

Determine whether a string is a palindrome.

Experience

Pseudocode was expected for this DSA question.

Question 4

Medium

Find the first repeated character in a string.

Experience

Pseudocode was expected for this DSA question.

60 min

Question 1

Medium

Design a database schema for an Amazon-like application.

Experience

The proposed schema was to include users, products, cart, orders, and user settings. The discussion also covered a resume walkthrough and database normalization. Travel was arranged for this in-person final round; the candidate was not selected.

Sort by:

Loading comments…