Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
SCD types refer to slowly changing dimensions in data warehousing, categorized into Type 1, Type 2, and Type 3.
Type 1 SCD: Overwrites existing data with new information, losing historical data.
Type 2 SCD: Maintains historical data by creating new records for changes, with a surrogate key for each version.
Type 3 SCD: Keeps both old and new values in the same record, with separate columns for each version.
A junk dimension is a single dimension table that combines multiple low-cardinality attributes that are not related to the fact table.
Contains attributes that are not related to the fact table
Reduces the number of dimension tables in the data warehouse
Helps in simplifying the data model and improving query performance
Snowflake schema is a normalized form of star schema with multiple levels of dimension tables.
Snowflake schema has normalized dimension tables, leading to reduced redundancy and improved data integrity.
Star schema has denormalized dimension tables, which can lead to data redundancy but faster query performance.
Snowflake schema is more complex to query compared to star schema due to multiple levels of normalization.
Star...
Top trending discussions
posted on 30 Nov 2022
I applied via LinkedIn and was interviewed before Nov 2021. There were 3 interview rounds.
There are basic aptitude questions for freshers level
I applied via Campus Placement and was interviewed before May 2022. There were 5 interview rounds.
It was a coding round with sql ,python questions , few aptitude questions
I applied via Referral and was interviewed in May 2024. There were 4 interview rounds.
Python and SQL questions were asked
ACID properties ensure data integrity in DBMS: Atomicity, Consistency, Isolation, Durability.
Atomicity ensures that all operations in a transaction are completed successfully or none at all.
Consistency ensures that the database remains in a consistent state before and after the transaction.
Isolation ensures that multiple transactions can be executed concurrently without affecting each other.
Durability ensures that once...
The test was in hackerrank platform, it was moderate level.
I applied via Campus Placement
Dsa problems dp and tress problem
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
5 years of experience in software development
Proficient in developing web applications
Skilled in using various technologies
Passionate about software engineering
I applied via Internshala and was interviewed in Sep 2022. There were 3 interview rounds.
Includes basic aptitude question with additional questions based on coding languages fundamentals.....
Binary search is a search algorithm that finds the position of a target value within a sorted array.
Divide the array into two halves
Compare the target value with the middle element
If the target value matches the middle element, return its position
If the target value is less than the middle element, search the left half of the array
If the target value is greater than the middle element, search the right half of the arra...
posted on 27 Jul 2023
I applied via Campus Placement and was interviewed in Jun 2023. There were 3 interview rounds.
Basic coding questions with some aptitude questions
posted on 26 Dec 2023
I applied via Campus Placement and was interviewed before Dec 2022. There were 5 interview rounds.
General aptitude and reasoning
General coding questions
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
BI Consultant
56
salaries
| ₹5.3 L/yr - ₹15 L/yr |
Associate Consultant
51
salaries
| ₹4.2 L/yr - ₹12 L/yr |
Consultant
33
salaries
| ₹6.4 L/yr - ₹26.4 L/yr |
Associate BI Consultant
32
salaries
| ₹4 L/yr - ₹11 L/yr |
Senior BI Consultant
29
salaries
| ₹7.2 L/yr - ₹24.8 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services