Filter interviews by
I applied via Campus Placement
My SQL query working fetching to data
Programming and data query fetching
Grammer and general understanding
I applied via Referral and was interviewed before Aug 2022. There were 7 interview rounds.
English, mental ability, reasoning
Based on document review
Easy coding round ,like 2d array,pattern
It makes to develop any static website or any static project techniques
I applied via Naukri.com and was interviewed in Apr 2023. There were 2 interview rounds.
Find second max salary of employee by department in SQL
Use GROUP BY clause to group employees by department
Use MAX() function to find the maximum salary
Use subquery to find the second maximum salary
Find second max salary of employee by department using pandas dataframe
Group the dataframe by department
Sort the salaries in descending order
Select the second highest salary for each department
Python code to download file from aws s3 to local using boto3
Install boto3 library using pip
Create an S3 client using boto3
Use the download_file method to download the file from S3 to local
A program to count the number of words in a text file using PySpark.
Read the text file using SparkContext
Split the lines into words using flatMap
Map each word to a tuple of (word, 1)
Reduce by key to count the occurrences of each word
Save the output to a file
I applied via LinkedIn and was interviewed in Sep 2020. There were 5 interview rounds.
VIF stands for Variance Inflation Factor, a measure of multicollinearity in regression analysis.
VIF is used to detect the presence of multicollinearity in regression analysis.
It measures how much the variance of the estimated regression coefficient is increased due to multicollinearity.
A VIF value of 1 indicates no multicollinearity, while a value greater than 1 suggests increasing levels of multicollinearity.
A commonl...
I applied via Walk-in and was interviewed in Mar 2020. There was 1 interview round.
R square is a statistical measure that represents the proportion of the variance in the dependent variable explained by the independent variables.
R square is a value between 0 and 1, where 0 indicates that the independent variables do not explain any of the variance in the dependent variable, and 1 indicates that they explain all of it.
It is used to evaluate the goodness of fit of a regression model.
Adjusted R square t...
Variable reducing techniques are methods used to identify and select the most relevant variables in a dataset.
Variable reducing techniques help in reducing the number of variables in a dataset.
These techniques aim to identify the most important variables that contribute significantly to the outcome.
Some common variable reducing techniques include feature selection, dimensionality reduction, and correlation analysis.
Fea...
The Wald test is used in logistic regression to check the significance of the variable.
The Wald test calculates the ratio of the estimated coefficient to its standard error.
It follows a chi-square distribution with one degree of freedom.
A small p-value indicates that the variable is significant.
For example, in Python, the statsmodels library provides the Wald test in the summary of a logistic regression model.
Multicollinearity in logistic regression can be checked using correlation matrix and variance inflation factor (VIF).
Calculate the correlation matrix of the independent variables and check for high correlation coefficients.
Calculate the VIF for each independent variable and check for values greater than 5 or 10.
Consider removing one of the highly correlated variables or variables with high VIF to address multicollinear...
Bagging and boosting are ensemble methods used in machine learning to improve model performance.
Bagging involves training multiple models on different subsets of the training data and then combining their predictions through averaging or voting.
Boosting involves iteratively training models on the same dataset, with each subsequent model focusing on the samples that were misclassified by the previous model.
Bagging reduc...
Logistic regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.
It is a type of regression analysis used for predicting the outcome of a categorical dependent variable based on one or more predictor variables.
It uses a logistic function to model the probability of the dependent variable taking a particular value.
It is commo...
Gini coefficient measures the inequality among values of a frequency distribution.
Gini coefficient ranges from 0 to 1, where 0 represents perfect equality and 1 represents perfect inequality.
It is commonly used to measure income inequality in a population.
A Gini coefficient of 0.4 or higher is considered to be a high level of inequality.
Gini coefficient can be calculated using the Lorenz curve, which plots the cumulati...
A chair is a piece of furniture used for sitting, while a cart is a vehicle used for transporting goods.
A chair typically has a backrest and armrests, while a cart does not.
A chair is designed for one person to sit on, while a cart can carry multiple items or people.
A chair is usually stationary, while a cart is mobile and can be pushed or pulled.
A chair is commonly found in homes, offices, and public spaces, while a c...
Outliers can be detected using statistical methods like box plots, z-score, and IQR. Treatment can be removal or transformation.
Use box plots to visualize outliers
Calculate z-score and remove data points with z-score greater than 3
Calculate IQR and remove data points outside 1.5*IQR
Transform data using log or square root to reduce the impact of outliers
I applied via Approached by Company and was interviewed before Sep 2021. There were 3 interview rounds.
Explain dynamic programming with memoization
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Cost Analyst
47
salaries
| ₹3 L/yr - ₹6 L/yr |
Product Support Engineer
31
salaries
| ₹2.6 L/yr - ₹6 L/yr |
Data Analyst
27
salaries
| ₹1.9 L/yr - ₹6.5 L/yr |
Invoice Analyst
27
salaries
| ₹2 L/yr - ₹3.8 L/yr |
Software Engineer
21
salaries
| ₹4 L/yr - ₹10.4 L/yr |
Duck Creek Technologies
FinThrive
Mobileum
AgreeYa Solutions