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

Clear (1)

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 applied via Company Website and was interviewed before Jun 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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. All related to Linux and os only

Interview Preparation Tips

Interview preparation tips for other job seekers - I am working as Linux admin or lead engineer from 12 years.

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.

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Unix and sql concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions will be based on your resume

I applied via Indeed and was interviewed before Dec 2018. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic sap pm questions and preventive maintenance

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basic knowledge, and hands on experience of sap will be helpful to answer technical questions, don't try to fake simply say no if you don't know.

Interview Questionnaire 

1 Question

  • Q1. Mostly about my experience and questions related to AWS & Devops

I applied via Referral and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Related to banking and IT field

Interview Preparation Tips

Interview preparation tips for other job seekers - You need to prepare really hard to get job in such a big MNC

I applied via Campus Placement and was interviewed before Sep 2021. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. I was asked to brief about resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Be completely clear on the details on your resume
Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

INTERVIEWS

Celebal Technologies

No Interviews

INTERVIEWS

Bridge Group Solutions

No Interviews

INTERVIEWS

Philips Innovation Campus

No Interviews

INTERVIEWS

Guidewire Software

No Interviews

INTERVIEWS

BNP Paribas India Solutions

No Interviews

INTERVIEWS

Pine Labs

No Interviews

INTERVIEWS

BNP Paribas India Solutions

No Interviews

INTERVIEWS

Bridge Group Solutions

No Interviews

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
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent