RejectedData Engineer at Media.net
- Difficulty
- Process took
- 0-1 Weeks
- Rounds
- 1
- Format
- Remote
- Applied via
- Job Portal
How it went
Ready for variations of standard DSA problems rather than only the textbook ones Practice SQL aggregations, joins, and groupings thoroughly
What they would tell you
Ready for variations of standard DSA problems rather than only the textbook ones Practice SQL aggregations, joins, and groupings thoroughly
How to prepare
Overall, I found the interview fairly easy, with questions covering standard DSA and SQL topics. Despite solving everything, I was not selected.
Round by round
- 1
Technical Interview 160 min
The first problem was a variation of the Next Greater Element 2 problem, the scenario given was slightly different from the classic problem, but I leveraged the same concept and solved it successfully The final DSA question was classic Climbing Stairs problem, solved it using dynamic programming and explained my approach Next, moved on to SQL question Tables provided CUSTOMER(customer_id, name, email) PRODUCT(product_id, price) ORDERS(order_id, customer_id, product_id, date, discount_key) DISCOUNT(discount_key, discount) Questions asked:
- Find the bottom 5 orders (based on some criteria like price or date).
- Calculate the average product value per customer week-wise. I was able to write queries for both questions efficiently, handling joins, groupings, and aggregations.
What came up
A candidate-reported account, lightly edited. Interview processes change by team and date.