Filter interviews by
I applied via Approached by Company and was interviewed before Jan 2024. There were 2 interview rounds.
Union and Union All are SQL commands used to combine the result sets of two or more SELECT statements.
Union is used to combine the result sets of two or more SELECT statements, removing duplicates.
Union All is used to combine the result sets of two or more SELECT statements, including duplicates.
Union and Union All require that the number of columns in each SELECT statement is the same.
Example: SELECT column1 FROM tabl...
Rank is the position of an element in a sorted list, while dense rank is the position of an element in a sorted list with no gaps between ranks.
Rank assigns unique numbers to each element based on their order in a sorted list.
Dense rank also assigns unique numbers to each element, but without any gaps between ranks.
For example, if we have a list of numbers [10, 20, 20, 30], the rank of 20 would be 2 and the dense rank ...
ETL validations ensure data accuracy, completeness, and consistency during the extraction, transformation, and loading process.
Schema validation to ensure data types and formats are correct
Data completeness checks to verify all expected data is present
Duplicate data detection to prevent redundancy
Referential integrity checks to maintain relationships between tables
Data quality checks to identify anomalies or errors
To find duplicates in an array of strings
Iterate through the array and store each element in a HashSet
If the element is already in the HashSet, it is a duplicate
Alternatively, sort the array and compare adjacent elements for duplicates
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Referral and was interviewed before Jan 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
OOPs stands for Object-Oriented Programming System
Java is a class-based OOPs language
Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs
Objects have state and behavior
Java supports interfaces, which allow for multiple inheritance
Example: A car can be represented as an object wit...
Java solves machine dependency by using bytecode and virtual machine.
Java code is compiled into bytecode which is platform-independent
The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific
JVM translates bytecode into machine code for the specific platform
This allows Java code to run on any platform with a JVM installed
Example: A Java program compiled on Windows can run on Linux or Mac as
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
Numerical ability and logical reasoning followed by some coding mcqs
Printing 1 to 100 without for loop
Use recursion to print numbers from 1 to 99
Print 100 outside the recursion
Use a base case to stop recursion at 100
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
Simple aptitude test
I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.
Attended the codevita competition in final year of college.
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
It was a basic aptitude test.
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.
- basic programming on C
based on 2 interviews
Interview experience
Sales Officer
4
salaries
| ₹3.8 L/yr - ₹7 L/yr |
Accountant
3
salaries
| ₹2.4 L/yr - ₹3 L/yr |
Data Entry Operator
3
salaries
| ₹1.1 L/yr - ₹3 L/yr |
Saregama India
T-Series
Zee Entertainment Enterprises
Sun Pharmaceutical Industries