Add office photos
i
Celebal Technologies
Compare
Filter interviews by
Celebal Technologies Interview Questions, Process, and Tips
Top Celebal Technologies Interview Questions and Answers
- Q1. Are you familiar with Celebal Technologiesasked in Data Engineer interview
- Q2. What is append in power queryasked in Power BI Developer interview
- Q3. What are oops? Explain 4 pillarsasked in Data Analyst interview
Celebal Technologies Interview Experiences
115 interviews found
Selected
I applied via Referral and was interviewed before Sep 2023. There was 1 interview round.
(4 Questions)
- Q1. Pyspark partion and group by , azure , databricks
- Q2. Azure databricks
- Q3. Azure adls gen 2
- Q4. Azure data factory
Interview Preparation Tips
Top Celebal Technologies Data Engineer Interview Questions and Answers
Data Engineer Interview Questions asked at other Companies
Pallavi Patil
I applied via Campus Placement and was interviewed in Mar 2023. There were 2 interview rounds.
Logical reasoning, logical , many more
Swapping two programs, multilevel inheritance
Interview Preparation Tips
Software Engineer Trainee Interview Questions asked at other Companies
Bhola Shankar Tiwari
I applied via Company Website and was interviewed in Sep 2022. There were 4 interview rounds.
It contain MCQ question which contain F section but all are easy. It contain some coding problem of easy, medium and hard level of Data structure and problems related to your domain.
(2 Questions)
- Q1. They mainly asked the question related to your Domain.
- Q2. SQL, DS,OOPS,DBMS etc.
(1 Question)
- Q1. HR only asked about yourself and offered you a salary.
Interview Preparation Tips
- SQL
- Data Analytics
Data Analyst Interview Questions asked at other Companies
Selected
I applied via campus placement at Pimpri Chinchwad College of Engineering, Pimpri and was interviewed before Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What are joins in sql ?
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. What is difference between duplicate and reference ?
- Ans.
Duplicate is an exact copy of something, while reference is a pointer to the original object.
Duplicate is a separate copy of the original item, while reference points to the original item.
Changes made to a duplicate do not affect the original, but changes made to a reference affect the original.
Duplicate has its own memory space, while reference shares memory space with the original object.
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a background in marketing and have worked in the industry for 5 years.
I am currently pursuing a Master's degree in Business Administration to further my skills and knowledge.
I am a team player and enjoy collaborating with others to achieve common goals.
- Q2. Salary expectation
Skills evaluated in this interview
Associate Interview Questions asked at other Companies
Celebal Technologies interview questions for popular designations
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
Associate Data Engineer Interview Questions asked at other Companies
Get interview-ready with Top Celebal Technologies Interview Questions
Data Scientist and Machine Learning Engineer Interview Questions & Answers
Anonymous
posted on 29 Aug 2024
Selected
I applied via LinkedIn and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- Q1. Count and say leetcode question
- Q2. Maximum frequecy leetcode question
Data Scientist and Machine Learning Engineer Interview Questions asked at other Companies
Jobs at Celebal Technologies
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
Associate Data Engineer Interview Questions asked at other Companies
Selected
I applied via campus placement at Asansol Engineering College (AEC) and was interviewed before Nov 2023. There was 1 interview round.
Time was given 1.5 hrs and there were 30 mcq from OOP'S, SQL, OS, Networking, DBMS and 2 coding questions were given, difficulty ranging from easy to medium, The test was online proctored, this was the final test those who are selected, were directly absorbed in the Company as summer Intern, in their specified interest of domain.
Summer Intern Interview Questions asked at other Companies
I applied via Cocubes and was interviewed in Sep 2022. There were 5 interview rounds.
I was shortlisted through Cocubes
It include aptitude question, question from domain, coding and SQL
(1 Question)
- Q1. Mainly focused on your projects and the domain for which you have applied.
(1 Question)
- Q1. Typical HR questions.
Interview Preparation Tips
Associate Interview Questions asked at other Companies
Selected
I applied via campus placement at Lovely Professional University (LPU) and was interviewed before Feb 2023. There were 2 interview rounds.
Basic aptitude, Sql, and some programming mcq question
Basic coding question
Reactjs Developer Interview Questions asked at other Companies
Celebal Technologies Interview FAQs
The duration of Celebal Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Celebal Technologies Interviews By Designations
- Celebal Technologies Data Engineer Interview Questions
- Celebal Technologies Associate Interview Questions
- Celebal Technologies Data Scientist 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
Celebal Technologies Interview Process
based on 77 interviews in last 1 year
Interview experience
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Celebal Technologies Reviews and Ratings
based on 565 reviews
Rating in categories
|
Data Engineer
362
salaries
|  ₹4 L/yr - ₹11 L/yr |
|
Associate
232
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Associate Data Engineer
151
salaries
| ₹2.5 L/yr - ₹10.1 L/yr |
|
Associate Consultant
145
salaries
| ₹5 L/yr - ₹16.6 L/yr |
|
Data Scientist
127
salaries
| ₹4.5 L/yr - ₹13 L/yr |
TCS
Infosys
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Celebal Technologies Interview Questions
