TELUS Health Business Analyst Interview Questions and Answers

I want to join Vision India to contribute to its mission of empowering communities through education and sustainable development initiatives.

• Alignment with Vision: I admire Vision India's commitment to transforming lives through education and skill development, which resonates with my values.

• Impactful Work: I am eager to be part of projects that create tangible change, such as improving literacy rates or providing voca...read more

After my degree, I focused on skill development, internships, and exploring opportunities in your company for growth.

• I took online courses in data analysis and project management to enhance my skills.

• I interned at a local startup, where I contributed to a successful marketing campaign.

• I volunteered for community service, which helped me develop teamwork and leadership skills.

• I researched your company’s values and proje...read more

Use SQL to retrieve the top 2 salaries from each department efficiently.

• Use a Common Table Expression (CTE) or a subquery to rank salaries within each department.

• Example SQL: WITH RankedSalaries AS (SELECT Department, Salary, ROW_NUMBER() OVER (PARTITION BY Department ORDER BY Salary DESC) AS Rank FROM Employees) SELECT Department, Salary FROM RankedSalaries WHERE Rank <= 2;

• This method ensures you get the top salari...read more

Use a combination of backup and delete approach to safely delete the records.

• Take a backup of the live system before deleting any records.

• Identify the records to be deleted using a query or script.

• Delete the records in batches to avoid overwhelming the system.

• Monitor the system during the deletion process for any issues.

• Verify the deletion by checking the number of records before and after.

• Consider archiving the delete...read more