Filter interviews by
SQL joins are used to combine rows from two or more tables based on a related column between them.
SQL joins are used to retrieve data from multiple tables based on a related column between them
Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right ...
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions include ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and more
They allow for calculations to be performed on a specific subset of rows within a query result set
Window functions are commonly used in analytical queries to calculate running totals, moving averages, and more
Anagrams are two strings that have the same characters in a different order.
Check if the two strings have the same length.
Sort the characters in both strings and compare if they are equal.
Alternatively, count the frequency of characters in both strings and compare the counts.
I applied via Naukri.com and was interviewed in Jan 2024. There were 3 interview rounds.
Top trending discussions
I applied via Referral and was interviewed in Dec 2020. There were 5 interview rounds.
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
Regarding problem-solving
Regarding sql question
I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.
Interviewer gave business scenarios and asked what will do in this problem statement
I applied via Campus Placement and was interviewed before Jun 2022. There were 4 interview rounds.
Basic level appitude and reasoning test
Case scenario will be given to solve
I appeared for an interview before Mar 2024, where I was asked the following questions.
Data streaming involves continuous data transmission for real-time processing and analysis using various technologies.
Data streaming allows for real-time data processing, enabling immediate insights and actions.
Technologies include Apache Kafka, which is used for building real-time data pipelines.
Apache Flink is another technology that provides high-throughput, low-latency data processing.
Amazon Kinesis is a cloud-base...
Real-time data replication across databases can be achieved using various techniques and tools to ensure data consistency and availability.
Use Change Data Capture (CDC) to track changes in the source database and replicate them to target databases in real-time.
Implement database triggers that automatically push changes to other databases upon data modification.
Utilize message queues (e.g., Kafka, RabbitMQ) to stream da...
I applied via Campus Placement and was interviewed before Aug 2020. There were 7 interview rounds.
based on 2 interviews
Interview experience
based on 8 reviews
Rating in categories
5-10 Yrs
Not Disclosed
4-6 Yrs
Not Disclosed
5-7 Yrs
Not Disclosed
Data Engineer
7
salaries
| ₹9 L/yr - ₹20.5 L/yr |
Data Consultant
5
salaries
| ₹8.3 L/yr - ₹12 L/yr |
Senior Data Consultant
5
salaries
| ₹11 L/yr - ₹21 L/yr |
HR Manager
4
salaries
| ₹3 L/yr - ₹8.5 L/yr |
Data Analyst
4
salaries
| ₹9.3 L/yr - ₹14 L/yr |
Dhruv Research
S.M. Consultants
Cheers Interactive
Thoucentric