Upload Button Icon Add office photos
Engaged Employer

i

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

Porter Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Porter Data Analyst Interview Questions and Answers

Updated 1 Feb 2024

Porter Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 1 Feb 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQl questions what is rank in sql
Round 2 - Case Study 

Case study on fuel and diesel consumption

Round 3 - HR 

(1 Question)

  • Q1. Why porter and how

Data Analyst Interview Questions & Answers

user image Shivam Dubey

posted on 29 Dec 2022

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

I applied via AngelList and was interviewed in Nov 2022. 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 

It was about mathematical aptitude like weighted average, percentile, quantitative aptitude, basic you learnt before

Round 3 - HR 

(2 Questions)

  • Q1. 1. Tell me about yourself? 2. What skills you possess? 3. Any other questions you want to ask any doubt? 4. Where do you live. Can you come to work everyday? The interview was overall easy.
  • Q2. What skills do you possess that can help us improvise?

Interview Preparation Tips

Topics to prepare for Porter Data Analyst interview:
  • MySQL
  • SQL Server
  • Advanced Excel
  • Python
  • Programming
  • C++
Interview preparation tips for other job seekers - Be affirmative in your words while talking to HR. Keep smiling all along the interview.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
Q4. Sliding Window Maximum Problem Statement You are given an array/l ... read more
asked in Tredence
Q5. Find First Repeated Character in a String Given a string 'STR' co ... read more

Interview questions from similar companies

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

I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Questions from arrays and strings and some aptitude questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. How to merge 2 csv files
  • Ans. 

    To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.

    • Open both CSV files in a software like Microsoft Excel.

    • Copy the data from one CSV file and paste it into the other CSV file.

    • Save the merged CSV file with a new name.

    • Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.

  • Answered by AI
  • Q2. Basic questions on arrays
Round 3 - HR 

(1 Question)

  • Q1. 3 reasons why u choose this company
  • Ans. 

    I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.

    • Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

    • Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

    • Company culture - I value a positive work environment and the...

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Questions on python

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Interviewer asked me basic SQL questions
  • Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Round 2 - Coding Test 

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Basic Excel Questions
  • Q2. Medium and Basic SQL Questions
  • Q3. Resume based Question
  • Q4. Case Study Questions
  • Q5. Questions on Project
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL based questions wer asked on joins , rank function,

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

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

Round 1 - Technical 

(2 Questions)

  • Q1. SQL base Question
  • Q2. About your projects
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing

Round 2 - Case Study 

1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day

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

I applied via Company Website and was interviewed in Jul 2023. There were 4 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 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(5 Questions)

  • Q1. What is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.

    • It emphasizes code readability and uses indentation to define code blocks.

    • Python has a large standard library and a vibrant community of developers.

    • Example: print('Hello, World!')

    • Example: import pandas as pd

  • Answered by AI
  • Q2. What is python used for?
  • Ans. 

    Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.

    • Data analysis and visualization

    • Web development (Django, Flask)

    • Artificial intelligence and machine learning (TensorFlow, PyTorch)

    • Automation and scripting

    • Scientific computing (NumPy, SciPy)

  • Answered by AI
  • Q3. What type of language is python?
  • Ans. 

    Python is a high-level programming language known for its simplicity and readability.

    • Python is an interpreted language, meaning it does not need to be compiled before running.

    • It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.

    • Python has a large standard library and a thriving community, making it versatile and widely used.

    • Example: Python is used for web develop...

  • Answered by AI
  • Q4. What is oops in python?
  • Ans. 

    Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.

    • OOP allows for the organization of code into reusable components called classes.

    • Classes can have attributes (variables) and methods (functions) associated with them.

    • In Python, everything is an object, and classes can be defined using the 'class' keyword.

    • Encapsulation, inheritance, and polymorph

  • Answered by AI
  • Q5. What is array in python?
  • Ans. 

    An array in Python is a data structure that stores a collection of elements of the same type.

    • Arrays can store elements such as integers, floats, or strings.

    • Arrays are indexed starting from 0, with elements accessed using their index.

    • Example: arr = ['apple', 'banana', 'cherry']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Joins and basics
Round 2 - Case Study 

Netflix user churn case study,
Uber booking number reduce

Porter Interview FAQs

How many rounds are there in Porter Data Analyst interview?
Porter interview process usually has 3 rounds. The most common rounds in the Porter interview process are HR, Resume Shortlist and Aptitude Test.
How to prepare for Porter Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Porter. The most common topics and skills that interviewers at Porter expect are SQL, Advanced Excel, Analytical, Analytics and Automation.

Tell us how to improve this page.

Porter Data Analyst Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more
Porter Data Analyst Salary
based on 20 salaries
₹6.5 L/yr - ₹10 L/yr
36% more than the average Data Analyst Salary in India
View more details

Porter Data Analyst Reviews and Ratings

based on 2 reviews

5.0/5

Rating in categories

4.5

Skill development

5.0

Work-life balance

5.0

Salary

4.5

Job security

5.0

Company culture

4.5

Promotions

5.0

Work satisfaction

Explore 2 Reviews and Ratings
Business Associate
257 salaries
unlock blur

₹2.2 L/yr - ₹4.3 L/yr

Business Executive
224 salaries
unlock blur

₹1.2 L/yr - ₹3.5 L/yr

Assistant Manager
95 salaries
unlock blur

₹4.1 L/yr - ₹13.3 L/yr

Senior Business Associate
76 salaries
unlock blur

₹3.1 L/yr - ₹6.3 L/yr

Senior Manager
74 salaries
unlock blur

₹14 L/yr - ₹24 L/yr

Explore more salaries
Compare Porter with

Dunzo

3.4
Compare

Flipkart

4.0
Compare

Amazon

4.1
Compare

Snapdeal

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