Celebal Technologies Interview Questions, Process, and Tips

Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
Add your answer

Q1. Salary discussion with roles and responsiblity
Add your answer

Q1. Form was shared with basic questions like why do want to join this Center of Excellence (COE) program ?
Add your answer
Q2. How will you benefit from the training/internship?
Ans. 
I will benefit from the training/internship by gaining valuable hands-on experience, expanding my skill set, and building a professional network.
• Gain practical experience in the field

• Develop new skills and knowledge

• Build a network of professionals for future opportunities
Answered by AI
Add your answer
Q3. Choices were given between data science and data engineering?
Ans. 
Data science focuses on analyzing and interpreting complex data, while data engineering focuses on designing and building data pipelines.
• Data science involves analyzing and interpreting large amounts of data to extract insights and make predictions.

• Data engineering involves designing and building data pipelines to collect, store, and process data efficiently.

• Data scientists use tools like Python, R, and machine learnin...read more
Answered by AI
Add your answer

People were shortlisted from the previous round of applications and seperated in group of 8 for GD with alloted timings in entire day.

Communication and English speaking skills were main focus. Topics were very common standard topics available in interviewbit, GFG etc. Not on any current trending topic. Easy if you have prepared on common topics.

Entire group had 1 hour to complete.

Q1. What are advance types of join ?
Ans. 
Advanced types of join include outer join, self join, and cross join.
• Outer join: includes unmatched rows from one or both tables

• Self join: joins a table with itself

• Cross join: combines each row from one table with each row from another table
Answered by AI
Add your answer
Q2. Difference between having clause and where clause?
Ans. 
The WHERE clause is used to filter rows before grouping, while the HAVING clause is used to filter groups after grouping.
• WHERE clause is used with SELECT, UPDATE, and DELETE statements.

• HAVING clause is used with SELECT statements that include GROUP BY clause.

• WHERE clause filters individual rows based on conditions.

• HAVING clause filters groups based on conditions.

• WHERE clause is applied before the GROUP BY clause.

• HAVING...read more
Answered by AI
Add your answer
Q3. Differnce between join and union?
Ans. 
Join combines rows from two or more tables based on a related column, while union combines rows from two or more tables into a single result set.
• Join is used to combine rows from different tables based on a related column.

• Union is used to combine rows from two or more tables into a single result set.

• Join can be used with different types like inner join, left join, right join, etc.

• Union only combines rows with the same ...read more
Answered by AI
Add your answer
Q4. Basic oops concept ?
Add your answer
Q5. What are python data structure?
Ans. 
Python data structures are containers that hold and organize data in different ways.
• Some common Python data structures are lists, tuples, sets, and dictionaries.

• Lists are ordered and mutable, allowing duplicate elements.

• Tuples are ordered and immutable, useful for storing related data together.

• Sets are unordered and contain unique elements, useful for mathematical operations.

• Dictionaries are key-value pairs, providing
Answered by AI
Add your answer

Q1. Tell me something about yourself
Add your answer
Q2. Would you be able to commute to jaipur
Add your answer

Aptitude questions and normal maths, logical questions

3 coding question of different level

It is an online coding test and the duration is 3 hours. They test your python skills here. Questions are related to Python and Pandas. You have to write code for the given questions.

Q1. Few basic python programs related to lists, data structures, strings, Fibonacci series etc
Add your answer
Q2. Asked ML related questions like regression, classification algorithms, NLP questions, evaluation metrics, how to handle if there are many attributes in dataset etc
Add your answer