Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Celebal Technologies Team. If you also belong to the team, you can get access from here

Celebal Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Celebal Technologies Data Engineer Interview Questions, Process, and Tips

Updated 22 Nov 2024

Top Celebal Technologies Data Engineer Interview Questions and Answers

View all 16 questions

Celebal Technologies Data Engineer Interview Experiences

17 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(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.

  • Answered by AI
  • Q5. Redshift related questions

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Kiran Bagate

posted on 15 Jun 2024

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(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.

    • ...

  • Answered by AI
  • 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.

  • Answered by AI
  • Q4. Tell me about architecture of the project that you are working on

Skills evaluated in this interview

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in Sigmoid
Q5. K-th Element of Two Sorted Arrays You are provided with two sorte ... read more

Data Engineer Interview Questions & Answers

user image Onkar Pandole

posted on 22 Nov 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Newspaper Ad and was interviewed in May 2024. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Sql queries, python program and my clg background
  • Q2. Star pattern, codding and sql question oral
Round 2 - One-on-one 

(2 Questions)

  • Q1. Joins , sub queries
  • Q2. Trigger, group by
Round 3 - Coding Test 

Programing questiion star pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - not good

Data Engineer Interview Questions & Answers

user image aditya oza

posted on 30 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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...

  • Answered by AI
  • 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.

  • Answered by AI

Skills evaluated in this interview

Celebal Technologies interview questions for designations

 Big Data Engineer

 (2)

 Senior Data Engineer

 (1)

 Associate Data Engineer

 (2)

 Azure Data Engineer

 (1)

 Data Scientist

 (9)

 Data Analyst

 (3)

 Data Science

 (1)

 Data Scientist and Machine Learning Engineer

 (1)

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Aug 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Online Interview 

(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

  • Answered by AI
  • 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.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I joined Celebal Technology as Intern, The interviewer asked python and SQL easy questions.
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

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL basic questions, Difference between types of join, Aggregate function, Triggers and cursors
Round 2 - HR 

(1 Question)

  • Q1. Salary discussion with roles and responsiblity

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear the concepts of SQL and what you mentioned in CV should match

Data Engineer Jobs at Celebal Technologies

View all
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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 ...

  • Answered by AI
  • 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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basic

Skills evaluated in this interview

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Sep 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Technical 

(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.
Round 2 - HR 

(1 Question)

  • Q1. Questions were around my preference of location, salary etc.

Interview Preparation Tips

Topics to prepare for Celebal Technologies Data Engineer interview:
  • Databricks
  • Azure
  • Pyspark
Interview preparation tips for other job seekers - Prepare well with spark, python, sql coding questions. Basics of cloud tech can be asked. Knowledge of Databricks will be a big plus
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(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...

Data Engineer Interview Questions & Answers

user image Onkar Satish Pandole

posted on 20 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected 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.

Round 1 - Technical 

(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.

  • Answered by AI
  • 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 ...

  • Answered by AI

Skills evaluated in this interview

Celebal Technologies Interview FAQs

How many rounds are there in Celebal Technologies Data Engineer interview?
Celebal Technologies interview process usually has 1-2 rounds. The most common rounds in the Celebal Technologies interview process are Technical, HR and Coding Test.
How to prepare for Celebal Technologies Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Celebal Technologies. The most common topics and skills that interviewers at Celebal Technologies expect are Python, SQL, Data Modeling, ETL and Big Data.
What are the top questions asked in Celebal Technologies Data Engineer interview?

Some of the top questions asked at the Celebal Technologies Data Engineer interview -

  1. Are you familiar with Celebal Technolog...read more
  2. What is the Goal of Celebal Technolog...read more
  3. Difference between having clause and where clau...read more
How long is the Celebal Technologies Data Engineer interview process?

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 Data Engineer Interview Process

based on 18 interviews

3 Interview rounds

  • Technical Round - 1
  • Technical Round - 2
  • HR Round
View more
Celebal Technologies Data Engineer Salary
based on 373 salaries
₹4 L/yr - ₹12 L/yr
34% less than the average Data Engineer Salary in India
View more details

Celebal Technologies Data Engineer Reviews and Ratings

based on 57 reviews

2.8/5

Rating in categories

3.3

Skill development

2.7

Work-life balance

2.5

Salary

2.3

Job security

2.6

Company culture

2.5

Promotions

2.7

Work satisfaction

Explore 57 Reviews and Ratings
Data Engineer
373 salaries
unlock blur

₹4 L/yr - ₹12 L/yr

Associate
246 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Associate Data Engineer
157 salaries
unlock blur

₹2.5 L/yr - ₹11 L/yr

Associate Consultant
156 salaries
unlock blur

₹5 L/yr - ₹16.4 L/yr

Data Scientist
126 salaries
unlock blur

₹4.5 L/yr - ₹14.2 L/yr

Explore more salaries
Compare Celebal Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview