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 Data Engineer Interview Questions, Process, and Tips
Top Celebal Technologies Data Engineer Interview Questions and Answers
- Q1. Are you familiar with Celebal Technologies
- Q2. What is the Goal of Celebal Technologies
- Q3. Difference between having clause and where clause?
Celebal Technologies Data Engineer Interview Experiences
17 interviews found
Anonymous
(5 Questions)
- Q1. Explain the project you are working on.
- Q2. A code on python, strings.
- Q3. Two tables given and asked how many outputs will you get if you apply inner joim
- Q4. Versioning in aws
- Ans.
Versioning in AWS allows you to manage different versions of your resources.
AWS S3 supports object versioning to keep multiple versions of an object in the same bucket.
AWS Lambda supports versioning to manage different versions of your functions.
AWS API Gateway supports versioning to manage different versions of your APIs.
- Q5. Redshift related questions
Skills evaluated in this interview
Kiran Bagate
I applied via Walk-in and was interviewed in May 2024. There was 1 interview round.
(4 Questions)
- Q1. What is indexing in SQL?
- Ans.
Indexing in SQL is a technique used to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of data.
They work similar to the index in a book, allowing the database to quickly find the rows that match a certain condition.
Indexes can be created using a single column or a combination of columns.
...
- Q2. Lift capacity and passenger sql query
- Q3. What is your experience in Pyspark , python
- Ans.
I have extensive experience in using Pyspark and Python for data engineering tasks.
I have worked on various projects involving data processing, transformation, and analysis using Pyspark and Python.
I am proficient in writing efficient and optimized code in Pyspark for big data processing.
I have experience in handling large datasets and implementing complex data pipelines using Pyspark and Python.
- Q4. Tell me about architecture of the project that you are working on
Skills evaluated in this interview
Onkar Pandole
I applied via Newspaper Ad and was interviewed in May 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Sql queries, python program and my clg background
- Q2. Star pattern, codding and sql question oral
(2 Questions)
- Q1. Joins , sub queries
- Q2. Trigger, group by
Programing questiion star pattern
Interview Preparation Tips
aditya oza
(2 Questions)
- Q1. Explain Differnece between ETL AND ELT?
- Ans.
ETL is Extract, Transform, Load where data is extracted, transformed, and loaded in that order. ELT is Extract, Load, Transform where data is extracted, loaded, and then transformed.
ETL: Data is extracted from the source, transformed in a separate system, and then loaded into the target system.
ELT: Data is extracted from the source, loaded into the target system, and then transformed within the target system.
ETL is sui...
- Q2. Explain the differnece between the difference?
- Ans.
The difference between the difference is the result of subtracting one value from another.
Difference is the result of subtracting two values.
The difference between two values can be positive, negative, or zero.
For example, the difference between 10 and 5 is 5.
Skills evaluated in this interview
Celebal Technologies interview questions for designations
(2 Questions)
- Q1. Calculate repeating element in list
- Ans.
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
- Q2. Calculate maximum salary in SQL
- Ans.
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.
Interview Preparation Tips
1. Calculate maximum salary
2. Given two tables and what will be the output after the inner join
3. Calculate repeating number in a list in python.
4. Class object
Skills evaluated in this interview
Get interview-ready with Top Celebal Technologies Interview Questions
Selected
I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.
(1 Question)
- Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
(1 Question)
- Q1. Salary discussion with roles and responsiblity
Interview Preparation Tips
Data Engineer Jobs at Celebal Technologies
(5 Questions)
- 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
- 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...
- 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 ...
- Q4. Basic oops concept ?
- 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
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Some basic questions around list iterations were asked
- Q2. Questions around sql, database in general, dbms (dml, dql, ddl, acid properties, etc) were asked.
(1 Question)
- Q1. Questions were around my preference of location, salary etc.
Interview Preparation Tips
- Databricks
- Azure
- Pyspark
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.
(1 Question)
- Q1. Sql queries- nth highest salary python code- reverse string, word count program repartition vs coalesce reader and writer API External vs managed table Spark architecture broadcast join where clause vs hav...
Onkar Satish Pandole
Selected
I applied via campus placement at Dr DY Patil Institute of Management and Research, Pune and was interviewed before Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. What is joins , write a subquery
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Joins are used in SQL to retrieve data from multiple tables based on a related column between them.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Subqueries are queries nested within another query, typically used to return a single value or a list of values for comparison.
- Q2. Joins, ADF, CTE find 2nd highest no
- Ans.
Use SQL query with joins, common table expressions (CTE) and Azure Data Factory (ADF) to find the 2nd highest number.
Use a SQL query with joins to combine the necessary tables or datasets.
Utilize common table expressions (CTE) to simplify the query and make it more readable.
Leverage Azure Data Factory (ADF) to automate the process of running the query and retrieving the result.
Order the numbers in descending order and ...
Skills evaluated in this interview
Top trending discussions
Celebal Technologies Interview FAQs
The duration of Celebal Technologies Data Engineer 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 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
Celebal Technologies Data Engineer Interview Process
based on 18 interviews
3 Interview rounds
- Technical Round - 1
- Technical Round - 2
- HR Round
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Celebal Technologies Data Engineer Reviews and Ratings
based on 57 reviews
Rating in categories
|
Data Engineer
378
salaries
|  ₹4 L/yr - ₹12 L/yr |
|
Associate
246
salaries
| ₹4 L/yr - ₹10 L/yr |
|
Associate Data Engineer
158
salaries
| ₹2.5 L/yr - ₹11 L/yr |
|
Associate Consultant
156
salaries
| ₹5 L/yr - ₹16.4 L/yr |
|
Data Scientist
124
salaries
| ₹4.5 L/yr - ₹16.5 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Celebal Technologies Interview Questions >
- Celebal Technologies Data Engineer Interview Questions
