Athena Health On-Campus Experience — 2025

Result
Rejected
Posted
18 Sept 2025
349 reads

Summary

Although I wasn't shortlisted for the Technical Round, my Athena Health on-campus experience provided valuable insights into their assessment process, coding challenges, SQL queries, and various interview scenarios, which I believe will significantly help me in future opportunities.

How it went

I recently participated in Athena Health's on-campus recruitment drive. The entire process started with a Hackerrank assessment which included two coding questions, one SQL query, and four multiple-choice questions. Following this, the recruitment rounds were structured as Shortlisting, Technical Round (TR), Managerial Round (MR), and finally, HR. Regrettably, I did not make it past the shortlisting stage for the Technical Round. Despite not progressing further, I gained significant clarity on the types of questions posed in their technical, managerial, and even HR rounds, which I found to be extremely insightful and beneficial for my interview preparation.

Questions asked (30)

  1. 01

    Equal String Operations

    Data Structures & Algorithms

    Given two strings str1 and str2, check if str1 can be made equal to str2 using operations to remove the first character of str1 and insert at any position. If possible, return the minimum number of operations; else return -1.

  2. 02

    Word Matching with Transformations

    Data Structures & Algorithms

    Two strings a and b are considered matching if a can be converted to b using: Swap adjacent characters. Select substring of length k>1 with identical characters and increment all to next alphabet. Given two arrays of strings, determine for each pair whether they are matching (return 1 or 0).

  3. 03

    Min Heap Operations

    Data Structures & Algorithms

    Given a binary min heap 5,7,6,10,9,12,11,13, what is the level order after 2 extract-min operations?

  4. 04

    Daily Wages Calculation (SQL)

    Other

    Tables: laborers (id, name, previous_balance) and daily_hours (labor_id, entry_time, exit_time). Pay = $30 * total_hours_worked + previous_balance. Write a query to return all active employees (worked some hours), with total amount owed, sorted by name. Entry and exit times were given as VARCHAR in format YYYY-MM-DD HH:MM:SS, so I had to cast to DATETIME and use TIMESTAMPDIFF(HOUR, entry_time, exit_time).

  5. 05

    Doubly Linked List Properties

    Data Structures & Algorithms · Easy

    What are the correct properties of a doubly linked list? (a) linear or circular, (b) same space as singly linked lists, (c) Needs a header. Choose the correct combination (e.g., 1) a, b; 2) b, c).

  6. 06

    Merge Sort Time Complexity

    Data Structures & Algorithms · Easy

    Given the merge sort code, what is its time complexity?

  7. 07

    Database View Size Estimation

    Other

    An employee table has 10 columns and 1 million rows, with a size of 50 MB. If a view is created with 5 columns and 1 million rows from this table, what would be the size of the view?

  8. 08

    Valid Parentheses

    Data Structures & Algorithms · Easy

    A coding question like Valid Parentheses was asked.

  9. 09

    Palindrome Number (Optimized)

    Data Structures & Algorithms · Easy

    Given an integer, determine if it is a palindrome. An optimized approach was requested.

  10. 10

    SQL Join based on Condition

    Other

    Given a set of tables, I was asked to join them based on a specific condition.

  11. 11

    Explain CRUD Operations

    Other · Easy

    Explain Create, Read, Update, Delete (CRUD) operations.

  12. 12

    Explain ACID Properties

    Other · Easy

    Explain the ACID properties (Atomicity, Consistency, Isolation, Durability) in databases.

  13. 13

    Explain Authorization

    Other

    Explain the concept of Authorization.

  14. 14

    Sorting Algorithm Pseudocode

    Data Structures & Algorithms

    Provide pseudocode for a sorting algorithm.

  15. 15

    Longest Substring with Unique Characters

    Data Structures & Algorithms · Medium

    A coding question on finding the longest substring with unique characters.

  16. 16

    Check String Presence in Long String

    Data Structures & Algorithms

    Given an array of strings, check if these strings are present in a longer string.

  17. 17

    Explain SQL Inner Join

    Other · Easy

    Explain the concept of SQL Inner Join.

  18. 18

    Three Mislabelled Boxes Puzzle

    Other

    A logical question: three boxes are labelled incorrectly. How can you find the correctly labelled box with minimal moves?

  19. 19

    Estimation: Coffee Shops in an Area

    System Design

    An estimation question: how many coffee shops are in a given area, based on preference data?

  20. 20

    OOPS Design: Coffee Machine

    Other

    Design a coffee machine using Object-Oriented Programming (OOP) principles.

  21. 21

    Call by Reference vs. Call by Value

    Other · Easy

    Explain the difference between call by reference and call by value.

  22. 22

    Interfaces and Multiple Inheritance

    Other

    Provide an example illustrating interfaces and multiple inheritance.

  23. 23

    Search in Rotated Sorted Array

    Data Structures & Algorithms · Medium

    Given a rotated sorted list, return the index of a specific key.

  24. 24

    Explain Polymorphism and Encapsulation

    Other · Easy

    Explain the concepts of polymorphism and encapsulation in OOP.

  25. 25

    Move Zeroes

    Data Structures & Algorithms · Easy

    Given an array, move all zeroes to the end of it while maintaining the relative order of the non-zero elements.

  26. 26

    SQL Group By with Count

    Other · Easy

    Explain and demonstrate the use of SQL GROUP BY clause with COUNT aggregate function.

  27. 27

    Database Cache Memory with Update Example

    Other

    Explain cache memory in a database context, including an update example.

  28. 28

    Difference Between Dates

    Data Structures & Algorithms

    A coding question to find the difference between two dates.

  29. 29

    Tree Traversals, Height, and Balanced Trees

    Data Structures & Algorithms

    Questions about tree traversals, calculating tree height, and properties of balanced trees.

  30. 30

    8 Balls, 1 Heavier Puzzle

    Other

    A puzzle: given 8 balls, one is heavier. Find the heavier ball using only 2 weighings.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Athenahealth recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!