Hevo Data Senior Data Analyst Interview Questions and Answers

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

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
Add your answer
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...read more
Answered by AI
Add your answer
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
Answered by AI
Add your answer

Q1. Questions on self join
Add your answer

HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.

Q1. Started with basic sql question like diff btw nosql & sql, join etc
Add your answer
Q2. Table were given in google sheet & had to write basic level queries on them eg. cte's, agg function, lead & lag func
Add your answer

Q1. The interviewer was not serious at all, asked silly quizzes instead of business case study, KPI & metrics
Add your answer
Q2. Prepare for logical reasoning
Add your answer

Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc

Q1. SQL visualisation
Add your answer
Q2. SQL Questions theory
Add your answer

Q1. SDLC questions - Role of a BA during different phases
Ans. 
A Business Analyst plays a crucial role throughout the Software Development Life Cycle (SDLC) by gathering requirements, analyzing business needs, and ensuring successful project implementation.
• During the planning phase, the BA works closely with stakeholders to gather and analyze requirements.

• In the design phase, the BA translates business requirements into functional specifications for the development team.

• During the...read more
Answered by AI
Add your answer
Q2. Questions on testing - Types of testing, testing process
Add your answer

Q1. Questions based on your projects and on Scrum, Agile methodologies, tools used by business analysts
Add your answer

Q1. Study aspects of BA role
Ans. 
The Business Analyst role involves studying various aspects of business operations and processes.
• Analyzing business requirements and translating them into functional specifications

• Conducting stakeholder interviews to gather information and understand business needs

• Identifying and documenting business processes and workflows

• Performing data analysis to identify trends and patterns

• Creating and maintaining project document...read more
Answered by AI
Add your answer
Q2. What are the roles in scrum?
Ans. 
The roles in Scrum include Product Owner, Scrum Master, and Development Team.
• Product Owner: Represents the stakeholders and ensures the product backlog is prioritized.

• Scrum Master: Facilitates the Scrum process, removes obstacles, and ensures adherence to Scrum principles.

• Development Team: Self-organizing group responsible for delivering the product increment.

• Examples: Product Owner - Defines product vision and backlog...read more
Answered by AI
Add your answer
Q3. What are different types of testing?
Ans. 
Different types of testing include unit testing, integration testing, system testing, and acceptance testing.
• Unit testing: Testing individual components or units of software to ensure they function correctly.

• Integration testing: Testing the interaction between different components or modules to ensure they work together.

• System testing: Testing the entire system to verify that it meets the specified requirements.

• Accepta...read more
Answered by AI
Add your answer

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
Answered by AI
Add your answer
Q2. Skills you have
Add your answer

General topics 20 min about daily life

Research about HR around the world

Q1. About yourself jkjjj iiii yyy ooo
Add your answer
Q2. About your resume jnj jhk; kl iiii
Add your answer