Celebal Technologies Interview Questions, Process, and Tips

Q1. Probability related
Add your answer
Q2. Stats related like IQR etc.
Add your answer

Q1. Difference between entropy & information gain
Ans. 
Entropy measures randomness in data, while information gain measures the reduction in uncertainty after splitting data.
• Entropy is used in decision trees to measure impurity in a dataset before splitting it.

• Information gain is used in decision trees to measure the effectiveness of a split in reducing uncertainty.

• Entropy ranges from 0 (pure dataset) to 1 (completely impure dataset).

• Information gain is calculated as the d...read more
Answered by AI
Add your answer
Q2. LSTM & GRU, Which to use when ?
Ans. 
LSTM for longer sequences, GRU for faster training and less complex models.
• Use LSTM for tasks requiring long-term dependencies and memory retention.

• Use GRU for faster training and simpler models with fewer parameters.

• Consider using LSTM for tasks like language translation or speech recognition.

• Consider using GRU for tasks like sentiment analysis or text generation.
Answered by AI
Add your answer

Time Series data were given, we have to provide some insights

Q1. Majorly around databricks
Add your answer
Q2. Azure Data Factory
Add your answer

Q1. Explain the project you are working on.
Add your answer
Q2. A code on python, strings.
Add your answer
Q3. Two tables given and asked how many outputs will you get if you apply inner joim
Add your answer
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
Add your answer
Q5. Redshift related questions
Add your answer

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.

• ...read more
Answered by AI
Add your answer
Q2. Lift capacity and passenger sql query
Add your answer
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
Add your answer
Q4. Tell me about architecture of the project that you are working on
Add your answer

It was smoothly done and questions are easy.

It was smoothly done and difficulty level good

Q1. Oops concepts and ask defination of all concepts
Add your answer
Q2. Pattern program using any language
Ans. 
Print a pattern program using any programming language
• Use nested loops to print the desired pattern

• Identify the pattern and determine the number of rows and columns needed

• Experiment with different loop structures to achieve the desired output
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Why are you want to join us
Add your answer

Q1. Sql queries, python program and my clg background
Add your answer
Q2. Star pattern, codding and sql question oral
Add your answer

Q1. Joins , sub queries
Add your answer
Q2. Trigger, group by
Add your answer

Programing questiion star pattern