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

Clear (1)

Celebal Technologies Data Analyst Interview Questions, Process, and Tips

Updated 18 Oct 2023

Top Celebal Technologies Data Analyst Interview Questions and Answers

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 Resume 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
  • Ans. 

    OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.

    • Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.

    • Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...

  • Answered by AI
  • 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 Resume 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. Suppose there is a room in the office and X people enter room thr ... 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

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 Resume 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 .

Interview questions from similar companies

I applied via Referral and was interviewed in Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. what is responsibility of data ayalyst. 2. About project. 3. how to deal multi- source problem. 4. what are key skill required for data analyst. 5. some statistical method that are useful for data anyly...

Interview Preparation Tips

Interview preparation tips for other job seekers - it was tough but if you confident in yourself you can do anything.

I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell about yourself and college. some technical questions and some systems related questions.
  • Q2. Some situation questions about your answer relating.

Interview Preparation Tips

Interview preparation tips for other job seekers - first think is self confidence and positive attitude. maintain a eye contact to interviewer. sitting structure important and honest answer they wanted that's it. be prepared for a back story of your strength and weakness

Interview Questionnaire 

3 Questions

  • Q1. About my self and my experience.
  • Q2. What's the reason for leaving previous job?
  • Q3. Technical question depends on process.

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

Interview Questionnaire 

1 Question

  • Q1. Da tools

Interview Preparation Tips

Interview preparation tips for other job seekers - Get referal

I applied via Company Website and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python data structures
  • Q2. MongoDB database algorithms
  • Ans. 

    MongoDB database algorithms are used for efficient data storage, retrieval, and processing.

    • MongoDB uses various algorithms for indexing, sharding, and aggregation.

    • Indexing algorithms include B-tree, hash, and text search indexes.

    • Sharding algorithms include range-based, hash-based, and zone-based sharding.

    • Aggregation algorithms include map-reduce and aggregation pipeline.

    • MongoDB also uses algorithms for query optimizati

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your basics

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prior experience,questions related to data analysis tools.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview process is fast,mine got done in a day but if you are selected and your salary negotiation is finished, it will take almost a month to get offer letter,so need not worry till that time you will surely get it.
The reason behind the offer letter delay is they have to get approvals from multiple teams which creates a delay on the process.

I applied via Naukri.com and was interviewed before Aug 2021. 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. What is Structured Query Language?
  • Ans. 

    Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases.

    • SQL is used to create, modify, and delete databases, tables, and data

    • It is used to retrieve data from databases using queries

    • SQL is used to perform operations on data such as sorting, filtering, and grouping

    • Examples of SQL-based database management systems include MySQL, Oracle, and Microsoft SQL Server

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - My Goal is to get the Job as a Data Analyst or Business analyst

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

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 Technical, Resume Shortlist and HR.
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

Recently Viewed

INTERVIEWS

SparkCognition

No Interviews

INTERVIEWS

Parasco

No Interviews

INTERVIEWS

SparkCognition

No Interviews

LIST OF COMPANIES

Bharat Fritz Werner

Overview

Tell us how to improve this page.

Celebal Technologies Data Analyst Interview Process

based on 1 interview

2 Interview rounds

  • Resume Shortlist Round
  • Technical Round
View more
Celebal Technologies Data Analyst Salary
based on 26 salaries
₹4 L/yr - ₹9 L/yr
At par with the average Data Analyst Salary in India
View more details

Celebal Technologies Data Analyst Reviews and Ratings

based on 3 reviews

3.4/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 3 Reviews and Ratings
Data Engineer
381 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
250 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Engineer
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
123 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Celebal Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent