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

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

I applied via Campus Placement 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 Sum Problem Given an array or list ARR consisting of N integers, your task is to identify all distinct triplets within the array that sum up to a specified number K. Explanation: A triplet is a set {ARR[i], ARR[j], ARR[k... read more
View answer (2)
Celebal Interview Questions and Answers for Freshers
illustration image
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)
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:
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 

(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

 Data Scientist

 (1)

 Associate Consultant

 (1)

 Data Engineer

 (1)

 Associate Software Engineer

 (1)

Interview questions from similar companies

I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is Excel what is vlookup what is your strength and weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and bold

I was interviewed before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

  • Q1. 

    Sum of Two Numbers Represented as Arrays

    Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

  • Ans. 

    Given two numbers represented as arrays, calculate their sum and return the result as an array.

    • Iterate through the arrays from right to left, adding digits and carrying over if necessary

    • Handle cases where one array is longer than the other by considering the remaining digits

    • Ensure the final sum array does not have any leading zeros

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR 

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear basics of oops and design pattern

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

I applied via Campus Placement and was interviewed before Jan 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. First question in hr interview is tell about yourself then the hr asked questions what I mentioned in my resume. So put the information in resume what you known well. My unique talent is I'm a stage spea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold, be confident, don't put irrelevant information in your resume update yourself relating to your studies

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

Interview Questionnaire 

1 Question

  • Q1. 1.interviewer asked about my mini Project, some questions from my project on Machine Learning and some basic HR questions 2.If you have mentioned some projects in resume the interviewer will surely ask fr...

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and answer confidently
Be good on basics whatever domain you're from.
Good to know basics of one programming



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

Iris Software

No Interviews

INTERVIEWS

Gainsight

No Interviews

INTERVIEWS

Aspire Systems

No Interviews

INTERVIEWS

Einfochips

No Interviews

INTERVIEWS

Celebal

No Interviews

INTERVIEWS

Gainsight

No Interviews

INTERVIEWS

Einfochips

No Interviews

INTERVIEWS

Einfochips

No Interviews

INTERVIEWS

Lentra AI

No Interviews

INTERVIEWS

TEKsystems

No Interviews

Tell us how to improve this page.

Celebal Interview Process

based on 4 interviews

Interview experience

4.3
  
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
 • 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

₹0 L/yr - ₹0 L/yr

Software Engineer
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Developer
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
3 salaries
unlock blur

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