Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cambay Consulting Team. If you also belong to the team, you can get access from here

Cambay Consulting Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Cambay Consulting Data Analyst Interview Questions and Answers

Updated 8 Mar 2025

Cambay Consulting Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 8 Mar 2025

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Aptitude Test 

Just typical test with maths and English

Round 2 - HR 

(1 Question)

  • Q1. Salary discussion that's it

Top trending discussions

View All
Interview Hub
4d (edited)
anshitanegi
·
ex -
Planet Spark
When HR’s Chinese English made me drop the interview!
So, I talked to the HR yesterday about the interview. I asked Please send me the location But their English… bro I was shocked! It was like talking to someone jisne english nahi kuch ar hi seekh liya ho, if the HR’s English is this I can only imagine the rest of the company I decided to drop the interview with this chinese english😶‍🌫️
FeedCard Image
Got a question about Cambay Consulting?
Ask anonymously on communities.

Interview questions from similar companies

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

I applied via Recruitment Consulltant and was interviewed before Oct 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(4 Questions)

  • Q1. SQL Related Questions
  • Q2. What are the joins in SQL?
  • Q3. How to improve the Query performance?
  • Q4. Scenario based questions?
  • Ans. 

    Data analysts must navigate complex scenarios to derive insights and make data-driven decisions.

    • Identify the key metrics relevant to the scenario, such as sales growth or customer retention.

    • Use data visualization tools like Tableau or Power BI to present findings clearly.

    • Conduct A/B testing to evaluate the impact of different strategies, e.g., marketing campaigns.

    • Collaborate with cross-functional teams to understand th...

  • Answered by AI
Round 2 - Coding Test 

Scenario based SQL questions and how to improve our sales.

Skills evaluated in this interview

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Write code to calculate the number of people in a room at the end ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
  • Q1. Who is a subscriber? Who is member
  • Ans. 

    A subscriber is someone who signs up for a service, while a member is part of a group or organization.

    • Subscribers typically pay for access to content or services, e.g., magazine subscribers.

    • Members are often part of a community or organization, e.g., members of a gym.

    • Subscribers may not have voting rights, while members often do, e.g., in a club.

    • A subscriber can be a one-time user, while a member usually has ongoing in...

  • Answered by AI
  • Q2. How enrollments sre done?
  • Ans. 

    Enrollments are typically done through a structured process involving registration, verification, and confirmation steps.

    • 1. Registration: Users fill out an enrollment form with personal details.

    • 2. Verification: Submitted information is verified for accuracy and eligibility.

    • 3. Payment: If applicable, payment is processed for enrollment fees.

    • 4. Confirmation: Participants receive a confirmation email or notification.

    • 5. Or...

  • Answered by AI

I applied via LinkedIn and was interviewed in Aug 2021. There were 3 interview rounds.

Round 1 - 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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Knowledge on your skills
Round 3 - HR 

(2 Questions)

  • Q1. Share details of your previous job.
  • Q2. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for business analysis topics
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2023. There were 2 interview rounds.

Round 1 - 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 tips
Round 2 - HR 

(2 Questions)

  • Q1. How many years of experience in life insurance domain?
  • Ans. No experience in life insurance and not as BA in insurance domain.
  • Answered Anonymously
  • Q2. Required 5 years of experience as BA?
  • Ans. I clearly said have only 1.5 years of experience as BA in IT industry and asking same question.
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - I have been getting same kind of calls everyday and I only ask them how many years of experience they require as BA so I say I don't have much experience. Beware guys first you yourself question them instead they asking questions to us.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL , Basic of Pyspark
  • Q2. Joins , SQL query writing, Pyspark basics

Interview Preparation Tips

Interview preparation tips for other job seekers - Some Depth knowledge of Technical and AWS Tools + managerial Questions
Be interview-ready. Browse the most asked HR questions.
illustration image
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before May 2024, where I was asked the following questions.

  • Q1. What is your previous work experience, and how do you describe your workflow?
  • Ans. 

    I have extensive experience in data analysis, focusing on transforming complex data into actionable insights for business growth.

    • Worked at XYZ Corp as a Data Analyst, where I improved reporting efficiency by 30% through automation.

    • Utilized SQL and Python for data extraction and analysis, leading to a 15% increase in sales through targeted marketing strategies.

    • Collaborated with cross-functional teams to identify key per...

  • Answered by AI
  • Q2. Nothing much in the interview, they want you to work at least 2 years and leave
Are these interview questions helpful?

I applied via Naukri.com and was interviewed in Jun 2019. There were 6 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Software manual testing related questions..retesting, regression testing, types of testing, domain
  • Q2. Stlc, sdlc, retesting, regression testing, Writing test cases

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear testing basic concepts,domain knowledge in which you are working.

I applied via Referral and was interviewed before Dec 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Java, Spark Concepts
  • Q2. Threading with example

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on past projects and concepts
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Telephonic Call 

(1 Question)

  • Q1. About Experience, about recruitment & Naukri

Cambay Consulting Interview FAQs

How many rounds are there in Cambay Consulting Data Analyst interview?
Cambay Consulting interview process usually has 2 rounds. The most common rounds in the Cambay Consulting interview process are Aptitude Test and HR.

Tell us how to improve this page.

Overall Interview Experience Rating

1/5

based on 1 interview experience

Difficulty level

Moderate 100%
View more

Cambay Consulting Data Analyst Reviews and Ratings

based on 1 review

2.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Healthcare Recruiter
27 salaries
unlock blur

₹1.8 L/yr - ₹4 L/yr

Business Development Executive
13 salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Inside Sales Associate
10 salaries
unlock blur

₹3.5 L/yr - ₹5.3 L/yr

Corporate Recruiter
10 salaries
unlock blur

₹2.4 L/yr - ₹4.3 L/yr

Finance Executive
9 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Cambay Consulting with

Aarvi Encon

3.9
Compare

Bonace Engineers

4.1
Compare

US Tech Solutions

3.7
Compare

S2 Infotech

3.5
Compare
write
Share an Interview