Jupiter Money CSR Executive Interview Questions and Answers

Q1. Previous work experience and process
Add your answer

SQL - technical round

Case Study round - 2

Medium Leetcode, Array, String, Tree, DP

Q1. System Design, Design Payment Platform
Add your answer

Mostly medium leetcode

Mostly medium level DSA

Q1. AWS, GCP , Kubernetes, Docker
Add your answer

Q1. Security standards, cloud security
Add your answer

Q1. What is the order of execution in sql
Ans. 
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• 1. FROM: Specifies the tables involved in the query.

• 2. WHERE: Filters the rows based on specified conditions.

• 3. GROUP BY: Groups the rows that have the same values into summary rows.

• 4. HAVING: Filters groups based on specified conditions.

• 5. SELECT: Selects the columns to be included in the result set.

• 6. ORDER BY: Sorts the result set base
Answered by AI
Add your answer

Q1. How to do conditional formatting in excel
Ans. 
Conditional formatting in Excel allows users to format cells based on specified conditions.
• Select the range of cells you want to apply conditional formatting to

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose the desired formatting option, such as color scales, data bars, or icon sets

• Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...read more
Answered by AI
Add your answer

Asked to write an in memory SQL database. Time was 1.5 hours. I made the mistake of choosing C++ and writing the code to make it very flexible and extensible. This led to me not being able to complete the task in the given time.
Tip: practice LLD round in a high level language like Python or Typescript. Speed is very important.

Q1. LLD HLD HM rounds
Add your answer

It was a basic Aptitude test, Needed to learn Probability, Permutation , Cobination and SQL.
Total Duration 1 Hour.