Annapurna Finance Data Analyst Interview Questions and Answers

1 hour coding test on intermediate python programming

They will ask general aptitude test

It was 30 minutes aptitude test

Q1. Salary related questions
Add your answer
Q2. Work related questions
Add your answer
Q3. They asked about last job details
Add your answer

Q1. What is your current role ?
Add your answer
Q2. Why are you looking for a job change?
Add your answer

Q1. Python based list iteration, SQL join based questions
Add your answer

Q1. What are the project you have worked upon ?
Add your answer

Asked about a case study on whom to give a loan among 1000 customers

Q1. Tell me about the types of join sql.
Ans. 
Types of join SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q2. Tell about the dax function
Ans. 
DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.
• DAX functions are used to create calculated columns, measures, and calculated tables in Power BI and Excel.

• DAX functions include mathematical, logical, statistical, and text functions.

• Examples of DAX functions are SUM, AVERAGE, IF, RELATED, CALCULATE, etc.
Answered by AI
Add your answer

Q1. Proficiency in data analytics tool level?
Add your answer

Asked questions of finance and aptitude

Q1. What is machine learning?
Ans. 
Machine learning is a branch of artificial intelligence that involves developing algorithms and models that enable computers to learn from and make predictions or decisions based on data.
• Machine learning is a subset of artificial intelligence that focuses on developing algorithms that can learn from and make predictions or decisions based on data.

• It involves training models on large datasets to recognize patterns and m...read more
Answered by AI
Add your answer
Q2. What do you know about SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to retrieve and manipulate data in relational databases

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• SQL can be used to create tables, indexes, and views

• Examples of SQL databases include MySQL, PostgreSQL, Oracle
Answered by AI
Add your answer
Q3. What you know about software Development?
Ans. 
Software development involves creating, designing, testing, and maintaining software applications.
• Software development includes coding, testing, debugging, and documenting software applications.

• Developers use programming languages like Java, Python, C++, etc. to write code.

• Agile and Waterfall are common software development methodologies.

• Version control systems like Git are used to manage code changes.

• Software developm...read more
Answered by AI
Add your answer

Q1. What are the algorithms you know in machine learning and their details ?
Ans. 
Various machine learning algorithms with brief details
• Supervised Learning: Linear Regression, Logistic Regression, Support Vector Machines (SVM), Decision Trees, Random Forest

• Unsupervised Learning: K-means Clustering, Hierarchical Clustering, Principal Component Analysis (PCA)

• Reinforcement Learning: Q-Learning, Deep Q-Networks (DQN)

• Neural Networks: Convolutional Neural Networks (CNN), Recurrent Neural Networks (RNN), L
Answered by AI
Add your answer
Q2. Python questions
Add your answer

Apptitude test conducted where there are 60 question in 60 min

Python, Verbal , Apptitude

Last one is interview round