Sumitomo Mitsui Banking Corporation Senior Business Analyst Interview Questions and Answers

Q1. Business analyst roles and responsibilities
Add your answer

Q1. Tell me about something you failed at
Add your answer

Tableau visualisation dashboard analysing data

Q1. Basics of data analyat
Add your answer

Q1. What interest you in data analysis
Ans. 
I am fascinated by the ability to uncover insights and make informed decisions based on data analysis.
• Data analysis allows me to identify trends and patterns in data that can drive business decisions

• I enjoy the challenge of transforming raw data into meaningful information

• Data analysis helps me understand customer behavior and preferences, leading to improved strategies and outcomes
Answered by AI
Add your answer

Q1. API related questions
Add your answer
Q2. Soap, rest api details
Add your answer
Q3. XML, Json related questions
Add your answer
Q4. Prioritisation based questions
Add your answer
Q5. Case study related questions
Add your answer

Q1. SQL joins and cte
Add your answer
Q2. Jira software operation
Ans. 
Jira software is a project management tool used for tracking issues and managing tasks.
• Jira allows users to create and track issues, assign tasks, and prioritize work.

• Users can customize workflows, create dashboards, and generate reports.

• Integration with other tools like Confluence and Bitbucket is possible.

• Example: Creating a new issue, assigning it to a team member, and tracking its progress.
Answered by AI
Add your answer

Q1. How many years exp
Add your answer
Q2. What domain have you worked? Did you work in finance project?
Add your answer

Q1. Normal work did in past
Ans. 
Performed data analysis, requirement gathering, process improvement, and documentation in past roles.
• Conducted data analysis to identify trends and insights

• Gathered requirements from stakeholders to understand business needs

• Improved processes by identifying inefficiencies and proposing solutions

• Documented findings, requirements, and processes for reference
Answered by AI
Add your answer
Q2. And what are my aspirations
Add your answer

Q1. Why would you be a good fit
Ans. 
I have a strong background in data analysis, problem-solving skills, and excellent communication abilities.
• Extensive experience in data analysis and interpretation

• Strong problem-solving skills to identify and address business needs

• Excellent communication abilities to collaborate with stakeholders and present findings

• Proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer
Q2. Tell me about your experience
Ans. 
I have over 5 years of experience as a Business Analyst in the finance industry.
• Led cross-functional teams to analyze market trends and develop strategic plans

• Performed data analysis to identify key business insights and opportunities

• Collaborated with stakeholders to gather requirements and define project scope

• Utilized tools such as SQL, Excel, and Tableau for data visualization and reporting

• Presented findings and reco...read more
Answered by AI
Add your answer

Q1. Design an order management system
Ans. 
An order management system to streamline the process of receiving, tracking, and fulfilling customer orders.
• Define user roles and permissions for accessing and managing orders

• Create a user-friendly interface for entering and tracking orders

• Integrate with inventory management system to ensure accurate stock levels

• Automate order processing and notifications to improve efficiency

• Generate reports on order status, sales tre
Answered by AI
Add your answer
Q2. Data points involved in the order management system
Ans. 
Data points in an order management system include customer information, order details, payment information, shipping details, and order status.
• Customer information (name, address, contact details)

• Order details (products, quantities, prices)

• Payment information (payment method, transaction ID)

• Shipping details (shipping address, tracking number)

• Order status (pending, processing, shipped, delivered)
Answered by AI
Add your answer
Q3. Trade life cycle
Add your answer

Sql python puzzle moderate level

Q1. Overall was good. Sql excel pivots were aske
Add your answer