Filter interviews by
I applied via Referral and was interviewed before Jan 2023. There were 4 interview rounds.
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop.
It allows users to write complex queries without needing to know Java or MapReduce.
Hive organizes data into tables, partitions, and buckets for efficient querying and analysis.
It supports custom MapReduce scri...
A Database Management System (DBMS) is a software that allows users to create, retrieve, update, and manage data in a database.
DBMS helps in organizing and structuring data efficiently
It provides tools for data manipulation, querying, and security
Examples include MySQL, Oracle, SQL Server
A primary key is a unique identifier for each record in a database table.
A primary key must contain unique values for each record in the table.
It cannot contain null values.
It can consist of one or multiple columns.
Example: In a table of students, the student ID can be a primary key.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
A temporary table is a table that is created and exists only for the duration of a database session.
Temporary tables are typically used to store intermediate results during a complex query or to isolate data for a specific task.
They are automatically dropped when the session ends or when the table is explicitly dropped.
Temporary tables are often prefixed with a '#' or '##' to differentiate them from permanent tables.
A trigger function in SQL is a stored procedure that is automatically executed in response to certain events on a particular table.
Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
They are useful for enforcing business rules, auditing changes, and maintaining data integrity.
Example: CREATE TRIGGER audit_trigger AFTER INSERT ON employees FOR EACH ROW EXECUTE PROCEDURE audit_
SQL query for XYZ scenario
Use SELECT statement to retrieve data from the table
Use WHERE clause to filter data based on the XYZ scenario
Consider using JOIN if data from multiple tables is needed
Top trending discussions
I applied via Walk-in and was interviewed in Apr 2021. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.
I appeared for an interview before Dec 2020.
Round duration - 90 Minutes
Round difficulty - Medium
2 coding questions and 20 mcq
You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:
Find the minimum time required to rot all fresh oranges in a grid.
Use Breadth First Search (BFS) to simulate the rotting process.
Track the time taken to rot all oranges and return -1 if any fresh oranges remain.
Handle edge cases like no fresh oranges or all oranges already rotten.
Consider using a queue to efficiently process adjacent oranges.
Ensure to update the grid with the new state of oranges after each second.
Given a natural number N
, return the sum of all its proper divisors.
A proper divisor of Y
is defined as a number X
such that X < Y
and Y % X = 0
.
T...
Calculate the sum of proper divisors of a given natural number.
Iterate from 1 to sqrt(N) and check for divisors
If a divisor is found, add it to the sum and also add N/divisor if it is not the same as divisor
Return the sum as the result
Round duration - 45 Minutes
Round difficulty - Medium
Technical interview
Given an array ARR
consisting of non-negative integers, rearrange the numbers to form the largest possible number. The digits within each number cannot be changed.
Rearrange the array elements to form the largest possible number by concatenating them.
Sort the array elements in a custom comparator function to get the largest number.
Convert the sorted array elements to strings and concatenate them to form the final number.
Handle cases where the numbers have the same prefix by comparing the concatenated forms.
Tip 1 : Be clear about whatever you have mentioned in resume, don't mention buzz words, because interviewer can go in depth
Tip 2 : Along with DS and Algo, if you have 3-4 months experience or internship experience, then be ready to answer scenario based technical questions like scaling the application that you developed and design concepts that can be used for improving
Tip 3 : Last but most important tip is to be calm through out the whole process ,don't loose hope if any round didn't go well ,if you have explained your thought process there is still chance to procees to next round so keep preparating for next rounds.
Tip 1 : Keep it one page resume and mention keywords which align with your technical and personal competencies.
Tip 2 : Mention 3-4 projects in the order that , project which you can explain best should be at top,then the next, and so on.
I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.
Round 1 is quit easy , only verbal ability is little bit difficult. So anyone can easy to qualify round.
I applied via Referral and was interviewed in Dec 2020. There were 3 interview rounds.
I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.
based on 2 interviews
Interview experience
based on 7 reviews
Rating in categories
Data Analyst
12
salaries
| ₹3.5 L/yr - ₹7 L/yr |
Market Research Manager
4
salaries
| ₹15 L/yr - ₹31.5 L/yr |
Senior Data Analyst
3
salaries
| ₹5 L/yr - ₹9 L/yr |
Senior Quality Analyst
3
salaries
| ₹6 L/yr - ₹16 L/yr |
Devops Engineer
3
salaries
| ₹44 L/yr - ₹55 L/yr |
TCS
Accenture
Wipro
Cognizant