Premium Employer

i

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

PolicyBazaar Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

PolicyBazaar Senior Database Developer Interview Questions, Process, and Tips

Updated 25 Jan 2022

Top PolicyBazaar Senior Database Developer Interview Questions and Answers

  • Q1. Can you discuss the numeric data types available in SQL Server?
  • Q2. What is the difference between Merge and Union All transformations in SQL?
  • Q3. What is the difference between the Snowflake schema and the Star schema in data warehousing?
View all 17 questions

PolicyBazaar Senior Database Developer Interview Experiences

2 interviews found

I appeared for an interview in Mar 2021.

Round 1 - Video Call 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions based on DBMS and SQL

  • Q1. What is indexing in the context of databases?
  • Ans. 

    Indexing in databases is a technique used to improve the speed of data retrieval by creating a data structure that allows for quick lookups.

    • Indexes are created on columns in a database table to speed up the retrieval of data.

    • They work similar to the index in a book, allowing the database to quickly find the rows that match a certain value.

    • Examples of indexes include primary keys, unique keys, and composite indexes.

    • With...

  • Answered by AI
  • Q2. Can you discuss the numeric data types available in SQL Server?
  • Ans. 

    SQL Server offers various numeric data types for storing different types of numerical values.

    • SQL Server provides data types like int, bigint, smallint, tinyint for storing whole numbers.

    • Numeric data types like decimal and numeric are used for storing fixed-point numbers.

    • Float and real data types are used for storing floating-point numbers with different precision levels.

    • Money and smallmoney data types are used for stor

  • Answered by AI
Round 2 - Video Call 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Medium

Technical round with questions based on DBMS and SSIS.

  • Q1. What is normalization in the context of database management systems?
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalization involves breaking down data into smaller, more manageable tables

    • It helps in reducing data redundancy by storing data in a structured manner

    • Normalization ensures data integrity by minimizing anomalies such as update, insert, and delete anomalies

    • There are different normal forms like 1NF, 2NF, 3NF, a

  • Answered by AI
  • Q2. Can you explain the concept of Containers in SSIS?
  • Ans. 

    Containers in SSIS are logical grouping of tasks and components that help in organizing and managing workflows.

    • Containers help in organizing and managing workflows in SSIS packages

    • They can be used to group related tasks together for better readability and maintenance

    • Examples of containers in SSIS include Sequence Container, For Loop Container, and Foreach Loop Container

  • Answered by AI
  • Q3. What are the different row transformations in SSIS?
  • Ans. 

    Different row transformations in SSIS include Conditional Split, Derived Column, Lookup, and Merge.

    • Conditional Split: Routes data rows to different outputs based on specified conditions.

    • Derived Column: Adds new columns or modifies existing columns using expressions.

    • Lookup: Retrieves data from a related table based on a specified key.

    • Merge: Combines data from multiple sources into a single dataset.

  • Answered by AI
  • Q4. What are event handlers in SSIS?
  • Ans. 

    Event handlers in SSIS are workflows that are triggered by specific events during the execution of a package.

    • Event handlers can be used to perform additional tasks or actions based on the success or failure of specific tasks within a package.

    • Common events that can trigger event handlers include OnError, OnPreExecute, OnPostExecute, OnWarning, etc.

    • Event handlers can be configured to send emails, log information, execute...

  • Answered by AI
Round 3 - Video Call 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions based on Data warehousing and SSIS.

  • Q1. What is the difference between the Snowflake schema and the Star schema in data warehousing?
  • Ans. 

    Snowflake schema has normalized dimension tables while Star schema has denormalized dimension tables.

    • Snowflake schema has a centralized fact table connected to multiple dimension tables normalized into sub-dimension tables.

    • Star schema has a denormalized structure with dimension tables directly connected to the fact table.

    • Snowflake schema requires more joins for querying data compared to Star schema.

    • Star schema is easie...

  • Answered by AI
  • Q2. What is the difference between Merge and Union All transformations in SQL?
  • Ans. 

    Merge combines two result sets into one, while Union All combines and includes duplicates.

    • Merge is used to combine two result sets into one, eliminating duplicates.

    • Union All is used to combine two result sets into one, including duplicates.

    • Merge requires the result sets to have the same number of columns and compatible data types.

    • Union All does not require the result sets to have the same number of columns or data type

  • Answered by AI
Round 4 - HR 

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from Delhi Technological University. Eligibility criteriaAbove 7 CGPAPolicyBazaar.com interview preparation:Topics to prepare for the interview - Database, SSIS, Algorithms, System Design, Operating SystemsTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Mar 2021. There were 6 interview rounds.

Interview Questionnaire 

10 Questions

  • Q1. 1. What is indexing. some practical questions based on indexing?
  • Q2. 2. What is Bookmarking, Row id, Key Index, covering index?
  • Ans. 

    Explanation of database terms: Bookmarking, Row id, Key Index, covering index.

    • Bookmarking is a feature that allows users to save the location of a record in a database for future reference.

    • Row id is a unique identifier assigned to each row in a table.

    • Key Index is an index created on a column or set of columns that uniquely identifies each row in a table.

    • Covering index is an index that contains all the columns required ...

  • Answered by AI
  • Q3. 3.Details of all types of Data Types
  • Ans. 

    Data types are classifications of data items that determine the nature of operations that can be performed on them.

    • Numeric data types: int, float, double, decimal

    • Character and string data types: char, varchar, text

    • Date and time data types: date, time, datetime

    • Boolean data type: bool

    • Binary data types: binary, varbinary, image

  • Answered by AI
  • Q4. 4. What is Normalization
  • Ans. 

    Normalization is the process of organizing data in a database to reduce redundancy and dependency.

    • It involves breaking down a table into smaller tables and defining relationships between them.

    • Normalization helps to eliminate data inconsistencies and anomalies.

    • There are different levels of normalization, with each level having specific rules to follow.

    • For example, first normal form (1NF) requires that each column in a t...

  • Answered by AI
  • Q5. 5.Containers in SSIS
  • Ans. 

    Containers in SSIS are logical groupings of tasks and containers that define the workflow of an SSIS package.

    • Containers can be used to group related tasks together and provide a clear visual representation of the package workflow.

    • There are several types of containers in SSIS, including Sequence Containers, For Loop Containers, and Foreach Loop Containers.

    • Sequence Containers are used to group tasks together and define t...

  • Answered by AI
  • Q6. 6.Types of Transformations in SSIS?
  • Ans. 

    Transformations in SSIS are used to modify data during ETL process.

    • Data Conversion Transformation

    • Conditional Split Transformation

    • Aggregate Transformation

    • Sort Transformation

    • Merge Transformation

    • Lookup Transformation

    • Derived Column Transformation

    • Multicast Transformation

    • Union All Transformation

    • Pivot Transformation

    • Unpivot Transformation

  • Answered by AI
  • Q7. 7.Event Handling and Error Handling in SSIS?
  • Ans. 

    Event and error handling are crucial in SSIS to ensure smooth execution and proper handling of exceptions.

    • Event handling involves capturing and responding to events that occur during package execution.

    • Error handling involves identifying and handling errors that occur during package execution.

    • SSIS provides various built-in event handlers and error handlers, such as OnError, OnTaskFailed, OnPostExecute, etc.

    • Custom event ...

  • Answered by AI
  • Q8. 8.Star Flake and Snow Flake Schema which one's performance is better?
  • Ans. 

    Snow Flake Schema has better performance than Star Flake Schema.

    • Snow Flake Schema has normalized tables which reduces data redundancy and improves query performance.

    • Star Flake Schema has denormalized tables which can lead to data redundancy and slower query performance.

    • Snow Flake Schema is better suited for complex queries with multiple joins.

    • Star Flake Schema is better suited for simple queries with fewer joins.

    • Perfor...

  • Answered by AI
  • Q9. 9.What is Temp Variables, Temp Tables, CTE
  • Ans. 

    Temp variables, tables, and CTE are used in SQL to store temporary data during query execution.

    • Temp variables are used to store temporary data within a query.

    • Temp tables are used to store temporary data that can be accessed by multiple queries.

    • CTE (Common Table Expression) is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

    • Temp variables and tables are created using th...

  • Answered by AI
  • Q10. 10. Difference between merge and union?
  • Ans. 

    Merge combines two tables based on a specified condition, while union combines two tables with the same structure.

    • Merge is used to update or insert data into a target table based on a join condition with a source table.

    • Union is used to combine the results of two SELECT statements into a single result set.

    • Merge requires a join condition and can perform insert, update, and delete operations.

    • Union requires that both table...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Look Good. Be Confident, Always wear a watch during Interview. Try to make eye contact even you can't see interviewer on screen

Skills evaluated in this interview

Senior Database Developer Interview Questions Asked at Other Companies

Q1. Can you discuss the numeric data types available in SQL Server?
Q2. What is the difference between Merge and Union All transformation ... read more
Q3. What is the difference between the Snowflake schema and the Star ... read more
Q4. 8.Star Flake and Snow Flake Schema which one's performance is bet ... read more
Q5. What is indexing in the context of databases?

Interview questions from similar companies

I appeared for an interview before Jan 2021.

Round 1 - Video Call 

(2 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

The round was held on Google Meet and I was given 2 coding problems for which first I had to explain my approach and then I had to write code in Shared Google Docs and dry run on sample test cases and discuss Time and Space Complexity.

  • Q1. 

    Validate BST Problem Statement

    Given a binary tree with N nodes, determine whether the tree is a Binary Search Tree (BST). If it is a BST, return true; otherwise, return false.

    A binary search tree (BST)...

  • Ans. 

    Validate if a given binary tree is a Binary Search Tree (BST) or not.

    • Check if the left subtree of a node contains only nodes with data less than the node's data.

    • Check if the right subtree of a node contains only nodes with data greater than the node's data.

    • Recursively check if both left and right subtrees are also binary search trees.

  • Answered by AI
  • Q2. 

    Maximum Sum Path from Leaf to Root

    Given a binary tree with 'N' nodes, identify the path from a leaf node to the root node that has the maximum sum among all root-to-leaf paths.

    Example:

    All the possibl...

  • Ans. 

    Find the path from a leaf node to the root node with the maximum sum in a binary tree.

    • Traverse the binary tree from leaf to root while keeping track of the sum of each path.

    • Compare the sums of all paths and return the path with the maximum sum.

    • Use recursion to traverse the tree efficiently and keep updating the maximum sum path.

  • Answered by AI
Round 2 - Video Call 

(3 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This was also a Data Structures and Algorithms round where I was asked to solve 2 coding problems explaining my approach with proper Complexity Analysis . After the coding questions were over there was some time left so the interviewer asked me some concepts related to DBMS.

  • Q1. 

    Next Permutation Problem Statement

    You are given a permutation of 'N' integers. A sequence of 'N' integers is considered a permutation if it includes all integers from 1 to 'N' exactly once. Your task is ...

  • Ans. 

    The task is to rearrange a given permutation of 'N' integers to form the lexicographically next greater permutation.

    • Iterate from right to left to find the first element that is smaller than the element to its right.

    • Swap this element with the smallest element to its right that is greater than it.

    • Reverse the elements to the right of the swapped element to get the lexicographically next greater permutation.

  • Answered by AI
  • Q2. 

    Largest BST Subtree Problem Statement

    You are given a binary tree with 'N' nodes. Your task is to determine the size of the largest subtree within the binary tree which is also a Binary Search Tree (BST).

    ...
  • Ans. 

    Find the size of the largest subtree in a binary tree that is also a Binary Search Tree.

    • Traverse the tree in a bottom-up manner to check if each subtree is a BST.

    • Keep track of the size of the largest BST subtree encountered so far.

    • Use recursion to solve this problem efficiently.

    • Example: For the input 1 2 3 4 -1 5 6 -1 7 -1 -1 -1 -1 -1 -1, the largest BST subtree has a size of 3.

  • Answered by AI
  • Q3. Can you explain indexing in databases?
  • Ans. 

    Indexing in databases is a technique used to improve the speed of data retrieval by creating a data structure that allows for quick lookups.

    • Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

    • Types of indexes include B-tree, hash, and bitmap indexes.

    • Indexes can improve the performance of SELECT queries but may slow down INSERT, UPDATE, and DELETE operation...

  • Answered by AI
Round 3 - Video Call 

(2 Questions)

Round duration - 50 Minutes
Round difficulty - Medium

This round also had 2 questions related to DS and Algo . One was from graphs and the other was an implementation of a LRU Cache . There were 2 interviewers and both of them were quite friendly and helpful. Overall, this round went well.

  • Q1. 

    Detect Cycle in a Directed Graph

    You are provided with a directed graph composed of 'N' nodes. You have a matrix called 'EDGES' with dimensions M x 2, which specifies the 'M' edges in the graph. Each edge...

  • Ans. 

    Detect cycle in a directed graph using depth-first search (DFS) algorithm.

    • Use DFS to traverse the graph and detect back edges (edges that point to an ancestor node).

    • Maintain a visited array to keep track of visited nodes and a recursion stack to keep track of nodes in the current path.

    • If a back edge is found during traversal, a cycle exists in the graph.

    • Return true if a cycle is detected, false otherwise.

  • Answered by AI
  • Q2. 

    LRU Cache Design Question

    Design a data structure for a Least Recently Used (LRU) cache that supports the following operations:

    1. get(key) - Return the value of the key if it exists in the cache; otherw...

  • Ans. 

    Design a Least Recently Used (LRU) cache data structure that supports get and put operations with capacity constraint.

    • Use a combination of hashmap and doubly linked list to efficiently implement the LRU cache.

    • Keep track of the least recently used item and update it accordingly when inserting new items.

    • Ensure to handle the capacity constraint by evicting the least recently used item when the cache is full.

    • Implement get(...

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAFlipkart interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 MonthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Basic on on SQL,
  • Q2. Unix server Comands

I appeared for an interview before Dec 2020.

Round 1 - Face to Face 

(2 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This round was purely based on Data Structures and Algorithms . One has to be fairly comfortable in solving Algorithmic problems to pass this round . Both the questions asked were quite common and luckily I had already prepared them from CodeStudio and LeetCode.

  • Q1. 

    Binary Tree Traversals Problem Statement

    Given a Binary Tree with 'N' nodes, where each node holds an integer value, your task is to compute the In-Order, Pre-Order, and Post-Order traversals of the binar...

  • Ans. 

    Compute the In-Order, Pre-Order, and Post-Order traversals of a Binary Tree given in level-order format.

    • Implement functions to perform In-Order, Pre-Order, and Post-Order traversals of a Binary Tree.

    • Use level-order input to construct the Binary Tree.

    • Traverse the Binary Tree recursively to generate the required traversals.

    • Ensure proper handling of null nodes represented by -1 in the input.

    • Return the three traversals as

  • Answered by AI
  • Q2. 

    Reverse Linked List Problem Statement

    Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.

    Input:

    The first line of input is an intege...
  • Ans. 

    Reverse a singly linked list by altering the links between nodes.

    • Iterate through the linked list and reverse the links between nodes

    • Use three pointers to keep track of the current, previous, and next nodes

    • Update the links between nodes to reverse the list

    • Return the head of the reversed linked list

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 45 Minutes
Round difficulty - Medium

This round basically tested some concepts from Data Structures and File Manipulation .

  • Q1. 

    Intersection of Two Arrays Problem Statement

    Given two arrays A and B with sizes N and M respectively, both sorted in non-decreasing order, determine their intersection.

    The intersection of two arrays in...

  • Ans. 

    The problem involves finding the intersection of two sorted arrays efficiently.

    • Use two pointers to iterate through both arrays simultaneously.

    • Compare elements at the pointers and move the pointers accordingly.

    • Handle cases where elements are equal and update the intersection array.

    • Return the intersection array as the result.

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPABig Basket interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, Operating Systems, Aptitude, OOPSTime required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I appeared for an interview before Jan 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Two coding questions were given in the first round to be solved in 60 minutes.

  • Q1. 

    Rearrange Array Elements Problem Statement

    Given an array A containing 'N' integers and an integer m, rearrange the elements of the array such that the differences between the array elements and m are sor...

  • Ans. 

    Rearrange array elements based on their differences from a given integer.

    • Calculate the differences between each element and the given integer.

    • Sort the elements based on their differences while maintaining the original order for elements with the same difference.

    • Implement a function to rearrange the array elements as per the given criteria.

  • Answered by AI
  • Q2. 

    Print Nodes at Distance K from a Given Node

    Given an arbitrary binary tree, a node of the tree, and an integer 'K', find all nodes that are at a distance K from the specified node, and return a list of th...

  • Ans. 

    The task is to find all nodes in a binary tree that are at a distance K from a given node.

    • Traverse the binary tree to find the given node

    • From the given node, perform a depth-first search to find all nodes at distance K

    • Use a list to store the values of the nodes at distance K

    • Return the list of values in any order

  • Answered by AI
Round 2 - Face to Face 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Easy

This was a technical round with questions based on DSA, DBMS, Computer Networking and project based questions.

  • Q1. 

    Triangle of Numbers Pattern

    Ninja is tasked with printing a triangle pattern based on a given number 'N' for any test case.

    Example:

    Input:
    N = 4
    Output:
       1
    232
    34545
    4567654

    Explanation:

    The pat...

  • Ans. 

    Print a triangle pattern of numbers based on a given number 'N'.

    • Iterate through each row and print the numbers accordingly

    • Use spaces to center-align the numbers in each row

    • Increment the numbers in each row as per the pattern

  • Answered by AI
  • Q2. What is the difference between a web server and an application server?
  • Ans. 

    Web server serves static content over HTTP, while application server runs dynamic content and business logic.

    • Web server handles HTTP requests and responses, serving static content like HTML, images, and CSS.

    • Application server executes business logic, runs dynamic content, and interacts with databases.

    • Web server examples include Apache, Nginx, while application server examples include Tomcat, JBoss.

    • Web server focuses on...

  • Answered by AI
  • Q3. How does the internet work?
  • Ans. 

    The internet is a global network of interconnected computers that communicate using standardized protocols.

    • The internet is made up of a vast number of interconnected networks of computers.

    • Data is transmitted over the internet using protocols such as TCP/IP.

    • Websites are hosted on servers connected to the internet, and users access them using web browsers.

    • Internet Service Providers (ISPs) provide access to the internet f...

  • Answered by AI
  • Q4. Write a SQL query to find the nth highest salary.
  • Ans. 

    SQL query to find the nth highest salary

    • Use the 'SELECT DISTINCT' statement to get unique salary values

    • Order the salaries in descending order using 'ORDER BY' clause

    • Use 'LIMIT' and 'OFFSET' to get the nth highest salary

  • Answered by AI
Round 3 - HR 

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Interview Preparation Tips

Professional and academic backgroundI completed Information Technology from Chitkara University. Eligibility criteriaAbove 7 CGPAInfo Edge India (Naukri.com) interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement

Interview Preparation Tips

Round: Resume Shortlist
Experience: They selected 10 students from our college from CS and IT .They are looking for guys with extra projects done during college .App development will be a bonus ,contribution to open source and competitive programming will help for shortlisting.
Some of my friends had research papers published and they too got selected.

Round: Test
Experience: Have to write code snippet for 4 questions in 45 minutes
1.Difference between hour hand and minute hand
2.longest palindromic sub string.
3.Product Array puzzle
4.Some question related to matrix

Tips: All question were from geeksforgeeks
So practice it well ..u will make through it

Round: Test
Experience: Long Discussion on projects
They will scan each and every line of your Resume ,so dont write bullshits..
I wrote about interest in AI and got screwed..Discussion on college projects and final year project.
Then asked me to design a snake and ladder game OOPS concepts
Told me to find sum of all elements of sub matrix..(hint pre-processing the matrix)
Asked me about sessions and cookies
Gave a query to write on database indexing (dont remember exactly)
Asked me the code of the difference between hour hand and minute hand and extended it wid the second hand
Asked me as how to implement a dictionary
asked about TRIES ,CODE SNIPPET ON THE SHARED DOCS
One of my friend was asked to implement (set) of STL
Tips: The interviewer was cool guy..helped me a lot always made me comfortable.Interact with them as much as possible

Round: Test
Experience: Wid the CTO of the company .
Started wid the projects again .ACID properties,Database transactions,Concurrency Control
Optimization in database.
Then he asked me to code a function
Given a hash function applied on letters of English words ,un-hash it.Took me 45 minutes to reach the solution ,he helped me a lot.
Asked me to write the code for diameter of a binary tree
Asked me write the code for Boolean Matrix
One of my friend was asked to a question in which there was a bug in a m*n matrix and we have to find the bug(hint dfs or bfs)
Tips: keep calm ,,just keep talking ad he will help u a lot...

Round: HR
Experience: This was the toughest round for me...I had cleared all the rounds but they rejected me in the HR round ,,,dont know where I screwed..Learn every thing of Zomato..
They offered me an internship and thereafter they would look to give a PPO ...!!!lets see what happens

Skills: Coding Skills And Knowledge On Data Structures
Duration: 3
College Name: NIT Srinagar

Interview Questionnaire 

9 Questions

  • Q1. Write a regex for email validation?
  • Ans. 

    Regex for email validation

    • Start with a string of characters followed by @ symbol

    • Followed by a string of characters and a period

    • End with a string of characters with a length of 2-6 characters

    • Allow for optional subdomains separated by periods

    • Disallow special characters except for . and _ in username

  • Answered by AI
  • Q2. Parse the XML? and store the output in JSON. Discussed different approaches?
  • Q3. Print prime numbers in a given range and optimize the solution?
  • Ans. 

    Print prime numbers in a given range and optimize the solution.

    • Use Sieve of Eratosthenes algorithm to generate prime numbers efficiently

    • Start with a boolean array of size n+1, mark all as true

    • Loop through the array and mark all multiples of each prime as false

    • Print all the indexes that are still marked as true

  • Answered by AI
  • Q4. Puzzle – 25 horses – 5 lanes, find fastest 3 horses?
  • Q5. Web related questions on Sessions and cookies?
  • Q6. A lot of discussion on my resume, experience etc
  • Q7. Find angle between hour hand and minute hand in clock if time is given? Write a program or pseudo code?
  • Ans. 

    Find angle between hour and minute hand in a clock given the time.

    • Calculate the angle made by the hour hand with respect to 12 o'clock position

    • Calculate the angle made by the minute hand with respect to 12 o'clock position

    • Find the difference between the two angles and take the absolute value

    • If the angle is greater than 180 degrees, subtract it from 360 degrees to get the smaller angle

  • Answered by AI
  • Q8. A hash function was written to convert a string into a hash. Write a un-hash function to revert it(from hash to string)?
  • Ans. 

    To un-hash a string, use a reverse algorithm to convert the hash back to the original string.

    • Create a reverse algorithm that takes the hash as input and outputs the original string

    • Use the same logic as the hash function but in reverse order

    • If the hash function used a specific algorithm, use the inverse of that algorithm to un-hash the string

  • Answered by AI
  • Q9. He discussed about expectations and role. Asked me if I have any questions. He said to me “yaha aana hai to marwani padegi. tyar ho”? I smiled and asked what are the work timings? He said 9-9 and I was kin...

Interview Preparation Tips

General Tips: I applied through a recruiter. Then I got a call from Zomato HR. It was for LAMP developer profile. She asked me about my profile and also shared some expectations from the role. She asked me to come for F2F rounds to take the process further
Skills: Web development, JSON, Algorithm
College Name: na
Motivation: Overall process was not very tough. But they have start up culture. People work their for 11-12 hours a day. Sometimes on Saturday as well. So people who are geeks or have nothing in life to do except their job can go and join

Skills evaluated in this interview

Interview Questionnaire 

6 Questions

  • Q1. Given a Linked list , print yes if it is palindrome else print no
  • Q2. Print the level order traversal of the binary tree in the spiral form
  • Ans. 

    Print the level order traversal of binary tree in spiral form

    • Perform level order traversal of the binary tree

    • Alternate the direction of traversal for each level

    • Use a stack to reverse the order of nodes in each level

    • Print the nodes in the order of traversal

  • Answered by AI
  • Q3. Maximum of all subarrays of size k(Expected Time Complexity O(N). Input : arr[] = {1, 2, 3, 1, 4, 5, 2, 3, 6} k = 3 Output : 3 3 4 5 5 5 6
  • Ans. 

    Find the maximum element in each subarray of size k in a given array.

    • Iterate through the array from index 0 to n-k.

    • For each subarray of size k, find the maximum element.

    • Store the maximum elements in a separate array.

    • Return the array of maximum elements.

  • Answered by AI
  • Q4. Given Two sorted array of size size n each. Find the Kth largest element in these two array (Expected Time Complexity Log(n))
  • Ans. 

    To find the Kth largest element in two sorted arrays, we can use the merge step of merge sort algorithm.

    • Merge the two arrays into a single sorted array using a modified merge sort algorithm.

    • Return the Kth element from the merged array.

  • Answered by AI
  • Q5. Website having several web-pages. And also there are lot many user who are accessing the web-site. say user 1 has access pattern : x->y->z->a->b->c->d->e->f user 2 has access pattern : z->a->b->c->d user 3...
  • Q6. Given two array , one of size m+n and contains m element and other position are empty , 2nd array is of size n and contains n element. both array are sorted , now merge the second array to first one such t...
  • Ans. 

    Merge two sorted arrays into one sorted array with expected time complexity of (m+n).

    • Use a two-pointer approach to compare elements from both arrays and merge them into the first array.

    • Start comparing elements from the end of both arrays and place the larger element at the end of the first array.

    • Continue this process until all elements from the second array are merged into the first array.

  • Answered by AI

Interview Preparation Tips

Round: Test
Duration: 90 minutes

Skills: Algorithm , OS, DBMS, data structure
College Name: NIT BHOPAL

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: Coding questions were comparatively easy. There were three questions.1. Given a string map each character of which to the corresponding digit in a 10 digit mobile phone keypad.2. Don't remember, will add when it comes to my mind.3. Don't remember, will add when it comes to my mind.

Skills: Coding ability, Complete knowledge of working of internet.,
College Name: IIT Bombay

PolicyBazaar Interview FAQs

What are the top questions asked in PolicyBazaar Senior Database Developer interview?

Some of the top questions asked at the PolicyBazaar Senior Database Developer interview -

  1. 8.Star Flake and Snow Flake Schema which one's performance is bett...read more
  2. 2. What is Bookmarking, Row id, Key Index, covering ind...read more
  3. 9.What is Temp Variables, Temp Tables, ...read more

Tell us how to improve this page.

Join PolicyBazaar Let's find you the Best Insurance

Interview Questions from Similar Companies

Amazon Interview Questions
4.0
 • 5.1k Interviews
Flipkart Interview Questions
3.9
 • 1.4k Interviews
BigBasket Interview Questions
3.9
 • 362 Interviews
JustDial Interview Questions
3.5
 • 330 Interviews
Info Edge Interview Questions
3.9
 • 323 Interviews
Zomato Interview Questions
3.7
 • 312 Interviews
Naukri Interview Questions
4.0
 • 187 Interviews
Uber Interview Questions
4.2
 • 149 Interviews
MakeMyTrip Interview Questions
3.7
 • 123 Interviews
View all

PolicyBazaar Senior Database Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Sales Executive
1.2k salaries
unlock blur

₹1.6 L/yr - ₹5 L/yr

Associate Sales Consultant
1.1k salaries
unlock blur

₹1.8 L/yr - ₹6 L/yr

Relationship Manager
897 salaries
unlock blur

₹2.2 L/yr - ₹6 L/yr

Sales Associate
384 salaries
unlock blur

₹1.8 L/yr - ₹5.2 L/yr

Team Lead
378 salaries
unlock blur

₹3.1 L/yr - ₹12.2 L/yr

Explore more salaries
Compare PolicyBazaar with

Amazon

4.0
Compare

Flipkart

3.9
Compare

Indiamart Intermesh

3.6
Compare

BigBasket

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