AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Celebal Technologies
Compare
Filter interviews by
Celebal Technologies Business Analyst Interview Questions and Answers
Celebal Technologies Business Analyst Interview Experiences
2 interviews found
Selected
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
(3 Questions)
- Q1. What are the principles of the Project Management ?
- Ans.
Project Management principles are fundamental guidelines for managing projects effectively.
Clear objectives and goals must be defined at the beginning of the project.
Effective communication is essential for all stakeholders involved in the project.
Proper planning and scheduling are crucial for successful project completion.
Risk management strategies should be in place to address potential issues that may arise.
Regular ...
- Q2. Explain the functioning of the Project that you worked on ?
- Q3. Explain some of the Python functions you worked on in the Project with the values ?
- Ans.
I worked on Python functions in the project to manipulate data and perform calculations.
Used Python functions like 'sum()', 'max()', 'min()' to calculate total, maximum, and minimum values of datasets.
Implemented custom functions to clean and preprocess data before analysis.
Utilized functions like 'filter()', 'map()', 'reduce()' for data transformation and aggregation.
Created functions to generate visualizations using
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Very simple easy questions. Interviewer herself looked very immature and not knowlegeable.
- Q2. Sdlc, Basic steps
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Sahil Chhabra
Interview Questionnaire
1 Question
- Q1. For me there was just one interview combined of guesstimates and Puzzles
Interview Preparation Tips
Experience: Consisted of 5 sections - English, Quant, Logical Reasonong, Statistics, Probability/Analytical questions. 10 questions per section. Medium level difficulty. It was followed by an subjective test by 1 question. The question was describe the most challenging experience while working in a Team.10 mins for this question
Tips: Practise Quant and logical reasoning. Stay focussed and confident.
Duration: 60 minutes
Total Questions: 50
Round: Group Discussion
Experience: First 1 min everyone has to speak then the group has to conclude in last 5 mins.
Tips: Reading newspaper is a must.
Duration: 20 minutes
Round: Interview
Experience: 1. Estimate the length of your hairs.2. What will you infer from the data of your collage (if provided) consisting of name contact details rank and sitting/not sitting for placements.3. Divide a disk/circle into 8 equal parts.4. 100 coins to be put into infinite boxes. How to place so that by just taking the EXACT number of boxes I can have money of any denomination under 100.5. 10% discount followed by 15% discount and then vice-versa. Which is better for shopekeeper?
Tips: Ans to last 33. three cuts4. 1 2 4 8 16 32 375. same for both
General Tips: Read about the company and work profile before hand. It helps a lot to frame the answer of Why Axtria?
Skill Tips: Practise and stay confident
Skills: Quantitative, communication skills
College Name: IIT Kharagpur
Motivation: Analytical job. Tremendous growth opportunities.
P B Viswa Vardhan
Interview Questionnaire
14 Questions
- Q1. He gave me a puzzle to solve
- Q2. What is your GRE score ?
- Ans.
I apologize, but I do not have a GRE score as it is not applicable to my role as a Business Analyst.
As a Business Analyst, my skills and experience are evaluated through my work history, education, and certifications.
GRE scores are typically required for admission to graduate programs, but not for a Business Analyst position.
My focus is on utilizing my analytical and problem-solving skills to support business decisions
- Q3. What is your CAT score ?
- Ans.
CAT score is not applicable for a Business Analyst role.
CAT score is a standardized test for admission to management programs.
It is not relevant for a Business Analyst role.
Business Analysts require skills in data analysis, problem-solving, and communication.
Other relevant qualifications for a Business Analyst role include a degree in business, economics, or a related field, and experience in data analysis or project m
- Q4. Why do you want to join our firm?
- Ans.
I am impressed with the company's reputation and growth potential.
Your company has a strong reputation in the industry.
I am excited about the opportunity to work with a talented team.
I believe your company's growth potential aligns with my career goals.
Your company's values and mission resonate with me.
I am impressed with the innovative projects your company is working on.
- Q5. Who is the CEO of our company ?
- Ans.
I'm sorry, I don't have access to that information.
No data available
I don't have access to that information
- Q6. You have written some PORs in you CV, But I feel this is not at all a POR!!! ?
- Q7. What are your plans for the future?
- Ans.
My plans for the future include continuous learning, career growth, and contributing to the success of the company.
Continuously improve my skills and knowledge through training and development programs
Take on challenging projects and responsibilities to advance my career
Collaborate with colleagues to achieve company goals and objectives
- Q8. How do people remember you by ? define it in one word
- Ans.
Reliable
Consistent in meeting deadlines and delivering quality work
Trustworthy and dependable
Known for being organized and detail-oriented
- Q9. What are your 2 strengths ?
- Ans.
My strengths are attention to detail and problem-solving skills.
Attention to detail helps me identify potential issues and ensure accuracy in my work.
Problem-solving skills enable me to analyze complex situations and find effective solutions.
For example, in my previous role, I was able to identify a flaw in the company's inventory management system and proposed a solution that saved the company thousands of dollars.
I a...
- Q10. What is your weakness?
- Ans.
My weakness is public speaking.
I tend to get nervous when speaking in front of large groups.
I am actively working on improving my public speaking skills through practice and training.
I have found that preparing thoroughly and practicing beforehand helps me feel more confident.
I also try to focus on the message I am trying to convey rather than my own nerves.
- Q11. What people dont like in you ?
- Q12. Where do you see yourself 5 years down the line ?
- Ans.
In 5 years, I see myself as a senior business analyst leading a team and contributing to the growth of the company.
Leading a team of business analysts
Contributing to the growth of the company through data-driven insights and recommendations
Continuing to develop my skills and knowledge in the field of business analysis
Building strong relationships with stakeholders and clients
Exploring opportunities for process improvem
- Q13. What is your JEE Rank, 10th and Inter Math score ?
- Ans.
I do not have the JEE rank, but my 10th and Inter Math scores are above average.
I do not have my JEE rank available at the moment.
However, my 10th and Inter Math scores are above average.
I can provide more details on my academic achievements and relevant experience.
For example, I have completed a course in data analysis and have experience in using SQL for data querying.
- Q14. He too asked me a puzzle on probability
Interview Preparation Tips
Experience: The test was organized by cocubes.com .After writing many tests in cocubes.com , I felt a little better and easier.
Tips: Answers the questions you know. Don't forget to tick all the left overs before submitting the test if there are no negative markings :P .Write the exam in your normal pace. Don't panic or get tensed. Just be your self
Duration: 50 minutes
Total Questions: 50
Round: Group Discussion
Experience: We were 15 in the group. This wasn't like normal GDs. We were given a minute each to speak. I was the last member to speak. Almost all the points were covered. I did add new points and new dimensions to the discussion.
Tips: You will find many tips on the Internet.The most important thing I felt was " Create interest in people to listen to what you are speaking, And Speak the right things". Maintain Eye contact. Smile often. Always add points to the make the discussion constructive.
Round: Interview
Experience: I was a bit stressed out when he pointed out that I didn't do the works which actually I did them. But I always kept my cool. Answered him wisely.
Tips: Be Honest. take your time. Never admit the things which he will try to confuse you. Better answer him the right way than answering him quickly. Be a thoughtful person
Round: Interview
Experience: I was honest through out the interview.
Tips: Always be Honest. Keep your confidence levels high.Do your Homework. Prepare before hand for the most important HR questions. Don't fumble upon in front of the interviewer. Rehearse the answers which you have written down in front of a mirror or Best Friend. I prefer Friends to mirror as mirrors don't give you feedback :P .
General Tips: Be Honest.Just Recollect your past events.
Skill Tips: "Be yourself and " Sell the buyer what he is looking for ""
Skills: Quick learning, Confidence, Logical reasoning
College Name: IIT Kharagpur
Motivation: Good learning environment and Data Analysis is an emerging field.
Funny Moments: As soon as I entered the room HR was busy doing some phone calls and stuff, After a minute I asked him whether He was tensed :P :D
Interview Preparation Tips
Experience: It was not a group discussion to be exact. It was more like an extempore. We were given 2-3 minutes before starting, to think about the topic and then the coordinator would call out a name and that person had to speak for about 2 minutes or so, after which the coordinator would call another name.
Tips: Take a paper with you to write down the points.
Always make short points and elaborate on your own. Don't write down the whole paragraph. It wastes a lot of time.
Don't deviate from the topic. Just make sure whatever you speak, in favor or against, should make sense.
Do not use any fake accent.
Duration: 10 minutes
College Name: IIT ROORKEE
Interview Questionnaire
4 Questions
- Q1. A plane is 200Km away from its destination and starts to descend. What would be the angle at which the plane descends? (Guesstimates)
- Ans.
The angle at which the plane descends cannot be accurately determined without additional information.
The angle of descent depends on the rate of descent and the distance remaining to the destination.
The weight of the plane, wind speed and direction, and other factors can also affect the angle of descent.
Without knowing the rate of descent or the remaining distance, it is impossible to accurately estimate the angle of d
- Q2. General Questions from resume
- Q3. Why am I opting for a job instead for MS/MBA?
- Ans.
I believe gaining practical experience in a job will complement my theoretical knowledge from MS/MBA.
Practical experience is crucial for a business analyst role
A job will provide opportunities to apply theoretical knowledge in real-world scenarios
A job will also help me develop soft skills such as communication and teamwork
MS/MBA can be pursued later for further career growth
A job can provide financial stability while
- Q4. Which area would I love to work after I join Axtria?
Interview Preparation Tips
Experience: My Final Year Thesis was on Data Analytics which was a big plus. I was asked general questions on the aim of my project and how can I sell it to the concerned persons. It was a short interview of about 15-20 mins.
I told the interviewer that 5-10 degree would be the angle at which the plane will be descending but he forced that it is too less. Having seen a lot of air crash investigations, I was sure about it and confidently proved that 5-10 degrees is good enough by assuming the altitude at which the plane flies.
Tips: Practice Guessestimates. Be confident on what you say. You should be thorough with every point written on your resume.
Round: HR Interview
Experience: It wasn't hard to convince him about going for Job instead of MS/MBA. No such difficulty in answering the questions put forth by the interviewer.
Skills: Confidence, Knowledge of Analytics
College Name: IIT GUWHATI
I appeared for an interview before Mar 2016.
Interview Questionnaire
6 Questions
- Q1. Tell me about yourself. Resume based questions. Be well prepared with your resume. Guesstimate and puzzles.
- Q2. Guesstimate: Estimate the quantity of detergent used in india in 1 year.
- Ans.
Approximately 2 million metric tons of detergent is used in India annually.
Consider the population of India and the average usage of detergent per person.
Factor in the usage of detergent in industries and commercial establishments.
Take into account the different types of detergents used for various purposes.
Refer to market research reports for more accurate data.
Assume a growth rate in detergent usage based on populati...
- Q3. Puzzle: Given a dice with only 2 possible outcomes 1 & 3 and with probabilities 1/3 and 2/3 respectively. What will you do so that the dice can be used for tossing(in tossing, we expect unbiased outcomes).
- Q4. Any questions?
- Ans.
Yes, I have a few questions regarding the role and responsibilities of a Business Analyst.
Can you tell me more about the company's current business processes?
What are the key performance indicators (KPIs) that the company tracks?
How does the company measure the success of a project?
What tools and software does the company use for data analysis?
Can you provide an example of a successful project that the Business Analyst
- Q5. The interviewer asked general questions about me and varanasi city. Since i am from non-circuit branch, he asked why i am not choosing to go for core jobs. Then Basic programming questions in python and f...
- Q6. Do you have any questions?
Interview Preparation Tips
Experience: Employer was cool and has made it very comfortable. It was more of a friendly conversation.
Tips: Which ever analytics interview it is, you should have thorough practice in guesstimates, case studies and puzzles whether or not you have done any project in analytics.
Round: Technical + HR Interview
Tips: Staying confident is important. You can make best use of 'Do you have any questions?' It can give good impression on you if you can ask good questions about the profile/working/competitors etc. If you are shortlisted go through the company website to know about the company. That will help you a lot in asking these type of questions.
Skills: Problem Solving Abilties, Programming, Communication And Confidence
College Name: IIT BHU
I applied via Company Website and was interviewed before Jul 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Scrum
- Q2. Agile
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Intellect Design Arena
Anonymous
posted on 21 Nov 2021
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. How to route a payment from foreign country to domestic?
- Ans.
To route a payment from foreign country to domestic, one can use international wire transfer or online payment platforms.
International wire transfer can be done through banks or money transfer services
Online payment platforms like PayPal, TransferWise, or Payoneer can also be used
Exchange rates and fees should be considered before choosing a method
Compliance with regulations and documentation requirements is important
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
3 Questions
- Q1. Tell us about yourself
- Ans.
I am a business analyst with experience in data analysis and project management.
I have a degree in business administration
I have worked with various industries including healthcare and finance
I am skilled in data visualization and reporting
I have experience in leading cross-functional teams
I am proficient in SQL and Excel
- Q2. What is your area of interest?
- Ans.
My area of interest is data analysis and visualization.
I enjoy working with large datasets and finding insights through data analysis.
I have experience using tools such as Excel, Tableau, and Python for data analysis and visualization.
I am interested in exploring new data sources and learning new techniques for data analysis.
For example, I recently worked on a project analyzing customer behavior data for a retail compa...
- Q3. What are the other companies you have applied to and how many rounds of the selection process have you cleared there?
Interview Preparation Tips
Experience: The selection process was open for students from all branches. Around 70 students were shortlisted based on their resume. Shortlisting was mainly on CGPA basis and on an average 5 top students were shortlisted from each branch.
Round: Test
Experience: There was a written test conducted for shortlisted candidates. The test was primarily based on the CAT pattern where questions were asked from verbal reasoning, logical reasoning and quantitative aptitude. The test comprised of 2 sections. First section comprised of 3 HR questions:
Why do you want to join this company?
Tell us about yourself.
Describe a situation where you displayed leadership skills.
These 3 questions were to be typed out in 150–200 words each in a total of 20 minutes. Second section started immediately after this. 25 minutes were given to answer 35 multiple choice questions from various sections including 10 coding based questions. The difficulty level was medium.
Duration: 45 minutes
Total Questions: 38
Round: HR Interview
Experience: They asked me to tell them about myself and also some puzzles and core field related questions. Interview was conducted using Skype. It started with basic HR question and then the interviewer asked me about my area of interest. He asked two questions from that field and then asked me to solve one guesstimate case. There was another question on the definition of data analysis.
My area of interest was Operations Research. First he asked me to explain transportation problem and second question was about solving a transshipment problem using Excel solver software. Other candidates were also asked some puzzles and several other HR questions.
College Name: IIT ROORKEE
Celebal Technologies Interview FAQs
Some of the top questions asked at the Celebal Technologies Business Analyst interview -
Tell us how to improve this page.
Celebal Technologies Interviews By Designations
- Celebal Technologies Data Engineer Interview Questions
- Celebal Technologies Data Scientist Interview Questions
- Celebal Technologies Associate Interview Questions
- Celebal Technologies Intern Interview Questions
- Celebal Technologies SQL Developer Interview Questions
- Celebal Technologies Internship Trainee Interview Questions
- Celebal Technologies Data Analyst Interview Questions
- Celebal Technologies Associate Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Celebal Technologies Business Analyst Interview Process
based on 1 interview
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Celebal Technologies Business Analyst Reviews and Ratings
based on 6 reviews
Rating in categories
|
Data Engineer
418
salaries
|  ₹4 L/yr - ₹12 L/yr |
|
Associate
261
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Associate Consultant
158
salaries
| ₹5 L/yr - ₹15 L/yr |
|
Associate Data Engineer
158
salaries
| ₹4 L/yr - ₹11 L/yr |
|
Data Scientist
121
salaries
| ₹4.5 L/yr - ₹15.1 L/yr |
Intellect Design Arena
Thomson Reuters
Oracle Cerner
NextComm Corporation
- Home >
- Interviews >
- Celebal Technologies Interview Questions >
- Celebal Technologies Business Analyst Interview Questions
