Upload Button Icon Add office photos

Nepa

Compare button icon Compare button icon Compare
3.4

based on 56 Reviews

Filter interviews by

Nepa Data Analyst Interview Questions and Answers

Updated 22 Jun 2017

Nepa Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Jun 2017

I was interviewed before Jun 2016.

Interview Preparation Tips

Round: Resume Shortlist
Experience: In this round, they shortlisted about 50 resumes from a pool of 200. My resume was a page long and I made it specifically for this job in the sense that I put in only those projects and research papers that were relevant to my job profile.
Tips: Your resume shouldnt be longer than one page. Make it crisp and relevant. Include only those hobbies and interests that you are actually passionate about and have pursued in some way or the other. A long resume which is very elaborate kind of puts them off. You want to save some content for the interview also when they ask you to actually elaborate on something that they find interesting. Also, sometimes you may decide to not put certain things down in the resume so that when they ask you to talk about yourself, you can say something that is not on the resume.

Round: Technical + HR Interview
Experience: It was a 30 minute long interview. Technical part was asking course related questions. They also gave me certain situations related to workplace and how I would react in the same. Also I had done some background check on the company and its international subsidiary which also came handy. One very interesting part was when they asked about my interests and I am a football freak. So I named the team I had been following and supporting for 10 years and the HR guy was very passionate about the opposite team so we bonded on that. All in all, it was a very positive and friendly experience.
Tips: Try to keep the atmosphere as friendly and positive as possible. Look pleasant and fresh. Dont try to play you interviewer. You can ask them to give you a minute or so to think if you are not very sure of the answer but dont do that with every question. Before you start answering take about 5 seconds to structure your answer in the head. When they ask you to talk about yourself dont say something thats already written on your CV. Instead, start with something that is relevant to the job profile and end it on a positive note by bringing out something positive in your personality.

Skills: Analytical Skills, Multitasking
College Name: NMIMS

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
No response

I applied via AmbitionBox and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Round 2 - Case Study 

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

Round 3 - Group Discussion 

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Interview Preparation Tips

Interview preparation tips for other job seekers - I am willing to work hard and invest ample time in the company's development, demonstrating effective time management while sincerely engaging in daily scheduled project-based research and maintaining team spirit.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Pivot Table Based questions for a Sales data set

Interview Preparation Tips

Topics to prepare for Flipkart Data Analyst interview:
  • Advanced Excel
  • Python
Interview preparation tips for other job seekers - I was asked excel and python questions only. The position for which I was interviewing needed these skills as the primary skills. The knowledge of sql was not considered really.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic Apititude Questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between WHERE and HAVING??
  • Ans. 

    WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.

    • WHERE is used with SELECT statement to filter rows based on a condition

    • HAVING is used with GROUP BY statement to filter groups based on a condition

    • WHERE is applied before data is grouped, HAVING is applied after data is grouped

    • Example: SELECT * FROM table WHERE column = 'value'

    • Example: SELECT column, COUNT(*) FROM table GROUP B

  • Answered by AI
  • Q2. Where- Row Level Filters Having-Aggregate Filters
  • Ans. 

    Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.

    • Row level filters are used to filter individual rows of data before any aggregations are performed.

    • Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

    • Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why do you wanna join Uber?
  • Q2. Best Company Ever

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL and Excel and Basic Python

Skills evaluated in this interview

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

I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Projects Worked
  • Ans. 

    I have worked on various projects involving data analysis, visualization, and interpretation.

    • Developed predictive models using machine learning algorithms

    • Performed data cleaning and preprocessing to ensure accuracy

    • Created interactive dashboards for stakeholders to easily understand insights

  • Answered by AI
  • Q2. SQL functions used in the projects
  • Ans. 

    Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.

    • COUNT: Used to count the number of rows in a table.

    • SUM: Used to calculate the sum of a column.

    • AVG: Used to calculate the average value of a column.

    • MAX: Used to find the maximum value in a column.

    • MIN: Used to find the minimum value in a column.

    • GROUP BY: Used to group rows that have the same values into summary rows.

  • Answered by AI
  • Q3. Machine learning alogriths

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic to Advanced level of SQL
  • Q2. Discussed 1 -2 Business Cases studies
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic questions based on Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL
Interview experience
1
Bad
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Portal and was interviewed in Jun 2023. There were 3 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 tips
Round 2 - Aptitude Test 

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
  • Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
  • Answered Anonymously
  • Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - Coding Test 

Some coding question about optimization algorthim

Interview Preparation Tips

Interview preparation tips for other job seekers - Leecode should be consider

Tell us how to improve this page.

Nepa Data Analyst Salary
based on 7 salaries
₹3 L/yr - ₹7.5 L/yr
27% less than the average Data Analyst Salary in India
View more details

Nepa Data Analyst Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

3.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Analyst
34 salaries
unlock blur

₹4 L/yr - ₹6.2 L/yr

Project Manager
11 salaries
unlock blur

₹5 L/yr - ₹11.1 L/yr

Senior Analyst
11 salaries
unlock blur

₹5.7 L/yr - ₹8.2 L/yr

Assistant Manager
9 salaries
unlock blur

₹6 L/yr - ₹9.5 L/yr

Assistant Officer
8 salaries
unlock blur

₹1.8 L/yr - ₹3 L/yr

Explore more salaries
Compare Nepa with

Nielsen Holdings

3.7
Compare

Kantar

3.5
Compare

GfK MODE

3.3
Compare

IQVIA

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