IDFC FIRST Bank Business Analyst Interview Questions, Process, and Tips

Q1. About previous project
Add your answer
Q2. Python code and some sql quries
Add your answer

Q1. Er diagram in dbms
Ans. 
ER diagram in DBMS is a visual representation of data relationships in a database.
• ER diagram stands for Entity-Relationship diagram

• It shows entities, attributes, and relationships between entities

• Entities are represented as rectangles, attributes as ovals, and relationships as diamonds

• Example: An ER diagram for a university database would show entities like Student, Course, and Department
Answered by AI
Add your answer
Q2. Coursor, views etc
Add your answer

It was very good exp6

Q1. Regarding agile and water fall method
Add your answer
Q2. What is the process that you do in agilemethod
Ans. 
In Agile methodology, the process involves iterative development, collaboration, and flexibility.
• Agile methodology focuses on breaking down projects into smaller tasks called user stories.

• Teams work in short iterations called sprints, typically 2-4 weeks long.

• Daily stand-up meetings are held to discuss progress, challenges, and plans for the day.

• Continuous feedback and adaptation are key principles in Agile methodology...read more
Answered by AI
Add your answer
Q3. What is scrum and what is the process
Ans. 
Scrum is an agile framework for managing work on complex projects.
• Scrum involves breaking down work into small, manageable tasks called user stories.

• It includes roles like Product Owner, Scrum Master, and Development Team.

• Scrum events include Sprint Planning, Daily Standups, Sprint Review, and Sprint Retrospective.

• The process involves iterative development cycles called Sprints, typically 2-4 weeks long.

• Scrum emphasize
Answered by AI
Add your answer
Q4. What is the agile cycle to process
Ans. 
The agile cycle process involves planning, executing, evaluating, and adapting in iterative cycles.
• The agile cycle starts with planning, where the team defines the scope, objectives, and requirements of the project.

• Next, the team executes the plan by developing and testing the product incrementally.

• After each iteration, the team evaluates the progress and gathers feedback from stakeholders.

• Based on the feedback, the te...read more
Answered by AI
Add your answer

Q1. Regarding salary 7
Add your answer

Q1. Questions were mostly on SQL, SSIS and DWH.
Add your answer
Q2. Performance tuning.
Add your answer

Q1. About projects on which currently working.
Add your answer
Q2. Indexes, Parallelism, Scheduling, Stored Procedures
Add your answer

Q1. Salary discussion .
Add your answer