Chetu Data Engineer Interview Questions and Answers

Q1. About the project and technical aspect
Add your answer

Hackerearth problem on reversing the string & one more array question

Q1. Reverse the string
Ans. 
Reverse a given string
• Use built-in functions like reverse() in Python

• Iterate through the string in reverse order and append characters to a new string

• Use stack data structure to reverse the string
Answered by AI
Add your answer
Q2. SQL based windowing function
Add your answer

Q1. What is the architecture of Spark?
Add your answer

Q1. About project what are optimization you have done
Add your answer

Normal online code / frontend test

Q1. How would you build book my show
Ans. 
Designing and building a platform similar to BookMyShow involves creating a user-friendly interface for booking tickets for various events.
• Develop a user-friendly website and mobile app for users to browse and book tickets for movies, concerts, plays, etc.

• Implement a secure payment gateway for users to make online transactions.

• Integrate a database to store information about events, venues, tickets, and user bookings.

• In...read more
Answered by AI
Add your answer

Q1. Solid principals, awareness of patterns
Add your answer

Q1. How would you build tinyurl like service, systems designs
Ans. 
To build a tinyurl-like service, design a system with a URL shortening algorithm, a database to store mappings, and a redirect service.
• Use a hashing algorithm to generate short URLs from long URLs (e.g. MD5, SHA-256).

• Store the mappings of short URLs to long URLs in a database (e.g. MySQL, Redis).

• Implement a redirect service that takes a short URL, looks up the corresponding long URL in the database, and redirects the u...read more
Answered by AI
Add your answer

Q1. Non-technical questions
Add your answer

Q1. Basic sql query and some project related questions
Add your answer
Q2. What is indexing
Add your answer

Q1. Some management questions
Add your answer

Mainly 4 Questions
1-2 MCQ
3: Create a class deriving from IReptile and return an object of HatchEgg which has Hatch Method. Hatch Method should return same IReptile object.
4) Sorting IDs in dictionary

Q1. The Interviewer was Very Rude and he doesn't care about the Requirements of Hiring a candidate. he was constantly asking about Other Companies Architectures and The things you did in them. instead of havin...read more
Add your answer
Q2. SOLID, Interfaces , Boxing/Unboxing
Add your answer