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 Associate Data Engineer Interview Questions and Answers
Celebal Technologies Associate Data Engineer Interview Experiences
2 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Jul 2022. There were 2 interview rounds.
First round is basically on python multiple choice questions and then it was asking 6 python easy-moderate question(Don't worry it's not like DSA) then 6 SQL questions which is kind of midium level questions.
(2 Questions)
- Q1. Interviewer asked more about pandas, numpy and according to my resume. 1.what's Linear Regression (As on my resume mentioned that algorithm.)?? I can't remember such pandas and numpy questions but I can sa...
- Q2. How is an empty class created in python.
- Ans.
An empty class can be created in Python using the 'pass' keyword.
Use the 'class' keyword to define a class.
Add the class name and a colon after the 'class' keyword.
Use the 'pass' keyword to indicate an empty class body.
Interview Preparation Tips
- Python
- sql
2.If you get the job then they would definitely put you in a contract of 2 or 3 years, So remember you can negotiate as much as you can.
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.
2 SQL questions with some dsa and python mqs.
(4 Questions)
- Q1. Mostly asked SQL questions.
- Q2. Joins, normalisation, aggregate functions etc
- Q3. SQL queries to find duplicate values
- Ans.
Use SQL queries with GROUP BY and HAVING clause to find duplicate values in a table.
Use GROUP BY clause to group the records based on the columns you want to check for duplicates.
Use HAVING clause to filter out the groups that have more than one record, indicating duplicates.
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
- Q4. SQL queries to find second highest salary
- Ans.
Use SQL query with subquery to find second highest salary
Use ORDER BY clause to sort salaries in descending order
Use LIMIT clause to get the second row after skipping the first row
Use a subquery to avoid duplicates if multiple employees have the same highest salary
(1 Question)
- Q1. Generic behavioral questions
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. #3 interviews were there 1. Basic Telephonic all basic questions were there then 2. zoom video for detaled code and sql queries 3. advanced for algo designing and case analysis questions.All related to had...
- Q2. Basic question and coding is answered as per knowledge and experience. Advance questions is totally based on aptitude . reasonng and decision making skills
- Q3. Why TechMahindra guys conduct interviews if after selecting all technical round they dnt have any offer to give. And make it as hold.
Interview Preparation Tips
I was interviewed in Nov 2016.
Interview Questionnaire
7 Questions
- Q1. Tell us about yourself
- Ans.
I am a highly motivated and detail-oriented individual with a strong background in consulting.
I have a Bachelor's degree in Business Administration from XYZ University.
I have completed internships at ABC Consulting and gained experience in market research and data analysis.
I am proficient in various consulting tools and software, such as Excel, PowerPoint, and Tableau.
I have excellent communication and problem-solving ...
- Q2. Why should we select you?
- Ans.
I have a strong background in consulting and a proven track record of delivering results.
Extensive experience in consulting industry
Proven track record of delivering successful projects
Strong analytical and problem-solving skills
Excellent communication and interpersonal skills
- Q3. Why Infosys?
- Ans.
Infosys is a global leader in technology services and consulting, known for its innovative solutions and commitment to excellence.
Infosys has a strong reputation for delivering high-quality services to clients worldwide
The company offers a wide range of opportunities for professional growth and development
Infosys values diversity and inclusion, creating a supportive work environment for employees
The company's focus on ...
- Q4. 2 strengths and weaknesses each
- Ans.
Strengths: Analytical thinking, strong communication. Weaknesses: Impatience, perfectionism.
Strengths: Analytical thinking - able to break down complex problems into manageable parts.
Strengths: Strong communication - able to effectively convey ideas and information to others.
Weaknesses: Impatience - tendency to rush through tasks without paying attention to details.
Weaknesses: Perfectionism - difficulty in accepting an
- Q5. Why did you choose to do an MBA in marketing?
- Ans.
I chose to do an MBA in marketing because of my passion for understanding consumer behavior and creating effective marketing strategies.
I have always been interested in understanding why people make certain purchasing decisions and how marketing can influence those decisions.
I believe that marketing is a crucial aspect of any business and can make or break a company's success.
During my undergraduate studies, I took sev...
- Q6. 3 difficult times in professional/personal life you had to face and how you overcame the same?
- Ans.
Overcoming difficult times in professional and personal life through resilience and determination.
Losing a job and facing financial instability - took up freelance work and actively searched for new opportunities.
Dealing with a family member's illness - sought support from loved ones and focused on caregiving while maintaining self-care.
Navigating a toxic work environment - set boundaries, sought guidance from mentors,...
- Q7. What is marketing?
- Ans.
Marketing is the process of promoting and selling products or services to customers.
Identifying customer needs and wants
Developing products or services to meet those needs
Promoting and advertising the products or services
Selling the products or services to customers
Building and maintaining customer relationships
Analyzing market trends and competition
Adjusting strategies to meet changing market conditions
Interview Preparation Tips
Experience: Our entire batch was asked to upload resume and then a shortlist was given out within a week
Tips: Objective should be clear and crisp, educational qualifications can be presented in a tabular form, work experience, project details and achievements should be given from most recent to least recent
Round: Technical + HR Interview
Experience: The environment was relaxed. 2 interviewers were there. Both asked questions. It was not a stress interview and I was also given time to think and answer
Tips: Confidence is important while answering. It is important to be clear on basics before learning high funda things. The answers should not be very long and essay like.
I applied via Campus Placement and was interviewed before Dec 2016. There were 5 interview rounds.
Interview Questionnaire
5 Questions
- Q1. General consulting questions were asked to assess consulting prowess
- Q2. Questions were asked directly from the CV related to my past work experience
- Q3. Role fitment was assessed here
- Q4. This was a simple interview and I was assessed as to whether I will fit into the company culture
- Q5. Questions pertaining to the company culture was asked
Interview Preparation Tips
Experience: Resume was shortlisted based on academic qualification and past relevant industry experience
General Tips: Do a self assessment for the role and the company. The interview will be straight forward. Do not bluff on the CV as most questions are asked from the CV
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Leadership, Decision Making Skills
Duration: <1 week
College Name: Goa Institute of Management
Jayanth Balivada
I was interviewed in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Brief yourself from your personal to professional advancement.
- Ans.
I have continuously strived for personal and professional growth, from pursuing higher education to gaining valuable work experience.
Completed Bachelor's degree in Business Administration
Obtained Master's degree in Marketing
Interned at a leading marketing firm
Secured a full-time position as a Marketing Specialist
Currently pursuing certifications in digital marketing
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Joined as a fresher, basic C program algo
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Oct 2019. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. MS DYNAMICS CRM Technical questions, Integration with other systems, UCI, Power Apps, Plugins execution pipeline, estimation technique, agile method
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.
(1 Question)
- Q1. Digital commerce related questions
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. It was mostly directed towards my college course and specialization
Interview Preparation Tips
Celebal Technologies Interview FAQs
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
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Data Associate Interview Questions
- Associate Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Celebal Technologies Associate Data Engineer Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Celebal Technologies Associate Data Engineer Reviews and Ratings
based on 21 reviews
Rating in categories
|
Data Engineer
381
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Associate
250
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Consultant
158
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Data Engineer
158
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Scientist
123
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Celebal Technologies Interview Questions >
- Celebal Technologies Associate Data Engineer Interview Questions
