Yubi Data Engineer Interview Questions and Answers

Q1. Fibonacci sequence
Add your answer
Q2. Databricks cluster questions
Add your answer
Q3. Intermediate SQL questions from datalemur
Add your answer
Q4. Python questions from geeksforgeeks
Add your answer
Q5. ETL information
Add your answer

Q1. Advanced SQL: Window and aggregation
Add your answer

Q1. Python: Shallow copy and deep copy
Add your answer

Q1. Project architecture questions
Add your answer

Q1. Explain the project architecture.
Ans. 
The project architecture consists of multiple components that work together to process and analyze data.
• The architecture follows a distributed computing model.

• Data is collected from various sources and stored in a data lake or data warehouse.

• Data processing and transformation tasks are performed using tools like Apache Spark or Hadoop.

• Processed data is then loaded into a database or data store for further analysis.

• Anal...read more
Answered by AI
View 1 more answer
Q2. What are flaws in your architecture?
Ans. 
Our architecture lacks scalability and real-time processing capabilities.
• Our current architecture is not designed to handle large volumes of data.

• Real-time processing of data is not possible with our current setup.

• We lack a proper data pipeline for efficient data processing.

• Our architecture is not fault-tolerant and lacks redundancy.

• We need to improve our data storage and retrieval mechanisms.

• Our architecture does not ...read more
Answered by AI
Add your answer

Q1. LLD/Machine coding - Design a social media application with users, posts, comments, likes, etc. There is also an admin who needs to approve post creation and can delete any post they want. Create appropria...read more
Add your answer

Q1. High-level design - Design a chat-based application like WhatsApp with only user-to-user chat feature (no group chats). Explain and draw out the E2E design by mentioning all the components and design decis...read more
Add your answer

Q1. Hiring Manager - basic questions like why Razorpay, what are your career goals, what does career growth look like for you, etc.
Add your answer

Sql, python, statistical questions

Q1. How daily work looks like?
Ans. 
Daily work involves analyzing data, creating reports, and communicating findings to stakeholders.
• Reviewing and cleaning data sets

• Creating visualizations and dashboards

• Conducting statistical analysis

• Communicating insights to non-technical stakeholders
Answered by AI
Add your answer
Q2. Most ise tools?
Ans. 
Some of the most commonly used tools for data analysis include Excel, Python, R, Tableau, and SQL.
• Excel is widely used for data manipulation and analysis.

• Python and R are popular programming languages for data analysis and machine learning.

• Tableau is a powerful data visualization tool.

• SQL is essential for querying databases and extracting data.
Answered by AI
Add your answer

4 sql tasks on 3 tables. Joins, subqueries

Cancellation in the number of bookings in an app has increased exponentially in the past few weeks, How would you conduct an RCA on the same.

Q1. Just to know more about why i want the role
Add your answer

Testing an payment flow on the application

1 hour, the coding test was based on a project given to us

Q1. Detailed questionnaire on React
Add your answer
Q2. Problem solving based on array manipulations
Add your answer