Filter interviews by
I applied via LinkedIn and was interviewed in Aug 2024. There was 1 interview round.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables and defining relationships between them.
It helps in reducing data redundancy and ensures data integrity.
Denormalized tables are preferred for read-heavy applications where performance is a priority.
Denormalization can improve query performance by ...
Star schema has a single fact table connected to multiple dimension tables, while snowflake schema has normalized dimension tables.
Star schema denormalizes data for faster query performance.
Snowflake schema normalizes data to reduce redundancy.
Star schema is easier to understand and query, but snowflake schema saves storage space.
Example: A star schema for a sales database would have a fact table for sales transactions...
Top trending discussions
posted on 18 Dec 2024
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
Developed a predictive model to forecast customer churn for a telecommunications company.
Used machine learning algorithms such as logistic regression and random forest.
Performed data preprocessing, feature engineering, and model evaluation.
Collaborated with business stakeholders to understand requirements and present findings.
Achieved 85% accuracy in predicting customer churn.
Implemented the model into the company's CR
Data Analysts are responsible for collecting, processing, and analyzing data to help organizations make informed decisions.
Collect and organize data from various sources
Clean and preprocess data to ensure accuracy
Analyze data using statistical techniques and tools
Create visualizations and reports to present findings
Provide insights and recommendations based on data analysis
Collaborate with stakeholders to understand bu
I am looking for a competitive salary based on my experience, skills, and the market rate for Data Analyst roles.
Research the average salary range for Data Analyst positions in the specific location and industry
Consider your level of experience, education, and skills when determining your salary expectations
Be prepared to negotiate based on the benefits package offered by the employer
Provide a salary range rather than ...
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Simple and easy questions for me
HLOOKUP is a function in Excel used to search for a value in the top row of a table and return a value in the same column from a specified row.
HLOOKUP stands for Horizontal Lookup.
It is used to search for a value in the top row of a table and return a value in the same column from a specified row.
Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP(100, A1:D4, 3, FALSE) will searc...
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.
VLOOKUP stands for 'Vertical Lookup'.
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.
The function requires four arguments: the value to search for, the range of cells to search in, the column index number...
An interview with advanced Excel question
I applied via Walk-in and was interviewed before Mar 2021. There were 2 interview rounds.
TELL ME ABOUT YOUR SELF
based on 1 interview
Interview experience
Assistant Manager
160
salaries
| ₹5.7 L/yr - ₹20 L/yr |
Deputy Manager
94
salaries
| ₹9.6 L/yr - ₹21 L/yr |
Key Account Manager
79
salaries
| ₹9 L/yr - ₹23 L/yr |
Production Engineer
66
salaries
| ₹1.3 L/yr - ₹4 L/yr |
Trainee
52
salaries
| ₹1 L/yr - ₹3.2 L/yr |
Timken
Schaeffler India
Ntn Bearing
NSK