Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Celebal Technologies Team. If you also belong to the team, you can get access from here

Celebal Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Celebal Technologies Associate Data Engineer Interview Questions and Answers

Updated 29 May 2024

Celebal Technologies Associate Data Engineer Interview Experiences

2 interviews found

I applied via LinkedIn and was interviewed in Jul 2022. There were 2 interview rounds.

Round 1 - Coding Test 

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.

Round 2 - One-on-one 

(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.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Celebal Technologies Associate Data Engineer interview:
  • Python
  • sql
Interview preparation tips for other job seekers - 1.If you are good in python and sql then you got this job.
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

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Coding Test 

2 SQL questions with some dsa and python mqs.

Round 2 - Technical 

(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;

  • Answered by AI
  • 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

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Generic behavioral questions

Skills evaluated in this interview

Associate Data Engineer Interview Questions Asked at Other Companies

asked in Cognizant
Q1. Datastge - How will you remove Header and trailer from Sequential ... read more
asked in Cognizant
Q2. How to delete duplicate rows in Sql
asked in Capgemini
Q3. How would you recommend customer to migrate on cloud
asked in Cognizant
Q4. How to find process id in linux
asked in Cognizant
Q5. Reading Data from a .log file and finding out each column with a ... read more

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

Interview preparation tips for other job seekers - Please discuss frankly to HR after selecting in all interview round will i get the offer with expected salary or just it will hold to infinite time.

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

  • Answered by AI
  • 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

  • Answered by AI
  • 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 ...

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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,...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
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

Round: Resume Shortlist
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

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

  • Answered by AI

Interview Preparation Tips

Skills: Communication And Confidence, Technical Skill And Speaking Skill

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

Interview preparation tips for other job seekers - Very easy to crack

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

Interview preparation tips for other job seekers - Very good technical round of interview, prepare very well. All topics right from basics are asked.

I applied via Naukri.com and was interviewed before Jul 2021. 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 tips
Round 2 - Technical 

(1 Question)

  • Q1. Digital commerce related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Common understanding of user experience and digital commerce capabilities

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

Interview preparation tips for other job seekers - If Infosys comes for campus hiring, they come with an intention of hiring you. So just give your interview confidently and you will be recruited.

Celebal Technologies Interview FAQs

How many rounds are there in Celebal Technologies Associate Data Engineer interview?
Celebal Technologies interview process usually has 2-3 rounds. The most common rounds in the Celebal Technologies interview process are Coding Test, One-on-one Round and Technical.
What are the top questions asked in Celebal Technologies Associate Data Engineer interview?

Some of the top questions asked at the Celebal Technologies Associate Data Engineer interview -

  1. How is an empty class created in pyth...read more
  2. SQL queries to find second highest sal...read more
  3. SQL queries to find duplicate val...read more

Tell us how to improve this page.

Celebal Technologies Associate Data Engineer Interview Process

based on 2 interviews

Interview experience

3
  
Average
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
 • 791 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
View all
Celebal Technologies Associate Data Engineer Salary
based on 158 salaries
₹2.5 L/yr - ₹11 L/yr
16% less than the average Associate Data Engineer Salary in India
View more details

Celebal Technologies Associate Data Engineer Reviews and Ratings

based on 21 reviews

2.6/5

Rating in categories

3.3

Skill development

2.9

Work-life balance

2.6

Salary

2.5

Job security

2.4

Company culture

2.2

Promotions

2.7

Work satisfaction

Explore 21 Reviews and Ratings
Data Engineer
381 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
250 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Data Engineer
158 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
123 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Celebal Technologies 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