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 Interview Questions, Process, and Tips

Updated 17 Jan 2025

Top Celebal Technologies Interview Questions and Answers

View all 69 questions

Celebal Technologies Interview Experiences

Popular Designations

118 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
2-4 weeks
Result
Not Selected

I applied via Walk-in

Round 1 - Coding Test 

Basics of the C++ and DSA like Array Linkedlist graph

React Js Frontend Developer Interview Questions asked at other Companies

Q1. 1. What is difference between abstract class and interface ?
View answer (1)

Architect Interview Questions & Answers

user image Anonymous

posted on 18 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic datawarehousing concepts
  • Q2. Powerbi questions basic ones

Interview Preparation Tips

Interview preparation tips for other job seekers - keep your options open

Architect Interview Questions asked at other Companies

Q1. How do you find the resources available on a server if it is on premise?
View answer (2)

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 May 2024

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

I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion with roles and responsiblity

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear the concepts of SQL and what you mentioned in CV should match

Top Celebal Technologies Data Engineer Interview Questions and Answers

Q1. Are you familiar with Celebal Technologies
View answer (1)

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a GameYou and your friend Ninjax are playing a game of coins. Ninjax place the 'N' number of coins in a straight line. The rule of the game is as follows: 1. Each coin has a value associated with it. 2. It’s a two-playe... read more
View answer (6)

Unpaid Apprenticeship Interview Questions & Answers

user image Anonymous

posted on 10 Sep 2024

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

I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Express Interest 

(3 Questions)

  • Q1. Form was shared with basic questions like why do want to join this Center of Excellence (COE) program ?
  • Q2. How will you benefit from the training/internship?
  • Ans. 

    I will benefit from the training/internship by gaining valuable hands-on experience, expanding my skill set, and building a professional network.

    • Gain practical experience in the field

    • Develop new skills and knowledge

    • Build a network of professionals for future opportunities

  • Answered by AI
  • Q3. Choices were given between data science and data engineering?
  • Ans. 

    Data science focuses on analyzing and interpreting complex data, while data engineering focuses on designing and building data pipelines.

    • Data science involves analyzing and interpreting large amounts of data to extract insights and make predictions.

    • Data engineering involves designing and building data pipelines to collect, store, and process data efficiently.

    • Data scientists use tools like Python, R, and machine learnin...

  • Answered by AI
Round 2 - Group Discussion 

People were shortlisted from the previous round of applications and seperated in group of 8 for GD with alloted timings in entire day.

Communication and English speaking skills were main focus. Topics were very common standard topics available in interviewbit, GFG etc. Not on any current trending topic. Easy if you have prepared on common topics.

Entire group had 1 hour to complete.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was easy to get selected in the guided curriculum. It was course of 13 to 15 weeks depending on the choice of stream in our case data science or data engineering. Daily assignments every week to be completed and expect a internship completion certificate at end.

Celebal Technologies interview questions for popular designations

 Data Engineer

 (17)

 Data Scientist

 (9)

 Associate

 (8)

 Intern

 (7)

 SQL Developer

 (5)

 Associate Consultant

 (3)

 Data Analyst

 (3)

 Internship Trainee

 (3)

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. What are advance types of join ?
  • Ans. 

    Advanced types of join include outer join, self join, and cross join.

    • Outer join: includes unmatched rows from one or both tables

    • Self join: joins a table with itself

    • Cross join: combines each row from one table with each row from another table

  • Answered by AI
  • Q2. Difference between having clause and where clause?
  • Ans. 

    The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.

    • WHERE clause is used with SELECT, UPDATE, and DELETE statements.

    • HAVING clause is used with SELECT statements that include GROUP BY clause.

    • WHERE clause filters individual rows based on conditions.

    • HAVING clause filters groups based on conditions.

    • WHERE clause is applied before the GROUP BY clause.

    • HAVING...

  • Answered by AI
  • Q3. Differnce between join and union?
  • Ans. 

    Join combines rows from two or more tables based on a related column, while union combines rows from two or more tables into a single result set.

    • Join is used to combine rows from different tables based on a related column.

    • Union is used to combine rows from two or more tables into a single result set.

    • Join can be used with different types like inner join, left join, right join, etc.

    • Union only combines rows with the same ...

  • Answered by AI
  • Q4. Basic oops concept ?
  • Q5. What are python data structure?
  • Ans. 

    Python data structures are containers that hold and organize data in different ways.

    • Some common Python data structures are lists, tuples, sets, and dictionaries.

    • Lists are ordered and mutable, allowing duplicate elements.

    • Tuples are ordered and immutable, useful for storing related data together.

    • Sets are unordered and contain unique elements, useful for mathematical operations.

    • Dictionaries are key-value pairs, providing

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basic

Skills evaluated in this interview

Top Celebal Technologies Data Engineer Interview Questions and Answers

Q1. Are you familiar with Celebal Technologies
View answer (1)

Data Engineer Interview Questions asked at other Companies

Q1. Optimal Strategy for a GameYou and your friend Ninjax are playing a game of coins. Ninjax place the 'N' number of coins in a straight line. The rule of the game is as follows: 1. Each coin has a value associated with it. 2. It’s a two-playe... read more
View answer (6)

Get interview-ready with Top Celebal Technologies Interview Questions

QA Engineer Interview Questions & Answers

user image Anonymous

posted on 23 Oct 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell me something about yourself
  • Q2. Would you be able to commute to jaipur

QA Engineer Interview Questions asked at other Companies

Q1. 80 pairs of socks in a dark room, 40 black, 40 white, how many minimum number of socks need to be taken out to get 15 pairs of socks
View answer (7)

Jobs at Celebal Technologies

View all
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude questions and normal maths, logical questions

Round 2 - Coding Test 

3 coding question of different level

Internship Trainee Interview Questions asked at other Companies

Q1. Tell about your UG project? How will you design a table for 1 tonne load and what are all the consideration needed for it? Tell the Equations you know in strength of Materials? What are manufacturing processes involved to fabricate ball bea... read more
View answer (1)
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

It is an online coding test and the duration is 3 hours. They test your python skills here. Questions are related to Python and Pandas. You have to write code for the given questions.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Few basic python programs related to lists, data structures, strings, Fibonacci series etc
  • Q2. Asked ML related questions like regression, classification algorithms, NLP questions, evaluation metrics, how to handle if there are many attributes in dataset etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not join in this company. They say that they'll convert you as a Full time employee in 8 months but ultimately they will convert you after one year and mass lay offs are going on.

Data Scientist Interview Questions asked at other Companies

Q1. Special Sum of Array Problem Statement Given an array 'arr' containing single-digit integers, your task is to calculate the total sum of all its elements. However, the resulting sum must also be a single-digit number. To achieve this, repea... read more
Add answer

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 at Indian Institute of Technology (IIT), Roorkee 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
  • 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 asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Intern Interview Questions & Answers

user image Anonymous

posted on 25 Jul 2024

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

I applied via Campus Placement and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Yes it was quite easy

Round 2 - HR 

(1 Question)

  • Q1. Brief overall analysis

Intern Interview Questions asked at other Companies

Q1. Case. There is a housing society “The wasteful society”, you collect all the household garbage and sell it to 5 different businesses. Determine what price you will pay to the society members in Rs/kg, given you want to make a profit of 20% ... read more
View answer (8)

Celebal Technologies Interview FAQs

How many rounds are there in Celebal Technologies interview?
Celebal Technologies interview process usually has 2-3 rounds. The most common rounds in the Celebal Technologies interview process are Technical, Coding Test and HR.
How to prepare for Celebal Technologies 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 Celebal Technologies. The most common topics and skills that interviewers at Celebal Technologies expect are C#, Javascript, SQL, .Net and Python.
What are the top questions asked in Celebal Technologies interview?

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

  1. 2. What are the main modules of Node.js? Explain in deta...read more
  2. 1. What is Node.js? Describe the inner workings of Node...read more
  3. How to create soft link and hardlink How to create empty file in Lin...read more
How long is the Celebal Technologies interview process?

The duration of Celebal Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Celebal Technologies Interview Process

based on 118 interviews

Interview experience

3.9
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 810 Interviews
Globant Interview Questions
3.8
 • 171 Interviews
View all

Celebal Technologies Reviews and Ratings

based on 624 reviews

3.4/5

Rating in categories

3.8

Skill development

3.4

Work-life balance

3.3

Salary

3.1

Job security

3.3

Company culture

3.2

Promotions

3.4

Work satisfaction

Explore 624 Reviews and Ratings
HR Executive-Performance Management

Jaipur

3-5 Yrs

Not Disclosed

Sap Bw Hana Consultant

Noida,

Hyderabad / Secunderabad

+1

10-15 Yrs

Not Disclosed

Sap Bods Developer

Noida,

Pune

3-8 Yrs

Not Disclosed

Explore more jobs
Data Engineer
380 salaries
unlock blur

₹4 L/yr - ₹12 L/yr

Associate
250 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Associate Consultant
160 salaries
unlock blur

₹5 L/yr - ₹16.3 L/yr

Associate Data Engineer
158 salaries
unlock blur

₹2.5 L/yr - ₹11 L/yr

Data Scientist
124 salaries
unlock blur

₹4.5 L/yr - ₹14.3 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