i
Jupiter Money
Filter interviews by
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.
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:
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
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
I was interviewed in Dec 2021.
Round duration - 90 Minutes
Round difficulty - Easy
Problem solving using SQL questions
Round duration - 90 Minutes
Round difficulty - Easy
A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round
Round duration - 30 Minutes
Round difficulty - Easy
Social empathatic fit round
Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding
Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job
Jupiter Money interview questions for designations
Top trending discussions
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Sql, python, statistical questions
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
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.
4 sql tasks on 3 tables. Joins, subqueries
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.
I was interviewed in Sep 2024.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
I was interviewed before Feb 2024.
Mostly medium leetcode
Mostly medium level DSA
I applied via Referral and was interviewed in Mar 2021. There were 3 interview rounds.
I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.
I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.
SQL
Python
R
Tableau
Excel
SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard
based on 3 interviews
Interview experience
based on 4 reviews
Rating in categories
Customer Support Executive
14
salaries
| ₹3.8 L/yr - ₹6 L/yr |
Customer Service Executive
14
salaries
| ₹5 L/yr - ₹6.4 L/yr |
Product Manager
12
salaries
| ₹13 L/yr - ₹40 L/yr |
Senior Product Manager
9
salaries
| ₹38 L/yr - ₹62 L/yr |
Product Designer
8
salaries
| ₹10.3 L/yr - ₹30 L/yr |
Paytm
PhonePe
Mobikwik
Payed