AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Drip Capital
Compare
Filter interviews by
Drip Capital Data Analyst Interview Questions and Answers
Drip Capital Data Analyst Interview Experiences
1 interview found
I applied via Walk-in and was interviewed in Nov 2024. There were 3 interview rounds.
Guesstimation question provided.
(2 Questions)
- Q1. Probability related questions
- Q2. Statistics related questions
(1 Question)
- 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
Top trending discussions
Interview questions from similar companies
(2 Questions)
- 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.
- 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:
Skills evaluated in this interview
Shardul Jadhav
Selected
Hackerrank test mostly on python and sql
(2 Questions)
- Q1. SQL based questions
- Q2. Python based questions
Data Analyst Interview Questions & Answers
Open Financial Technologies Private Limited
Anonymous
posted on 29 Mar 2024
Selected
I applied via Referral and was interviewed before Mar 2023. There were 2 interview rounds.
Intermediate level coding round
(2 Questions)
- Q1. Project explaination
- 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
Interview Preparation Tips
- SQL
- Python
- Dashboards
I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQl window functions, how to use joins group by in queries, how data analytics works.. What is ETL
Interview Preparation Tips
Selected
(5 Questions)
- Q1. Fibonacci sequence
- Q2. Databricks cluster questions
- Q3. Intermediate SQL questions from datalemur
- Q4. Python questions from geeksforgeeks
- Q5. ETL information
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.
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
(1 Question)
- Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.
Interview Preparation Tips
- SQL
Selected
Hackerrank test mostly on python and sql
(2 Questions)
- Q1. SQL based questions
- Q2. Python based questions
Senior Data Analyst Interview Questions & Answers
Open Financial Technologies Private Limited
Anonymous
posted on 31 Jul 2024
Selected
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
Practice sql as much as you can
Be good with nath and reasoning
Reasoning was asked
Interview Preparation Tips
Data Analyst Intern Interview Questions & Answers
EarlySalary Services
Anonymous
posted on 19 Oct 2024
I applied via campus placement at Indian Institute of Information Technology and Management (ABV-IIITM), Gwalior and was interviewed in Apr 2024. There were 2 interview rounds.
45 min , 45 questions
(2 Questions)
- Q1. Technical question( PowerBI, data science)
- Q2. Behaviourial question
Interview Preparation Tips
Drip Capital Interview FAQs
Tell us how to improve this page.
Drip Capital Interviews By Designations
- Drip Capital Business Development Manager Interview Questions
- Drip Capital Data Analyst Interview Questions
- Drip Capital Finance Manager Interview Questions
- Drip Capital Inside Sales Executive Interview Questions
- Drip Capital Insurance Associate Interview Questions
- Drip Capital International Sales Executive Interview Questions
- Drip Capital Manager Interview Questions
- Drip Capital Product Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Drip Capital Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
|
Senior Associate
35
salaries
|  ₹4.5 L/yr - ₹13.5 L/yr |
|
Business Development Manager
28
salaries
| ₹5 L/yr - ₹13.5 L/yr |
|
Software Engineer
24
salaries
| ₹10 L/yr - ₹28.5 L/yr |
|
Senior Manager
13
salaries
| ₹13.2 L/yr - ₹24 L/yr |
|
Associate
13
salaries
| ₹4.1 L/yr - ₹7 L/yr |
Axio
LendingKart
NeoGrowth Credit
Indifi Technologies
- Home >
- Interviews >
- Drip Capital Interview Questions >
- Drip Capital Data Analyst Interview Questions
