Hevo Data Interview Questions and Answers

Q1. Coding question: Find the longest consecutive increasing sequence in an array
Ans. 
Find the longest consecutive increasing sequence in an array of strings.
• Iterate through the array and keep track of the current consecutive sequence length

• Update the longest consecutive sequence length as you iterate

• Return the longest consecutive sequence found
Answered by AI
Add your answer
Q2. Coding question: Find the 2nd lowest and 2nd highest elements in an array
Ans. 
Find 2nd lowest and 2nd highest elements in an array of strings
• Convert the array of strings to an array of integers for comparison

• Sort the array in ascending order to find the 2nd lowest element

• Sort the array in descending order to find the 2nd highest element
Answered by AI
Add your answer

Q1. Submit a 2-3 minutes self made video covering the topics: (a) Journey from childhood to college (b) Why do you think you are a good fit for this role? (c) Accomplishments in college other than general acad...read more
Add your answer

Two assignments were given which included instructions to solve those assignments.

1. First assignment involved creating a data pipeline to transport a Google Sheet data (provided by them) into Snowflake data warehouse.

2. Second assignment involved hosting a website using docker CLI. The steps and the webpage to be hosted were provided but some intentional errors were added. We had to resolve those errors and submit the output.

Q1. Explain your journey from childhood to your college.
Add your answer
Q2. Are you a single child? What are the advantages and disadvantages of being or not being a single child?
Add your answer
Q3. Feedback about the whole recruitment process
Add your answer
Q4. How informative did you find the Pre Placement Talk?
Add your answer
Q5. Write few lines about your hometown
Add your answer
Q6. The interviewer asked one technical question as well in this round: What is the difference between == and === operators?
Add your answer
Q7. If tomorrow, a company comes with a higher package and you have the offer from Hevo Data, how would you decide?
Add your answer

Few aptitude and general quantitative questions were provided

Coding round consisted of two coding questions, one medium and another easy

There were two assignment rounds, assignment included 2 hrs of time given where:
1. We had to create a data pipeline between snowflake and Hevo Data's Site.
2. Create a docker image and make a website live as given. (wrong codes were provided, their main aim was to check our error resolving capabilities)

Q1. Journey from childhood to college?
Add your answer
Q2. Where do you see yourself in next 10 years achieving everything?
Add your answer
Q3. Name and write something about your hobby in 5 lines?
Add your answer

The assignment consisted of 2 questions:

1. First was to build an ETL piple using Snowflakes and Hevo's tech platform.
2. Second question was to use docker to build a simple nginx server which renders a simple HTML page.

All the relevant files (for assignment 2) and step by step instructions where provided by the company. All the participants were allowed to use google, chatgpt and any other tools at their disposal to finish these two tasks.

Total Time: 2hrs

Q1. Tell me something about you childhood.
Add your answer
Q2. Where do you see yourself 5 years down the line.
Add your answer
Q3. What future plans do you have.
Add your answer

Only basic question and theory was there

Case study about ai was there