Upload Button Icon Add office photos
Engaged Employer

i

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

Celebal Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Celebal Technologies Data Analyst Interview Questions and Answers

Updated 18 Oct 2023

Celebal Technologies Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Oct 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Sep 2023. 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 - Aptitude Test 

It was very easy and out of 1000 students 300 students got shortlisted.

Round 3 - Technical 

(5 Questions)

  • Q1. It was also easy and out of 300 students 30 got shortlisted.
  • Q2. What are oops? Explain 4 pillars
  • Q3. What is DBMS and SQL?
  • Ans. 

    DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.

    • DBMS is a software system that allows users to define, create, maintain, and control access to databases.

    • SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.

    • Examples of popular DBMS in...

  • Answered by AI
  • Q4. What is MongoDB? Explain it.
  • Ans. 

    MongoDB is a NoSQL database program that uses a document-oriented data model.

    • NoSQL database program

    • Document-oriented data model

    • Uses JSON-like documents for data storage

    • Supports dynamic schemas for flexible data structures

  • Answered by AI
  • Q5. Explain all hooks of React.
  • Ans. 

    React hooks are functions that let you use state and other React features without writing a class.

    • Hooks are functions that let you use state and other React features in functional components

    • useState() - allows functional components to have local state

    • useEffect() - allows functional components to perform side effects

    • useContext() - allows functional components to access context

    • useReducer() - an alternative to useState() ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Go for it!

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 4 Nov 2022

I applied via Campus Placement and was interviewed in Oct 2022. There were 4 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 - Coding Test 

Consisting of around 10 SQL querying questions and 2 Python programming questions and 30 SQL + PowerBI related MCQs

Round 3 - Technical 

(3 Questions)

  • Q1. SQL related questions
  • Q2. Questions on ETL and Bigdata
  • Q3. Resume related questions
Round 4 - HR 

(1 Question)

  • Q1. Company policies and work culture explanation and acceptance to work

Interview Preparation Tips

Topics to prepare for Celebal Technologies Data Analyst interview:
  • MySQL
  • ETL
  • Bigdata
  • DBMS
Interview preparation tips for other job seekers - Prepare SQL very well. And you will easily clear all the rounds. Be confident. The hiring team is great

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

Data Analyst Interview Questions & Answers

user image Bhola Shankar Tiwari

posted on 10 Oct 2022

I applied via Company Website and was interviewed in Sep 2022. There were 4 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 - Aptitude Test 

It contain MCQ question which contain F section but all are easy. It contain some coding problem of easy, medium and hard level of Data structure and problems related to your domain.

Round 3 - Technical 

(2 Questions)

  • Q1. They mainly asked the question related to your Domain.
  • Q2. SQL, DS,OOPS,DBMS etc.
Round 4 - HR 

(1 Question)

  • Q1. HR only asked about yourself and offered you a salary.

Interview Preparation Tips

Topics to prepare for Celebal Technologies Data Analyst interview:
  • SQL
  • Data Analytics
Interview preparation tips for other job seekers - Prepare your self well in your domain. you prepare your self from any website .

Top trending discussions

View All
Interview Hub
1w
a client servicing executive
FeedCard Image
Got a question about Celebal Technologies?
Ask anonymously on communities.

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Basics of Python(Pandas)
  • Q2. Advanced SQL functions
  • Q3. Concepts of Statistics in brief
  • Ans. 

    Statistics is the study of collecting, analyzing, and interpreting data.

    • Descriptive statistics summarize and describe data

    • Inferential statistics make predictions and draw conclusions about a population based on a sample

    • Hypothesis testing is used to determine if there is a significant difference between groups

    • Regression analysis is used to model the relationship between variables

    • Probability theory is used to quantify un...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The entire process was smooth and I was given time to think after each question.
The interview process did not make me feel nervous at any point

I applied via Campus Placement and was interviewed in Dec 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical questions on sql

Interview Preparation Tips

Interview preparation tips for other job seekers - it is good experience and moderate prepare for sql, data visualisation etc,it lasted for 2 hrs 30 mins. the interviwers want to test by both technical and soft skills

I applied via Naukri.com and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

It was a genuine test with quite some logical questions of math ,english,ds and some aptitude based which i clearly dont remember thoroughly but crux is mentioned

Round 2 - Technical 

(1 Question)

  • Q1. It was an one on one technical round with hiring personnel of axtria and can be termed easy to intermediate question
Round 3 - One-on-one 

(1 Question)

  • Q1. This was a genuine HR or can say mangerial round where questions usually asked were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Go on for the job as they are still hiring and just try to stick with basic and as you clear the aptitude test your selection chances increases by much

Celebal Technologies HR Interview Questions

17 questions and answers

Q. What are your top 3 skills?
Q. Why would you like to work in sales?
Q. What are your experiences and insights regarding project management methodo ... read more
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 - Aptitude Test 

Easy

Round 3 - Technical 

(1 Question)

  • Q1. Reg previous project and some puzzles
Round 4 - HR 

(2 Questions)

  • Q1. Share details of your previous job.
  • Q2. Why are you looking for a change?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident about wat you know
Are these interview questions helpful?
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude, English and basic programming mcq question were there. Around 70 questions

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Dec 2022. 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 - Aptitude Test 

Contains math aptitide and basic tableau questions

Round 3 - Coding Test 

Sql coding test with joins sub queries and stored procedures

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn SQL, tableau and build some basic dash boards and hen have them attached to ur resume
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jun 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 - One-on-one 

(1 Question)

  • Q1. Ask your past experience and technical related stuff in the resume. Need to have good understanding knowledge and Having good speaking confidence, enough to attract the interviewer.

Celebal Technologies Interview FAQs

How many rounds are there in Celebal Technologies Data Analyst interview?
Celebal Technologies interview process usually has 3-4 rounds. The most common rounds in the Celebal Technologies interview process are Resume Shortlist, Technical and Aptitude Test.
What are the top questions asked in Celebal Technologies Data Analyst interview?

Some of the top questions asked at the Celebal Technologies Data Analyst interview -

  1. What are oops? Explain 4 pill...read more
  2. What is MongoDB? Explain ...read more
  3. What is DBMS and S...read more

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 1 interview experience

Difficulty level

Moderate 100%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

Chetu Data Analyst Interview Questions
3.4
 • 205 Interviews
AVASOFT Data Analyst Interview Questions
2.7
 • 176 Interviews
ivy Data Analyst Interview Questions
3.6
 • 133 Interviews
Axtria Data Analyst Interview Questions
2.9
 • 127 Interviews
DE Shaw Data Analyst Interview Questions
3.8
 • 125 Interviews
View all
Celebal Technologies Data Analyst Salary
based on 32 salaries
₹4 L/yr - ₹8.3 L/yr
15% less than the average Data Analyst Salary in India
View more details

Celebal Technologies Data Analyst Reviews and Ratings

based on 4 reviews

4.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.9

Salary

4.9

Job security

4.9

Company culture

4.9

Promotions

4.9

Work satisfaction

Explore 4 Reviews and Ratings
Data Engineer
471 salaries
unlock blur

₹4.5 L/yr - ₹10 L/yr

Associate
299 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Associate Data Engineer
192 salaries
unlock blur

₹4.2 L/yr - ₹10 L/yr

Associate Consultant
172 salaries
unlock blur

₹6 L/yr - ₹13 L/yr

Data Scientist
160 salaries
unlock blur

₹7.2 L/yr - ₹14.7 L/yr

Explore more salaries
Compare Celebal Technologies with

Thomson Reuters

4.1
Compare

HighRadius

2.8
Compare

Oracle Cerner

3.6
Compare

Chetu

3.4
Compare
write
Share an Interview