Upload Button Icon Add office photos

Filter interviews by

Celcom Interview Questions and Answers

Updated 4 Feb 2024

Celcom Interview Experiences

1 interview found

Senior Data Engineer Interview Questions & Answers

user image yuvindiraa pubalan

posted on 4 Feb 2024

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

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

Round 1 - Case Study 

Detailed case study and also technical assessment

Round 2 - Technical 

(2 Questions)

  • Q1. Distributed systems
  • Q2. Python and also sql

Interview Preparation Tips

Topics to prepare for Celcom Senior Data Engineer interview:
  • Data Structures

Senior Data Engineer Interview Questions asked at other Companies

Q1. Write a query to get the customer with the highest total order value for each year, month. [Note: Order table is different and Customer table is different. Order_ID and Customer_ID are the PK of the table with Oid from Customer table being ... read more
View answer (2)

Interview questions from similar companies

Interview Questionnaire 

3 Questions

  • Q1. Tell me about ur self
  • Ans. 

    I am a highly skilled System Engineer with expertise in designing and implementing complex systems.

    • Experienced in managing and troubleshooting network infrastructure

    • Proficient in virtualization technologies such as VMware and Hyper-V

    • Strong knowledge of operating systems like Windows and Linux

    • Familiar with scripting languages like PowerShell and Bash

    • Excellent problem-solving and communication skills

  • Answered by AI
  • Q2. Have u done any teamwork
  • Ans. 

    Yes, I have experience working in teams.

    • I have worked on several group projects during my studies.

    • I have collaborated with colleagues to solve complex technical problems.

    • I have participated in cross-functional teams to implement system upgrades.

    • I have also been part of agile development teams, working closely with software engineers and testers.

    • One example of teamwork is when I led a team of engineers to successfully d

  • Answered by AI
  • Q3. Family background

Interview Preparation Tips

Round: Test
Experience: There are two sections ....1) verbal 2)analytical and reasoning. paper was little bit tough. i didn't remember the type of questions.

Round: HR Interview
Experience: The HR was very cool and friendly. He asked me general questions like "tell me about ur self","have u done any teamwork" etc and then he asked me about my favourite subject.Then he asked me to explain the subject considering him as an 8th class student. Then he asked me about my family background. And the interview was about 30mins.

General Tips: You must be very cool while facing interview and u should ur confidence and interest towards the company.
College Name: NIT WARANGAL

Assistant Trainee Interview Questions & Answers

TCS user image YATISH KUMAR KESHWANI

posted on 9 Feb 2015

Interview Questionnaire 

22 Questions

  • Q1. What are the subjects you have command in?
  • Q2. Tell me about your final year project?
  • Q3. Tell me about the industrial training you had?
  • Q4. How does an induction motor works?
  • Q5. Why motor is rated in KW whereas Transformer and generator in KVA?
  • Ans. 

    Motors are rated in KW because they consume power, while transformers and generators are rated in KVA because they produce power.

    • Motors convert electrical energy into mechanical energy, so they consume power and are rated in KW.

    • Transformers and generators produce electrical energy, so they are rated in KVA based on their apparent power.

    • KVA takes into account both the real power (KW) and the reactive power (KVAR) produc...

  • Answered by AI
  • Q6. What is the type of motor used in ceiling fans?
  • Ans. 

    The type of motor used in ceiling fans is an induction motor.

    • Ceiling fans typically use single-phase induction motors.

    • These motors are designed to provide a constant speed and are efficient in converting electrical energy into mechanical energy.

    • The motor consists of a stator and a rotor, with the stator being the stationary part and the rotor being the rotating part.

    • The stator contains windings that create a rotating m...

  • Answered by AI
  • Q7. Hoe does a thermal power plant works?
  • Ans. 

    A thermal power plant generates electricity by converting heat energy into mechanical energy.

    • Thermal power plants use fossil fuels or nuclear energy to heat water and produce steam.

    • The steam drives a turbine, which is connected to a generator that produces electricity.

    • The heat source can be coal, natural gas, oil, or nuclear reactions.

    • The steam is condensed back into water and recycled in a closed-loop system.

    • Thermal p...

  • Answered by AI
  • Q8. Write a program to make a GP
  • Ans. 

    A program to generate a geometric progression (GP).

    • Take the first term, common ratio and number of terms as input.

    • Use a loop to calculate each term of the GP.

    • Print the generated GP as output.

  • Answered by AI
  • Q9. Write a program to print factorial using recursion
  • Ans. 

    A program to print factorial using recursion

    • Define a function to calculate factorial recursively

    • Base case: if the number is 0 or 1, return 1

    • Recursive case: multiply the number with factorial of (number - 1)

    • Print the factorial of a given number

  • Answered by AI
  • Q10. Write the logic to reverse a string without using string fnctions
  • Ans. 

    Logic to reverse a string without using string functions

    • Iterate through the string from the last character to the first

    • Create a new string and append each character to it in reverse order

  • Answered by AI
  • Q11. Tell me about yourself?
  • Q12. What are your hobbies?
  • Q13. Apart from your technical pat and studies what have you done in college?
  • Q14. What do you prefer, ethics or values?
  • Q15. Suppose you are working in office and somebody came and slapped you, what will you do?
  • Q16. Tell me about yourself for 5 minutes
  • Q17. What are your views about Mr. Narendra Modi as PM of India
  • Q18. Any extra curricular activities you have participated in school or college
  • Q19. What are your strengths?
  • Q20. What are your weaknesses?
  • Q21. Being an Electrical engineer why do you want to join an IT company
  • Q22. What do you know about TCS?

Interview Preparation Tips

Round: Test
Experience: In email writing one question was given describing the situation and maximum word limit. It has the keywords given to be used. 1 question, 10 minutes.This section is generally used to check your verbal ability. Make sure to use all the keywords given and complete it within time, with no spelling mistakes of course. Missing a keyword or a spelling mistake could be your goodbye to qualified list.The second section had 30 questions of quantitative aptitude. Duration 70 mins. There are questions from various sections, such as Time and speed, Time and distance, Data interpretation,etc.There are 2-3 star marked questions which have more weight-age. There my also be a dummy question who doesn't have any matching answer. Make sure uh don't attempt these questions.26-27 questions is the cut-off for qualified list.But you have to do the email writing part correctly.
Tips: Practice email writing online from various websites such as technicalbaba.com, indiageeks.comPractice quantitative aptitude as it is a must in any interview you will face. you can use R.S.Agarwal or CAT material.
Duration: 90 minutes
Total Questions: 30 + 1

Round: Interview
Experience: Greeting the interviewer is a must. Be confident and enthusiastic. Have your resume properly ready. Technical questions from your subject will be asked. Not a must that you should know any programming language like C, C++, JAVA.
Tips: Prepare 3-4 subjects of your core branch. Never try to flatter the interviewer. Be confident and answer the questions appropriately. Dont say directly " I DON'T KNOW". Atleast try even if you dont know the answer.

Round: Interview
Experience: There are certain questions which doesnt have direct answers. You have to be diplomatic about them. You should be able to see all the possible situation when a question like that is asked.

Round: Interview
Experience: The HR head may manipulate you, try to stress you, etc. Be calm and confident.Think before you speak. Prepare your answers before hand for general questions. Write your introduction on a paper and prepare it well so that you speak it confidently...
Tips: Be yourself. Be confident. Never argue with the interviewer.All the best

General Tips: Be presentable in the interview. Wear a watch. Show respect to the interviewer. Prepare 3-4 technical subjects well. Read last 15 days newspaper. Be confident when you speak. Improve your English if you are weak in it.
Skill Tips: ""
Skills: Verbal ability, Attitude, Technical knowledge, General knowledge
College Name: IMS ENGINEERING COLLEGE, GHAZIABAD
Motivation: TCS is a semi government company with a decent package and high job security.

Skills evaluated in this interview

Interview Questions & Answers

Cognizant user image Anonymous

posted on 20 Jan 2015

Interview Questionnaire 

5 Questions

  • Q1. Tell me about yourself
  • Q2. What do you know about the company?
  • Q3. What are your greatest strength and weaknesses?
  • Q4. What are your ambitions in life?
  • Q5. When are you getting married?
  • Ans. 

    I am not currently planning on getting married.

    • I am currently focused on my career and personal growth.

    • Marriage is not a priority for me at this time.

    • I believe in taking the time to find the right person and building a strong foundation before getting married.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: PART ONE: Verbal Ability, uses of articles (a, an, the) and a RC. 
PART TWO: logical reasoning, standard IQ type Questions, was simple. 
PART THREE: An essay, one out of two, one choice was nuclear deal and the other was education system in India.

Round: Technical Interview
Experience: Some regular puzzles were given, which were easy. A discussion on internship work.

Round: HR Interview
Experience: They are looking for people with good aptitude, very good communication skills and strong desire to learn. Also, someone with good academic record and clear career goals.
Tips: Do not panic in the interview.

General Tips: For GD, improve the content by reading and/or discussing among wing mates. Don't be aggressive but be assertive and ENERGETIC.
College Name: IIT KANPUR

Interview Preparation Tips

Round: Resume Shortlist
Experience: Candidates with CG equal to or higher than 8.0 were selected.

Round: Test
Experience: It was divided in 2 sets of 45 minutes each.
Coding: To write a function to find if a string is palindrome or not. 
Verbal+quant: These were CAT model questions.
Duration: 90 minutes

Round: Interview
Experience: There were 2 rounds of this interview. Both were HR and questions based on resume and some general questions were asked.
Tips: I think I was selected because of my CG, coding skills and communication skills.

General Tips: If you're preparing for core, make sure you start revising your subjects soon. Keep your notes and concentrate on structures.
Skill Tips: I started my preparations in November by going through case study material available in lan and solving CAT questions.
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: Deloitte selection procedure involves a written test which is
same as CAT format (certainly not that tough). Though I had not joined any test series to prepare for it, but I must strongly recommend that you should actually join a test series (provided by Career Launcher or
TIME). This test series will actually help you to synchronize your mind to the format and moreover it would help to refresh the question solving skills which you used to exercise while preparing for JEE.

Round: Group Discussion
Experience: general topic is given (mostly it is as to how you would go for implementing a new type of technology in a company, and hence you all have to decide the stepwise procedure for the implementation), then whole of the group is called in presentation room where each one is told personally to speak about the same topic as that of GD. This constitutes
second round. Finally, if you clear it, you get to face the interviews.
Tips: From now onwards, start reading newspaper daily. Just give at least one hour reading the editorials from newspaper and make it your habit. Not only for GD's, but for life in general, its very important that you should have a certain view about things happening around you and in the world and newspapers are the best thing which help you form your views and also know about the expert opinions on day to day topics. So, make sure that you read newspaper daily.

Round: Other Interview
Experience: For interview, main thing is that you should be well conversed about everything you have mentioned on your resume. So, before you go for any interview, just make sure that you can speak about for 5 minutes on
every single thing in resume. Deloitte is a company which is open for all the btech students and hence its mainly looking for the students who have a right attitude and are good at their interests.
Tips: have a perfect set of communication skills. I had not done
any special type of preparations for the interview or group discussions but all these skills actually developed during these years. I would advise that in order to gain more confidence at speaking, you should start taking challenges from now on and should actively participate in any sort of debates and GD.

College Name: IIT Roorkee

N/A Interview Questions & Answers

HCLTech user image Anonymous

posted on 27 Jan 2015

Interview Preparation Tips

Round: Other Interview
Experience: 1 round of 10 minutes duration.
Depends very much on what position they are trying to fill in and area of expertise of the interviewer(s). They asked me basic questions on Image Processing. Interview went decent

College Name: IIT MADRAS

Interview Questionnaire 

1 Question

  • Q1. Telephonic/Computer assessment for English proficiency

Interview Preparation Tips

Round: Test
Experience: Aptitude was not too easy or too tough like that of CAT. But if one has prepared for CAT exam even a bit, then he can perform pretty well.
Tips: Practice previous year CAT papers. Question sections and format asked in Capgemini test will be similar to that of CAT exam. Improve reading skills by reading anything that interests you.
Duration: 180 minutes
Total Questions: 120

Round: Other Interview
Experience: You will have to talk with a programmed voice using voice call. You need to follow the instructions of the programmed voice. They will record whatever you speak and judge your speaking skills.
Tips: Try to speak in English with at least few peers.

Round: HR Interview
Experience: You must be well thorough with your CV. Common questions like:*Tell me about yourself?*What are your strength and weakness?*Why consultancy and analyst profile?*What do you know about analyst profile?*What does Capgemini does? Tell us more about Capgemini?
etc can be expected for sure.The HR is not interested in your departmental knowledge, rather he is more interested in the way you are explaining something tin a layman manner. He/She cares how you analyse situations. Some random sitaution may be posed and HR may ask you to analyse the situation.
Tips: #Confidence in yourself.#Well verse with CV.#Able to explain even to layman.#Know basic information about data analytics.

General Tips: Aptitude+Communication fluency+Confidence = Job in  Capgemini
Skill Tips: Practice.
Skills: Aptitude, Communication, Confidence
College Name: I.I.T Guwahati
Motivation: Multi national and reputed.

Interview Questions & Answers

Amazon user image Anonymous

posted on 21 Jan 2015

Interview Preparation Tips

Round: Test
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.

Round: Interview
Experience: There were 3 interview rounds:
There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few
very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products.  The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.
The second interview was resume based. He asked me about my thesis, internship, various projects, positions of responsibility etc. The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study: “As a banking organization, you have given house loans to a lot of customers. Given the current scenario, you have to profile the customers to which loans have been given based on the chances that they would pay back.” He started with this scenario and as I gradually started analyzing things and proposing models he kept on increasing the complexity saying you don’t have this data, you can’t make that assumption etc. Ultimately he narrowed down it down to a problem which was almost unsolvable. When I got stuck at that he told me that his idea was to just give me a taste of the toughness of problems they encounter in day-to-day business.

General Tips: After spending three or four years enjoying the IITK adventure, one suddenly feels a jolt when he/she arrives in the final year. You find yourself wondering at times, asking yourself the pertinent question, what next? And seriously, the best way to start preparing for placements, GRE, CAT or any other exam for that matter is answering this question honestly. Take a few minutes of your precious time and think what you want to do with your life? Where does your heart truly lie? I know it’s not that easy to decide on this but at least give this a good thought and prioritize your options. Make a list of them on paper if that helps. Once you are done with this, the real planning starts. Take each option one by one and do a truthful analysis of yourself from the perspective of that option. For e.g., say you have CAT as your first priority, and then analyze your strengths and weaknesses from CAT’s perspective. What all areas you need to improve on? How much time and effort would it take? How much time you have got left? By doing this exercise you will really get to know the work that needs to be done and will help you plan for the remaining time.


Resume:
I am sure you would have heard it umpteen times but still I will repeat it to stress the point, take resume making seriously! A good resume would drive your interview in the direction you want it to go, a bad resume on the other hand might end the chances of you even getting interviewed! Start by trying to remember each and every achievement of your life and write it down. Spend a few days on this part till you are sure you have got almost everything. Now write it down properly in formal language in the form of a master resume. This would serve
as a repository of information for all your subsequent resumes. And on top of that, having a fresh memory of your achievements would help you in answering the questions in interviews (especially HR questions). Ideally you should have a separate resume for every company you sit for. The way to do this is make sector specific resumes and edit them accordingly for the different companies of that sector. For example, make a single resume for all the core CSE companies and then you can probably change the list of projects (or their order of appearance) targeting individual companies.

PPTs:
If you are serious about getting job in a company, you cannot afford to miss its pre placement talk. PPT is not only an opportunity to know about the company, but it also gives you the chance to know what the company is looking for. This will give you the basic idea around which you should structure your resume and preparation for that company.
Preparation:
Core Computer Science Companies: All the core CS companies first take a written test which contains questions on C/C++, may have JAVA, UNIX, Algorithms, Data Structures, basics of Operating Systems and Compilers, some questions on basic networking in case the company works in that field. Almost all the companies have a couple of questions in which you are required to write code on paper. Some companies also have a few questions on aptitude, simple maths or data interpretations. You can find the company specific details in the placement feedback guide. This is the major
shortlisting step for core companies, so you cannot take it lightly. You can start preparing by revising the relevant courses you did (like Data Structures, Algorithms, Operating Systems, and Compilers). Practice a few questions available in the various placement preparation guides on LAN. Most importantly, practice writing code on paper. This is something we are not used to and requires some practice. This not only will do you good in the written test, but also help you in the interviews.
Non Core Companies (Finance, Consulting, and Analytics):
The written tests of most of these companies are quite similar to CAT. So if you are not preparing for CAT, get hold of some CAT preparation material for practice. These tests are more speed based than knowledge, so practice is absolutely essential. Revising some basic mathematics (like probability, progressions etc.) would also do you good. Apart from that, you need to have some basic knowledge and understanding of the field the company works in. For example, if you are appearing for a finance company, learn the basic concepts and common terminologies of finance. The least it would do is show that you are sincerely interested in the field the company works in.
College Name: IIT KANPUR

Interview Preparation Tips

Round: Resume Shortlist
Experience: Shortlisted on CGPA>8

Round: Test
Experience: Only one test was conducted on data interpretations and then shortlisting based on test scores was done.

Round: Group Discussion
Experience: Group discussion was conducted and mostly related to their sector topics were given.

Round: HR Interview
Experience: Interview was of only one round and in it both HR and technical were completed in 15 minutes.

Skill Tips: Quantifying most of things in your resume and also in interview would give a good impression.Internships also does matter and questions on AVOVA in statistical courses are also focused.For chemical dept, Statistical design and analysis of experiments course gives the edge over others.Questions related to logistic regress were also asked.
College Name: IIT MADRAS

Celcom Interview FAQs

How many rounds are there in Celcom interview?
Celcom interview process usually has 2 rounds. The most common rounds in the Celcom interview process are Case Study and Technical.
What are the top questions asked in Celcom interview?

Some of the top questions asked at the Celcom interview -

  1. Distributed syst...read more
  2. Python and also ...read more

Tell us how to improve this page.

Celcom Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.9
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Amazon Interview Questions
4.1
 • 5k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
View all
Solution Architect
3 salaries
unlock blur

₹34 L/yr - ₹42 L/yr

Explore more salaries
Compare Celcom with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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