Add office photos
i
Hevo Data
Compare
Filter interviews by
Hevo Data Data Analyst Interview Questions and Answers
Hevo Data Data Analyst Interview Experiences
1 interview found
592 _UTKARSH SINGH
It was basically Arrays and String
It was given based on Docker
(1 Question)
- Q1. Asked about myself
Top trending discussions
Interview questions from similar companies
Anonymous
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
Basic Hacker Rank SQL Questions 2 . and 10 MCQ based
(3 Questions)
- Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
- Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
- Ans.
The query selects all columns and calculates the total amount for each customer in table t2.
The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.
The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.
The 'select *' statement selects all columns from the table along with the calculated total amount.
The 'sum(amt) over (partiti...
- Q3. How many Customers has purchased same item on the Same day more than onnce
- Ans.
To find customers who purchased the same item multiple times on the same day.
Identify unique customers who purchased the same item multiple times on the same day
Check for duplicate transactions by customer and item on the same day
Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day
Interview Preparation Tips
(2 Questions)
- Q1. Introduce Yourself
- Ans.
I am a data analyst with a background in statistics and experience in analyzing large datasets to drive business decisions.
Graduated with a degree in Statistics
Proficient in data analysis tools such as Python, R, and SQL
Experience in creating visualizations to communicate insights
Strong problem-solving skills
- Q2. Skills you have
They are asking about SQL queries and BI dashboard knowledge
(2 Questions)
- Q1. 1. Tell about yourself? 2. What is your Project? 3. WHat challenges faced in Data Engineering role 4. BI dashboard development experience
- Ans.
I am a data engineer with experience in BI dashboard development and overcoming challenges in the field.
I have worked on various data engineering projects, including building data pipelines and optimizing data storage.
One of my notable projects involved developing a real-time data processing system for a retail company, which improved their inventory management and sales forecasting.
In my previous role, I faced challen...
- Q2. 1. What is Data models 2. What are the activities used in ADF 3. What is IR?
- Ans.
Answers to questions related to Data Models, ADF activities, and IR.
Data models are the representation of data structures and relationships between them.
ADF activities include data movement, data transformation, and control activities.
IR stands for Integration Runtime, which is a compute infrastructure used to provide data integration capabilities across different network environments.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
6 mcqs and 2 sql questions
(5 Questions)
- Q1. Difference between having and where in sql
- Ans.
In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.
HAVING is used with GROUP BY to filter groups based on aggregate functions
WHERE is used to filter rows before grouping
HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;
Example: S
- Q2. Sql joins and it types
- Q3. Window functions and subqueries
- Q4. Sql scenario question based on joins
- Q5. Kpi's and metrics
(1 Question)
- Q1. Business problem related to case study
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Introduce Yourself
- Ans.
I am a data analyst with a background in statistics and experience in analyzing large datasets to drive business decisions.
Graduated with a degree in Statistics
Proficient in data analysis tools such as Python, R, and SQL
Experience in creating visualizations to communicate insights
Strong problem-solving skills
- Q2. Skills you have
They are asking about SQL queries and BI dashboard knowledge
(2 Questions)
- Q1. 1. Tell about yourself? 2. What is your Project? 3. WHat challenges faced in Data Engineering role 4. BI dashboard development experience
- Q2. 1. What is Data models 2. What are the activities used in ADF 3. What is IR?
- Ans.
Answers to questions related to Data Engineer role
Data models are the logical representation of data objects and their relationships
ADF activities include data movement, data transformation, and control activities
IR stands for Integration Runtime, which is a compute infrastructure used to provide data integration capabilities
Interview Preparation Tips
I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.
HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.
(2 Questions)
- Q1. Started with basic sql question like diff btw nosql & sql, join etc
- Q2. Table were given in google sheet & had to write basic level queries on them eg. cte's, agg function, lead & lag func
(2 Questions)
- Q1. The interviewer was not serious at all, asked silly quizzes instead of business case study, KPI & metrics
- Q2. Prepare for logical reasoning
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2024. There were 2 interview rounds.
Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc
(2 Questions)
- Q1. SQL visualisation
- Q2. SQL Questions theory
Interview Preparation Tips
Shekhar Bisht
(1 Question)
- Q1. Questions on self join
Hevo Data Interview FAQs
Tell us how to improve this page.
Hevo Data Interviews By Designations
- Hevo Data Technical Intern Interview Questions
- Hevo Data Accountant Interview Questions
- Hevo Data Business Analyst Interview Questions
- Hevo Data Customer Experience Lead Interview Questions
- Hevo Data Customer experience Specialist Interview Questions
- Hevo Data Data Analyst Interview Questions
- Hevo Data Director Interview Questions
- Hevo Data Key Account Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Hevo Data Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Business Analyst
10
salaries
|  ₹7 L/yr - ₹13 L/yr |
|
Sales Development Representative
9
salaries
| ₹7.1 L/yr - ₹11 L/yr |
|
Account Executive 1
8
salaries
| ₹15 L/yr - ₹19 L/yr |
|
Key Accounts Executive
7
salaries
| ₹9 L/yr - ₹17.9 L/yr |
|
Program Manager
7
salaries
| ₹20.9 L/yr - ₹36.8 L/yr |
Wingify
CleverTap
Postman
Freshworks
- Home >
- Interviews >
- Hevo Data Interview Questions >
- Hevo Data Data Analyst Interview Questions
