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

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

I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Sql queries- nth highest salary python code- reverse string, word count program repartition vs coalesce reader and writer API External vs managed table Spark architecture broadcast join where clause vs hav...

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
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. -SQL basics , HTML and basic javascript

Software Developer Interview Questions asked at other Companies

Q1. Maximum Subarray Sum Problem Statement Given an array of integers, determine the maximum possible sum of any contiguous subarray within the array. Example: Input: array = [34, -50, 42, 14, -5, 86] Output: 137 Explanation: The maximum sum is... read more
View answer (42)
Celebal Technologies Interview Questions and Answers for Freshers
illustration image

Data Engineer Interview Questions & Answers

user image Onkar Satish Pandole

posted on 20 Oct 2024

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

I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is joins , write a subquery
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Joins are used in SQL to retrieve data from multiple tables based on a related column between them.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Subqueries are queries nested within another query, typically used to return a single value or a list of values for comparison.

  • Answered by AI
  • Q2. Joins, ADF, CTE find 2nd highest no
  • Ans. 

    Use SQL query with joins, common table expressions (CTE) and Azure Data Factory (ADF) to find the 2nd highest number.

    • Use a SQL query with joins to combine the necessary tables or datasets.

    • Utilize common table expressions (CTE) to simplify the query and make it more readable.

    • Leverage Azure Data Factory (ADF) to automate the process of running the query and retrieving the result.

    • Order the numbers in descending order and ...

  • Answered by AI

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)

Intern Interview Questions & Answers

user image Anonymous

posted on 27 Dec 2024

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

I applied via LinkedIn and was interviewed before Dec 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Core skills, college project
Round 2 - Technical 

(1 Question)

  • Q1. Basics of machine learning and Deel learning

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 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 experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. Pyspark partion and group by , azure , databricks
  • Q2. Azure databricks
  • Q3. Azure adls gen 2
  • Q4. Azure data factory

Interview Preparation Tips

Interview preparation tips for other job seekers - all about,pyspark,azure,databricks

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)

Get interview-ready with Top Celebal Technologies Interview Questions

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

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

Round 1 - Aptitude Test 

Logical reasoning, logical , many more

Round 2 - Coding Test 

Swapping two programs, multilevel inheritance

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on mathematical concepts (aptitude basics)

Software Engineer Trainee Interview Questions asked at other Companies

Q1. Palindromic Linked List Problem Statement Given a singly linked list of integers, determine if it is a palindrome. Return true if it is a palindrome, otherwise return false. Example: Input: 1 -> 2 -> 3 -> 2 -> 1 -> NULL Outpu... read more
View answer (1)

Jobs at Celebal Technologies

View all

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 .

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)

Associate Interview Questions & Answers

user image Anonymous

posted on 26 Aug 2024

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

I applied via Campus Placement and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are joins in sql ?
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. What is difference between duplicate and reference ?
  • Ans. 

    Duplicate is an exact copy of something, while reference is a pointer to the original object.

    • Duplicate is a separate copy of the original item, while reference points to the original item.

    • Changes made to a duplicate do not affect the original, but changes made to a reference affect the original.

    • Duplicate has its own memory space, while reference shares memory space with the original object.

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a dedicated and hardworking individual with a passion for learning and growth.

    • I have a background in marketing and have worked in the industry for 5 years.

    • I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.

    • I am a team player and enjoy collaborating with others to achieve common goals.

  • Answered by AI
  • Q2. Salary expectation

Skills evaluated in this interview

Associate Interview Questions asked at other Companies

Q1. What is mean of TTR & why required for powder coating process ?
View answer (17)

I applied via LinkedIn and was interviewed in Jul 2022. There were 2 interview rounds.

Round 1 - Coding Test 

First round is basically on python multiple choice questions and then it was asking 6 python easy-moderate question(Don't worry it's not like DSA) then 6 SQL questions which is kind of midium level questions.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Interviewer asked more about pandas, numpy and according to my resume. 1.what's Linear Regression (As on my resume mentioned that algorithm.)?? I can't remember such pandas and numpy questions but I can sa...
  • Q2. How is an empty class created in python.
  • Ans. 

    An empty class can be created in Python using the 'pass' keyword.

    • Use the 'class' keyword to define a class.

    • Add the class name and a colon after the 'class' keyword.

    • Use the 'pass' keyword to indicate an empty class body.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Celebal Technologies Associate Data Engineer interview:
  • Python
  • sql
Interview preparation tips for other job seekers - 1.If you are good in python and sql then you got this job.
2.If you get the job then they would definitely put you in a contract of 2 or 3 years, So remember you can negotiate as much as you can.

Skills evaluated in this interview

Associate Data Engineer Interview Questions asked at other Companies

Q1. Datastge - How will you remove Header and trailer from Sequential data file
View answer (2)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Count and say leetcode question
  • Q2. Maximum frequecy leetcode question

Data Scientist and Machine Learning Engineer Interview Questions asked at other Companies

Q1. What are supervised and unsupervised learning models?
View answer (2)
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

JOBS

Numeric Technologies India

No Jobs

JOBS

Clarion Technologies

No Jobs

SALARIES

Bridge Group Solutions

JOBS

Rapsys Technologies

No Jobs

JOBS

Sitaram Spinners

No Jobs

REVIEWS

BNP Paribas India Solutions

No Reviews

INTERVIEWS

AmbitionBox

No Interviews

REVIEWS

BNP Paribas India Solutions

No Reviews

SALARIES

Bridge Group Solutions

JOBS

Broad Air Conditioning

No Jobs

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
Chetu Interview Questions
3.3
 • 172 Interviews
View all

Celebal Technologies Reviews and Ratings

based on 546 reviews

3.0/5

Rating in categories

3.5

Skill development

3.1

Work-life balance

2.8

Salary

2.7

Job security

2.9

Company culture

2.7

Promotions

3.0

Work satisfaction

Explore 546 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
391 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
250 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Engineer
159 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
125 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