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 Engineer Interview Questions and Answers

Updated 2 Sep 2022

Porter Data Engineer Interview Experiences

1 interview found

I applied via I don't remember and was interviewed in Aug 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. About experience DBMS questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't take the job if your gut says the interviewer wasn't polite during the interview.

I dint feel comfortable right from the start of the interview. The interviewer was condescending and not accepting even correct answers and claiming I failed to know basic stuff required for the role. I ended the interview in less than half the time it was scheduled for. I'm sure I don't want to work under such a person who wants to keep rejecting answers and pointing how you did not know answer to a question.

Interview is generally to understand how good the candidate is and how good the company is. After first 5 mins of the call I knew I dint want to work there. He added a team member just to tell him if there was any important thing he had to look into (like that other guy is some kind of service assistant to him).

Even after I accepted I wasn't the right fit for the role and bailed, he again pointed out how I barely knew anything that I should for the role (which is not necessary as the interview is over).

Interview questions from similar companies

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

(1 Question)

  • Q1. What is difference between dense_rank and rank function
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via campus placement at Netaji Subhas Institute of Technology (NSIT) and was interviewed before Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

It was demure and well balanced.

Round 2 - Technical 

(2 Questions)

  • Q1. Databases based on resume.
  • Q2. Sql based questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. Sql based question
  • Q2. Resume and intern experiences.

Interview Preparation Tips

Interview preparation tips for other job seekers - be thorough with resume.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(1 Question)

  • Q1. Design the generic tool or package using pyspark which allows to create connections to multiple databases like mysql, s3 or api. Fetch the result and do transformations like handling null values and then s...
  • Ans. 

    Design a generic tool in pyspark to connect to multiple databases, fetch results, handle null values, and store output in another database

    • Use pyspark to create a tool that can connect to databases like mysql, s3, or api

    • Implement functions to fetch data from the databases and perform transformations like handling null values

    • Utilize pyspark to store the transformed data in another database

    • Consider using pyspark SQL funct

  • Answered by AI

Skills evaluated in this interview

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
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was an online assessment. Some coding questions. Some cs fundamental mcqs. SQL query, Rest Api question.

Round 2 - Assignment 

An assignment to create a game using nodejs/ go lang/ java.

Round 3 - Technical 

(2 Questions)

  • Q1. Discussion related to Assignment. Told some changes and told to add some more functionalities.
  • Q2. Some APIS were given. It was case study. You had to show the dishes to a customer according to his preferences.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Questions were crayon box ,the bot and the game and happy neighbourhood for 90 mins

Round 2 - Technical 

(2 Questions)

  • Q1. Array basics was asked
  • Q2. Segment tree,prefix sum
Round 3 - Technical 

(1 Question)

  • Q1. Low level design was asked
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Create pagination component using an api show the data for the pages
  • Ans. 

    Create a pagination component using an API to display data for different pages.

    • Use API to fetch data for each page

    • Implement pagination logic to display data for each page

    • Allow users to navigate between pages

  • Answered by AI

Skills evaluated in this interview

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
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Oct 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 

So after Resume shortlisting you have Round 1 as Programming Test (60%) & Aptitude Test (40%) in which you will be asked 15 aptitude questions and 2 DSA problems. You will get 1 hour to write the test.
DSA problems:
1. Merge 2 sorted arrays
2. find the target sum in given array and return their indexes

Round 3 - One-on-one 

(3 Questions)

  • Q1. If you clear Round 1 then you will go forward to Round 2 which is one-to-one technical round. In this round you will be asked leetcode problems and some conceptual questions. I was asked to Find the Max su...
  • Q2. Length of Longest Substring with distinct character
  • Ans. 

    Find the length of the longest substring with distinct characters in a given string.

    • Use a sliding window approach to keep track of the current substring.

    • Maintain a set to store the distinct characters in the current substring.

    • Update the maximum length of the substring whenever a longer substring is found.

  • Answered by AI
  • Q3. Find Max sum of subarray.
  • Ans. 

    The maximum sum of a subarray is to be found.

    • Use Kadane's algorithm to find the maximum sum of a subarray.

    • Initialize two variables: maxSum and currentSum.

    • Iterate through the array and update currentSum by adding the current element.

    • If currentSum becomes negative, reset it to 0.

    • If currentSum is greater than maxSum, update maxSum.

    • Return maxSum as the maximum sum of a subarray.

  • Answered by AI
Round 4 - One-on-one 

(2 Questions)

  • Q1. Last round was Head of engineering round in this you will be asked some technical questions like: Apply Merge sort on a Linked List
  • Q2. 25 Horses: Google interview problem

Interview Preparation Tips

Topics to prepare for Moglix Software Engineer interview:
  • Leetcode easy&medium
  • Aptitude
  • Famous interview Problems
Interview preparation tips for other job seekers - Prepare your aptitude well as most of the candidates got rejected in the aptitude round.
Don't show your nervousness.
Read Problem statements, Understand it and then approach to solve it.
Practice, market scenario is though right now.
Lastly, have faith in yourself that you would do you best.

Skills evaluated in this interview

Porter Interview FAQs

How many rounds are there in Porter Data Engineer interview?
Porter interview process usually has 1 rounds. The most common rounds in the Porter interview process are Technical.

Tell us how to improve this page.

Porter Data Engineer Salary
based on 4 salaries
₹18 L/yr - ₹25 L/yr
92% more than the average Data Engineer Salary in India
View more details
Business Associate
258 salaries
unlock blur

₹2.2 L/yr - ₹4.3 L/yr

Business Executive
223 salaries
unlock blur

₹1.9 L/yr - ₹3.5 L/yr

Assistant Manager
96 salaries
unlock blur

₹4 L/yr - ₹13.3 L/yr

Senior Business Associate
78 salaries
unlock blur

₹3.1 L/yr - ₹6.3 L/yr

Senior Manager
73 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