Upload Button Icon Add office photos
Engaged Employer

i

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

Vertoz Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Vertoz Data Engineer Interview Questions and Answers

Updated 14 Aug 2024

Vertoz Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 14 Aug 2024

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. SQL Window Functions and RANK, DENSE RANK Difference
  • Ans. 

    SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.

    • RANK function assigns a unique rank to each distinct row within a partition.

    • DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

    • Both functions are used with the OVER() clause in SQL to define the partition and order of rows.

  • Answered by AI
  • Q2. Hadoop Default Replication Factor

Interview Preparation Tips

Topics to prepare for Vertoz Data Engineer interview:
  • SQL
  • Spark
  • Hadoop
  • YARN
Interview preparation tips for other job seekers - Easy questions asked related to SQL Window Functions, Spark Repartition and Coalesce, Spark Architecture, YARN, Hadoop Replication Factor, Spark Write Modes and many such easy questions.

Salary offered is below industry standard.
Overall not a good experience.

Skills evaluated in this interview

Data Engineer Jobs at Vertoz

View all

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Technical telephonic round

Interview Preparation Tips

Round: Test
Experience: Round one
was an online technical and general aptitude and English round.
There were two sections.
First you have to complete general aptitude questions in a fix time (45 or 30 mins).
Questions in this round were very easy and basic and related to time and work,
train problems, age problems, percentage, number series questions, English and
logical reasoning questions.
In second
section there were two coding questions. You have to code them in 30 minutes.
Questions were very easy like Fibbonacci series, Matrix Multiplication,
Factorial, Vowels and consonants separating, power finding, Numbers and character
separating etc.
Tips: Attempt Both the coding question if it is possible.

Round: Technical Interview
Experience: It was an online coding round. They sent two questions for coding and then email the code to them. Questions were very easy. you have to code them in one and half hour.
Everyone coded both of the questions. (sorry I forgot the questions).

Round: Technical Interview
Experience: It was a
little tedious round. They asked concepts related to networking like IPv4,
routing, Subnet masking, Internet Layers, Network Modules. They were trying to
cover all topics. Then they ask related to software computing and their modules, Database modules and some SQL queries. There were questions related to data structures like arrays, link
lists, searching techniques and their complexities, some C and C++ concepts.
It was approximate two hours interview. You have to clear all the basics concepts of
all the subjects for clear the interview.
Tips: They will try to cover all sections you need to try be confidient and answer quickly.

Skills: Coding Skills, Problem solving efficiency, Interpersonal skills
College Name: IIT Dhanbad

I applied via Campus Placement

Interview Questionnaire 

3 Questions

  • Q1. Tell me one thing about you that's not listed on your resume
  • Ans. 

    I am an avid traveler and have visited over 20 countries

    • I love experiencing new cultures and trying new foods

    • I have backpacked through Europe and Asia

    • I have volunteered in orphanages in Cambodia and Nepal

  • Answered by AI
  • Q2. When you hear InMobi, what's the first word that comes in your head?
  • Ans. 

    Mobile advertising platform

    • Adtech

    • Mobile marketing

    • App monetization

  • Answered by AI
  • Q3. The office of InMobi technologies has 10 floors, each with 300 employees. In the morning (7-8 AM), the building sees 3000 employees entering and waiting in a queue for 3 lifts. In the morning, everyone goe...

Interview Preparation Tips

Round: Resume Shortlist
Experience: The first round was a resume shortlist, which I think was on the basis of programming and coding courses (and projects) taken along with your CGPA. Out of 10 shortlisted people, I knew 4 and all of us were 9 pointers. The rest who I didn't know turned out to be 9 pointers as well! :P
Out of 10 shortlisted people, 3 (including me) were from ECE and the rest were from CS. Even though InMobi was open for Mathematics & Computing, no person from MnC dept. was in the shortlist. (Presumably due to their CGPAs or some other criterion that I'm not in the knowledge of.)
Tips: i) High CGPA is a must (We're talking above 9, at the end of 2nd year for CS/ECE and 3rd year for MnC)
ii)Taking programming and algorithm courses and projects is important, as that must be visible in your resume.

Round: Puzzle Interview
Experience: One special thing about the interviews, you're asked not to wear any formals! That actually helps in taking the tension off of things!
It's simple logic, after that. Increase the lift's speed (taking in mind of the safety), collecting usage data, optimising the lift's floor-stoppage according to that.
As told after the interview, the interviewer is just observing how you think and approach a problem.

One odd thing was not being asked about any coding/algorithm questions even though the profile was for a software engineer.

After this question, I was asked if I had any questions to ask. I simply stated that the work environment and culture affected me as much as the profile I'm applying for. Thus, the drive and motivation of the people who work there is also very important. So I asked what are the companies' values which the employees believe in, too.
Tips: Stay confident, don't let any tension get to your head.
In the future, InMobi may start asking coding questions too in the interviews. or change the selection procedure, which will be communicated in the PPT of InMobi.
Whatever may happen, the first round should show your zeal to solve problems, your creativity in trying different approaches, and applying logic to find the best solution.

Round: HR Interview
Experience: OK! There were a lot of questions asked since the interview was more like a conversation taking place. Like in ANY conversation, keep proper eye contact, smile and be approachable for any questions. Show enthusiasm in your voice and your answers. The interviewer asked me questions about
i)My resume, and all the activities that I'd listed there. (eg: Why did you enlist in this course? Do you like coding?)
ii)Why programming, how does it interest you?
iii)Basic questions about InMobi, like 'What do you know about us after attending the PPT?' and 'Why InMobi'

Since I had done quite a lot of marketing activities, I was also asked about that. Will you do an MBA in the future? What all did you do for marketing? I had a strong background in digital marketing, and we had a little chat about mobile marketing and what's the future of mobile advertising.
Tips: Smile, for god's sake! It's a conversation about you, do all the basic things to improve the conversational experience.
Small things like greeting the interviewer, smiling, proper eye contact, and speaking properly are paramount.

Like in any HR interview, make sure you know yourself and your resume properly, so that you don't phase out in the interview when asked some 'unexpected' question. (since that's when they know thatyou might be lying/exaggerating). Hence introspect enough before sitting the interviews.

General Tips: Make sure you're able to convince yourself and the interviewers for why do you want to work in Inmobi Technolgies.

I've already shared the rest in previous sections! :)

2 people out of 10 were selected for this internship experience, so make sure you prepare well! All the best! :D

Skill Tips: I don't think that this adds on as a skill, but InMobi wants to create a huge impact on the mobile world and the mobile advertising sector.
Your knowledge about this sector in general could help you strike good conversations (at least in the HR round).
Skills: Logic, Problem Solving Abilties, Creativity, Communication Skills
Duration: 2.5
College Name: IIT Kharagpur
Motivation: I'm a gadget geek from my childhood. The mobile industry amazes me as it's been the biggest change-bringer in the modern world. InMobi as a company wants to create a huge impact in the mobile advertising space and mobile advertising! And seeing their products that they offer in this domain had me thinking that they're doing something unique and awesome!
The work culture of InMobi is just amazing, right from flexible work hours to the epic office they have in Bangalore full of awesome people working towards that one goal! Also, InMobi offers their employees opportunities to shift between various verticals if they want to. All of this (along with a good compensation ;-) ) was enough motivation for me to apply!
Funny Moments: When I was asked whether I was in the third year, I said yes, and then said, usually people think that I'm still in high school!
We had a good laugh on that one! :P

Otherwise also, the entire procedure was relaxed and fun in general.

Interview Questionnaire 

9 Questions

  • Q1. Find Maximum sub sequence sum in an array ?
  • Ans. 

    Maximum sub sequence sum in an array

    • Use Kadane's algorithm

    • Initialize max_so_far and max_ending_here to 0

    • Iterate through the array and update max_ending_here and max_so_far

    • Return max_so_far

  • Answered by AI
  • Q2. What do you understand by the endianness of the system ? How do you find out the the type of endianness ?
  • Ans. 

    Endianness refers to the byte order of a system. It determines how multi-byte data types are stored in memory.

    • Little-endian systems store the least significant byte first, while big-endian systems store the most significant byte first.

    • Endianness can affect the way data is transmitted between systems.

    • To determine the endianness of a system, you can use the byte order mark (BOM) or write a test program that checks the by...

  • Answered by AI
  • Q3. Sort an array which consists of 0's and 1's only
  • Ans. 

    Sort an array of 0's and 1's only.

    • Use two pointers, one at the beginning and one at the end of the array.

    • Swap 0's from the beginning with 1's from the end until the pointers meet.

    • Alternatively, use a counting sort algorithm to count the number of 0's and 1's and then reconstruct the array.

  • Answered by AI
  • Q4. A question on applications of minimum spanning tree, apply prim's or kruskal's algorithm
  • Q5. What do you understand by Heaps, max and min heaps ?
  • Ans. 

    Heaps are data structures used to efficiently find the maximum or minimum element in a collection.

    • Max heap: parent nodes are always greater than or equal to child nodes

    • Min heap: parent nodes are always smaller than or equal to child nodes

    • Heaps are commonly used in priority queues and sorting algorithms

    • Heap operations include insert, delete, and extract max/min

    • Example: An array [3, 8, 2, 5, 1, 4, 6] can be represented a

  • Answered by AI
  • Q6. What do you understand by hashing ? questions on application of hashing
  • Q7. Find 3 nos a,b and c in an array where a+b = c
  • Ans. 

    Find 3 numbers in an array where a+b=c.

    • Loop through the array and check for all possible combinations of a and b.

    • Use a hash table to store the values of a and b, and check if c is present in the hash table.

    • Sort the array and use two pointers to find a and b, and then check if their sum equals c.

  • Answered by AI
  • Q8. Some puzzles, as the other interviewee said, but not asked to me
  • Q9. Questions on Dynamic programming

Interview Preparation Tips

College Name: NA

Skills evaluated in this interview

I was interviewed before Jun 2016.

Interview Questionnaire 

9 Questions

  • Q1. Questions on my resume. 1. What is your CGPA? 2. Tell us about your project (3-2 project).
  • Q2.  Which coding language do you prefer and why?
  • Ans. 

    I prefer Python because of its simplicity, readability, and extensive libraries.

    • Python is known for its simplicity and readability, making it easier to write and understand code.

    • Python has a large number of libraries and frameworks that can be used to quickly develop applications.

    • Python's syntax is clean and concise, allowing for faster development and easier maintenance.

    • Python is widely used in various domains such as...

  • Answered by AI
  • Q3. Questions on my interests
  • Q4. Questions on Android ROMS
  • Q5. Salary discussions
  • Q6. Work place (location)
  • Q7. Questions on technical skills required for the post
  • Q8. Where do you lack? (And more questions to build stress)
  • Q9. Why do you want to work with Pubmatic?
  • Ans. 

    I want to work with Pubmatic because of their innovative technology solutions and strong reputation in the industry.

    • Pubmatic is known for their cutting-edge technology solutions in the digital advertising space

    • I admire Pubmatic's strong reputation and track record in the industry

    • I believe working at Pubmatic will provide me with valuable learning opportunities and career growth

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Essay on 'Today's trending topics'. My topic was, 'Smartphone boon or curse'.
Tips: Write in lay man's language. Your approach should be an engineer's point of view.
Duration: 1 hour

Round: Technical Interview
Experience: Face to Face interview with Assistant Manager.
This interview was mainly to check my communication skills and basic technical knowledge.
Tips: Try to be yourself. Improve your communication skills, as no company selects a candidate who can't present her/his views.

Round: Behavioural Interview
Experience: Face to Face interview with Manager.
(I was selected after this round because of my confidence. )
Tips: As mentioned before you must have confidence and good communication skills. Be thorough with your basics orelse you will land up in an awkward situation. :p

Round: HR Interview
Experience: This round was for discussing salary and other facilities.
Tips: Be sure about your answer for 'preferred work place'. All the best.

Skills: Coding Skills, Proficiency In English, Confidence, Communication

Interview Questionnaire 

3 Questions

  • Q1. Algorithms on arrays and strings (coding)
  • Ans. 

    Algorithms for manipulating arrays and strings in coding

    • Use sorting algorithms like quicksort and mergesort for arrays

    • Use string manipulation functions like substring and replace for strings

    • Use dynamic programming for optimizing solutions to array and string problems

  • Answered by AI
  • Q2. Distributed Database Design
  • Q3. Large scale Ad Server Design
  • Ans. 

    Designing a large scale Ad Server

    • Use distributed systems for scalability

    • Implement caching for faster ad delivery

    • Ensure high availability and fault tolerance

    • Use real-time bidding for efficient ad placement

    • Implement fraud detection mechanisms

    • Ensure compliance with privacy regulations

  • Answered by AI

Interview Preparation Tips

Round: Interview
Experience: They tested on thought-process during design problems. What problems are with the current solution I suggested and how to improve it...
Tips: Hints from interviewer are very helpful
Keep talking while you are thinking

Skills: Algorithms, Thinking Skills, Coding
College Name: IIT KHARAGPUR

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: A coding test (Students were asked to bring Laptops)
Tips: Be thorough with C/C++, networking, OS, Data structures and architecture
Duration: 90 minutes

Round: Interview
Experience: 3 rounds of interview, one hour each, all technical 
Interview Process:All the three rounds are oriented around programming. A lot of focus was given to Data structures, C/C++, OS and algorithmsThe code from previous test is shown and they expect you to fix any bugs if thereThe interviewers are quietly friendly and help if you get stuck at any pointIf you do have any related projects, anticipate some thorough questions on that
Tips: Though the interviewers are helpful, get your basics clear early on. Don't rely on them.Practice coding sessions, a lot of companies have them as a shortlisting criteria.

College Name: IIT Madras

I applied via Campus Placement and was interviewed before Jul 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

General aptitude test with math and logic related questions. there were also coding questions which were given more weightage than the other questions.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Standard linked list questions like finding the middle of a linked list, checking if the linked list is a loop etc
  • Q2. Max heap related questions.
Round 3 - One-on-one 

(1 Question)

  • Q1. This interview was mostly math related questions. for eg: prove if a number is irrational.

Interview Preparation Tips

Topics to prepare for Amagi Media Labs Software Engineer interview:
  • Data Structures
  • Maths
  • puzzles
Interview preparation tips for other job seekers - focus is on checking basic coding and problem solving skills. a separate round for testing mathematical ability was a surprise.

Interview Questionnaire 

1 Question

  • Q1. What type of products are there ?
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Leetcode easy-medium

Round 2 - Technical 

(2 Questions)

  • Q1. What is Cyber Security and information security?
  • Ans. 

    Cyber security is the practice of protecting systems, networks, and data from digital attacks.

    • Cyber security involves implementing measures to prevent unauthorized access, data breaches, and other cyber threats.

    • It includes technologies, processes, and practices designed to protect networks, devices, programs, and data from attack, damage, or unauthorized access.

    • Examples of cyber security measures include firewalls, ant...

  • Answered by AI
  • Q2. What are the types of encryption?
  • Ans. 

    Types of encryption include symmetric encryption, asymmetric encryption, and hashing.

    • Symmetric encryption: Uses the same key for both encryption and decryption, examples include AES and DES.

    • Asymmetric encryption: Uses a pair of public and private keys for encryption and decryption, examples include RSA and ECC.

    • Hashing: Converts data into a fixed-size string of bytes, examples include MD5 and SHA.

  • Answered by AI

Skills evaluated in this interview

Vertoz Interview FAQs

How many rounds are there in Vertoz Data Engineer interview?
Vertoz interview process usually has 1 rounds. The most common rounds in the Vertoz interview process are Technical.
How to prepare for Vertoz Data Engineer 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 Vertoz. The most common topics and skills that interviewers at Vertoz expect are Hive, Big Data, Python, SQL and Architecture.
What are the top questions asked in Vertoz Data Engineer interview?

Some of the top questions asked at the Vertoz Data Engineer interview -

  1. SQL Window Functions and RANK, DENSE RANK Differe...read more
  2. Hadoop Default Replication Fac...read more

Tell us how to improve this page.

Vertoz Data Engineer Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

InMobi Interview Questions
3.5
 • 35 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
PubMatic Interview Questions
3.9
 • 30 Interviews
Moris Media Interview Questions
4.5
 • 24 Interviews
Z1 Tech Interview Questions
4.0
 • 11 Interviews
Sincro Interview Questions
3.6
 • 8 Interviews
View all
Vertoz Data Engineer Salary
based on 4 salaries
₹4 L/yr - ₹11 L/yr
44% less than the average Data Engineer Salary in India
View more details

Vertoz Data Engineer Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AD Operations Specialist
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Specialist
13 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Talent Acquisition Specialist
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

System Administrator
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Vertoz with

InMobi

3.5
Compare

Komli Media

4.0
Compare

Affle

3.1
Compare

Amagi Media Labs

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