Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by OneCard Team. If you also belong to the team, you can get access from here

OneCard Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

OneCard Data Analyst Interview Questions and Answers

Updated 11 Nov 2024

OneCard Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Nov 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Coding Test 

Basic python, sql and pandas questions

Round 2 - Technical 

(2 Questions)

  • Q1. Case study (Probability questions)
  • Q2. Resume projects

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview

Interview questions from similar companies

I applied via IIM Jobs and was interviewed before Nov 2021. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
  • Ans. 

    Different types of Joins in SQL and the outputs when joining two tables with nulls.

    • Types of joins in SQL include inner join, left join, right join, and full outer join.

    • When joining two tables with nulls, the output depends on the type of join used.

    • In an inner join, null values are excluded from the result.

    • In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...

  • Answered by AI
  • Q2. Can you union tables with different datatypes.
  • Ans. 

    Yes, but it requires careful handling of data types and potential conversion.

    • Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

    • Data types should be compatible, otherwise conversion may be necessary.

    • For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

    • ...

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Given a data set, should write sql queries to answer a few questions
  • Q2. A few puzzles would be asked to evaluate the problem solving skills.
Round 4 - One-on-one 

(1 Question)

  • Q1. Business Case studies - try parctising profitablility and other cases
Round 5 - Technical 

(1 Question)

  • Q1. An Excel round will also be there if you apply for business analyst role.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared - SQL, Excel and problem solving.
All the best for the interview.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Easy questions based on Logical Reasoning, Mathematics, English

Round 2 - Group Discussion 

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Round 3 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself Tell me something from your resume Desribe your project
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(1 Question)

  • Q1. General questions and sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare aptitude and SQL questions and Bi tools
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Apr 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Apti was based on analytical skills

Round 2 - Group Discussion 

It was a fun GD which had the topic future app experiences.

Round 3 - Case Study 

Asked questions on guestimates and my analytical skills

Round 4 - HR 

(3 Questions)

  • Q1. HR questions and 1 analytical question asked.
  • Q2. Question asked on my location
  • Q3. Question asked on guestimates

Interview Preparation Tips

Interview preparation tips for other job seekers - Good Company. though long hiring process but was good overall.

Data Analyst Interview Questions & Answers

PhonePe user image Megha choudhary

posted on 28 Dec 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - HR 

(2 Questions)

  • Q1. Sql,power bi,aptitude,technical
  • Q2. How you take criticism
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Referral

Round 1 - HR 

(2 Questions)

  • Q1. Are you available to join immediately?
  • Q2. What's your location preference?

I applied via LinkedIn and was interviewed in Feb 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Basic sql and excel questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Basic cultural fit and puzzle questions

Interview Preparation Tips

Interview preparation tips for other job seekers - moderate level interview not very difficult just prepare basic questions well
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Case Study of zomato ?
  • Q2. Some basic math questions. Simultaneous equations .

Interview Preparation Tips

Interview preparation tips for other job seekers - However good you are in the interview in case study you need to get the math problems correct on the first attempt. I got it wrong but answered it correctly within one minute. But they said " i lack attention to detail" and didnt consider me for the next round.

Data Analyst Interview Questions & Answers

Paytm user image Rahul Jindal

posted on 19 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Sql questions on windows functions, subquery
  • Q2. Guesstimmate on how many cricket bat is solved in a year
  • Ans. 

    It is difficult to accurately estimate the number of cricket bats sold in a year without specific data.

    • The number of cricket bats sold in a year can vary based on factors such as seasonality, popularity of cricket, and market trends.

    • One approach to estimate could be to consider the total population of cricket-playing countries and the average number of bats owned by players.

    • Another approach could be to look at the sale...

  • Answered by AI
Contribute & help others!
anonymous
You can choose to be anonymous

OneCard Interview FAQs

How many rounds are there in OneCard Data Analyst interview?
OneCard interview process usually has 2 rounds. The most common rounds in the OneCard interview process are Coding Test and Technical.

Recently Viewed

INTERVIEWS

Europa Locks

No Interviews

Tell us how to improve this page.

OneCard Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Tide Business Finance Platform

Thrive at work, live fully - experience balance like never before!

OneCard Data Analyst Salary
based on 17 salaries
₹7.4 L/yr - ₹16.3 L/yr
135% more than the average Data Analyst Salary in India
View more details

OneCard Data Analyst Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

-

Skill development

-

Work-life balance

-

Salary

-

Job security

-

Company culture

-

Promotions

-

Work satisfaction

Explore 1 Review and Rating
Product Manager
38 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
26 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer experience Specialist
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
22 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Scientist
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare OneCard with

Uni Cards

3.9
Compare

Paytm

3.3
Compare

PhonePe

4.0
Compare

Mobikwik

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent