IDFC FIRST Bank Data Analyst Interview Questions and Answers

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

Q1. SQL Basics and Good Communication
Add your answer
Q2. Structured Profile Summary
Add your answer

Q1. Asked about the projects from the resume. It was based on Python. The project was stock prediction using ml. They mainly asked about the concepts used. And they also asked the equations related to data sci...read more
Add your answer

Q1. I didn't qualified for this round
Add your answer

It consists of resume-based skill questions.

Q1. Why do you want to join ICICI Bank?
Ans. 
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
• ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service

• I am impressed by ICICI Bank's focus on technology and digital banking solutions

• I believe that working at ICICI Bank will provide me with opportunities for career growth an...read more
Answered by AI
Add your answer
Q2. Can you tell me about your projects?
Ans. 
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
• Developed predictive models to optimize marketing strategies

• Utilized clustering techniques for customer segmentation

• Built time series models for sales forecasting
Answered by AI
Add your answer

Pandas and SQL questions and some business case

Q1. The head of the vertical took interview, explained role and asked about my experience.
Add your answer
Q2. What project did you work on?
Add your answer

Q1. A senior data scientist asked technical questions on my experience.
Add your answer
Q2. What is the advantage or lstm over rnn.
Ans. 
LSTM has better memory retention than RNN.
• LSTM can remember long-term dependencies better than RNN.

• LSTM has a gating mechanism that controls the flow of information.

• LSTM can handle vanishing gradient problem better than RNN.

• LSTM is more suitable for tasks that require long-term memory, such as speech recognition and language translation.
Answered by AI
Add your answer
Q3. What is multicollinearity and what are its effects?
Ans. 
Multicollinearity is a phenomenon where two or more independent variables in a regression model are highly correlated.
• It can lead to unstable and unreliable estimates of regression coefficients.

• It can make it difficult to determine the individual effect of each independent variable on the dependent variable.

• It can also result in inflated standard errors and p-values, making it difficult to identify statistically signif...read more
Answered by AI
Add your answer

Q1. What is indexing
Ans. 
Indexing is a technique used to optimize the performance of databases by creating a data structure that allows for quick retrieval of data.
• Indexing involves creating a data structure that maps the values of a particular column in a database table to their physical storage locations on disk.

• It helps in speeding up data retrieval operations by allowing the database to quickly locate the rows that satisfy a certain condit...read more
Answered by AI
Add your answer