PromptCloud Data Engineer Interview Questions and Answers for Experienced

Round: Test
Experience: A bit difficult but sensible way to get started with the selection procedure. Questions purely attack the algorithmic and stastitic aspects.
Tips: Get yourself ready with conceptual clartity regarding algorithms and stastics . Don't be ambitious to attempt all the questions, completely solving one problem would be more than enough for getting through this level.
Duration: 120 minutes
Total Questions: 3

Round: Technical Interview
Experience: Believe me. You never feel inferior, it's really interactive and very friendly. Interviewer gave me a few chances and hints whenever i've gone wrong. Overall interview experience was awesome.
Tips: If you're up to this round, they believe you have the potential. So don't panic if you are unable to answer their questions. Just tell them which aspects which you are comfortable with and they will proceed correspondingly, Just be honest whatsoever.

Skill Tips: Prefer having some revision about the above skills before undergoing the selection process.
Skills: Math Puzzles, Algorithmic Approach To Problem Solving, Data Structures
Duration: 2months
College Name: IIT Madras
Funny Moments: Receiving the offer letter from HR official who visited our campus :)

Round: Resume Shortlist
Experience: Sent resume to an HR through Linkedin and got the call for interview

Round: Technical Interview
Experience: Had 3 rounds of technical interviews with Product Owner, Product Manager and VP Product. Most of the questions were related to maths, statistics and a few on machine learning. Even though I did not have much background on these, I was asked to give my inputs and try to find a solution. We discussed recommendation engines for Quora, Linkedin and e-commerce websites. Then they asked me how can we remove the bias that comes in the practo ratings of the doctors due to feedback from various channels. How can we identify if the customer is booking an appointment by looking at reviews or ratings? How can we identify spam reviews before publishing them? How can we build a product which can help users write a better quality review? Most of the questions were related to data science and how we can improve the products using data. The data analyst role for which I was being interviewed, was a first of its kind role in Practo. The JD was to basically work with the product team and help them in improving products, building new features etc. using data science/ data analytics.

Skills: Product Sense, Attitude, Data Science, Data Analysis, Basics Of Machine Learning
College Name: IIT Madras
Motivation: being the leader of the healthcare industry, high growth startup, opportunity to solve interesting problems using data

Round: Test
Experience: There was Pool Campus Placement of  4 Colleges together(NIT Jalandhar,NIT Hamirpur ,Candigarh University and CGC Landran ) at Chandigarh University.Written test was taken on Hacker Rank. There were 5 Coding Questions of Linklist , Dynamic Programming,Priority Queues etc . 
You didn't have to do All the questions (3 can get you to the next round).

One thing that need to be beware of is that on Hacker Rank Your Draft is Saved every second(or so). So don't copy from the internet and just paste there(they will get to know).
Tips: Make sure you practice lot of Algorithms.
Duration: 120 minutes
Total Questions: 5

Round: Problem Statement
Experience: Only 8 Students were selected for this round
20 mins were given for it
and afterwards each student had personal discussion(10 mins) with them to explain their schema .
3-4 Questions were also asked related to your schema and how to perform a particular query
Tips: You should Be Through with DBMS
Make sure there is no redundant table and Primary keys are marked

Round: Technical Interview
Experience: 2 were selected for the Interview
Firstly they make you very Comfortable and ask how were the previous Rounds.
Then they asked about the two questions of First Round and my approach 
Then couple of questions on The design that was made Earlier.
Then there were questions on How Internet Works ,gcc,Linux,git,sql.

Then the Interviewer asked if I have any question
I asked about (as the work on doctor's app) how they know the credibility of a doctor which is enlisted in their app.
Interviewer was really Impressed by the question and told me all about it with all details.


Both were selected
Tips: Be cool in the Interview
Think Loudly and Interact with them well.
If they want you to ask any question ,it should not be related to technical stuff ,it should be related to the company

College Name: NIT JALANDHAR

Skills:
College Name: NA

Interview preparation tips for other job seekers - Study core JS concepts and be strong in react fundamentals

Topics to prepare for Vegrow Data Analyst interview:

• Guess Estimate
• SQL