Filter interviews by
I applied via Campus Placement and was interviewed before Sep 2023. There were 2 interview rounds.
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
Types of 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 table
RIGHT JOIN re...
DDL commands are Data Definition Language commands used to define, modify, and delete database objects.
DDL stands for Data Definition Language
Common DDL commands include CREATE, ALTER, and DROP
Examples: CREATE TABLE, ALTER TABLE ADD COLUMN, DROP TABLE
I have a strong background in data analysis, with experience in various tools and techniques.
I have a degree in Statistics and have completed multiple data analysis projects during my studies.
I am proficient in using tools like Excel, SQL, and Python for data analysis.
I have experience in cleaning and analyzing large datasets to extract meaningful insights.
I have excellent problem-solving skills and attention to detail
Yes, I am ready to move for the right opportunity.
I am open to relocating for a position that aligns with my career goals.
I have experience moving for previous job opportunities.
I am willing to consider different locations based on the job requirements.
Top trending discussions
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
Allows users to summarize and analyze large datasets
Can easily reorganize data by dragging and dropping fields
Provides options to calculate sums, averages, counts, etc. for data
Helps in creating interactive reports and charts
Useful for identifying trends and patterns in data
Forecasting problem - Predict daily sku level sales
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
Bias is the error introduced by approximating a real-world problem, leading to underfitting.
Variance is the error introduced by modeling the noise in the training data, leading to overfitting.
High bias can cause a model to miss relevant relationships between features and target variable.
High variance can cause a model to ...
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.
Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.
Examples of parametric models inc...
Easy and moderate level question
Given a relevant topic and discussion on it
posted on 29 Feb 2024
I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.
ETL stands for Extract, Transform, Load. It is a process used in data warehousing to extract data from various sources, transform it into a consistent format, and load it into a target database.
ETL stands for Extract, Transform, Load
Extract: Involves extracting data from various sources such as databases, applications, and files
Transform: Involves cleaning, filtering, and transforming the extracted data into a consiste...
Reasoning and aptitude questions were asked
Overfitting occurs when a machine learning model learns the training data too well, including noise and outliers, leading to poor generalization on new data.
Overfitting happens when a model is too complex and captures noise in the training data.
It leads to poor performance on unseen data as the model fails to generalize well.
Techniques to prevent overfitting include cross-validation, regularization, and early stopping.
...
Overfitting occurs when a model learns the details and noise in the training data to the extent that it negatively impacts the model's performance on new data.
Overfitting happens when a model is too complex and captures noise in the training data.
It leads to poor generalization and high accuracy on training data but low accuracy on new data.
Techniques to prevent overfitting include cross-validation, regularization, and...
Software Engineer
22
salaries
| ₹3 L/yr - ₹5.7 L/yr |
Associate Consultant
6
salaries
| ₹4.4 L/yr - ₹7 L/yr |
Software Developer
4
salaries
| ₹2.5 L/yr - ₹5.4 L/yr |
Technical Consultant
4
salaries
| ₹5 L/yr - ₹6 L/yr |
Oracle Technical Consultant
4
salaries
| ₹4 L/yr - ₹6 L/yr |
KPMG India
Deloitte
PwC
Ernst & Young