Add office photos
Filter interviews by
Hive Data Analyst Interview Questions and Answers for Experienced
1 interview found
Anonymous
I applied via Referral and was interviewed in Nov 2024.
1 Interview Round
One-on-one Round (2 Questions)
- Q1. Explain ur projects Add Answer
- Q2. Excel related questions Add Answer
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Walk-in and was interviewed in Jun 2024.
1 Interview Round
HR Round (7 Questions)
- Q1. I'm changing my domain because I don't see much scope for growth in my current domain and I want to make advantage of new opportunities for learning, creativity...read more Add Answer
- Q2. I understand that being asked to work for an extended number of hours comes with a good reason in the first place, so I'm ok with it. Add Answer
- Q3. Over the year I have really upskilled my self. I believe based on the market standards for this particular role and my experience and skill set a salary range b...read more Add Answer
- Q4. Can you share more about the day to day responsibilities of this role? Add Answer
- Q5. If I am hired for this role, what would you want me to a achieve in my first two months? Add Answer
- Q6. No ma'am certainly not. Before coming here, I read the job description thoroughly and I have the right skills and qualification required for the role. Add Answer
- Q7. I believe a change in work environment with stimulate my creativity and drive for success. Add Answer
Interview Preparation Tips
1 Interview Round
Technical Round (1 Question)
- Q1. There is table which holds details of matches played between the countries in first 2 columns and who won the match in 3rd column. write a query to get no. of m...read more View Answers (1)
Skills evaluated in this interview
Sohini Bera
1 Interview Round
One-on-one Round (1 Question)
- Q1. Write a code to determine average salary wrt location View Answers (1)
2 Interview Rounds
Technical Round (2 Questions)
- Q1. Sql intermediate level Add Answer
- Q2. Power bi intermediate level Add Answer
HR Round (2 Questions)
- Q1. Family background & earning source Add Answer
- Q2. What you like about EY Add Answer
1 Interview Round
Technical Round (1 Question)
- Q1. SQL Coding question and Power BI Add Answer
I applied via Approached by Company and was interviewed in Apr 2024.
1 Interview Round
Technical Round (1 Question)
- Q1. Mostly ask questions on sql. Add Answer
Selected
I applied via Referral and was interviewed before Aug 2023.
4 Interview Rounds
Coding Test Round
Basic questions of SQL, Python and Power Bi
Technical Round (2 Questions)
- Q1. Basics question Windows function in SQL, Calculate function in Power bi and pandas in Python Add Answer
- Q2. Scenarios based questions on how to analyse data. What to look for. And what charts to use in certain scenarios Add Answer
One-on-one Round (1 Question)
- Q1. Past Job experiences, basic Technical questions. And all. Add Answer
HR Round (1 Question)
- Q1. Past experience. When can I join. Salary and all.. Add Answer
I applied via Naukri.com and was interviewed in Dec 2022.
3 Interview Rounds
Coding Test Round
String Reverse Coding Test
User
Share Detail for coding test
ChatGPT
Certainly! I'd be happy to provide you with details for a coding test. Here's an example of a coding test description:
Title: String Reversal
Description:
Write a function that takes a string as input and returns the reverse of that string. The function should reverse the order of characters in the string and return the reversed string as the output.
Requirements:
The function should be named reverseString and take a single parameter, inputString, of type string.
The function should return a string.
The function should handle both uppercase and lowercase letters.
The function should preserve any whitespace or special characters in the input string.
The function should not use any built-in or library functions that directly solve this problem.
Example:
Input: "Hello, World!"
Output: "!dlroW ,olleH"
Note:
The input string can be of any length.
The input string may contain alphanumeric characters, whitespace, or special characters.
Evaluation Criteria:
Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with.
Good luck!
Aptitude Test Round
String Reverse Coding Test
User
Share Detail for coding test
ChatGPT
Certainly! I'd be happy to provide you with details for a coding test. Here's an example of a coding test description:
Title: String Reversal
Description:
Write a function that takes a string as input and returns the reverse of that string. The function should reverse the order of characters in the string and return the reversed string as the output.
Requirements:
The function should be named reverseString and take a single parameter, inputString, of type string.
The function should return a string.
The function should handle both uppercase and lowercase letters.
The function should preserve any whitespace or special characters in the input string.
The function should not use any built-in or library functions that directly solve this problem.
Example:
Input: "Hello, World!"
Output: "!dlroW ,olleH"
Note:
The input string can be of any length.
The input string may contain alphanumeric characters, whitespace, or special characters.
Evaluation Criteria:
Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with. Good luck!
User
Share derail for amplitude test
ChatGPT
Certainly! Here's an example of a coding test description for an amplitude test:
Title: Finding Amplitude
Description:
Write a function that takes a list of integers as input and returns the amplitude of the list. The amplitude of a list is defined as the difference between the largest and smallest elements in the list.
Requirements:
The function should be named findAmplitude and take a single parameter, inputList, which is a list of integers.
The function should return an integer representing the amplitude of the input list.
The function should handle both positive and negative integers.
The function should handle an empty list as input and return 0 as the amplitude.
Example:
Input: [2, 5, 9, -1, 3, 7]
Output: 10
Explanation:
The largest element in the list is 9, and the smallest element is -1. Therefore, the amplitude is 9 - (-1) = 10.
Note:
The input list can contain duplicates.
The input list can be of any length.
Evaluation Criteria:
Correctness of the solution.
Efficiency and clarity of the code.
Proper handling of edge cases and error conditions.
Adherence to coding best practices.
Please complete the task within 30 minutes and submit your solution as a single file. Feel free to use any programming language you are comfortable with.
Good luck!
Group Discussion Round
Certainly! Here's an example of a group discussion topic:
Topic: The Impact of Artificial Intelligence on the Job Market
Description:
In this group discussion, we will explore the impact of artificial intelligence (AI) on the job market. AI is rapidly advancing, and its integration into various industries and sectors has raised concerns about the future of work.
Points to consider:
Potential job displacement: Discuss how AI has the potential to automate tasks and replace human jobs in various fields. Explore which industries or job roles are most susceptible to automation and the potential consequences for workers.
Job creation: Explore the other side of the argument and discuss how AI can also create new job opportunities. Consider the emergence of AI-related roles such as data scientists, AI trainers, and AI ethicists. Discuss the skills and expertise required for these new job roles.
Skills and education: Discuss the importance of skills development and education in adapting to the changing job market. Explore what skills will be in high demand in an AI-driven economy and how individuals and organizations can upskill or reskill to remain relevant.
Ethical considerations: Consider the ethical implications of AI in the job market. Discuss issues such as algorithmic bias, data privacy, and the responsibility of companies and policymakers in ensuring a fair and inclusive job market.
Job market transformation: Discuss the overall transformation of the job market due to AI. Explore how AI is reshaping traditional job roles, the gig economy, and the potential for new forms of work, such as remote work and flexible arrangements.
Guidelines:
Each participant should express their thoughts and ideas clearly and respectfully.
Encourage active listening and give everyone an opportunity to speak.
Support your arguments with relevant examples or data, if possible.
Be open to different perspectives and engage in constructive debate.
Evaluation Criteria:
Clarity of thought and expression.
Ability to articulate and support arguments.
Active participation and engagement with other participants.
Respectful and collaborative attitude towards the group discussion.
Please prepare your thoughts on the topic before the discussion. The group discussion will last for approximately 30 minutes. Good luck!
Interview Preparation Tips
Develop a Strong Foundation: Ensure you have a solid understanding of the fundamental concepts and techniques in data science. This includes knowledge of statistics, mathematics, programming (Python and R are commonly used), machine learning algorithms, and data manipulation.
Build a Portfolio: Create a portfolio that showcases your data science skills and projects. This could include personal projects, Kaggle competition entries, or contributions to open-source projects. A portfolio demonstrates your practical experience and can set you apart from other candidates.
Gain Practical Experience: Seek out opportunities to work on real-world data science problems. Consider internships, freelance projects, or collaborations with researchers or companies. Practical experience not only enhances your skills but also demonstrates your ability to apply your knowledge to solve real problems.
Stay Updated: Keep up with the latest developments in the field of data science. Follow blogs, participate in online forums and communities, and attend conferences or webinars. Being aware of emerging technologies, techniques, and trends shows your dedication to continuous learning and growth.
Network: Build connections within the data science community. Attend industry events, join professional organizations, and engage with professionals through social media platforms like LinkedIn and Twitter. Networking can lead to valuable job opportunities, referrals, and insights into the industry.
Customize Your Applications: Tailor your resume and cover letter for each job application. Highlight relevant skills, projects, and experiences that align with the specific requirements of the position. A personalized application shows your attention to detail and genuine interest in the role.
Prepare for Interviews: Be prepared for technical interviews that assess your data science skills. Practice coding exercises, algorithmic problem-solving, and be able to explain your projects in a clear and concise manner. Additionally, be prepared to answer behavioral and situational questions to demonstrate your problem-solving, teamwork, and communication skills.
Continuously Learn and Improve: Data science is a rapidly evolving field, so embrace a growth mindset. Seek opportunities to learn new techniques, explore new domains, and expand your skill set. Take online courses, attend workshops, or pursue advanced degrees if necessary. Show that you are committed to staying ahead of the curve.
Emphasize Communication Skills: Data scientists are not just expected to analyze data but also effectively communicate their findings to non-technical stakeholders. Develop your ability to present complex concepts in a clear and concise manner, both verbally and in written form. Strong communication skills will make you a valuable asset to any organization.
Be Persistent and Resilient: The job search process can be challenging and may require time and perseverance. Don't get discouraged by rejection or setbacks. Learn from each experience, seek feedback, and continuously refine your approach. With persistence and a positive attitude, you'll increase your chances of landing a data science job.
Remember, the field of data science is highly competitive, so it's important to stand out from the crowd. By following these tips and continuously improving your skills, you can increase your chances of securing a rewarding job in data science. Good luck with your job search!
Aashutosh Goyal
Selected
I applied via Referral and was interviewed before Oct 2022.
4 Interview Rounds
Resume Shortlist Round
HR Round (2 Questions)
- Q1. Basic Skillset questions Add Answer
- Q2. Projects worked on Add Answer
One-on-one Round (1 Question)
- Q1. Knowledge on Marketing tools and case scenarios Add Answer
Technical Round (1 Question)
- Q1. SQl Queries, Previous projects Add Answer
Hive Interview FAQs
Tell us how to improve this page.
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
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
Hive Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Data Analyst
55
salaries
|  ₹3 L/yr - ₹6.1 L/yr |
|
Market Research Analyst
15
salaries
| ₹3.5 L/yr - ₹7.5 L/yr |
|
Quality Analyst
7
salaries
| ₹10.5 L/yr - ₹15 L/yr |
|
Market Research Specialist
7
salaries
| ₹4.8 L/yr - ₹7.8 L/yr |
|
Technical Recruiter
6
salaries
| ₹4 L/yr - ₹8 L/yr |
Ola Cabs
Swiggy
Zomato
Flipkart
Calculate your in-hand salary
- Home >
- Interviews >
- Hive Interview Questions >
- Hive Data Analyst Interview Questions for Experienced
