Upload Button Icon Add office photos

Filter interviews by

Celebal Interview Questions and Answers

Updated 23 Mar 2025

Celebal Interview Experiences

Popular Designations

5 interviews found

Salesforce Developer Interview Questions & Answers

user image Abhishek Sharma

posted on 23 Mar 2025

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024, where I was asked the following questions.

  • Q1. What is Salesforce crm, Salesforce Development roles, roles and profiles?, Write a trigger in apex programming language?
  • Q2. What are reports and dashboards?, when to use flow and when to use apex trigger?
  • Ans. 

    Reports and dashboards visualize data in Salesforce; flows automate processes, while Apex triggers handle complex logic.

    • Reports are structured summaries of data, while dashboards provide visual representations of multiple reports.

    • Use reports to analyze sales performance, e.g., a report showing monthly sales by region.

    • Dashboards can display key metrics like total sales, opportunities, and lead conversion rates in one vi...

  • Answered by AI

Salesforce Developer Interview Questions asked at other Companies

Q1. Write a trigger to update contact when accounts phone changed.
View answer (6)
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)
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Max salary recursive cte
  • Q2. Spark architecture
Round 3 - 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)

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 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)

Celebal interview questions for popular designations

 Data Scientist

 (1)

 Salesforce Developer

 (1)

 Associate Consultant

 (1)

 Data Engineer

 (1)

 Associate Software Engineer

 (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:
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 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)

Interview questions from similar companies

Interview Preparation Tips

Round: Resume Shortlist
Experience: CV should focus on the skill set previously mentioned. Concise and to the point sentences. Line out projects and internships well. Balance between academia and extra curriculars. Attend the CV making workshop of Opera and work on it accordingly.
Tips: Don’t put things totally irrelevant to the job profile. Don’t write long sentences. Know your CV well for further stages.Anything related to your CV should be at the tip of your tongue.

Round: Test
Experience: Don’t spend a lot of time on one question in quant section. There’s a cut-off in Quant and your focus should be on clearing it. If you clear the cut-off, the puzzle section will be evaluated, where solving at least 2 is generally good enough. Puzzles are hard, and need a lot of prior practice.

Round: HR Interview
Experience: Direct selections take place at the end of all interviews after a mutual discussion between all the panels. Know your CV thoroughly. Prepare for some HR questions as well. Puzzle solving and guesstimates are asked, so prepare them well. When you are asked a puzzle, do not sit quietly but think aloud. The interviewers help you structure your thoughts. Most of the times, just knowing your approach is enough for them
Tips: Evaluate the nature of your interviewer for the first 5 minutes and if possible treat the interview like a discussion. They just want to know more about you so tell it to them. Most of them are very friendly, and you will feel at ease. Be confident. Sound excited while talking about your projects/internships. It gives them confidence in you. Be very very thorough with your CV. Nothing gives a bad impression like not knowing about yourself. Ask questions if you have them at the end of the interview.

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skills: Mathematics, Computer Science
College Name: IIT KHARAGPUR
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

Analyst Interview Questions & Answers

ElectrifAi user image shubham gupta

posted on 17 Apr 2016

Interview Questionnaire 

7 Questions

  • Q1. How to assigning the new task to employees based on their past performance
  • Ans. 

    Assign tasks based on past performance by analyzing employee's strengths and weaknesses.

    • Analyze employee's past performance data

    • Identify their strengths and weaknesses

    • Assign tasks that align with their strengths

    • Provide training or support for areas of weakness

    • Regularly review and adjust task assignments based on performance

    • Consider employee preferences and career goals

  • Answered by AI
  • Q2. Some Probability problems
  • Q3. Some basic HR questions
  • Q4. Write a 10 digit largest number with some constraint (I didn’t remember the exact constraint but it’s a standard question)
  • Q5. Guesstimate the number of viewers to a sports blog
  • Ans. 

    Assuming the blog covers popular sports, the number of viewers can range from a few thousand to millions depending on the quality of content and marketing strategies.

    • Consider the popularity of the sports covered in the blog

    • Evaluate the quality of content and frequency of updates

    • Assess the marketing strategies used to promote the blog

    • Look at the engagement level of the blog's social media accounts

    • Take into account the c

  • Answered by AI
  • Q6. Guesstimate how much a thief, who operate on shopping can earn in a year
  • Ans. 

    A thief operating in shopping can earn anywhere from a few thousand to millions of dollars per year depending on their tactics and location.

    • The thief's location and the type of stores they target will greatly impact their earnings

    • Factors such as the thief's level of experience, skill, and risk-taking behavior will also play a role in their earnings

    • Some thieves may work alone while others may operate in organized groups...

  • Answered by AI
  • Q7. The probability of a car passes the highway in a subset time if the probability of a car passing in one hour given

Interview Preparation Tips

Round: Resume Shortlist
Experience: There were 3 Job profiles open of opera solutions (Solution Analyst, Analytics Specialist, and Software Engineer). Students are asked to sign just for one profile. There was a test for analytics and software profile and direct interview for solution profile (Consultant profile).
Tips: Spend enough time before choosing the profiles. Spoke to senior who had a similar job and figure out your best suitable profile and prepare accordingly.

Round: Test
Experience: Opera solution conducts workshop for shortlisted candidates. In the workshop, they mostly tell about technical part behind big data management such as Mainframe and Hadoop. After the workshop, the test was conducted. The test had two sections, the first section contains objective questions around 20-25 (I did not remember the exact number). Objective questions were of aptitude type (moderate level of difficulty). The second section contains 5-6 subjective questions, mainly focus on probability again the moderate level of difficulty. 30 students were shortlisted for next round (interview round).
Tips: Start preparing as early you can. Practice problem daily does not wait for last few day. The main point of practice is to develop a habit of increasing accuracy and speed which is the crucial points of aptitude test.
For probability practice, there are online website and blogs you can take help from them. I have listed down some which are used. You should have some prior practice before setting for test otherwise, it would be difficult to do well in the test as some questions are tricky and difficult to solve in the first time.
For aptitude practice, you can refer TIME material, I think that is sufficient.

-----/
-----.shtml
-----
-----.html

Duration: 60 min minutes
Total Questions: 20+5

Round: Guesstimate Interview
Experience: The interviewer first goes through my resume and ask some basic question, not in depth. Then he asked me some puzzle (similar type of question asked in the subjective paper but with a high level of difficulty) and one guesstimate.
My interview last for 10-15 mins, the interviewer is very helpful and always try to calm and comfort me.
The interviewer gave me feedback and point out some area on which I can quickly look it for further interview.

Tips: I have assigned a buddy, IIT graduate having the same specialization. (Opera solutions follow buddy program similar of other consultant company). I personally found out buddy program very useful, you should contact your buddy or at least talk to him ones. The information you get from a buddy is very helpful of preparing for an interview. You get some aspect on which domain you need to work.

Round: Technical Interview
Experience: Next round was the telephonic interview with a senior analyst. The interviewer asked me some question from my resume especially on the technical project which involves some mathematics tool.
Then he asked some probability problems which are very tough.

Tips: The interviewer was interested in your approach only, how you’re tackling the problem. How much wide can you think? The interviewer is also ready to help you and try to figure out your strength. So be calm and speak with confidence.

Round: Stress Interview
Experience: The interviewer asked me some question from my resume in depth.
He asked one guesstimate and one probability question.

Round: Behavioural Interview
Experience: The interviewer started with questions like why this company, which other companies did I appeared for.
He asked me some quick calculation problems.

General Tips: Resume: Spend sufficient time on the resume as I was the initial step of shortlisting.
You be able to speak at any point in your resume in detail, hence you must be sure of what you are writing in it.

Puzzle: Practice Daily

Guesstimate: Practice with your sincere friends
Skills: Ability To Make Quick Calculations, Puzzle Solving Capability, Knowledge Of Your Resume Points, Guesstimation Cases, Probability And Statistics
College Name: IIT Bombay

Interview Preparation Tips

Round: Resume Shortlist
Experience: I started preparing my resume somewhere around August end. I spoke to a few seniors about it and read quite a few resumes, especially of those seniors who either had a profile similar to mine or had secured jobs in fields of my interest, eg. Consulting, finance, etc. I also attended the Resume Writing Workshop conducted by McKinsey and Co. on campus and cleared a few doubts there.
Tips: I would advise you guys to start preparing your resumes well in advance, it is not something to be kept for the last minute. Being the first form of acquaintance between you and a firm, it is a highly important document and the way you highlight your strong points and attributes can go a long way in shortlisting you from amongst the hundreds of resumes that they have to scan. Also, it is important that you be able to speak on any point in your resume in detail, hence you must be sure of what you are writing in it.

Round: Case Study Interview
Experience: The procedure of selection for Opera Solutions was a set of 4 interviews, each having a case study and some HR questions. The initial shortlist had around 22 candidates, after the first 2 interviews around 10 candidates were selected for the final rounds. Finally 3 candidates were made offers.  There were no GDs, only case interviews. The first interview had a case involving a music company which scouts for amateur talent and launches them. They want to enter India and want you to analyse the market and suggest if its feasible or not. The interviewer gave a lot of data related to market share of pop music, bollywood, devotional music, etc and it suggested that the market share of the genre related to the company is very little. However I think what worked best was that I also pointed out certain solutions which could make it feasible, such as merging with another company in a genre where the given company has core competencies in. I think this was the high point of the interview which I atleast would like to believe compensated for a later interview that I did not do well in. Another interview had a case where a pharmaceutical company in the US wants to enter India. A set of constraints and data was given and I was asked to calculate if it should actually setup a manufacturing facility in India or manufacture in the US and transport to India. I did not do well in this one, I wasn’t being able to come up with a figure. Both the interviews had an HR component where I was asked about my strengths and weaknesses, about Mood Indigo and my academic record. I was asked to describe myself. I was also asked to talk about my co-intern’s project in ITC (she was also interviewing with Opera). In a subsequent interview after the shortlist, I was asked to estimate the market for Maruti cars, domestic air travel. They weren't expecting too much detail, the interviewer was more interested in the approach. point.
Tips: I attended most of the initial PPTs. One does get a good understanding of what a firm does and where exactly do you fit into it, you also understand what they are looking for and what is the extent of their operations. I must admit though that I found my interaction with seniors, especially those working in those firms was more informative and fruitful. They can give clarity in certain grey areas that companies might stay non-committal on.ending across links/documents would help us compile a single point resource) . I prepared for case studies from the material I took from seniors, most of which is available on the LAN. For case studies I prepared with a friend and sometimes in groups of 3. I think this method is better than individual preparation because the other person can point out where you are going wrong, you get a different perspective and at the same time you can prepare in a fashion where one interviews the other and vice versa, so you get slightly comfortable with how an actual interview might feel like. It is however important to ensure that the person you are preparing with is competent and complementary to your skill sets, so that you can improve upon aspects where you might be lacking in.

General Tips: Case studies and HR questions. One should be very comfortable with points mentioned in the resume and should be able to talk at length about any . I guess it'd just be shifting a little from being myself if you know what I mean. A lot of seniors would give you a lot of fundae, but at the end one must remember that unless one is comfortable with a certain way of speaking or certain method of solving cases, it wont look genuine. For example, one need not thrash out every single detail of a case before beginning to solve it, sometimes the interviewer might get impatient or might think you are trying to buy time to think by asking unnecessary details. So if you are the kind of a person who can intuitively draw good conclusions at the outset so as to decide which direction to proceed in and hence which questions to ask, you can surely go ahead and do that, you need not also ask questions that you know are not required. Case interviews are very feel-good interviews, even if you make a mistake you will be guided back on track by the interviewer, hence I personally would recommend that you stick more to your general approach to solving cases (if you know it is a good one and works of course) and not try to change too much just because a certain senior did it in a different way.
College Name: IIT BOMBAY

Analyst Interview Questions & Answers

ElectrifAi user image Himanshu Sharma

posted on 26 Mar 2015

Interview Preparation Tips

Round: Resume Shortlist
Tips: Resume building is the most important of all steps. Keep it concise and to the point.

Round: Test
Experience: Puzzles
Tips: Practice as many puzzles as possible

Round: Stress Interview
Tips: Keep your cool, divert interview towards your strong zones

Round: Technical Interview
Experience: Guesstimates (basic level) and puzzles. Also know your resume and courses well

General Tips: They want to check your thinking, try every problem given in interview. They would have simple solutions.
Skills: Critical Thinking
College Name: IIT DELHI
Motivation: Application of statistics

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume is the candidates face before the interview. All the things that he/she wants to communicate should be communicated well and in an organized manner. Giving excessive and irrelevant information doesn’t heed well with the company and the recruiting staff. For, non-core jobs a long resume is not necessarily a good resume. They generally prefer a short and concise resume giving only the details relevant to the job profile being offered. For example, for a post of Business Analyst giving a long list of technical and course projects will not help the candidates cause. I personally focussed a lot on Position of Responsibilities and extracurricular activities, especially those showcasing my leadership and oratory skills.

Round: HR Interview
Experience: The first interview began with some questions about me. The interviewer asked me to tell something about me and my hobbies. Then he moved on to my resume and asked questions related to my intern and the PORs I had held and asking me to give a brief description about the duties involved. These questions were basically to ease me into the interview. Then he asked the routine interview questions like why consulting, why not a core job, what makes you think you are suited for this job. He asked me to relate some incident that showcased my leadership and teamwork skills. After the HR part, he gave me a case study. I was asked to estimate the market size of the bulbs market in India. It was an easy enough case study and I asked a lot of questions like whether I have to estimate for commercial and domestic both, for bulbs and CFL both etc. The catch in the question was to consider the replacement ratio for the bulbs and CFL.

Round: HR Interview
Experience: The second interview also had a similar beginning with the routine questions. Then he moved on to case study which was a number crunching problem. He gave me almost no details and just narrated the situation. I had to as all the questions probing for the numbers and the data. The case went on as he kept elaborating the case with new additions.

Also, the interviewer was senior partner in the firm and I felt that I had made a genuine rapport with him. I felt free and asked him a lot of questions about his job, the job profile and how important an MBA degree is for the future. He explained me the details and I had a very healthy communication with him.

Round: HR Interview
Experience: This one was pretty short and quick. The interviewer decided to ask me questions about my hobbies. We discussed about Hollywood movies, actors, football and my other interests. We both shared an interest in Hollywood movies and we had a nice time discussing the merits of my favourite actor, MORGAN FREEMAN. Then he gave me a puzzle. There are 25 horses and only 5 can race in one race. I had to determine the fastest three horses in the minimum number of races (the answer is 7. Try it out. It’s not very tough). I was not able to solve the puzzle on my own but he guided me with various clues and finally I was able to complete the puzzle with his help.
Tips: Be prepared with the routine answers but don’t mug them up. Remember them in points and elaborate them as you go through the monologue. Answers to questions like why consulting and why should we hire you should be prepared very well. Prepare these answers yourself and don’t mug up some standard answers. The interviewer will know when you do that. Prepare some questions of your own about the job and the company and ask them to the interviewer when he gives you the chance. Don’t get nervous if you can’t get some question but instead try a new approach or ask for help.

General Tips: Focus a lot on extracurricular and PORs in the resume but at the same time keep it balanced. Prepare for case study interviews and puzzles. Be through with your resume and why you are there for the interview. Getting selected for the interview means you have an equally good opportunity as anyone else, so be confident.
College Name: IIT KANPUR
Motivation: The major information about the company was obtained from the pre-placement talk held by the company at the college campus. Also I talked to some of my seniors working there and in other consultancy firms as business analyst to get a feel about the profile and job description. Also enquiring about the attributes that the company majorly looks for from the seniors helped a lot.

Celebal Interview FAQs

How many rounds are there in Celebal interview?
Celebal interview process usually has 2-3 rounds. The most common rounds in the Celebal interview process are One-on-one Round, Resume Shortlist 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. What is Salesforce crm, Salesforce Development roles, roles and profiles?, Writ...read more

Tell us how to improve this page.

Celebal Interview Process

based on 5 interviews

Interview experience

4.4
  
Good
View more

Interview Questions from Similar Companies

CGS Interview Questions
3.5
 • 25 Interviews
ElectrifAi Interview Questions
2.7
 • 17 Interviews
Fusion Interview Questions
3.3
 • 17 Interviews
View all

Fast track your campus placements

View all

Celebal Reviews and Ratings

based on 24 reviews

2.5/5

Rating in categories

2.5

Skill development

2.5

Work-life balance

2.6

Salary

2.5

Job security

2.4

Company culture

2.3

Promotions

2.3

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

Primus Global Technologies

3.9
Compare

TriGeo Technologies

3.2
Compare

GrapplTech

4.8
Compare

Plada Infotech Services

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview