Upload Button Icon Add office photos
Engaged Employer

i

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

Novopay Solutions Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Novopay Solutions Product Analyst Intern Interview Questions and Answers

Updated 29 May 2024

Novopay Solutions Product Analyst Intern Interview Experiences

1 interview found

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

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

Round 1 - Assignment 

Assignment on a product case study in my case it was to design a mvp

Round 2 - Technical 

(1 Question)

  • Q1. About the assignment , past ex , domain knowledge(imp)
Round 3 - HR 

(1 Question)

  • Q1. Casual conv regarding my background
Round 4 - One-on-one 

(1 Question)

  • Q1. This round was with the vp it was short call about generic stuff why you wan to work here , past ex

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Introduce Yourself
  • Ans. 

    I am a data analyst with a background in statistics and experience in analyzing large datasets to drive business decisions.

    • Graduated with a degree in Statistics

    • Proficient in data analysis tools such as Python, R, and SQL

    • Experience in creating visualizations to communicate insights

    • Strong problem-solving skills

  • Answered by AI
  • Q2. Skills you have

Interview Questionnaire 

1 Question

  • Q1. System Design and Ds and algo questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Assignment 

HackerEarth based assessment.
1. 8 qs were stats & prob based multiples choices
2. 2 were medium level sql questions.

Round 2 - Technical 

(2 Questions)

  • Q1. Started with basic sql question like diff btw nosql & sql, join etc
  • Q2. Table were given in google sheet & had to write basic level queries on them eg. cte's, agg function, lead & lag func
Round 3 - Behavioral 

(2 Questions)

  • Q1. The interviewer was not serious at all, asked silly quizzes instead of business case study, KPI & metrics
  • Q2. Prepare for logical reasoning

Interview Preparation Tips

Interview preparation tips for other job seekers - Study A/B testing, Hypothesis testing & logical reasoning (quizzes)
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Aptitude Test 

Consisted of 10 questions, 2 SQL medium level questions and remaining easy aptitude, profit loss, work time etc

Round 2 - Technical 

(2 Questions)

  • Q1. SQL visualisation
  • Q2. SQL Questions theory

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be well prepared with SQL as the role required it.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Aptitude Test 

6 mcqs and 2 sql questions

Round 2 - Technical 

(5 Questions)

  • Q1. Difference between having and where in sql
  • Ans. 

    In SQL, 'HAVING' is used with GROUP BY to filter groups, while 'WHERE' is used to filter rows before grouping.

    • HAVING is used with GROUP BY to filter groups based on aggregate functions

    • WHERE is used to filter rows before grouping

    • HAVING is used after GROUP BY in the query, while WHERE is used before GROUP BY

    • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

    • Example: S

  • Answered by AI
  • Q2. Sql joins and it types
  • Q3. Window functions and subqueries
  • Q4. Sql scenario question based on joins
  • Q5. Kpi's and metrics
Round 3 - Technical 

(1 Question)

  • Q1. Business problem related to case study

Interview Preparation Tips

Interview preparation tips for other job seekers - learn sql, problem solving,puzzles,kpi's and metrics

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic Hacker Rank SQL Questions 2 . and 10 MCQ based

Round 2 - Technical 

(3 Questions)

  • Q1. Select customer, sum(amt ) as total_amt from t1 group by customer how many no. of rows it will return and explain this table t1 column name-> dept customer item amt
  • Q2. Select * , sum(amt) over (partition by customer) as total_amt from t2
  • Ans. 

    The query selects all columns and calculates the total amount for each customer in table t2.

    • The query uses a window function to calculate the sum of 'amt' for each customer in the 't2' table.

    • The 'partition by customer' clause divides the result set into partitions based on the 'customer' column.

    • The 'select *' statement selects all columns from the table along with the calculated total amount.

    • The 'sum(amt) over (partiti...

  • Answered by AI
  • Q3. How many Customers has purchased same item on the Same day more than onnce
  • Ans. 

    To find customers who purchased the same item multiple times on the same day.

    • Identify unique customers who purchased the same item multiple times on the same day

    • Check for duplicate transactions by customer and item on the same day

    • Aggregate the data to count the number of customers who made multiple purchases of the same item on the same day

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic sql and solve questiosn without seeing answers

Interview Questionnaire 

2 Questions

  • Q1. Laravel Nova task
  • Q2. Php basic questions

I applied via Approached by Company and was interviewed before May 2021. There were 3 interview rounds.

Round 1 - Coding Test 

There was a assignment in angular to create simple e-commerce application!

Round 2 - Technical 

(1 Question)

  • Q1. Basics of angula, html, css and js!
Round 3 - HR 

(1 Question)

  • Q1. Basic question with all why's and when's, salary discussion, date of joining, availability of joining, role, etc.,

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest, don't make up things, never hesitate to ask feedback and doubts.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Jan 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. OOPs related questions.
  • Q2. Joins, Indexes and some problems to write sql queries.

Novopay Solutions Interview FAQs

How many rounds are there in Novopay Solutions Product Analyst Intern interview?
Novopay Solutions interview process usually has 4 rounds. The most common rounds in the Novopay Solutions interview process are Assignment, Technical and HR.
What are the top questions asked in Novopay Solutions Product Analyst Intern interview?

Some of the top questions asked at the Novopay Solutions Product Analyst Intern interview -

  1. this round was with the vp it was short call about generic stuff why you wan to...read more
  2. about the assignment , past ex , domain knowledge(i...read more

Tell us how to improve this page.

Novopay Solutions Product Analyst Intern Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Vyapar Interview Questions
3.5
 • 55 Interviews
Fleetx.io Interview Questions
3.7
 • 28 Interviews
Classplus Interview Questions
3.4
 • 28 Interviews
Springworks Interview Questions
4.5
 • 23 Interviews
LambdaTest Interview Questions
4.5
 • 19 Interviews
ThoughtSpot Interview Questions
3.8
 • 18 Interviews
Fourkites Interview Questions
3.8
 • 17 Interviews
View all

Fast track your campus placements

View all
Software Development Engineer
26 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Sde1
21 salaries
unlock blur

₹6.5 L/yr - ₹10 L/yr

Software Developer
18 salaries
unlock blur

₹4.2 L/yr - ₹12 L/yr

Associate Product Manager
15 salaries
unlock blur

₹11 L/yr - ₹27.3 L/yr

Senior Executive
14 salaries
unlock blur

₹3 L/yr - ₹4.7 L/yr

Explore more salaries
Compare Novopay Solutions with

Vyapar

3.5
Compare

Nowfloats Technologies

3.2
Compare

ShopKirana

3.8
Compare

Classplus

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