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 5 Mar 2025

Top Celebal Technologies Interview Questions and Answers

View all 69 questions

Celebal Technologies Interview Experiences

Popular Designations

119 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Online Interview 

(2 Questions)

  • Q1. Calculate repeating element in list
  • Ans. 

    Find the repeating element in a list

    • Iterate through the list and keep track of elements seen so far

    • Use a hash set to efficiently check for duplicates

    • Return the first element that is already in the set

  • Answered by AI
  • Q2. Calculate maximum salary in SQL
  • Ans. 

    Use the MAX() function in SQL to calculate the maximum salary.

    • Use the MAX() function along with the column name of the salary field.

    • Example: SELECT MAX(salary) FROM employees;

    • Ensure the correct table and column names are used in the query.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I joined Celebal Technology as Intern, The interviewer asked python and SQL easy questions.
1. Calculate maximum salary
2. Given two tables and what will be the output after the inner join
3. Calculate repeating number in a list in python.
4. Class object

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 Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)
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)
Celebal Technologies Interview Questions and Answers for Freshers
illustration image

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 Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

Celebal Technologies interview questions for popular designations

 Data Engineer

 (17)

 Data Scientist

 (9)

 Associate

 (8)

 Intern

 (7)

 SQL Developer

 (5)

 Internship Trainee

 (3)

 Data Analyst

 (3)

 Associate Consultant

 (3)

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.

Get interview-ready with Top Celebal Technologies Interview Questions

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 Coin Game You are playing a coin game with your friend Ninjax. There are N coins placed in a straight line. Here are the rules of the game: 1. Each coin has a value associated with it. 2. The game involves two players... read more
View answer (1)

Jobs at Celebal Technologies

View all

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 (9)
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 (2)
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. for a data with 1000 samples and 700 dimensions, how would you find a line that best fits the data, to be able to extrapolate? this is not a supervised ML problem, there's no target. and how would you do it, if you want to treat this as a s... read more
View answer (5)

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 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)
Contribute & help others!
anonymous
You can choose to be anonymous

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.

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

SALARIES

Broad Air Conditioning

INTERVIEWS

Celebal Technologies

No Interviews

SALARIES

Broad Air Conditioning

INTERVIEWS

HSBC Group

No Interviews

SALARIES

Bridge Group Solutions

INTERVIEWS

Juspay Technologies

No Interviews

SALARIES

BNP Paribas India Solutions

Tell us how to improve this page.

Celebal Technologies Interview Process

based on 119 interviews

Interview experience

3.9
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 â€˘ 10.4k Interviews
Infosys Interview Questions
3.6
 â€˘ 7.5k Interviews
Wipro Interview Questions
3.7
 â€˘ 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 â€˘ 3.8k Interviews
HCLTech Interview Questions
3.5
 â€˘ 3.8k Interviews
LTIMindtree Interview Questions
3.8
 â€˘ 2.9k Interviews
Mphasis Interview Questions
3.4
 â€˘ 791 Interviews
Hexaware Technologies Interview Questions
3.5
 â€˘ 710 Interviews
Persistent Systems Interview Questions
3.5
 â€˘ 596 Interviews
Chetu Interview Questions
3.3
 â€˘ 172 Interviews
View all

Celebal Technologies Reviews and Ratings

based on 541 reviews

3.0/5

Rating in categories

3.5

Skill development

3.1

Work-life balance

2.9

Salary

2.6

Job security

2.9

Company culture

2.7

Promotions

3.0

Work satisfaction

Explore 541 Reviews and Ratings
C#WPF Developer /Lead

Jaipur

3-8 Yrs

Not Disclosed

HR Executive-Performance Management

Jaipur

3-5 Yrs

Not Disclosed

Sap Bw Hana Consultant

Noida,

Hyderabad / Secunderabad

+1

10-15 Yrs

Not Disclosed

Explore more jobs
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