IKS Health Interview Questions and Answers

MySQL database query

• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter data based on conditions

• Use JOIN to combine data from multiple tables

• Use ORDER BY to sort data in ascending or descending order

• Use LIMIT to limit the number of rows returned

As a Business Analyst, I was responsible for gathering and analyzing business requirements, creating functional specifications, conducting stakeholder meetings, and facilitating communication between business and IT teams.

• Gathered and documented business requirements from stakeholders

• Analyzed data to identify trends and make recommendations for process improvements

• Created functional specifications for new software deve...read more

Yes, I have experience working in both Waterfall and Scrum models.

• I have experience working in Waterfall model, where requirements are gathered upfront and the project progresses in a linear fashion.

• I have also worked in Scrum model, where the project is divided into sprints and iterative development is done.

• In Waterfall model, I have worked on projects with well-defined scope and fixed timelines.

• In Scrum model, I have...read more

I have experience handling teams ranging from 5 to 15 members as a Business Analyst.

• Managed a team of 8 analysts in a previous project

• Collaborated with a team of 12 developers and testers in another project

• Led a team of 5 business analysts in a recent initiative

Yes, I had regular interactions with the onshore team to gather requirements and provide updates on project progress.

• Regularly communicated with onshore team to gather requirements

• Provided updates on project progress to onshore stakeholders

• Collaborated with onshore team to ensure alignment on project goals

The Product Owner (PO) in my team was responsible for defining and prioritizing the product backlog. Business Analyst and PO coordinate through regular meetings, communication, and collaboration.

• The PO defines and prioritizes the product backlog based on business value and stakeholder needs.

• The Business Analyst works closely with the PO to understand requirements, gather feedback, and ensure alignment with business goa...read more

Requirements were gathered through collaboration between the Product Owner and Business Analyst in the team.

• Requirements were gathered through stakeholder interviews, workshops, and document analysis.

• The Product Owner and Business Analyst worked closely together to ensure all requirements were captured accurately.

• The Business Analyst facilitated the requirements gathering process and documented the findings for review ...read more

Clustered index physically reorders the data in the table while non-clustered index creates a separate structure.

• Clustered index determines the physical order of data in the table, while non-clustered index does not.

• A table can have only one clustered index, but multiple non-clustered indexes.

• Clustered index is faster for retrieval of data, while non-clustered index is faster for retrieval of specific rows.

• Example: Clu...read more