Experian Data Management Analyst Interview Questions and Answers

Q1. SQL Joins and remove duplicates
Add your answer
Q2. Function to create a transaction bin column
Ans. 
Create a function to generate a transaction bin column based on transaction amounts.
• Create bins based on transaction amounts (e.g. $0-$100, $101-$200, etc.)

• Use pandas cut() function in Python to create bins

• Assign bin labels to the transactions based on the bin ranges
Answered by AI
Add your answer

1 python and 1 SQL coding along with ML questions mostly related to monitoring and basic ML

1 python code and also related to ML ...the recruiter came with a dataset to solve

Guestimates, project discussions and Case Studies

Project indepth discussion and case study related Fraud Detection

Q1. Aligning own interest with team requirement
Add your answer

Data Coding, 1hr, series of questions in excel

Q1. Internal external tables
Add your answer
Q2. MySQL questions
Add your answer

Q1. SQL coding tests
Add your answer

Q1. Discussed about hybrid mode of work
Add your answer

Easy it about logical reasoning, grammar etc

Q1. Asking about company and role
Add your answer

General topic group discussion

Q1. Basics of Logistic regression
Add your answer
Q2. What is Logistic Regression? What is Recall
Ans. 
Logistic Regression is a statistical method used to model the probability of a certain event occurring based on one or more predictor variables. Recall is a metric used to evaluate the performance of a classification model.
• Logistic Regression is used for binary classification tasks, where the outcome variable is categorical and has two classes.

• It estimates the probability that a given input belongs to a certain categor...read more
Answered by AI
Add your answer
Q3. What is Recall?
Ans. 
Recall is a metric used in classification models to measure the ability of the model to find all relevant cases within a dataset.
• Recall is calculated as the number of true positive predictions divided by the sum of true positive and false negative predictions.

• It is also known as sensitivity or true positive rate.

• A high recall indicates that the model is good at identifying all relevant cases, even if it means more fals...read more
Answered by AI
Add your answer
Q4. What is the difference between linear and logistic reg.?
Ans. 
Linear regression is used for predicting continuous values, while logistic regression is used for predicting binary outcomes.
• Linear regression is used when the target variable is continuous and has a linear relationship with the independent variables.

• Logistic regression is used when the target variable is binary or categorical and the relationship between independent variables and the target is non-linear.

• Linear regres...read more
Answered by AI
Add your answer
Q5. What are the performance metrics of Regression
Ans. 
Performance metrics of Regression include Mean Squared Error, R-squared, Mean Absolute Error, etc.
• Mean Squared Error (MSE)

• R-squared (R^2)

• Mean Absolute Error (MAE)

• Root Mean Squared Error (RMSE)

• Adjusted R-squared
Answered by AI
Add your answer

Q1. Questions related to MySQL, from basic to advance, AWS basic questions.what is replication, types of replication, types of backup, types of logs in MySQL, etc
Add your answer

Q1. Second round for techno manger round, few logical questions, MySQL related question, mangement questions
Add your answer

Q1. Last round with chief of devops, basic hr and mangaer question, my vision and abilities, goals and ambition
Add your answer