cswork / libraryOpen practice workspace

Interview guides · Prasad Corporation Pvt

Prasad Corporation Pvt Software Engineer Interview Guide

Prasad Corporation Pvt Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

A Software Engineer at Prasad Corporation Pvt plays a pivotal role in designing, implementing, and maintaining the software systems that drive the organization's business objectives. You will be responsible for translating complex requirements into robust, scalable code, working across the full development lifecycle to ensure that our products meet the high standards our users expect. Whether you are working on mobile applications using frameworks like Flutter, managing data within NoSQL environments, or optimizing backend systems, your work directly influences the efficiency and reliability of our technology stack. This role is critical to the company because it sits at the intersection of technical innovation and business utility.

This guide is scoped to a Software Engineer candidate at Prasad Corporation Pvt.

Focus areas

  • System Design
  • Networking Fundamentals
  • Problem Solving

The Prasad Corporation Pvt interview process

Prasad Corporation Pvt 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 fit.

What to demonstrate

  • The process begins with an initial screening to assess candidate fit
  • Depth in System Design

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.

Technical Assessments

Candidates undergo technical assessments to evaluate their technical depth.

What to demonstrate

  • Candidates undergo technical assessments to evaluate their technical depth
  • Depth in System Design

How to prepare

  • Answer aloud and timed: Can you explain the difference between public and private IP addresses?
  • Answer aloud and timed: How do DNS and DHCP function within a networking context?

Multiple Interview Rounds

Candidates participate in multiple interview rounds focusing on both technical and cultural alignment.

What to demonstrate

  • Candidates participate in multiple interview rounds focusing on both technical and cultural alignment
  • Depth in System Design

How to prepare

  • Answer aloud and timed: Explain the difference between early and late analysis in physical design.
  • Answer aloud and timed: Can you solve a coding problem that requires calculating the product of all elements in an array except for the value at the current index?

Final Managerial Reviews

The process concludes with final reviews by management to make hiring decisions.

What to demonstrate

  • The process concludes with final reviews by management to make hiring decisions
  • Depth in System Design

How to prepare

  • Answer aloud and timed: How do you approach writing basic programs to solve logical problems?
  • Answer aloud and timed: What is your process for debugging code when a system failure occurs?

Where candidates lose points

Structure your answers

Use clear, logical steps when explaining your technical solutions to ensure the interviewer can follow your thought process.

Know your resume

Be prepared to discuss every project listed on your resume in depth, including the specific role you played and the challenges you overcame.

Engage with the interviewer

Treat the interview as a conversation rather than an interrogation; asking insightful questions about our tech stack shows real interest.

Practice coding on a whiteboard or paper

Sometimes you will be asked to write code without an IDE, so ensure you are comfortable with syntax and structure in a plain text environment.

Questions & practice

How do you declare an array, and what is the syntax for common conditional elements?

Medium · Technical and Domain Knowledge

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?

Can you solve a coding problem that requires calculating the product of all elements in an array except for th

Medium · Coding and Problem Solving

Can you solve a coding problem that requires calculating the product of all elements in an array except for the value at the current index?

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 approach writing basic programs to solve logical problems?

Medium · Coding and 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?

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?

Find version gaps and relay lag with window functions

Medium · window functions · event tables · frame semantics

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

  1. 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.
  2. 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.
  3. 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.
  4. 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?

What is Object-Oriented Programming (OOP), and can you provide examples for each principle?

Medium · Technical and Domain Knowledge

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?

Can you explain the difference between public and private IP addresses?

Medium · Technical and Domain Knowledge

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 DNS and DHCP function within a networking context?

Medium · Technical and Domain Knowledge

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 difference between early and late analysis in physical design.

Medium · Technical and Domain Knowledge

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 your process for debugging code when a system failure occurs?

Medium · Coding and 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 Prasad Corporation Pvt candidates report.

Day 1 — Map the Prasad Corporation Pvt loop

  • Write out the reported sequence: Initial Screening, Technical Assessments, Multiple Interview Rounds, Final Managerial Reviews.
  • 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 System Design

  • Spend the session on System Design, which Prasad Corporation Pvt candidates report being tested on.
  • Write one worked example in System Design and time yourself on it.

Deliverable: One timed worked example in System Design.

Day 3 — Work Networking Fundamentals

  • Spend the session on Networking Fundamentals, which Prasad Corporation Pvt candidates report being tested on.
  • Write one worked example in Networking Fundamentals and time yourself on it.

Deliverable: One timed worked example in Networking Fundamentals.

Day 4 — Work Problem Solving

  • Spend the session on Problem Solving, which Prasad Corporation Pvt candidates report being tested on.
  • Write one worked example in Problem Solving and time yourself on it.

Deliverable: One timed worked example in Problem Solving.

Day 5 — Answer out loud: Technical and Domain Knowledge

  • Answer aloud, timed: What is Object-Oriented Programming (OOP), and can you provide examples for each principle?
  • Answer aloud, timed: How do you declare an array, and what is the syntax for common conditional elements?

Deliverable: Spoken answers to 2 reported Technical and Domain Knowledge question(s), under time.

Day 6 — Answer out loud: Coding and Problem Solving

  • Answer aloud, timed: Can you solve a coding problem that requires calculating the product of all elements in an array except for the value at the current index?
  • Answer aloud, timed: How do you approach writing basic programs to solve logical problems?

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

Day 7 — Answer out loud: Behavioral and Leadership

  • Answer aloud, timed: Tell me about yourself.
  • Answer aloud, timed: Where do you see yourself in the next five years?

Deliverable: Spoken answers to 2 reported Behavioral and Leadership question(s), under time.

Behavioural preparation

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

Tell me about yourself.

Medium · Behavioral and 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?

Where do you see yourself in the next five years?

Medium · Behavioral and 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 are your primary strengths and weaknesses?

Medium · Behavioral and 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?

Why did you choose to apply to Prasad Corporation Pvt?

Medium · Behavioral and 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?