Upload Button Icon Add office photos

Filter interviews by

Celebal Interview Questions and Answers

Updated 11 Mar 2024

Celebal Interview Experiences

Popular Designations

4 interviews found

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

I applied via campus placement at ABES Engineering College, Ghaziabad and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

The first round was apptitude round in which total question was 35 .it was a pen paper exam and there is a reasoning ,appitude,python,c question.

Round 2 - Coding Test 

It was also a pen paper round.There was a four set in some set has 2 question or 4 questions.I am selection in this round.

Round 3 - One-on-one 

(1 Question)

  • Q1. It was a interview round where one coding question was asked and code of function overriding .difference between compile time and run time polymorphism and std in c++ . difference between refernce and a po...

Interview Preparation Tips

Interview preparation tips for other job seekers - strong oops concept and coding question on topic array and string and c++ knowledge

Associate Software Engineer Interview Questions asked at other Companies

Q1. Triplets with Given SumYou are given an array/list ARR consisting of N integers. Your task is to find all the distinct triplets present in the array which adds up to a given number K. An array is said to have a triplet {ARR[i], ARR[j], ARR[... read more
View answer (4)

Societe Generale Global Solution Centre

Be part of a company where work complements life, not consumes it

Rated 4.1/5 for Work-Life Balance by our employees

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

(2 Questions)

  • Q1. Max salary recursive cte
  • Q2. Spark architecture
Round 2 - One-on-one 

(3 Questions)

  • Q1. Personal interview
  • Q2. SQL and python questions
  • Q3. Databricks and PYSPARK

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on SQL and python

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 Interview Questions and Answers for Freshers
illustration image

Data Scientist Interview Questions & Answers

user image Simran Geryani

posted on 1 Oct 2023

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

I applied via Walk-in and was interviewed in Apr 2023. 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 - Assignment 

Made a machine learning model

Round 3 - Technical 

(2 Questions)

  • Q1. Python and SQL and. Data science questions
  • Q2. How would you Handle imbalanced data, imputation techniques
  • Ans. 

    Handling imbalanced data involves resampling techniques like oversampling or undersampling. Imputation techniques include mean, median, mode, or predictive modeling.

    • For imbalanced data, consider using techniques like oversampling (SMOTE) or undersampling to balance the classes.

    • Imputation techniques include filling missing values with mean, median, mode, or using predictive modeling like KNN or Random Forest.

    • Evaluate th...

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. Why should we hire you
  • Q2. Will you be able to give 40 hours a week

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good at python SQL and data science basics as well as supervised machine learning

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed before Nov 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Asked about my past experience
  • Q2. I have experience of dot.net for 2years

Associate Consultant Interview Questions asked at other Companies

Q1. There are 2 cricket teams, A and B, with 11 players each. If every player of team A shakes hands with every player of team B(once), what will be the total number of handshakes?
View answer (15)

Celebal interview questions for popular designations

 Associate Consultant

 (1)

 Associate Software Engineer

 (1)

 Data Engineer

 (1)

 Data Scientist

 (1)

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Aptitude Test 

The test went good with good logical questions

Round 2 - Technical 

(3 Questions)

  • Q1. They asked about the python frameworks related
  • Q2. In this they about the flask and Django questions
  • Q3. They asked about the Cloud related question API related questions.
Round 3 - HR 

(1 Question)

  • Q1. Related to the discussion on my location

Interview Preparation Tips

Interview preparation tips for other job seekers - the best company for the Freshers, and experienced people
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via campus placement at Bharati Vidyapeeth's College of Engineering for Women, Pune and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Permutations, probability etc

Round 2 - Technical 

(5 Questions)

  • Q1. Dbms ,oops , dsa
  • Q2. Write SQL query for joining two tables
  • Ans. 

    SQL query for joining two tables

    • Use the JOIN keyword to combine rows from two or more tables based on a related column between them

    • Specify the columns to be retrieved using SELECT statement

    • Use ON keyword to specify the join condition

  • Answered by AI
  • Q3. Analysis questions consists comparison
  • Q4. Array indexing, sorting array
  • Q5. Reverse the string
  • Ans. 

    Reverse a given string

    • Use a loop to iterate through the characters of the string and build a new string in reverse order

    • Alternatively, you can use built-in functions like reverse() or StringBuilder in some programming languages

  • Answered by AI
Round 3 - Group Discussion 

Basic GD topic was there

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be urself and give 100%

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. Basic questions about the experience and the product worked on

Interview Preparation Tips

Interview preparation tips for other job seekers - I interviewed with Techved consulting and had a horrible experience, it was like a bad dream.The process was a mess from start to finish ,process started with getting a call from the company HR, second interview was scheduled with CEO after 9 pm ,before logging in zoom call i confirmed with HR for the scheduled interview at 9 pm & was confirmed by HR ,waited for more than 15 minutes and nobody turned up ,after 9:15 pm HR says CEO is busy & rescheduled it to another day at same time 9 pm ,this time too before logging in I confirmed with HR if the CEO will turn up for the interview which I was told yes and I logged and waited for CEO to join but he didn't after multiple calls & Text to HR , finally CEO joins the meeting around 9:30 Pm,spoke to CEO for 10-15 minutes & he asked me to come down to his office for final conversation with him.Went to the mumbai office,they gave me a form to fill and strangely asked me to write an essay which i never did for any other company being having so many years of job experience.
And also till the time you don't reach their office HR will follow up with you like anything ,once you enter the office then it's totally a different world. Mine second half of the day was totally wasted they call me in goregaon office & intentionally eats your time for the meet which was mutually pre booked and confirmed scheduled.So after filling the form i was made to wait for long time before this person Francis comes who was never present in whole process and again takes the interview & he asked everything in detail of companies worked ,your targets ,incentives, remuneration etc and when asked him about his company salary & incentive structure he didn't reply & said that will be informed later also the budget they have is less of what I am expecting but the incentive is great and people are making three times of salary as their incentive ,asked him whats the target given on which he reply it will be informed later ,They want to ask you everything & when you ask them response is, it will be informed later .I told him I already had a discussion with another HR about the budget on which i was assured its fairly in range and also I am here as per the CEO, for meeting him for final discussion.After that I was again made to wait for more than a hour and they keep moving you from 1st floor to 2nd floor as per their small conference room availability.After waiting for about 3 hour I told the HR that I am getting late & will be leaving as I have another work commitment on which HR looks for CEO and ask me to wait for few more minutes,just when I was about to meet CEO, Francis ask me to wait and sends a girl who came to interview much after me being there, which was highly unprofessional & then francis ask me to meet another guy on different floor for interview before meeting the CEO ,gave the interview to this new guy and again they want to know everything about you and when u ask about the job nature and process he said he is from finance team once you join the team will guide u ,also they don't pay u for the days you worked for since their salary cycle is 20 to 21 and they hold employee salary of the 10 days and give it as FNF when employee resigns which is absurd .So after extensively speaking with HR & CEO on call along with waiting for more than 3 hour Francis comes an says that I have more experience and they are looking for a junior role with less experience and I can leave now,I told him I spoke extensively with HR and also with the CEO ,who invited me for the final meeting .First company found where the HR is more powerful than CEO & override CEO commitment & does insult candidate with zero respect for candidate time. Too many hints they gave as Red Flag ,it's a typical lala company with baniya employees behaviour.
-10 rating for Techwait Insulting company
Ceo should make their HR write an essay on basic human interaction,work ethics ,Time management, professionalism & Toxic traits.
Life Tip - before joining this company make sure you have a good Health & Term insurance .
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Asdasdasdasdasdasdadsasdasda
  • Q2. Asdasdasddasdasdasdasdasdasda
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Sep 2024. There were 5 interview rounds.

Round 1 - Coding Test 

Easy Level DS Questions - 30 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Cloud Services related questions
  • Q2. ETL Based question
Round 3 - Coding Test 

A comprehensive coding test which included job role simulation.

Round 4 - Coding Test 

Advanced Cloud Services questions

Round 5 - HR 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am a Senior Software Developer with 8 years of experience in full-stack development, specializing in Java and Angular.

    • 8 years of experience in full-stack development

    • Specialize in Java and Angular

    • Strong problem-solving skills

    • Experience working in agile environments

  • Answered by AI
  • Q2. Why did you leave your last organisation

Interview Preparation Tips

Interview preparation tips for other job seekers - Remote work although partially supported, is highly discouraged.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Solve the problems of maths

Round 2 - Technical 

(1 Question)

  • Q1. It's about the computer knowledge
Round 3 - HR 

(1 Question)

  • Q1. Take interview of the candidate

Interview Preparation Tips

Topics to prepare for HGS TECHNOLOGIES Project Management Officer interview:
  • Maths and computer
Interview preparation tips for other job seekers - Good
Contribute & help others!
anonymous
You can choose to be anonymous

Celebal Interview FAQs

How many rounds are there in Celebal interview?
Celebal interview process usually has 3 rounds. The most common rounds in the Celebal interview process are Resume Shortlist, One-on-one Round and Technical.
How to prepare for Celebal 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. The most common topics and skills that interviewers at Celebal expect are Apex, Salesforce, Web Development, Web Services and Agile Coaching.
What are the top questions asked in Celebal interview?

Some of the top questions asked at the Celebal interview -

  1. How would you Handle imbalanced data, imputation techniq...read more
  2. it was a interview round where one coding question was asked and code of functi...read more
  3. Python and SQL and. Data science questi...read more

Recently Viewed

INTERVIEWS

Boeing

85 interviews

Tell us how to improve this page.

Celebal Interview Process

based on 4 interviews

Interview experience

4.3
  
Good
View more

HCLTech

Workplace transformation starts with you

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
 • 788 Interviews
View all

Fast track your campus placements

View all

Celebal Reviews and Ratings

based on 24 reviews

2.2/5

Rating in categories

2.2

Skill development

2.2

Work-life balance

2.4

Salary

2.2

Job security

2.1

Company culture

2.1

Promotions

2.0

Work satisfaction

Explore 24 Reviews and Ratings
Salesforce Developer
27 salaries
unlock blur

₹3 L/yr - ₹6 L/yr

Software Engineer
7 salaries
unlock blur

₹4.2 L/yr - ₹17.2 L/yr

Data Engineer
6 salaries
unlock blur

₹4.5 L/yr - ₹8 L/yr

Software Developer
3 salaries
unlock blur

₹5.4 L/yr - ₹17.5 L/yr

Associate Software Engineer
3 salaries
unlock blur

₹6 L/yr - ₹6.5 L/yr

Explore more salaries
Compare Celebal 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