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 Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
It was well designed
(2 Questions)
- Q1. Basic Questions about data warehousing
- Q2. Dbt Scenarios
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Nov 2024. There were 3 interview rounds.
(1 Question)
- Q1. Basicn details to check for qualifications
(1 Question)
- Q1. About my projects
(1 Question)
- Q1. More details about ML models
(2 Questions)
- Q1. Cache vs persist
- Ans.
Cache is used for temporary storage of data in memory, while persist is used for saving data to disk for long-term storage.
Cache is typically faster as it stores data in memory for quick access.
Persist saves data to disk for durability and long-term storage.
Cache is often used for temporary data that can be recomputed if lost, while persist is used for important data that needs to be retained.
Examples: Using cache for ...
- Q2. Broadcast join and other optimization techniques
(4 Questions)
- Q1. Sql window function
- Q2. Spark architecture, dataframe vs rdd
- Q3. Python reverse sentence
- Ans.
Reverse a sentence using Python
Split the sentence into words using split() method
Reverse the list of words using list slicing
Join the reversed list of words back into a sentence using join() method
- Q4. Join based on nulls in sql
Skills evaluated in this interview
Tarun
Selected
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about your self?
- Q2. What technology & tools u know ? And basic questions regarding that topics ?
(2 Questions)
- Q1. Job culture and job responsibilities ?
- Q2. Some questions on an analytical tools like power BI ?
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(1 Question)
- Q1. About the project and technical aspect
It contain both Aptitude and Coding about base models and Deep learning too
(2 Questions)
- Q1. What different models technique ?
- Ans.
Different models techniques include linear regression, decision trees, random forests, support vector machines, and neural networks.
Linear regression is used for predicting continuous values.
Decision trees are used for classification and regression tasks.
Random forests are an ensemble method based on decision trees.
Support vector machines are used for classification tasks.
Neural networks are used for complex pattern re
- Q2. What are performance metric where to use what?
- Ans.
Different performance metrics are used for different types of machine learning models to evaluate their effectiveness.
For classification models, metrics like accuracy, precision, recall, F1 score, and ROC-AUC are commonly used.
For regression models, metrics like mean squared error (MSE), mean absolute error (MAE), and R-squared are commonly used.
For clustering models, metrics like silhouette score and Davies-Bouldin in...
(2 Questions)
- Q1. Explain about Project
- Q2. What are problems faced in that project?
Skills evaluated in this interview
Highly interactive and technical
1 hr test with focus on math and analytical thinking
Selected
I applied via Approached by Company and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Both interview took around 30min (tech) and 10-15 min (HR) The technical interviewer started with my introduction, and then he explained what are the technologies that company is working on. 1: Rate yo...
(1 Question)
- Q1. We made salary negotiation. Why not campus selection? Some family background then how I come to know about the company. He explained the technical backbone of the role and tips for growth
Interview Preparation Tips
- SQL
- Python
- ETL
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 Associate Consultant Interview Questions
- Celebal Technologies Data Analyst Interview Questions
- Celebal Technologies Internship Trainee 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 22 reviews
Rating in categories
|
Data Engineer
373
salaries
|  ₹4 L/yr - ₹12 L/yr |
|
Associate
246
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Associate Data Engineer
157
salaries
| ₹2.5 L/yr - ₹11 L/yr |
|
Associate Consultant
156
salaries
| ₹5 L/yr - ₹16.4 L/yr |
|
Data Scientist
126
salaries
| ₹4.5 L/yr - ₹14.2 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Celebal Technologies Interview Questions >
- Celebal Technologies Associate Data Engineer Interview Questions
