Ocrolus East Data Analyst Interview Questions and Answers

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. Case Study of zomato ?
Add your answer
Q2. Some basic math questions. Simultaneous equations .
Add your answer

Hackerrank test mostly on python and sql

Q1. SQL based questions
Add your answer
Q2. Python based questions
Add your answer

Intermediate level coding round

Q1. Project explaination
Add your answer
Q2. Explain project ind detail
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecommunications company.
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer

Q1. SQL question for cte and limit
Add your answer
Q2. Group by order by question and puzzle with senariobased
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

Guesstimation question provided.

Q1. Probability related questions
Add your answer
Q2. Statistics related questions
Add your answer

Q1. What do you know about the company, and where do you envision yourself in five years?
Ans. 
I know that the company specializes in data analysis and has a strong reputation in the industry. In five years, I envision myself leading a team of analysts and contributing to the company's growth.
• Company specializes in data analysis

• Has a strong reputation in the industry

• Envision myself leading a team of analysts in five years

• Contributing to the company's growth
Answered by AI
Add your answer

Technical SQL Coding Round of 1 hour

Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,

Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.

Bar Raiser Round of 1 hour involving -

1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?

2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.

3. Resume based work exp discussion

Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.
Add your answer