Add office photos
Celebal Technologies logo
Engaged Employer

Celebal Technologies

Verified
3.0
based on 541 Reviews
Video summary
Filter interviews by
Clear (1)

10+ Celebal Technologies Data Engineer Interview Questions and Answers

Updated 20 Oct 2024

Q1. Are you familiar with Celebal Technologies

Ans.

Celebal Technologies is a technology company specializing in data engineering and analytics solutions.

  • Celebal Technologies is known for providing data engineering and analytics solutions.

  • They offer services such as data integration, data warehousing, and data visualization.

  • Celebal Technologies works with clients across various industries to help them optimize their data processes.

  • They have expertise in technologies like Hadoop, Spark, and Python for data engineering.

  • The compa...read more

Add your answer
right arrow

Q2. What is the Goal of Celebal Technologies

Ans.

Celebal Technologies aims to provide innovative solutions using cutting-edge technologies to help businesses thrive in the digital age.

  • Developing advanced data analytics tools for businesses

  • Creating AI-driven solutions for automation and optimization

  • Offering consulting services for digital transformation

  • Empowering organizations with cloud computing and IoT solutions

Add your answer
right arrow

Q3. 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 clause is applied after the GROUP BY clause.

  • WHERE clause ...read more

Add your answer
right arrow

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

Add your answer
right arrow
Discover Celebal Technologies interview dos and don'ts from real experiences

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

Add your answer
right arrow

Q6. 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 fast access to values based on keys.

Add your answer
right arrow
Are these interview questions helpful?

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

Add your answer
right arrow

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

Add your answer
right arrow
Share interview questions and help millions of jobseekers 🌟
man with laptop

Q9. Multiple 2 numbers without using '*' operator.

Ans.

Use bitwise operations to multiply two numbers without using '*' operator.

  • Use bitwise shift left operation to multiply a number by 2.

  • Add the result of shifting left n times for the second number.

  • Example: 3 * 5 = 3 << 2 + 3 = 12.

Add your answer
right arrow

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

  • Examples: CREATE INDEX index_name ON table_name(column_nam...read more

Add your answer
right arrow

Q11. 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 suitable for scenarios where data needs to be transformed bef...read more

Add your answer
right arrow

Q12. 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 number of columns and compatible data types.

  • Join can inclu...read more

Add your answer
right arrow

Q13. 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 select the second row to find the 2nd highest number.

Add your answer
right arrow

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

Add your answer
right arrow

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

Add your answer
right arrow

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

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Celebal Technologies Data Engineer

based on 18 interviews
3 Interview rounds
Technical Round - 1
Technical Round - 2
HR Round
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Engineer Interview Questions from Similar Companies

Capgemini Logo
3.7
 • 40 Interview Questions
Cognizant Logo
3.7
 • 28 Interview Questions
PwC Logo
3.4
 • 20 Interview Questions
Altimetrik Logo
3.8
 • 13 Interview Questions
HSBC Group Logo
3.9
 • 11 Interview Questions
View all
Recently Viewed
INTERVIEWS
Sigmoid
5.6k top interview questions
SALARIES
JPMorgan Chase & Co.
INTERVIEWS
Sigmoid
No Interviews
INTERVIEWS
Sigmoid
No Interviews
DESIGNATION
INTERVIEWS
Sigmoid
No Interviews
INTERVIEWS
Acuity Knowledge Partners
No Interviews
SALARIES
Sigmoid
INTERVIEWS
Sigmoid
No Interviews
SALARIES
JPMorgan Chase & Co.
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter