Myntra Data Engineer Interview Questions and Answers for Freshers

Interview preparation tips for other job seekers - I recently went through an interview process and wanted to share some insights and advice for others.

I was informed by the HR team that my interview would be conducted in person, with all rounds taking place on the same day, and that I would receive the results the same day. As a result, I traveled a considerable distance to attend.for the interview the told me to wait for the 3 hrs.

- During the interview, it was disheartening to find that the interviewer seemed uninterested in my responses. I was asked to write queries on paper, and while I was explaining them, the interviewer was preoccupied with reading emails and all other work. Despite providing correct answers, the experience felt dismissive.

After the interview, I was asked to wait for feedback. After waiting for two hours, the HR team informed me that my review was still in process and that they would follow up. After three days and multiple follow-ups, I was eventually told that I did not clear the round.

While I am okay with the outcome, I have a few requests for companies conducting interviews:

1.Respect Candidates' Efforts and Time: Please be considerate of the efforts and time candidates invest, especially those who travel long distances.
2. Clear Communication: If face-to-face interviews are required, particularly for final rounds, please communicate this clearly to avoid unnecessary travel and inconvenience.

I hope these points help improve the interview process for future candidates.

Topics to prepare for Swiggy Data Analyst interview:

• Advanced Excel
• SQL Server
• Python

Interview preparation tips for other job seekers - online interview

Interview preparation tips for other job seekers - DSA, LLD(very much important)

Round: Test
Experience: Algorithmic coding test was conducted on hackerank platform. Around 60 students gave online test. There were 4-5 algo questions to be done in 90 mins duration.

Tips: Try to do at least 2 questions.

Round: Technical Interview
Experience: First Interviewer asked me to introduce myself. Then he asked me questions on data structures & Algo. He asked me about tree data structures, why it is used, time complexities of various operations on tree, balancing of tree, AVL Tree. He asked me write AVL Tree insertion, deletion, update code. Then he jumps to BTree, B+Tree and asks me write code on paper for various operations. Questions were asked on indexing, various types of indexing, how it is used in databases, etc. Then he briefly asked about the project I done in my internship.


Round: Technical Interview
Experience: Interviewer asked me how was my 1st round, I said it was great. He first asked me introduce myself. Then he asked about my projects mentioned in my resume. I done a project in machine learning on spam webpage detection. He was interested in that. He asked me what language, libraries I used to implement that project. Then he gave me real time scenario to predict whether an item is explosive or not. Then I approached this problem and asked information related to problem. He was impressed by the approach I target the problem. He asked me what machine learning model will be best and what are their pros and cons. Then he asked me question that given 100 sorted linked lists, you have to merge them and return single sorted linked list. I gave 3-4 solutions with their time & space complexities.


Round: HR Interview
Experience: Interviewer asked me common HR questions like tell me about yourself, my family background, why do you want to join the company, what impact you can make in Snapdeal, why should we hire you. After that he congratulated me for the role of SDE at Snapdeal. I was very happy at that moment.

All the 5 students cleared this round.

Skills: SQL, ML, Algorithms And Data Structures, Python, Basic C/C++
College Name: IIT Guwahati