cswork / libraryOpen practice workspace

Interview guides · Clearwater Analytics (CWAN)

Clearwater Analytics (CWAN) Software Engineer Interview Guide

Clearwater Analytics (CWAN) Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

As a Software Engineer at Clearwater Analytics (CWAN), you are at the heart of a high-growth, mission-critical financial technology ecosystem. You will be responsible for building and maintaining the scalable, high-performance platforms that institutional investors rely on for investment accounting, reporting, and analytics. Your work directly impacts how global financial institutions manage trillions of dollars in assets, necessitating a high degree of precision, reliability, and architectural foresight. This role is not just about writing code; it is about solving complex data problems within a distributed, enterprise-grade environment. You will contribute to the evolution of the company’s core technology stack, transitioning legacy architectures toward modern, cloud-native microservices while ensuring zero-downtime performance.

This guide is scoped to a Software Engineer candidate at Clearwater Analytics (CWAN).

Focus areas

  • Java
  • Object-Oriented Programming (OOP)
  • Algorithmic Problem Solving

The Clearwater Analytics (CWAN) interview process

Clearwater Analytics (CWAN) candidates report 5 rounds over 4-6 weeks. The stages below are what candidates describe, not a published process.

Online Assessment

Initial assessment to evaluate coding skills and technical knowledge.

What to demonstrate

  • Initial assessment to evaluate coding skills and technical knowledge
  • Depth in Java

How to prepare

  • Answer aloud and timed: Reverse an integer or string without using built-in library functions.
  • Answer aloud and timed: Given an array, find the sum of two values that equal a target number.

Recruiter Screening

Discussion with a recruiter to assess fit for the role and company.

What to demonstrate

  • Discussion with a recruiter to assess fit for the role and company
  • Depth in Java

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.

Interactive Coding Rounds

Multiple rounds of coding interviews focusing on problem-solving and coding efficiency.

What to demonstrate

  • Multiple rounds of coding interviews focusing on problem-solving and coding efficiency
  • Depth in Java

How to prepare

  • Answer aloud and timed: Determine if a number is prime or calculate the Fibonacci sequence using recursion vs. iteration.
  • Answer aloud and timed: Design a class to model a logic circuit (e.g., AND/OR gates).

Architectural Discussions

Discussions on system design and architecture to evaluate design skills.

What to demonstrate

  • Discussions on system design and architecture to evaluate design skills
  • Depth in Java

How to prepare

  • Answer aloud and timed: How would you model a library system or a vehicle fleet using classes?
  • Answer aloud and timed: Explain the principles of polymorphism and how you apply them in your projects.

Final Rounds

Comprehensive evaluation of skills and team dynamics through various interviews.

What to demonstrate

  • Comprehensive evaluation of skills and team dynamics through various interviews
  • Depth in Java

How to prepare

  • Answer aloud and timed: Discuss how you handle parameter passing and constructor design in Java or C#.
  • Answer aloud and timed: Design a URL shortening service (TinyURL).

Where candidates lose points

Think Aloud

Your interviewer wants to hear your logic. If you are stuck, communicate your thought process rather than staying silent.

Ask Clarifying Questions

Never jump straight into coding. Ask about constraints, edge cases, and the expected scale of the problem.

Prepare Your "Why

Be ready to explain why you want to work at Clearwater Analytics (CWAN) specifically, beyond just the desire for a job.

Practice Whiteboarding

Even in virtual interviews, you will often use shared editors that mimic a whiteboard. Practice writing code without the help of IDE auto-completion.

Questions & practice

Reverse an integer or string without using built-in library functions.

Medium · Technical & Algorithmic Proficiency

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?

Given an array, find the sum of two values that equal a target number.

Medium · Technical & Algorithmic Proficiency

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?

Implement a custom Queue using two Stacks.

Medium · Technical & Algorithmic Proficiency

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?

Explain the difference between various sorting algorithms and their time complexities.

Medium · Technical & Algorithmic Proficiency

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?

Determine if a number is prime or calculate the Fibonacci sequence using recursion vs. iteration.

Medium · Technical & Algorithmic Proficiency

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?

Explain your approach to database schema design for a high-volume application.

Medium · System Design & Architecture

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?

Denormalise tenant onto revisions and backfill it live

Hard · denormalisation · online migration · backfill

resource_revision (revision_id, resource_id, version, actor_user_id, change_kind, patch, request_id, created_at) has 400M rows and no tenant column; tenant_id lives only on resource. Two reads need it: a tenant-scoped audit feed ordered by created_at DESC, and an offboarding purge. Both join back to resource today. Justify adding tenant_id to resource_revision against those two reads, name the anomaly the copy introduces and the constraint that prevents it, then give the ordered migration for a live table taking 1.2k writes/second — the lock each step takes, how the backfill is batched, and where each step stops being reversible. PostgreSQL 16.

Approach

  1. Justify from the access path rather than from taste. Without the column, the audit feed either scans resource_revision by created_at and discards other tenants' rows, or resolves the tenant's resource_ids first and probes with them — both proportional to the tenant's whole history rather than to one page. With (tenant_id, created_at DESC, revision_id DESC) it is a seek that stops at 50 rows, and the purge becomes a ranged delete instead of a join.
  2. Name the cost exactly: a second copy of a fact can disagree with the first. Make the disagreement unwritable rather than documented — add UNIQUE (resource_id, tenant_id) on resource so it can serve as a foreign-key target, then FOREIGN KEY (resource_id, tenant_id) REFERENCES resource (resource_id, tenant_id) on the revision table. A revision can then only ever carry its parent's tenant.
  3. Step one, expand: ALTER TABLE resource_revision ADD COLUMN tenant_id BIGINT NULL, with no default, so it is a catalogue change and no rewrite. It still needs ACCESS EXCLUSIVE for an instant, and that instant queues behind the longest open transaction on the table while every later query queues behind it — set lock_timeout to 2s and retry rather than wait.
  4. Step two, dual-write: deploy the writer that populates tenant_id on every new revision while reads still use the join. Reversible by redeploying the previous build, because nothing reads the column yet.

Follow-up

  • The backfill is half finished and a rollback is required. What state is the table in, and what does the previous build do with a half-populated column?
  • How do you verify the backfill actually finished, given rows are still being inserted while it runs?

Design a class to model a logic circuit (e.g., AND/OR gates).

Medium · Object-Oriented Design (OOD)

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?

How would you model a library system or a vehicle fleet using classes?

Medium · Object-Oriented Design (OOD)

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 principles of polymorphism and how you apply them in your projects.

Medium · Object-Oriented Design (OOD)

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?

Discuss how you handle parameter passing and constructor design in Java or C#.

Medium · Object-Oriented Design (OOD)

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?

Design a URL shortening service (TinyURL).

Medium · System Design & Architecture

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?

How would you transition a monolithic application into a microservices architecture?

Medium · System Design & Architecture

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?

Listing latency scales with page size, not with filters

Easy · n+1 · latency · query batching

The tenant listing endpoint reads resource filtered by tenant_id and status, ordered by updated_at DESC, and returns each row plus the owner's display name from app_user and the actor of that resource's latest resource_revision. p99 is 55 ms at 10 rows per page and 1.4 s at 200. Database telemetry shows 401 statements per request, each under 1 ms, and nothing in the slow-query log. Diagnose the cause and give the fix, stating the statement count per request and the p99 you expect afterwards.

Approach

  1. Read the counters before forming a theory. 401 statements for 200 rows is one driver query plus two per row, and sub-millisecond execution with an empty slow-query log rules out a bad plan. The time is round trips, which is why it is invisible in every per-query metric and scales with rows returned rather than with filter selectivity.
  2. Name the two per-row statements from their normalised text: a single-row app_user lookup by user_id, and a resource_revision lookup by resource_id ordered by version DESC LIMIT 1. Confirm by dropping those two response fields and watching the statement count fall to one. That locates the calls in the serialisation layer, not the repository.
  3. Check that the arithmetic accounts for the whole gap. Measure one round trip to the replica in isolation; 400 trips at roughly 3 ms of network plus 0.2 ms of execution is about 1.3 s on top of a 55 ms baseline, which matches. If the multiplication had fallen short, the N+1 would only be part of the story and you would keep looking.
  4. Batch both lookups. Collect owner_user_ids and resource_ids from the driver query, then issue WHERE tenant_id = $1 AND user_id = ANY($2) for the users, and PostgreSQL's SELECT DISTINCT ON (resource_id) ... WHERE resource_id = ANY($2) ORDER BY resource_id, version DESC for the latest revision, which the UNIQUE (resource_id, version) index serves directly. On an engine without DISTINCT ON, use a lateral join or a row_number window. Three statements per request at any page size.

Follow-up

  • The page size is capped at 200 today. What breaks first if it is raised to 2,000, and is it still this bug?
  • How do you stop the next N+1 from reaching production, given that no individual query is slow and the endpoint's tests pass?

Suggested practice checklist

Built from the rounds and topics Clearwater Analytics (CWAN) candidates report.

Day 1 — Map the Clearwater Analytics (CWAN) loop

  • Write out the reported sequence: Online Assessment, Recruiter Screening, Interactive Coding Rounds, Architectural Discussions, Final Rounds.
  • 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 5 reported rounds, with the weakest marked.

Day 2 — Work Java

  • Spend the session on Java, which Clearwater Analytics (CWAN) candidates report being tested on.
  • Write one worked example in Java and time yourself on it.

Deliverable: One timed worked example in Java.

Day 3 — Work Object-Oriented Programming (OOP)

  • Spend the session on Object-Oriented Programming (OOP), which Clearwater Analytics (CWAN) 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 4 — Work Algorithmic Problem Solving

  • Spend the session on Algorithmic Problem Solving, which Clearwater Analytics (CWAN) candidates report being tested on.
  • Write one worked example in Algorithmic Problem Solving and time yourself on it.

Deliverable: One timed worked example in Algorithmic Problem Solving.

Day 5 — Answer out loud: Technical & Algorithmic Proficiency

  • Answer aloud, timed: Reverse an integer or string without using built-in library functions.
  • Answer aloud, timed: Given an array, find the sum of two values that equal a target number.

Deliverable: Spoken answers to 2 reported Technical & Algorithmic Proficiency question(s), under time.

Day 6 — Answer out loud: Object-Oriented Design (OOD)

  • Answer aloud, timed: Design a class to model a logic circuit (e.g., AND/OR gates).
  • Answer aloud, timed: How would you model a library system or a vehicle fleet using classes?

Deliverable: Spoken answers to 2 reported Object-Oriented Design (OOD) question(s), under time.

Day 7 — Answer out loud: System Design & Architecture

  • Answer aloud, timed: Design a URL shortening service (TinyURL).
  • Answer aloud, timed: How would you transition a monolithic application into a microservices architecture?

Deliverable: Spoken answers to 2 reported System Design & Architecture question(s), under time.

Behavioural preparation

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

How do you handle CI/CD, multithreading, or cloud integration in your projects?

Medium · System Design & Architecture

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 you had to explain a complex technical concept to a non-technical stakeholder.

Medium · Behavioral & Leadership

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 handle disagreements with teammates regarding technical implementation?

Medium · Behavioral & Leadership

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 motivates you to work in computer science, and why Clearwater Analytics (CWAN)?

Medium · Behavioral & Leadership

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 recent technical challenge you solved outside of your regular work requirements.

Medium · Behavioral & Leadership

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?