Idea Infinity IT Solutions Junior Data Analyst Interview Questions and Answers

Q1. What is the full form of ETL?
Ans. 
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...read more
Answered by AI
Add your answer
Q2. ETL Full form is Exact, Transform, Load.
Add your answer

Forecasting problem - Predict daily sku level sales

Q1. What is difference between bias and variance
Ans. 
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 ...read more
Answered by AI
Add your answer
Q2. Parametric vs non parametruc model
Ans. 
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...read more
Answered by AI
Add your answer

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Q1. Mostly about projects ml, nlp, python code would be asked
Add your answer

Q1. It would be focused on technical stuff in detail ml, nlp, deployments etc
Add your answer

Q1. Organisation fit
Add your answer

Q1. First of thanks you so much for giving this opportunity introduce my self my name is sai srividya lam from Hyderabad l have completed my graduation st,anns women's college from Malkajgiri Iam belongs to ...read more
Add your answer
Q2. Hyderabad was founded in 19591 and planned as a grid with the charminar at its centre. It has now grown well beyond the confines of the original walled city, to include a new town north of the music river,...read more
Add your answer
Q3. All about my hobbies
Add your answer
Q4. Which is my favourite colour
Ans. 
My favorite color is blue.
• Blue is often associated with calmness and tranquility.

• It is a versatile color that can be both soothing and bold.

• Examples of shades of blue include navy, sky blue, and teal.
Answered by AI
Add your answer
Q5. What is my favourite film
Ans. 
My favorite film is The Shawshank Redemption.
• Directed by Frank Darabont

• Based on a Stephen King novella

• Set in a prison

• Themes of hope and redemption

• Starring Tim Robbins and Morgan Freeman
Answered by AI
Add your answer
Q6. Which is my favourite food and this is like very mostly like it which is favourite colour l like mostly more more .
Add your answer
Q7. Which is my favourite hero and like most and my favourite music is what l like mostly more more.
Add your answer

Q1. What is overfitting in machine learning?
Ans. 
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.

• ...read more
Answered by AI
Add your answer
Q2. Overfitting accurs when a model learns the details.......etc
Ans. 
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...read more
Answered by AI
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer

General aptitude test

Q1. Work sector basd
Add your answer
Q2. Knowledge od data system
Add your answer
Q3. Marketing knowledge for data
Add your answer
Q4. Accounting And finance knowledge
Add your answer
Q5. Communication skill for co worker
Add your answer