Celebal Technologies Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 52 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Celebal Technologies.
Celebal Technologies
Data Engineer
Entry Average Positive experience No offer 3 rounds
Interview process
Recruiter call Technical screen Onsite
Interview formats
Technical Coding
So the process started with resume selection, then there was an exam with 3 SQL questions, 2 Python questions, and 20 MCQs. After passing that, I got selected for the interview where they asked about SQL joins, window functions, rank functions, group by, and having. For Python, they asked about strings and slicing, and palindromes. The interview involved screen sharing and implementing solutions in a code editor.
Confirmed questions8 questions
- The exam had 3 SQL questions.
- The exam had 2 Python questions.
- The exam had 20 MCQs.
Celebal Technologies
Azure Data Engineer
Mid Average Neutral experience No offer 1 round
Interview process
Technical screen
Interview formats
Technical Coding
The interview process involved these questions: Tell me about yourself, How you handle high cardinality columns in SQL, What is overload in databricks, What are pools in databricks how it is used, When you have 2 equal large data frames how you will handle joins, What is de duplicated in SQL, Given 2 tables and asked to get result for all joins, How to copy data from on premise sql server to ADLS, How will you handle incoming huge data around 50 GB, If your daily data is only 5GB, Explain about out of memory in pyspark. In what cases you will get OOM.
Confirmed questions8 questions
- Could you start by telling me about yourself?
- How do you manage SQL columns with high cardinality?
- Can you explain what overload means in the context of Databricks?
Celebal Technologies
Data Engineer Intern
Intern Difficult Positive experience No offer 5 rounds
Interview process
Recruiter call Technical screen Take home Onsite Offer
Interview formats
Behavioral Technical
So, first the company posts the job. Then you gotta apply with your resume and cover letter. After that, HR checks all the applications and picks out the good ones. Then, if you get picked, you'll have interviews with the hiring managers. They might also give you some tests or assignments to do. If all goes well, they'll offer you the job. You can then try to negotiate the salary and stuff. Finally, you either accept or decline the offer.
Confirmed questions1 question
- What's your motivation for applying to our company and for this particular role?
Celebal Technologies Data Engineer Interview Questions
Quoted word for word from Celebal Technologies interview reports.
“What is the difference between rank and dense rank in Pyspark?”
Read reports →“How to find the 2nd highest rank in SQL?”
Read reports →“Could you implement a function to find the mirror image of a binary tree?”
Read reports →“How would you return the most repeated element within a name?”
Read reports →“How would you retrieve results for all possible joins given two tables?”
Read report →“What is the difference between SCD 2 and SCD 3?”
Read report →“What's the procedure for copying data from an on-premise SQL Server to ADLS?”
Read report →“In SQL, what is the average salary of employees from each department?”
Read report →“What are some basic PySpark queries for reading and writing CSV files?”
Read report →Formats, difficulty and experience
Across all 52 Celebal Technologies interview reports.