Equitas Small Finance Bank Data Analyst Interview Questions and Answers

Q1. Sas proc format
Add your answer
Q2. How have you debug macros
Ans. 
I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.
• Reviewing the macro code line by line to identify any syntax errors or logical mistakes

• Using print statements to output variable values and check for unexpected results

• Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues

• Testing the macro with different inputs to
Answered by AI
Add your answer
Q3. How big data handled by you
Ans. 
I handle big data by using advanced analytics tools and techniques to extract valuable insights.
• Utilize data visualization tools like Tableau or Power BI to analyze and present data

• Use programming languages like Python or R for data manipulation and statistical analysis

• Implement machine learning algorithms to uncover patterns and trends in large datasets

• Leverage cloud computing platforms like AWS or Google Cloud for sc...read more
Answered by AI
Add your answer

Having 10 mcqs with 2 coding questions of medium level

Q1. Find missing number from 1 to n without using extra space and O(n) tc
Ans. 
Find missing number from 1 to n without using extra space and O(n) tc
• Use XOR operation to find the missing number

• Iterate through the array and XOR each element with its index and the result

• The missing number will be the final result after XORing all elements and indices
Answered by AI
Add your answer

General aptitude questions

Q1. Some behavior questions with company values
Add your answer

Leetcode easy to medium questions

Q1. Different types of sorting algorithms
Ans. 
Sorting algorithms are methods used to arrange elements in a list in a specific order.
• Bubble Sort - compares adjacent elements and swaps them if they are in the wrong order

• Merge Sort - divides the list into smaller sublists, sorts them, and then merges them back together

• Quick Sort - selects a 'pivot' element and partitions the list into two sublists around the pivot

• Insertion Sort - builds the final sorted list one elem...read more
Answered by AI
Add your answer
Q2. Question of increasing subsequence
Add your answer
Q3. Data Structure and Algorithms, OOPs , Operating System and DBMS questions
Add your answer

Q1. 2nd highest Salary SQL question
Add your answer
Q2. Project related questions
Add your answer
Q3. SQL ,DBMS questions
Add your answer

Q1. Why you want to join this company?
Add your answer
Q2. What are your positive and negative qualities?
Add your answer

MCQ were asked which were case study focused on basic mathematics.

Q1. How is ChatGPT good and bad at the same time?
Ans. 
ChatGPT is good at generating human-like responses quickly, but can also produce inaccurate or biased information.
• Good: ChatGPT can provide quick responses to user queries, saving time and effort.

• Bad: ChatGPT may generate inaccurate information or biased responses based on the data it was trained on.

• Good: ChatGPT can assist in customer service by answering frequently asked questions efficiently.

• Bad: ChatGPT may lack em...read more
Answered by AI
Add your answer

Q1. Automation done
Add your answer

Q1. Explain different type of SQL query?
Ans. 
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
• SELECT: Retrieves data from a database

• INSERT: Adds new records to a table

• UPDATE: Modifies existing records in a table

• DELETE: Removes records from a table

• JOIN: Combines rows from two or more tables based on a related column
Answered by AI
Add your answer

1 hours for aptitude and few coding

Q1. Easy question of DS and maths
Add your answer