Kissht Finance Data Analyst Interview Questions and Answers for Experienced

30 minutes Aptitude test

1 Hour 30 minutes on SQL screening test

It was hackerrank test

Q1. Questions based on MS Excel only and provide 1 assignment for data analysis.
Add your answer

Q1. Again easy questions on MS Excel like; Vlookup, pivot, summarize, sumif, etc
Add your answer

45 min , 45 questions

Q1. Technical question( PowerBI, data science)
Add your answer
Q2. Behaviourial question
Add your answer

Q1. Filtering methods in pandas?
Ans. 
Pandas filtering methods allow for selecting data based on conditions, enhancing data analysis and manipulation.
• Boolean indexing: Use boolean conditions to filter rows. Example: df[df['age'] > 30]

• Query method: Use the query() function for filtering. Example: df.query('age > 30')

• loc method: Access a group of rows and columns by labels. Example: df.loc[df['age'] > 30, ['name', 'age']]

• isin method: Filter rows bas...read more
Answered by AI
Add your answer
Q2. Make simple function to create new columns by using existing multiple other fields.
Add your answer
Q3. Write a simple SQL query for department wise budget?
Add your answer

How to improve credit model in order to increase sales growth of the organization?

Q1. Related to relocation?
Add your answer
Q2. Why you want to chnage current organization?
Ans. 
I seek new challenges and opportunities for growth that align with my career goals and passion for data science.
• Desire for professional growth: I want to work on more complex projects that push my analytical skills.

• Interest in innovative technologies: My current organization is not utilizing the latest tools in data science, like machine learning frameworks.

• Cultural fit: I am looking for a company that values collabora...read more
Answered by AI
Add your answer

Q1. Mostly revolves around SQL, A bit of python and in that also specially pandas and might be a bit of excel
Add your answer

Q1. SQL a bit advanced, Pandas and Python, and around your projects some time and if you mentioned ML then some questions around it mostly logistic regression,random foresr
Add your answer

Q1. Knowledge regarding cibil and collection
Add your answer

Q1. Introduce yourself
Add your answer
Q2. Can you take collection calls?
Ans. 
Yes, I am comfortable taking collection calls.
• I have experience in handling collection calls in my previous roles.

• I am confident in my communication skills and ability to negotiate payment plans.

• I understand the importance of maintaining professionalism and empathy during collection calls.
Answered by AI
Add your answer
Q3. How much salary you want?
Add your answer
Q4. From when you can join?
Add your answer