Celebal Technologies Senior Data Engineer Interview Questions and Answers

It was well designed

Q1. Basic Questions about data warehousing
Add your answer
Q2. Dbt Scenarios
Add your answer

It was a basic aptitude test.

Q1. Can you tell me about yourself?
Ans. 
I am a data engineer with a strong background in programming and database management.
• Experienced in designing and implementing data pipelines

• Proficient in SQL, Python, and ETL tools

• Skilled in data modeling and optimization

• Worked on projects involving big data technologies like Hadoop and Spark
Answered by AI
Add your answer
Q2. What factors should be considered when designing a road curve?
Ans. 
Factors to consider when designing a road curve
• Radius of the curve

• Speed limit of the road

• Banking of the curve

• Visibility around the curve

• Traffic volume on the road

• Road surface conditions

• Presence of obstacles or hazards

• Environmental factors such as weather conditions
Answered by AI
Add your answer
Q3. Can you provide details about your project?
Ans. 
Developed a real-time data processing system for analyzing customer behavior
• Used Apache Kafka for real-time data streaming

• Implemented data pipelines using Apache Spark for processing large volumes of data

• Utilized machine learning algorithms to predict customer behavior

• Designed and maintained data warehouse for storing and querying processed data
Answered by AI
Add your answer

Q1. Can you provide an introduction about yourself?
Ans. 
Experienced Data Engineer with a background in computer science and a passion for solving complex problems.
• Bachelor's degree in Computer Science

• Proficient in programming languages such as Python, SQL, and Java

• Experience with big data technologies like Hadoop and Spark

• Strong analytical and problem-solving skills

• Worked on projects involving data pipelines, ETL processes, and data warehousing
Answered by AI
Add your answer
Q2. What are your hobbies?
Ans. 
My hobbies include hiking, photography, and playing the guitar.
• Hiking: I enjoy exploring nature trails and challenging myself with different terrains.

• Photography: I love capturing moments and landscapes through my camera lens.

• Playing the guitar: I find relaxation and creativity in strumming chords and learning new songs.
Answered by AI
Add your answer
Q3. Which is your favorite movie
Ans. 
My favorite movie is The Shawshank Redemption.
• Directed by Frank Darabont

• Based on a Stephen King novella

• Themes of hope, friendship, and redemption

• Critically acclaimed and considered one of the greatest films of all time
Answered by AI
Add your answer

Q1. Tell me your Personal Details
Add your answer
Q2. Asking about your commitment
Add your answer
Q3. Previous company details
Add your answer
Q4. Any offers in your pipeline?
Add your answer