As a Software Engineer within the NSW Government, you play a vital role in delivering digital infrastructure that supports the citizens of New South Wales. Your work directly impacts the stability, scalability, and security of public-facing services. Whether you are working on backend systems, server infrastructure, or full-stack application development, your contributions ensure that critical government functions remain accessible and efficient for millions of residents. This role is unique because it combines the technical challenges of large-scale systems engineering with the mission-driven nature of public service. You will navigate complex architectural requirements, often dealing with legacy modernization and high-availability systems. It is a position for engineers who value stability, rigorous documentation, and the broader societal impact of their code. 02 · Compensation
Application Review
reportedInitial review of submitted applications to assess qualifications and fit.
What to demonstrate
- Initial review of submitted applications to assess qualifications and fit
- Depth in Systems engineering (server team)
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.
Online Cognitive Testing
reportedCandidates may undergo online cognitive tests to evaluate problem-solving abilities.
What to demonstrate
- Candidates may undergo online cognitive tests to evaluate problem-solving abilities
- Depth in Systems engineering (server team)
How to prepare
- Answer aloud and timed: What is your experience with cloud migration strategies for legacy government systems?
- Answer aloud and timed: How do you ensure security compliance when deploying new software updates?
Psychometric Evaluations
reportedAssessment of candidates' personality traits and cognitive styles through psychometric tests.
What to demonstrate
- Assessment of candidates' personality traits and cognitive styles through psychometric tests
- Depth in Systems engineering (server team)
How to prepare
- Answer aloud and timed: Describe a time you had to optimize a system for better performance or lower latency.
- Answer aloud and timed: Describe a time you had to explain a complex technical issue to a non-technical stakeholder.
Structured Interviews
reportedCandidates participate in structured interviews to assess technical and cultural fit.
What to demonstrate
- Candidates participate in structured interviews to assess technical and cultural fit
- Depth in Systems engineering (server team)
How to prepare
- Answer aloud and timed: How do you prioritize tasks when working on multiple high-priority projects simultaneously?
- Answer aloud and timed: Tell us about a time you disagreed with a team member’s technical approach. How did you resolve it?
Assessment Center
reportedInvolves group activities and panel interviews to evaluate candidates in a collaborative setting.
What to demonstrate
- Involves group activities and panel interviews to evaluate candidates in a collaborative setting
- Depth in Systems engineering (server team)
How to prepare
- Answer aloud and timed: How do you handle working under strict regulatory or policy constraints?
- Answer aloud and timed: What motivates you to work in the public sector compared to the private sector?
Final Offer
reportedSuccessful candidates receive a final offer after completing all assessment stages.
What to demonstrate
- Successful candidates receive a final offer after completing all assessment stages
- Depth in Systems engineering (server team)
How to prepare
- Work Systems engineering (server team) until you can explain it without notes
- Work Server infrastructure concepts until you can explain it without notes
PracHub editorial advice for the preparation topics above.
Prioritize Documentation
In your interviews, emphasize your commitment to clean code and thorough documentation. This is highly valued by government engineering teams.
Understand the Mission
Spend time researching the specific department or project you are interviewing for. Connecting your technical skills to the public value of the project will resonate well with interviewers.
Structured Communication
Use the STAR method (Situation, Task, Action, Result) to answer behavioral questions. It keeps your answers concise and ensures you hit the key points the interviewers are looking for.
Be prepared for a long hiring cycle
Keep applying for other roles to maintain your momentum while waiting for feedback from the government process.
Choose a category, try a prompt, then open its approach, worked solution or follow-up when you need it.
Identify the heaviest tenants in a five-minute window under memory pressure
The edge service handles about 3,000 requests per second across roughly 50,000 tenants, peaking near 9,000. Expose the 50 heaviest tenants by request count over the trailing five minutes so limits can be tightened before one tenant's backfill starves the fleet. You may not retain five minutes of raw records. Give the exact solution and its memory, then the bounded-memory approximation with its error stated as a formula, and say which you would ship and at what tenant cardinality that choice changes.
Approach
- Do the exact version first, because it is affordable at this cardinality: a ring of 300 one-second counters per tenant, advanced lazily, is 1,200 bytes of counters per tenant and roughly 60 to 90 MB for 50,000 tenants with overhead. Carry a running total and subtract the bucket you overwrite so a window read is O(1) rather than 300 adds.
- Extract the top 50 with a size-k min-heap over the tenant sums: O(d log k) for d tenants, against O(d log d) to sort them all. Maintaining the heap continuously instead of on query requires a tenant-to-heap-index map, because incrementing a count already inside the heap means sifting from a known position, and without that map you rebuild the heap on every request.
- State the approximation precisely rather than gesturing at sketches. Misra-Gries with m counters retains every item whose true count exceeds N/(m+1), and each retained count underestimates the truth by at most N/(m+1). With m = 1,000 and N = 900,000 requests in the window the error is roughly 900 requests, which is fine for spotting a tenant sending 50,000 and useless for ranking two tenants 200 apart.
- Say what breaks when the window slides: Misra-Gries and Space-Saving are insert-only and cannot be decremented as records age out. The workable construction is one summary per sub-window, say ten seconds, with 30 summaries merged at query time, and the merged error is the sum of the per-summary errors, so the bound degrades linearly in the number of sub-windows.
Follow-up
- The heaviest tenant is heavy because of one export job rather than user traffic. Should the limiter treat those as the same tenant?
- Two tenants sit tied at the boundary of the top 50. Does your answer flap, and does the flapping matter?
Merge partitioned event streams into one ordered feed with bounded lateness
The read-model service consumes 64 log partitions carrying about 4,000 events per second in total. Each partition is ordered within itself, but partitions drift by up to 30 seconds, and the activity feed must present a tenant's events in occurred_at order. Produce the merge. State its complexity, the buffer it requires in events and in bytes, what happens when one partition is idle, and what you do with an event that arrives after you have already emitted its position. Payloads average 1 KB.
Approach
- Merge with a min-heap over the 64 partition heads keyed on (occurred_at, event_id): O(log P) per event and O(n log P) overall. The tie-break on event_id is what makes the output deterministic when two partitions carry the same millisecond, which matters because the feed is paginated and a non-deterministic order reorders pages under the reader.
- Emitting the heap head is only correct once every partition has produced everything up to that timestamp, so the emit condition is a watermark: the minimum across partitions of the highest occurred_at seen, less the allowed lateness. Events are held until the watermark passes them, which is what turns individually ordered streams into a jointly ordered one.
- Size the buffer from the lateness rather than guessing: 4,000 events per second times 30 seconds is 120,000 buffered events, and at 1 KB each about 120 MB of heap. That number is the real price of the ordering guarantee and belongs in front of whoever asked for it.
- Handle the idle partition explicitly, because it fails the feed rather than corrupting it: a partition with no traffic never advances its own maximum, so the watermark freezes and output stops entirely. Either every partition emits a periodic idle marker carrying the broker's current time, or the watermark falls back to wall clock for a partition silent beyond a threshold.
Follow-up
- The lateness budget is raised to five minutes. What is the new buffer, and what besides memory changes?
- The consumer restarts. Where does it resume from, and what does the feed look like for the first 30 seconds?
Collapse a redelivered event batch into per-aggregate high-water marks
You drain a batch of up to 5,000,000 events, each (aggregate_id BIGINT, aggregate_version INT, event_type, payload). The log guarantees order within one aggregate only; the batch merges 64 partitions, and a relay failover has redelivered a range, so an older version for an aggregate can appear after a newer one. Given a map of last_applied_version per aggregate, produce the events worth applying, at most one per (aggregate_id, version), plus the count discarded. Target O(n) time. State the memory for 2,000,000 distinct aggregates and what you do when it does not fit.
Approach
- One pass, one hash map from aggregate_id to the highest version kept, and a discard counter. An event whose version is at or below last_applied_version for its aggregate is dropped without further work, which is the whole reason the event carries its version rather than a delta. O(n) expected time, O(d) space in distinct aggregates.
- Keep the maximum, never the last occurrence. The redelivered range means the final appearance of an aggregate in the batch can be an older version than one seen earlier in the same batch, so last-wins applies stale state over newer state and the projection regresses with no error anywhere.
- Cost the memory instead of calling it large: an 8-byte key plus a 4-byte version is 12 bytes of payload, and an open-addressed table held at a 0.7 load factor costs roughly 17 bytes per entry before per-slot metadata, so 2,000,000 aggregates is tens of megabytes in a native layout and several times that in a runtime that boxes both key and value.
- If the distinct set exceeds memory, partition on hash(aggregate_id) mod P and reduce each partition independently. Every event for one aggregate hashes to the same partition, so the per-partition result is exact and the merge is concatenation rather than a second reduction.
Follow-up
- The payload is a patch rather than a snapshot, so applying only the highest version loses the intermediate changes. What changes in your reduction?
- How do you detect that version 7 arrived while version 6 was never delivered, and what should the consumer do about the gap?
Denormalise tenant onto revisions and backfill it live
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
- 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.
- 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.
- 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.
- 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?
Find version gaps and relay lag with window functions
outbox_event holds event_id, aggregate_type, aggregate_id, aggregate_version, event_type, payload, status ('pending','published','dead'), attempts, created_at, published_at. A projection is missing rows and you must decide whether the relay skipped events or the consumer dropped them. Write three queries over the last seven days: one listing every aggregate_id whose published aggregate_version sequence has a hole, one giving per-day counts with a running total, and one returning the newest published event per aggregate. For each, say where the window function is evaluated relative to WHERE and LIMIT. PostgreSQL 16.
Approach
- Gaps: compute lead(aggregate_version) OVER (PARTITION BY aggregate_id ORDER BY aggregate_version) in a subquery, then filter next_version <> aggregate_version + 1 in the outer query. Window functions are evaluated after WHERE, GROUP BY and HAVING and before the outer ORDER BY and LIMIT, so the predicate cannot sit in the same WHERE clause and PostgreSQL 16 has no QUALIFY.
- Say what the seven-day filter does to the answer: it truncates every partition, so the first row per aggregate has no predecessor inside the window and a hole spanning the boundary is invisible. Widen the window, or join to resource.version as the authority for the true maximum.
- Running total: SELECT date_trunc('day', created_at) AS d, count() AS n, sum(count()) OVER (ORDER BY date_trunc('day', created_at) ROWS UNBOUNDED PRECEDING). An aggregate inside a window call is legal because grouping runs before windowing. The grouping key is unique per row here so ROWS and RANGE agree, but write the frame anyway — over ungrouped rows with tied timestamps the default RANGE frame pulls in every peer row and the total jumps.
- Newest per aggregate: DISTINCT ON (aggregate_id) ... ORDER BY aggregate_id, aggregate_version DESC is the cheap PostgreSQL-only form when an index matches that order; row_number() OVER (PARTITION BY aggregate_id ORDER BY aggregate_version DESC) = 1 is the portable form and needs a subquery for the same evaluation-order reason as the gap query.
Follow-up
- Relay failover redelivers events. Does a duplicate break the gap query, and how would you detect one from this table alone?
- Turn the gap check into a continuous monitor rather than a query someone runs after an incident. What does it watch?
How do you manage and monitor high-availability server environments?
How do you manage and monitor high-availability server environments?
Approach
- Clarify what is being asked and what a complete answer contains.
- State your assumptions explicitly before working the problem.
- Say what you would check first and why it is the highest-information step.
- 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 ensure security compliance when deploying new software updates?
How do you ensure security compliance when deploying new software updates?
Approach
- Clarify what is being asked and what a complete answer contains.
- State your assumptions explicitly before working the problem.
- Say what you would check first and why it is the highest-information step.
- Work from the requirement backwards to the design.
Follow-up
- What assumption would you test first?
- How would you know your answer was wrong?
Can you explain your approach to troubleshooting a critical system failure in production?
Can you explain your approach to troubleshooting a critical system failure in production?
Approach
- Establish what changed and when, before forming any theory.
- Pick a bisection that eliminates candidates whichever way it turns out.
- Check the instrumentation before believing the symptom.
- 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?
Built from the rounds and topics NSW Government candidates report.
Prepare, practise & reflect
One practical outcome each day. Spend longer where you need it.
0 / 7 done01Map the NSW Government loop
- Write out the reported sequence: Application Review, Online Cognitive Testing, Psychometric Evaluations, Structured Interviews, Assessment Center, Final Offer.
- 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 6 reported rounds, with the weakest marked.
02Work Systems engineering (server team)
- Spend the session on Systems engineering (server team), which NSW Government candidates report being tested on.
- Write one worked example in Systems engineering (server team) and time yourself on it.
Deliverable: One timed worked example in Systems engineering (server team).
03Work Server infrastructure concepts
- Spend the session on Server infrastructure concepts, which NSW Government candidates report being tested on.
- Write one worked example in Server infrastructure concepts and time yourself on it.
Deliverable: One timed worked example in Server infrastructure concepts.
04Work Online technical exercise
- Spend the session on Online technical exercise, which NSW Government candidates report being tested on.
- Write one worked example in Online technical exercise and time yourself on it.
Deliverable: One timed worked example in Online technical exercise.
05Answer out loud: Technical and Domain Knowledge
- Answer aloud, timed: How do you manage and monitor high-availability server environments?
- Answer aloud, timed: Can you explain your approach to troubleshooting a critical system failure in production?
Deliverable: Spoken answers to 2 reported Technical and Domain Knowledge question(s), under time.
06Answer out loud: Behavioral and Situational
- Answer aloud, timed: Describe a time you had to explain a complex technical issue to a non-technical stakeholder.
- Answer aloud, timed: How do you prioritize tasks when working on multiple high-priority projects simultaneously?
Deliverable: Spoken answers to 2 reported Behavioral and Situational question(s), under time.
07Dry run for NSW Government
- Run one full mock under time, then write down the two questions you most want to ask your interviewers.
Deliverable: A completed timed mock and two questions to ask.
Expand any day for tasks and deliverables. Your progress is saved on this device.
Behavioural rounds judge the decision you made and what it cost.
What is your experience with cloud migration strategies for legacy government systems?
What is your experience with cloud migration strategies for legacy government systems?
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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 optimize a system for better performance or lower latency.
Describe a time you had to optimize a system for better performance or lower latency.
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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 issue to a non-technical stakeholder.
Describe a time you had to explain a complex technical issue to a non-technical stakeholder.
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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 prioritize tasks when working on multiple high-priority projects simultaneously?
How do you prioritize tasks when working on multiple high-priority projects simultaneously?
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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?
Tell us about a time you disagreed with a team member’s technical approach. How did you resolve it?
Tell us about a time you disagreed with a team member’s technical approach. How did you resolve it?
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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 working under strict regulatory or policy constraints?
How do you handle working under strict regulatory or policy constraints?
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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 the public sector compared to the private sector?
What motivates you to work in the public sector compared to the private sector?
Approach
- Pick a story where you made the decision, not one where you watched it.
- State the situation in two sentences and spend the rest on the reasoning.
- Give the blast radius: what could have broken, and what you measured.
- 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?
- 01
What is your experience with cloud migration strategies for legacy government systems?
- 02
Describe a time you had to optimize a system for better performance or lower latency.
- 03
Describe a time you had to explain a complex technical issue to a non-technical stakeholder.
- 04
How do you prioritize tasks when working on multiple high-priority projects simultaneously?
How long should I expect the interview process to take?
The process can vary significantly, often taking anywhere from 1.5 to 6 months depending on the volume of candidates and the specific hiring cycle. Patience and consistent follow-up are key.
NSW Government Software Engineer candidate reports ↗Is the technical testing representative of actual work?
Expect a mix of standardized testing and role-specific assessments. Some candidates find the tests broad, so focus your preparation on core computer science fundamentals and general systems engineering principles.
NSW Government Software Engineer candidate reports ↗What differentiates successful candidates?
Successful candidates are those who balance technical depth with the ability to articulate their decision-making process clearly. Showing an understanding of the impact your work has on the public is a major differentiator.
NSW Government Software Engineer candidate reports ↗Is the work environment collaborative?
Yes, you will work closely with diverse, cross-functional teams. The environment is generally supportive, though it adheres to formal processes and hierarchies common in government.
NSW Government Software Engineer candidate reports ↗What topics does NSW Government test in interviews?
NSW Government interviews most often cover Data Quality Management, Data Analysis, Data Warehousing, Data Governance, and Stakeholder Management. The exact emphasis depends on the specific role you apply for.
NSW Government Software Engineer candidate reports ↗Sources & methodology 3 sources ↗
No official company page is cited. Rounds and questions come from candidate reports and PracHub editorial material; each source shows the date it was read.
- 01NSW Government Software Engineer candidate reports ↗
Company-reported rounds, questions and FAQ.
Candidate reports · Accessed 2026-09-22 - 02PracHub Software Engineer practice ↗
PracHub practice material, not company-reported.
PracHub page · Accessed 2026-09-22 - 03PracHub preparation framework ↗
PracHub preparation guidance.
PracHub page · Accessed 2026-09-22
Explore related engineering environments and compare the preparation focus.
Vercel Software Engineer Interview Guide
Debugging practice for Vercel software engineer prep built on a reproduction you trust, narrowing to the smallest failing input, and changing one variable per run so the result stays attributable.
CoreWeave Software Engineer Interview Guide
Failure-handling practice for CoreWeave software engineer candidates: requests whose outcome a timeout leaves unknown, where a retry is safe, and deduplicating at the receiver instead of assuming exactly-once delivery.
Confluent Software Engineer Interview Guide
Concurrency exercises for Confluent candidates: check-then-act races, deadlock from inconsistent lock ordering, and why two individually atomic operations do not compose into an atomic update.
Capital One Software Engineer Interview Guide
Code-reading and review practice for Capital One candidates: tracing unfamiliar control flow, finding the invariant a function quietly depends on, and separating a correctness defect from a matter of taste.