Chetu Data Engineer Interview Questions and Answers

Coding round of 2 questions of medium level

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

Q1. Talend, sql orcal, workbench
Add your answer

Q1. Salry expattions. reloaction leaves policy
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. Explain OOPS concept and how you apply it in your implementation
Ans. 
OOPS is a programming paradigm based on the concept of objects, which can contain data in the form of fields and code in the form of procedures.
• OOPS focuses on the concept of classes and objects

• Encapsulation: bundling data and methods that operate on the data within a single unit

• Inheritance: allows a class to inherit properties and behavior from another class

• Polymorphism: ability to present the same interface for diffe...read more
Answered by AI
View 1 more amswer
Q2. Difference between Comparable and Comparator. Difference between Abstract Class and Interface
Ans. 
Comparable is an interface used for natural ordering, Comparator is an interface used for custom ordering. Abstract class can have method implementations, Interface cannot.
• Comparable interface is used to define the natural ordering of objects. Example: String class implements Comparable interface for natural ordering based on alphabetical order.

• Comparator interface is used to define custom ordering of objects. Example:...read more
Answered by AI
View 1 more amswer
Q3. Given a string. Find the number of occurrences of each character
Ans. 
Count occurrences of each character in a given string
• Create an array to store the count of each character

• Iterate through the string and increment the count of each character in the array

• Return the array with counts for each character
Answered by AI
Add your answer
Q4. Given an array. Remove the number of duplicates
Ans. 
Remove duplicates from an array of strings
• Iterate through the array and store each element in a set to keep track of unique values

• Create a new array with the unique values from the set
Answered by AI
Add your answer
Q5. Given a student object having name and grade data variables. Sort the object on the basis of highest grade.
Add your answer

Q1. Why do we use SOLID principle, SRP and OCP violation?
Ans. 
SOLID principles help in creating maintainable, scalable, and flexible software.
• SOLID principles help in creating software that is easier to maintain and extend.

• Single Responsibility Principle (SRP) ensures that a class has only one reason to change, leading to more modular and cohesive code.

• Open/Closed Principle (OCP) states that a class should be open for extension but closed for modification, allowing for easy chang...read more
Answered by AI
Add your answer
Q2. What is singleton design pattern and how to implement it?
Ans. 
Singleton design pattern ensures a class has only one instance and provides a global point of access to it.
• Create a private static instance of the class within the class itself.

• Provide a public static method to access the instance.

• Ensure the constructor of the class is private to prevent instantiation from outside the class.

• Example: Singleton pattern is commonly used in database connections to ensure only one connectio
Answered by AI
Add your answer
Q3. OOPs based question: abstract vs interface, multiple inheritance, method overloading vs method overriding.
Add your answer
Q4. Dependency injection- what is it and any use case where to use?
Ans. 
Dependency injection is a design pattern where components are provided with their dependencies rather than creating them internally.
• Dependency injection helps in achieving loose coupling between components.

• It makes components easier to test by allowing for easier mocking of dependencies.

• Use cases include injecting database connections, logging services, and external API clients into components.
Answered by AI
Add your answer

Q1. Multithreading and TPL related questions?
Add your answer
Q2. How can we debug the any published dll?
Ans. 
Debugging a published dll involves using tools like Visual Studio debugger and logging mechanisms.
• Use Visual Studio debugger to attach to the process using the published dll

• Set breakpoints in the code to pause execution and inspect variables

• Use logging mechanisms to track the flow of execution and identify issues

• Check for any exceptions or errors thrown by the dll
Answered by AI
Add your answer
Q3. Data seeding in entity framework and how to map tables with entity?
Ans. 
Data seeding in Entity Framework involves pre-populating database tables with initial data. Mapping tables with entities involves defining relationships between database tables and entity classes.
• Data seeding in Entity Framework can be done using the 'Seed' method in the 'Configuration' class of the DbContext.

• To map tables with entities, use data annotations or Fluent API to define relationships between entities and da...read more
Answered by AI
Add your answer
Q4. Deployment related question in IIS.
Add your answer

Q1. Salary negotiation related discussion
Add your answer

Q1. Basicn details to check for qualifications
Add your answer

Q1. About my projects
Add your answer

Q1. More details about ML models
Add your answer