cswork / libraryOpen practice workspace

Interview guides · Ymca Of Greater New York

Ymca Of Greater New York Software Engineer Interview Guide

Ymca Of Greater New York Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

The YMCA of Greater New York is a cornerstone of community support, youth development, and healthy living across the five boroughs. As a Software Engineer at the YMCA of Greater New York, you do not just build commercial software; you design, develop, and maintain the digital infrastructure that directly impacts millions of New Yorkers. Your work ensures that families can seamlessly register for childcare, community members can access wellness programs, and donors can support vital community initiatives. In this role, you are responsible for bridging modern technology with community service. The digital products you build—ranging from member-facing web applications to internal database systems and operational tools—are critical to the daily functioning of dozens of branches.

This guide is scoped to a Software Engineer candidate at Ymca Of Greater New York.

Focus areas

  • Object-Oriented Programming (OOP)
  • Arrays
  • Database Management Systems (DBMS)

The Ymca Of Greater New York interview process

Ymca Of Greater New York candidates report 4 rounds over 3-5 weeks. The stages below are what candidates describe, not a published process.

Initial Screening

The process begins with an initial screening to assess candidate qualifications.

What to demonstrate

  • The process begins with an initial screening to assess candidate qualifications
  • Depth in Object-Oriented Programming (OOP)

How to prepare

  • Be able to walk your CV end to end in two minutes, and say why this company specifically.
  • Have your salary expectations, notice period and location constraints ready, and ask for the rest of the loop in writing.

Foundational Assessment

Candidates complete a foundational assessment with multiple-choice questions on general aptitude and core computer science concepts.

What to demonstrate

  • Candidates complete a foundational assessment with multiple-choice questions on general aptitude and core computer science concepts
  • Depth in Object-Oriented Programming (OOP)

How to prepare

  • Answer aloud and timed: How do you optimize a slow-running SQL query in a database management system (DBMS)?
  • Answer aloud and timed: Describe what a primary key and a foreign key are, and explain their significance in database design.

Conversational Interview

Candidates participate in conversational interviews focusing on past projects and technical preferences.

What to demonstrate

  • Candidates participate in conversational interviews focusing on past projects and technical preferences
  • Depth in Object-Oriented Programming (OOP)

How to prepare

  • Answer aloud and timed: Explain the concept of software testing. What is the difference between unit testing, integration testing, and system testing?
  • Answer aloud and timed: Given an array of integers, write an algorithm to find if there are any duplicate elements.

Technical Interview

Technical interviews are conducted online, often involving a panel including HR, a Senior Developer, and an Engineering Manager.

What to demonstrate

  • Technical interviews are conducted online, often involving a panel including HR, a Senior Developer, and an Engineering Manager
  • Depth in Object-Oriented Programming (OOP)

How to prepare

  • Answer aloud and timed: How would you implement a two-pointer approach to reverse a string or find a target sum in a sorted array?
  • Answer aloud and timed: Write a program to find the maximum element in an array using a single loop.

Where candidates lose points

Review your foundational CS concepts

Do not overlook basic subjects like object-oriented programming (OOP) principles and database management systems (DBMS). Candidates are frequently asked to explain these fundamentals in detail.

Be ready to walk through your resume projects in detail

The interviewers will ask about your specific technical choices, the challenges you faced, and how you resolved them.

Emphasize the "Why YMCA

Be prepared to talk about why you want to work for a community-focused non-profit. Showing alignment with the YMCA’s mission of youth development, healthy living, and social responsibility can set you apart from other candidates.

Questions & practice

Given an array of integers, write an algorithm to find if there are any duplicate elements.

Medium · Coding & Problem-Solving

Approach

  1. Restate the input: its shape, its size, and what is guaranteed about it.
  2. Name the brute-force solution and its complexity before improving on it.
  3. Choose the data structure from the access pattern, not from familiarity.
  4. State the target complexity and say which constraint rules the naive version out.

Follow-up

  • How does this change if the input no longer fits in memory?
  • What is the worst case, and how likely is it on real data?

How would you implement a two-pointer approach to reverse a string or find a target sum in a sorted array?

Medium · Coding & Problem-Solving

Approach

  1. Restate the input: its shape, its size, and what is guaranteed about it.
  2. Name the brute-force solution and its complexity before improving on it.
  3. Choose the data structure from the access pattern, not from familiarity.
  4. State the target complexity and say which constraint rules the naive version out.

Follow-up

  • How does this change if the input no longer fits in memory?
  • What is the worst case, and how likely is it on real data?

Write a program to find the maximum element in an array using a single loop.

Medium · Coding & Problem-Solving

Approach

  1. Restate the input: its shape, its size, and what is guaranteed about it.
  2. Name the brute-force solution and its complexity before improving on it.
  3. Choose the data structure from the access pattern, not from familiarity.
  4. State the target complexity and say which constraint rules the naive version out.

Follow-up

  • How does this change if the input no longer fits in memory?
  • What is the worst case, and how likely is it on real data?

How do you optimize a slow-running SQL query in a database management system (DBMS)?

Medium · Technical & Core Computer Science

Approach

  1. Name the grain you start from and join outward from it.
  2. Check whether any join is one-to-many before aggregating, or the sums inflate.
  3. Say which index the query would use, and what makes it unusable.
  4. Handle the rows that do not match: that is usually the actual question.

Follow-up

  • How does the query change if that join becomes one-to-many?
  • What happens to this when the table is ten times larger?

Write the update path that detects a concurrent edit

Medium · optimistic concurrency · transactional outbox · audit history

resource carries version INT NOT NULL DEFAULT 1. resource_revision holds revision_id, resource_id, version, actor_user_id, change_kind, patch JSONB, request_id, created_at with UNIQUE (resource_id, version). outbox_event holds aggregate_type, aggregate_id, aggregate_version, event_type, payload, status. A PUT carries the version the client read. Write the exact statements for the single transaction that applies the edit, records the revision and enqueues 'resource.updated', and give the handler's branch on zero affected rows. Then say what PostgreSQL 16 does under READ COMMITTED when two of these updates hit one row at once.

Approach

  1. One transaction, three writes, no network call inside it: UPDATE resource SET title = $3, version = version + 1, updated_at = now() WHERE resource_id = $1 AND tenant_id = $4 AND version = $2; then INSERT the resource_revision row at version $2 + 1; then INSERT the outbox_event row at the same aggregate_version. The event goes to a table rather than a broker because no transaction spans both.
  2. Branch on the affected-row count before doing anything else. Zero has three causes — stale version, wrong tenant, row gone — so re-read once and map to 409 carrying the current version, or 404 for an id outside the caller's tenant, which also stops the endpoint confirming that another tenant's id exists.
  3. State the engine behaviour instead of assuming it. Under READ COMMITTED the second UPDATE blocks on the row lock, and when the first commits PostgreSQL re-evaluates the WHERE clause against the newly committed row, so the version predicate now fails and the statement reports zero rows. Under REPEATABLE READ the identical collision raises SQLSTATE 40001 instead, so the handler must fold both shapes into one conflict response.
  4. Keep UNIQUE (resource_id, version) even though the predicate already serialises writers. It is what makes a lost update unwritable if any other path ever reaches the revision table, and it converts a logic bug into 23505 rather than into a silently missing history row.

Follow-up

  • A client sends the version it read ten minutes ago and the resource has moved three versions. What is in your 409 so it can resolve the conflict without a full re-fetch?
  • Two editors, two disjoint fields, no overlap. Does your answer still refuse the second write, and should it?

Explain the core pillars of object-oriented programming (OOP) and how you have applied them in your past proje

Medium · Technical & Core Computer Science

Explain the core pillars of object-oriented programming (OOP) and how you have applied them in your past projects.

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

What is the difference between a relational and a non-relational database, and when would you choose one over

Medium · Technical & Core Computer Science

What is the difference between a relational and a non-relational database, and when would you choose one over the other?

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

Describe what a primary key and a foreign key are, and explain their significance in database design.

Medium · Technical & Core Computer Science

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

Explain the concept of software testing. What is the difference between unit testing, integration testing, and

Medium · Technical & Core Computer Science

Explain the concept of software testing. What is the difference between unit testing, integration testing, and system testing?

Approach

  1. Say who the caller is and what they do when the call fails halfway.
  2. Define the identity of a request so a retry cannot double-apply it.
  3. Separate accepted, pending, failed and confirmed; they are different facts.
  4. Design the error taxonomy before the success shape; callers branch on it.

Follow-up

  • What happens if the caller retries after a timeout?
  • How does a client discover it is on an old version of this contract?

Walk me through the architecture of a recent software project you worked on. What were the key technical chall

Medium · Experience & Project Walkthroughs

Walk me through the architecture of a recent software project you worked on. What were the key technical challenges?

Approach

  1. Fix the scope first: who calls this, how often, and what they do when it fails.
  2. Name the read and write paths separately; they rarely have the same bottleneck.
  3. Choose a partition key and say what query it makes expensive.
  4. State the consistency you need, and where you are willing to be stale.

Follow-up

  • What breaks first when traffic grows ten times?
  • How does this behave when that dependency is down for an hour?

What is your primary area of technical expertise, and how do you stay updated with new technologies?

Medium · Experience & Project Walkthroughs

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

Describe a situation where you had to work with a legacy codebase. How did you approach understanding and impr

Medium · Experience & Project Walkthroughs

Describe a situation where you had to work with a legacy codebase. How did you approach understanding and improving it?

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

How do you prioritize tasks when working on multiple engineering deliverables with tight deadlines?

Medium · Experience & Project Walkthroughs

Approach

  1. Clarify what is being asked and what a complete answer contains.
  2. State your assumptions explicitly before working the problem.
  3. Say what you would check first and why it is the highest-information step.
  4. Work from the requirement backwards to the design.

Follow-up

  • What assumption would you test first?
  • How would you know your answer was wrong?

Walk through a simple code snippet and explain how you would debug a logical error within a nested loop.

Medium · Coding & Problem-Solving

Approach

  1. Establish what changed and when, before forming any theory.
  2. Pick a bisection that eliminates candidates whichever way it turns out.
  3. Check the instrumentation before believing the symptom.
  4. Separate the trigger from the cause; the deploy is rarely the bug.

Follow-up

  • What would you look at first, and what would it rule out?
  • How would you tell a cause from a coincidence here?

Suggested practice checklist

Built from the rounds and topics Ymca Of Greater New York candidates report.

Day 1 — Map the Ymca Of Greater New York loop

  • Write out the reported sequence: Initial Screening, Foundational Assessment, Conversational Interview, Technical Interview.
  • For each round, write one sentence on what it is judging, from the description above, and mark the one you are least ready for.

Deliverable: A one-page map of the 4 reported rounds, with the weakest marked.

Day 2 — Work Object-Oriented Programming (OOP)

  • Spend the session on Object-Oriented Programming (OOP), which Ymca Of Greater New York candidates report being tested on.
  • Write one worked example in Object-Oriented Programming (OOP) and time yourself on it.

Deliverable: One timed worked example in Object-Oriented Programming (OOP).

Day 3 — Work Arrays

  • Spend the session on Arrays, which Ymca Of Greater New York candidates report being tested on.
  • Write one worked example in Arrays and time yourself on it.

Deliverable: One timed worked example in Arrays.

Day 4 — Work Database Management Systems (DBMS)

  • Spend the session on Database Management Systems (DBMS), which Ymca Of Greater New York candidates report being tested on.
  • Write one worked example in Database Management Systems (DBMS) and time yourself on it.

Deliverable: One timed worked example in Database Management Systems (DBMS).

Day 5 — Answer out loud: Technical & Core Computer Science

  • Answer aloud, timed: Explain the core pillars of object-oriented programming (OOP) and how you have applied them in your past projects.
  • Answer aloud, timed: What is the difference between a relational and a non-relational database, and when would you choose one over the other?

Deliverable: Spoken answers to 2 reported Technical & Core Computer Science question(s), under time.

Day 6 — Answer out loud: Coding & Problem-Solving

  • Answer aloud, timed: Given an array of integers, write an algorithm to find if there are any duplicate elements.
  • Answer aloud, timed: How would you implement a two-pointer approach to reverse a string or find a target sum in a sorted array?

Deliverable: Spoken answers to 2 reported Coding & Problem-Solving question(s), under time.

Day 7 — Answer out loud: Experience & Project Walkthroughs

  • Answer aloud, timed: Walk me through the architecture of a recent software project you worked on. What were the key technical challenges?
  • Answer aloud, timed: What is your primary area of technical expertise, and how do you stay updated with new technologies?

Deliverable: Spoken answers to 2 reported Experience & Project Walkthroughs question(s), under time.

Behavioural preparation

Behavioural rounds judge the decision you made and what it cost.

How do you handle edge cases, such as null values or empty inputs, in your algorithms?

Medium · Coding & Problem-Solving

Approach

  1. Pick a story where you made the decision, not one where you watched it.
  2. State the situation in two sentences and spend the rest on the reasoning.
  3. Give the blast radius: what could have broken, and what you measured.
  4. Name the disagreement and how you resolved it with evidence.

Follow-up

  • What would you do differently if you ran that again?
  • How did you know your change caused the improvement?

Why do you want to work as a Software Engineer for a non-profit organization like the YMCA of Greater New York

Medium · Behavioral & Cultural Alignment

Why do you want to work as a Software Engineer for a non-profit organization like the YMCA of Greater New York?

Approach

  1. Pick a story where you made the decision, not one where you watched it.
  2. State the situation in two sentences and spend the rest on the reasoning.
  3. Give the blast radius: what could have broken, and what you measured.
  4. Name the disagreement and how you resolved it with evidence.

Follow-up

  • What would you do differently if you ran that again?
  • How did you know your change caused the improvement?

How do you explain complex technical concepts to non-technical stakeholders or team members?

Medium · Behavioral & Cultural Alignment

Approach

  1. Pick a story where you made the decision, not one where you watched it.
  2. State the situation in two sentences and spend the rest on the reasoning.
  3. Give the blast radius: what could have broken, and what you measured.
  4. Name the disagreement and how you resolved it with evidence.

Follow-up

  • What would you do differently if you ran that again?
  • How did you know your change caused the improvement?

Describe a time when you had to collaborate with a diverse group of people to solve a challenging problem.

Medium · Behavioral & Cultural Alignment

Approach

  1. Pick a story where you made the decision, not one where you watched it.
  2. State the situation in two sentences and spend the rest on the reasoning.
  3. Give the blast radius: what could have broken, and what you measured.
  4. Name the disagreement and how you resolved it with evidence.

Follow-up

  • What would you do differently if you ran that again?
  • How did you know your change caused the improvement?

What are your career expectations, and what is your preferred working style within an engineering team?

Medium · Behavioral & Cultural Alignment

Approach

  1. Pick a story where you made the decision, not one where you watched it.
  2. State the situation in two sentences and spend the rest on the reasoning.
  3. Give the blast radius: what could have broken, and what you measured.
  4. Name the disagreement and how you resolved it with evidence.

Follow-up

  • What would you do differently if you ran that again?
  • How did you know your change caused the improvement?