Shivalik Small Finance Bank Business Analyst Interview Questions and Answers

Q1. Projects done so far
Add your answer

Q1. 1. Introduce yourself 2. SQL Query using windows Function 3. What are different joins and there usage 4. Basic Questions on Excel 5. Difference between Data Analyst and Business Analyst
Add your answer

Q1. 1. Introduction 2. Explain any end to end live project you have done. 3. SQL Advanced queries using windows function. 4. SQL query using Windows function 5. Guestimate.
Add your answer

Q1. 1. Introduce yourself. 2. Why do you want to change the company now. 3. Why Paytm 4. Salary Expectation.
Add your answer

Q1. Write an update query in SQL (Easy)
Ans. 
Update query in SQL to modify data in a database table
• Use UPDATE statement followed by table name

• Set the column(s) to be updated using SET keyword

• Specify the new values for the column(s) to be updated

• Add WHERE clause to specify the condition for updating specific rows
Answered by AI
Add your answer
Q2. A case study SQL question which needs to be solved using CASE WHEN (Easy)
Add your answer
Q3. Past projects experience
Ans. 
I have experience working on various data analysis projects in industries such as finance and marketing.
• Developed predictive models to forecast sales trends

• Conducted A/B testing to optimize marketing campaigns

• Performed data cleaning and preprocessing to improve data quality

• Utilized SQL and Python for data analysis and visualization
Answered by AI
Add your answer
Q4. Banking domain knowledge
Add your answer

Basic online English spoken, listening and written test of approximately 60 mins.

Q1. Why did you decide to join NAB?
Ans. 
I decided to join NAB because of its strong reputation in the industry and opportunities for career growth.
• NAB has a strong reputation in the industry for its commitment to customer service and innovation

• I was impressed by NAB's focus on employee development and opportunities for career growth

• I believe that NAB's values align with my own professional goals and aspirations
Answered by AI
Add your answer
Q2. What is your perspective of the term 'Risk'?
Ans. 
Risk is the potential of gaining or losing something of value.
• Risk is the uncertainty of outcome, whether positive or negative.

• It involves the possibility of harm or loss.

• Risk can be managed through various strategies such as risk avoidance, risk reduction, risk transfer, or risk acceptance.

• Examples of risks include financial risk, health risk, and project risk.
Answered by AI
Add your answer
Q3. What is the difference between secured and unsecured loan?
Ans. 
Secured loans are backed by collateral, while unsecured loans are not.
• Secured loans require collateral to secure the loan, such as a house or car.

• Unsecured loans do not require collateral and are based on the borrower's creditworthiness.

• Secured loans typically have lower interest rates due to the lower risk for the lender.

• Examples of secured loans include mortgages and auto loans, while credit cards and personal loans
Answered by AI
Add your answer
Q4. What skills do you think matches with this job role?
Ans. 
Some skills that match with this job role include strong communication, attention to detail, time management, and teamwork.
• Strong communication skills to effectively interact with colleagues and clients

• Attention to detail to ensure accuracy in tasks and projects

• Time management skills to prioritize tasks and meet deadlines

• Teamwork skills to collaborate with team members and achieve common goals
Answered by AI
Add your answer
Q5. Why interpersonal skills are important in an organization?
Ans. 
Interpersonal skills are crucial for effective communication, collaboration, and relationship-building within an organization.
• Interpersonal skills help in building strong relationships with colleagues, clients, and stakeholders.

• Effective communication is key to successful teamwork and project management.

• Conflict resolution skills are essential for handling disagreements and maintaining a positive work environment.

• Empat...read more
Answered by AI
Add your answer

Q1. What was the job role in your previous company?
Add your answer

Easy listening reading writing and speaking test

Q1. Salary negotiations
Add your answer

I was given a SQL question that has to be done using CASE statement then GROUP BY etc. It was easy one. If you know basics you would do that. Then they checked your code over 8/10 sample cases and if you got through all of them you will be given interview date. My first round cleared and it was conducted at their Gurgaon office. My interview date was shifted many times due to unavailability of panel. They were causing frustrating delays.

Q1. Tell about yourself and any recent project and what tools and technology you used in that project.
Add your answer
Q2. How to remove duplicates using SQL
Ans. 
Use the DISTINCT keyword in SQL to remove duplicates from a table.
• Use the SELECT DISTINCT statement to retrieve unique rows from a table.

• Identify the columns that contain duplicate values and use the DISTINCT keyword with those columns.

• For example, SELECT DISTINCT column1, column2 FROM table_name;
Answered by AI
Add your answer
Q3. Some questions about Tableau. Basic questions. extracts, filters, blending etc
Add your answer

They have some external vendor for English test

Q1. It's all about your job profile
Add your answer

Q1. Experience with Power BI
Ans. 
I have extensive experience with Power BI.
• Created and maintained multiple dashboards for various departments

• Used DAX formulas to create complex calculations

• Integrated Power BI with other Microsoft tools like Excel and SharePoint

• Trained colleagues on how to use Power BI effectively
Answered by AI
Add your answer

Q1. CRS and FATCA compliance
Add your answer