Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Open Financial Technologies Private Limited Team. If you also belong to the team, you can get access from here

Filter interviews by

Open Financial Technologies Private Limited Data Analyst Interview Questions and Answers

Updated 29 Mar 2024

Open Financial Technologies Private Limited Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 29 Mar 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Intermediate level coding round

Round 2 - Technical 

(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

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Open Financial Technologies Private Limited Data Analyst interview:
  • SQL
  • Python
  • Dashboards
Interview preparation tips for other job seekers - all the best

Interview questions from similar companies

I appeared for an interview in Dec 2021.

Round 1 - Video Call 

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round 2 - Video Call 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

  • Q1. In a marketing campaign, how would you decide which metrics to track?
  • Ans. 

    Metrics selection based on campaign objectives, target audience, and key performance indicators.

    • Identify campaign objectives and goals

    • Consider target audience and their behavior

    • Select key performance indicators (KPIs) relevant to the campaign

    • Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

    • Analyze data to measure success and make data-driven decisions

  • Answered by AI
Round 3 - HR 

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Data Analyst in BangaloreEligibility criteriaNoJupiter Money interview preparation:Topics to prepare for the interview - SQL, Tablea, Data Visualisation, Key Metrics for a Product, Data Visualisation using PythonTime required to prepare for the interview - 2 MonthsInterview preparation tips for other job seekers

Tip 1 : SQL logics to be understood completely
Tip 2 : A good running working logic of Python
Tip 3 : Basics of Dashboarding

Application resume tips for other job seekers

Tip 1 : One pager , single column resume which shows all your skills
Tip 2 : Mention all things that make you relevant for the job

Final outcome of the interviewSelected
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL questions are asked in this round Some theory questions are asked as well

Interview Preparation Tips

Interview preparation tips for other job seekers - focus on SQL
practice plenty of SQL and case study problems
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Coding Test 

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.

Round 3 - Case Study 

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

Round 4 - HR 

(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

Topics to prepare for Jupiter Money Data Analyst interview:
  • SQL
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL - technical round

Round 2 - Case Study 

Case Study round - 2

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
-
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - Coding Test 

Mostly medium leetcode

Round 2 - Coding Test 

Mostly medium level DSA

Round 3 - Technical 

(1 Question)

  • Q1. AWS, GCP , Kubernetes, Docker
Round 4 - Technical 

(1 Question)

  • Q1. Security standards, cloud security
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. What techonologies do you know?
  • Ans. 

    I am proficient in SQL, Python, R, Tableau, and Excel for data analysis and visualization.

    • SQL

    • Python

    • R

    • Tableau

    • Excel

  • Answered by AI
Round 2 - Coding Test 

SQL Coding Tests. You get 3 tables and they ask you to find customer with certain conditions. Not hard

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Brief me about yourself
Round 2 - One-on-one 

(1 Question)

  • Q1. What is your experience as a data analyst?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Sql, python, statistical questions

Round 2 - HR 

(2 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
  • 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
Round 3 - Coding Test 

4 sql tasks on 3 tables. Joins, subqueries

Interview Preparation Tips

Interview preparation tips for other job seekers - Learm main statistics principles
Sql mandatory

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • 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
Round 2 - Technical 

(1 Question)

  • 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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be through with basics

Skills evaluated in this interview

Open Financial Technologies Private Limited Interview FAQs

How many rounds are there in Open Financial Technologies Private Limited Data Analyst interview?
Open Financial Technologies Private Limited interview process usually has 2 rounds. The most common rounds in the Open Financial Technologies Private Limited interview process are Coding Test and Technical.
What are the top questions asked in Open Financial Technologies Private Limited Data Analyst interview?

Some of the top questions asked at the Open Financial Technologies Private Limited Data Analyst interview -

  1. explain project ind det...read more
  2. project explainat...read more

Tell us how to improve this page.

Open Financial Technologies Private Limited Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Fast track your campus placements

View all
Open Financial Technologies Private Limited Data Analyst Salary
based on 16 salaries
₹4 L/yr - ₹12.2 L/yr
14% more than the average Data Analyst Salary in India
View more details

Open Financial Technologies Private Limited Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

2.0

Work-life balance

2.0

Salary

3.0

Job security

3.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
88 salaries
unlock blur

₹4.5 L/yr - ₹16.7 L/yr

Senior Software Engineer
58 salaries
unlock blur

₹11.5 L/yr - ₹31.5 L/yr

Business Development Specialist
24 salaries
unlock blur

₹4 L/yr - ₹10.5 L/yr

Product Support Engineer
23 salaries
unlock blur

₹1.5 L/yr - ₹10 L/yr

Product Manager
22 salaries
unlock blur

₹15 L/yr - ₹32 L/yr

Explore more salaries
Compare Open Financial Technologies Private Limited with

Rupeek

3.7
Compare

Razorpay

3.6
Compare

ACKO

3.7
Compare

Kissht Finance

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview