i
Celebal Technologies
Filter interviews by
Find the repeating element in a list
Iterate through the list and keep track of elements seen so far
Use a hash set to efficiently check for duplicates
Return the first element that is already in the set
Use the MAX() function in SQL to calculate the maximum salary.
Use the MAX() function along with the column name of the salary field.
Example: SELECT MAX(salary) FROM employees;
Ensure the correct table and column names are used in the query.
I applied via Walk-in
Basics of the C++ and DSA like Array Linkedlist graph
I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.
Celebal Technologies interview questions for popular designations
I applied via Campus Placement and was interviewed in Mar 2024. There were 2 interview rounds.
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
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...
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.
Get interview-ready with Top Celebal Technologies Interview Questions
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
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...
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 ...
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
I applied via Referral and was interviewed in Aug 2024. There were 2 interview rounds.
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.
I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.
It was very easy and out of 1000 students 300 students got shortlisted.
OOPs stands for Object-Oriented Programming. The 4 pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Inheritance: Allows a class to inherit properties and behavior from another class. Example: Parent class 'Animal' and child class 'Dog' inheriting from 'Animal'.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: Using private variables and public methods in...
DBMS stands for Database Management System, which is a software system that manages databases. SQL is a language used to interact with databases.
DBMS is a software system that allows users to define, create, maintain, and control access to databases.
SQL (Structured Query Language) is a language used to communicate with a database. It is used to retrieve, update, and manage data in a database.
Examples of popular DBMS in...
MongoDB is a NoSQL database program that uses a document-oriented data model.
NoSQL database program
Document-oriented data model
Uses JSON-like documents for data storage
Supports dynamic schemas for flexible data structures
React hooks are functions that let you use state and other React features without writing a class.
Hooks are functions that let you use state and other React features in functional components
useState() - allows functional components to have local state
useEffect() - allows functional components to perform side effects
useContext() - allows functional components to access context
useReducer() - an alternative to useState() ...
Top trending discussions
The duration of Celebal Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 119 interviews
Interview experience
based on 541 reviews
Rating in categories
Data Engineer
381
salaries
| â‚ą0 L/yr - â‚ą0 L/yr |
Associate
250
salaries
| â‚ą0 L/yr - â‚ą0 L/yr |
Associate Consultant
158
salaries
| â‚ą0 L/yr - â‚ą0 L/yr |
Associate Data Engineer
158
salaries
| â‚ą0 L/yr - â‚ą0 L/yr |
Data Scientist
123
salaries
| â‚ą0 L/yr - â‚ą0 L/yr |
TCS
Infosys
Wipro
HCLTech