Upload Button Icon Add office photos
Engaged Employer

i

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

PubMatic Verified Tick

Compare button icon Compare button icon Compare
4.1

based on 108 Reviews

Filter interviews by

PubMatic Big Data Engineer Interview Questions, Process, and Tips

Updated 1 Aug 2024

PubMatic Big Data Engineer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Technical 

(5 Questions)

  • Q1. Pyspark optimizations and theoretical questions
  • Q2. Find the number of pairs which sum to target.
  • Ans. 

    Count pairs in an array that sum up to a target value.

    • Iterate through the array and store the frequency of each element in a hashmap.

    • For each element, check if the difference between the target and the element exists in the hashmap.

    • Increment the count of pairs if the difference is found in the hashmap.

  • Answered by AI
  • Q3. Binary search moderate problems of array ones increasing then decreasing
  • Ans. 

    Binary search can be used to solve moderate problems of arrays that are first increasing and then decreasing.

    • Use binary search to find the peak element in the array, which marks the transition from increasing to decreasing.

    • Divide the array into two parts based on the peak element and apply binary search on each part separately.

    • Handle edge cases such as when the array is strictly increasing or strictly decreasing.

    • Exampl

  • Answered by AI
  • Q4. System design for a web surfing utility
  • Ans. 

    Design a system for a web surfing utility

    • Use a web crawler to gather data from websites

    • Implement a search engine to retrieve relevant information

    • Utilize a recommendation system to suggest related content

    • Include user authentication and personalized settings

    • Ensure scalability and performance for handling large amounts of data

  • Answered by AI
  • Q5. Smallest subarray having given target sum
  • Ans. 

    Find the smallest subarray in an array that has a given target sum.

    • Use a sliding window approach to find the subarray with the target sum.

    • Keep track of the current sum of elements in the window and adjust the window size accordingly.

    • Start with a window of size 1 and expand it until the sum is greater than or equal to the target sum.

    • Shrink the window from the left side while updating the smallest subarray length until t

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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 Apr 2023. There were 2 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 - Technical 

(4 Questions)

  • Q1. Find second max salary of employee by department in sql
  • Ans. 

    Find second max salary of employee by department in SQL

    • Use GROUP BY clause to group employees by department

    • Use MAX() function to find the maximum salary

    • Use subquery to find the second maximum salary

  • Answered by AI
  • Q2. Find second max salary 9f employee by department using python pandas dataframe
  • Ans. 

    Find second max salary of employee by department using pandas dataframe

    • Group the dataframe by department

    • Sort the salaries in descending order

    • Select the second highest salary for each department

  • Answered by AI
  • Q3. Python code to download file from aws s3 to local using boto3
  • Ans. 

    Python code to download file from aws s3 to local using boto3

    • Install boto3 library using pip

    • Create an S3 client using boto3

    • Use the download_file method to download the file from S3 to local

  • Answered by AI
  • Q4. Write word count program in pyspark
  • Ans. 

    A program to count the number of words in a text file using PySpark.

    • Read the text file using SparkContext

    • Split the lines into words using flatMap

    • Map each word to a tuple of (word, 1)

    • Reduce by key to count the occurrences of each word

    • Save the output to a file

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn the basics of python dataframe and SQL and pyspark

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
-
Result
Not Selected

I applied via Approached by Company and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Build ETL pipeline, Airflow, Projects
  • Ans. 

    Building ETL pipelines using Airflow for data engineering projects.

    • Define data sources and destinations

    • Design data transformation processes

    • Implement ETL workflows in Airflow

    • Schedule and monitor pipeline executions

    • Handle error handling and data quality checks

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Apr 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Assignment 

Tableau intensive assignment with few questions on SQL and basic Python

Round 3 - One-on-one 

(2 Questions)

  • Q1. Discussion on submitted assignment and current job role
  • Q2. What kind of analysis have you done in your current role?
Round 4 - HR 

(1 Question)

  • Q1. Basic discussion on why I am switching from my current company and salary discussion
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Reasonging, isssues, maths, science, socila

Round 2 - HR 

(2 Questions)

  • Q1. Challanges, issues
  • Q2. Challanges2, issues

I applied via Jobkart and was interviewed before Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Lathe machine parts, Types of lamps, belt drives, bearing , Fasteners, Electric basics ( Ckt, fuse, ckt breaker etc)

Interview Preparation Tips

Interview preparation tips for other job seekers - Mainly Specifications of products

Interview Questionnaire 

1 Question

  • Q1. Mostly technical. Like questions from Hadoop , mapreduce architecture and so on . Few Unix scripting questions and SQL statements
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Asked about my academics and experience.

PubMatic Interview FAQs

How many rounds are there in PubMatic Big Data Engineer interview?
PubMatic interview process usually has 1 rounds. The most common rounds in the PubMatic interview process are Technical.
What are the top questions asked in PubMatic Big Data Engineer interview?

Some of the top questions asked at the PubMatic Big Data Engineer interview -

  1. find the number of pairs which sum to targ...read more
  2. Binary search moderate problems of array ones increasing then decreas...read more
  3. smallest subarray having given target ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Globant Interview Questions
3.9
 • 162 Interviews
Grey Orange Interview Questions
3.2
 • 36 Interviews
InMobi Interview Questions
3.6
 • 34 Interviews
Mobileum Interview Questions
3.3
 • 34 Interviews
CodeClouds Interview Questions
4.5
 • 33 Interviews
View all
PubMatic Big Data Engineer Salary
based on 4 salaries
₹4 L/yr - ₹5.2 L/yr
59% less than the average Big Data Engineer Salary in India
View more details
Softwaretest Engineer
102 salaries
unlock blur

₹3.4 L/yr - ₹5.1 L/yr

Software Engineer
83 salaries
unlock blur

₹7 L/yr - ₹27 L/yr

Senior Software Engineer
70 salaries
unlock blur

₹15.2 L/yr - ₹39.1 L/yr

Principal Software Engineer
40 salaries
unlock blur

₹19.5 L/yr - ₹51 L/yr

QA Engineer
27 salaries
unlock blur

₹3.5 L/yr - ₹4.9 L/yr

Explore more salaries
Compare PubMatic with

InMobi

3.6
Compare

Komli Media

4.0
Compare

Adcolony

5.0
Compare

Affle

3.0
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview