Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Zinnov Management Consulting Data Analyst Interview Questions and Answers

Updated 23 Feb 2024

Zinnov Management Consulting Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 23 Feb 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. About skills in jd
Round 2 - Coding Test 

Basic python coding questions

Interview questions from similar companies

I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips

Interview Preparation Tips

Topics to prepare for Deloitte Data Analyst interview:
  • Procurement
  • Marketing
  • Career goal
Interview preparation tips for other job seekers - Location should be Delhi NCR,Monday would be good

I was interviewed before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

  • Q1. 

    Ninja and His Secret Information Encoding Problem

    Ninja, a new member of the FBI, has acquired some 'SECRET_INFORMATION' that he needs to share with his team. To ensure security against hackers, Ninja dec...

  • Ans. 

    The task is to encode and decode 'SECRET_INFORMATION' for security purposes and determine if the transmission was successful.

    • Read the number of test cases 'T'

    • For each test case, encode the 'SECRET_INFORMATION' and then decode it

    • Compare the decoded string with the original 'SECRET_INFORMATION'

    • Print 'Transmission successful' if they match, else print 'Transmission failed'

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Medium

  • Q1. 

    Equilibrium Index Problem Statement

    Given an array Arr consisting of N integers, your task is to find the equilibrium index of the array.

    An index is considered as an equilibrium index if the sum of elem...

  • Ans. 

    Find the equilibrium index of an array where sum of elements on left equals sum on right.

    • Iterate through the array and calculate prefix sum and suffix sum at each index.

    • Compare prefix sum and suffix sum to find equilibrium index.

    • Return the left-most equilibrium index or -1 if none found.

  • Answered by AI
Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Easy

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in PuneEligibility criteria7 CGPACapgemini interview preparation:Topics to prepare for the interview - Data Structures, OOPS, SQL, Python, JavaTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Focus more on SQL
Tip 2 : Keep up with ongoing projects in the company

Application resume tips for other job seekers

Tip 1 : Be honest about what you add.
Tip 2 : Don't forget to mention extra curriculars.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Apr 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Cut Cake in 3 cut to maximum pieces
  • Q2. Basic SQL queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident even you don’t have experience in the relevant skill set.

You can be absorbed to much related profile of your interests.

They only check how better you represent yourself and your problem solving approach.

I applied via Recruitment Consulltant and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about the tool you worked on?
  • Ans. 

    I worked on a data visualization tool for tracking sales performance.

    • The tool was built using Tableau and SQL.

    • It allowed users to view sales data by region, product, and time period.

    • Users could also create custom dashboards and reports.

    • The tool helped identify trends and opportunities for improvement.

    • I collaborated with the sales team to ensure the tool met their needs.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just tell about the flow of the tool and answer honestly.

Interview Questionnaire 

2 Questions

  • Q1. What is Data
  • Ans. 

    Data is a collection of facts, figures, or statistics that can be analyzed to gain insights and make informed decisions.

    • Data can be structured or unstructured

    • Data can be qualitative or quantitative

    • Examples of data include customer demographics, sales figures, and website traffic

    • Data can be analyzed using various tools and techniques to extract meaningful insights

  • Answered by AI
  • Q2. Data types

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About SAP BODS

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong and concentrate on basics.

I applied via Naukri.com and was interviewed in Jan 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why do you make the Candidate for months to process the interview

Interview Preparation Tips

Interview preparation tips for other job seekers - The first round was went well. Got a positive feedback on the same day. But they ask for almost all the documents you have. and don't schedule the client round and will get calls weekly or 2 weeks once about the next round but won't get any action.

I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Write a query where all the customer name start with A
  • Ans. 

    Query to retrieve all customer names starting with A.

    • Use the SELECT statement to retrieve customer names.

    • Use the LIKE operator with the pattern 'A%' to match names starting with A.

    • Specify the table and column name where the customer names are stored.

    • Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';

  • Answered by AI
  • Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was extremely easy and smooth.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. SQL, Power Bi, Python, Azure

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the Job Description properly. Clear you basics and prepare according to the JD
Contribute & help others!
anonymous
You can choose to be anonymous

Zinnov Management Consulting Interview FAQs

How many rounds are there in Zinnov Management Consulting Data Analyst interview?
Zinnov Management Consulting interview process usually has 2 rounds. The most common rounds in the Zinnov Management Consulting interview process are HR and Coding Test.
How to prepare for Zinnov Management Consulting Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Zinnov Management Consulting. The most common topics and skills that interviewers at Zinnov Management Consulting expect are Data Analysis, SQL, Data Visualization, Data Warehousing and ETL.

Recently Viewed

INTERVIEWS

Newgen Knowledge Works

No Interviews

INTERVIEWS

Kotak Mahindra Bank

No Interviews

INTERVIEWS

Zinnov Management Consulting

5.6k top interview questions

INTERVIEWS

Cognizant

5.6k top interview questions

INTERVIEWS

Techinfini Solutions

No Interviews

INTERVIEWS

JPM Group

No Interviews

INTERVIEWS

State Bank of India

No Interviews

INTERVIEWS

Zinnov Management Consulting

No Interviews

CAMPUS PLACEMENT

Sastra University

INTERVIEWS

Zinnov Management Consulting

No Interviews

Tell us how to improve this page.

Zinnov Management Consulting Data Analyst Interview Process

based on 3 interviews

Interview experience

4
  
Good
View more
Zinnov Management Consulting Data Analyst Salary
based on 9 salaries
₹2 L/yr - ₹4.5 L/yr
33% less than the average Data Analyst Salary in India
View more details

Zinnov Management Consulting Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

4.0

Work-life balance

2.0

Salary

3.0

Job security

3.0

Company culture

2.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Research Executive
112 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Research Executive
107 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Project Lead
105 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
89 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engagement Manager
50 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Zinnov Management Consulting with

McKinsey & Company

3.8
Compare

BCG

3.7
Compare

Bain & Company

3.8
Compare

KPMG India

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview