cswork / libraryOpen practice workspace

Interview guides · Pt. Intikom Berlian Mustika

Pt. Intikom Berlian Mustika Software Engineer Interview Guide

Pt. Intikom Berlian Mustika Software Engineer interview guide: reported rounds, questions and how candidates describe the process.

The 60-second brief

As a Software Engineer at Pt. Intikom Berlian Mustika, you play a critical role in driving digital transformation for some of Indonesia's largest enterprises. Operating as a premier IT system integrator and solutions provider, the company relies on its engineering team to design, develop, and deploy highly scalable software systems. Whether you are specializing as an Oracle Developer or a.NET Programmer, your work directly impacts the operational efficiency and technological capabilities of clients across the financial, manufacturing, retail, and public sectors. The engineering team at Pt. Intikom Berlian Mustika focuses on building robust enterprise applications that handle massive transaction volumes and complex business logic.

This guide is scoped to a Software Engineer candidate at Pt. Intikom Berlian Mustika.

Focus areas

  • .NET Development
  • Oracle Development
  • C#

The Pt. Intikom Berlian Mustika interview process

Pt. Intikom Berlian Mustika candidates report 4 rounds over 3-5 weeks. The stages below are what candidates describe, not a published process.

HR Interview

Assess your background, career aspirations, and cultural fit, focusing on communication skills and behavioral traits.

What to demonstrate

  • Assess your background, career aspirations, and cultural fit
  • Focusing on communication skills and behavioral traits

How to prepare

  • Answer aloud and timed: Explain the difference between a clustered and a non-clustered index, and when you would use each.
  • Answer aloud and timed: How do you optimize a slow-performing SQL query that involves multiple table joins?

Technical Evaluation

Rigorous assessment tailored to your specific stack, evaluating coding standards, database knowledge, and system design capabilities.

What to demonstrate

  • Rigorous assessment tailored to your specific stack, evaluating coding standards, database knowledge, and system design capabilities
  • Depth in .NET Development

How to prepare

  • Answer aloud and timed: What are the differences between a stored procedure and a function in Oracle Database?
  • Answer aloud and timed: Describe a scenario where you would use a database trigger, and explain the performance risks associated with it.

Medical Test

Standard medical test to confirm physical health and fitness for duty, typically funded by the company.

What to demonstrate

  • Standard medical test to confirm physical health and fitness for duty, typically funded by the company
  • Depth in .NET Development

How to prepare

  • Answer aloud and timed: How do you handle transaction management and rollbacks in PL/SQL?
  • Answer aloud and timed: What is the difference between ASP.NET MVC and ASP.NET Web API?

Contract Discussion

Formal discussion of employment terms, benefits, and project deployment details.

What to demonstrate

  • Formal discussion of employment terms, benefits, and project deployment details
  • Depth in .NET Development

How to prepare

  • Answer aloud and timed: Explain the concept of Dependency Injection in.NET Core and how it improves code maintainability.
  • Answer aloud and timed: How does the Common Language Runtime (CLR) manage memory, and what is the role of the Garbage Collector?

Where candidates lose points

Master the fundamentals of SQL

Regardless of your specialization, database operations are central to the company's projects. Be ready to write joins, subqueries, and analytical functions on a whiteboard or shared editor.

Be ready to discuss system integration

Since the company is a system integrator, structure your project descriptions around how your software connected with other systems, APIs, or legacy databases.

Understand the enterprise context

Frame your answers around reliability, security, and scalability. Enterprise clients value stable, secure code over experimental technologies.

Questions & practice

How does the Common Language Runtime (CLR) manage memory, and what is the role of the Garbage Collector?

Medium · .NET & Application Architecture

Approach

  1. Say what the runtime actually does before reasoning about the code.
  2. Name what is shared across threads and what owns each piece of state.
  3. Identify the window where an invariant is briefly untrue.
  4. Distinguish a value from a reference to it, and say which one you handed out.

Follow-up

  • What happens if two callers reach this at the same time?
  • Where could this allocate more than you expect?

How do you handle asynchronous programming in C# using async and await?

Medium · .NET & Application Architecture

Approach

  1. Say what the runtime actually does before reasoning about the code.
  2. Name what is shared across threads and what owns each piece of state.
  3. Identify the window where an invariant is briefly untrue.
  4. Distinguish a value from a reference to it, and say which one you handed out.

Follow-up

  • What happens if two callers reach this at the same time?
  • Where could this allocate more than you expect?

Canonicalise a request body into a stable idempotency fingerprint

Medium · parsing · canonicalisation · hashing

idempotency_key.request_fingerprint is a SHA-256 over the method, path and canonicalised body, and a retry whose fingerprint differs must be rejected with 422 rather than served the stored response. Write the canonicaliser. Bodies are JSON up to 256 KB nested at most 32 levels; clients vary key order, whitespace and unicode escaping, and some send 64-bit ids as JSON numbers. Produce a deterministic byte string such that semantically identical bodies match and any semantic difference does not. State your complexity and name two normalisations you refuse to perform.

Approach

  1. Parse once into a tree, then re-serialise under fixed rules: object keys sorted, array order preserved, one escaping convention, no insignificant whitespace. Parsing is O(n) and sorting keys is O(k log k) per object, so O(n log n) overall with O(depth) stack, and the 32-level cap is enforced during parsing because hostile nesting is how a canonicaliser becomes a stack overflow.
  2. Sort keys by their UTF-8 bytes and say why the obvious implementation is wrong in some runtimes: a default string comparison that orders by UTF-16 code units places surrogate pairs, meaning code points from U+10000 up, below U+E000 to U+FFFF, which is not UTF-8 byte order, so two services written in different languages disagree on the same document.
  3. Do not re-encode numbers through a double. IEEE-754 binary64 represents integers exactly only up to 2^53, so normalising a 19-digit id through a float changes it, and 1 against 1.0 cannot be reconciled without deciding whether they are the same value. Preserve the literal token, and require ids as strings at the API boundary if you want them comparable.
  4. Reject duplicate keys rather than picking one. JSON permits them and parsers disagree, most keeping the last, so any choice you make ties the fingerprint to a parser detail that the code handling the request does not necessarily share.

Follow-up

  • A client sends the same logical request with an extra field your API ignores. Same key, different fingerprint, so you return 422. Is that the right answer?
  • Where does the fingerprint get computed relative to request decompression and the body-size limit?

How do you optimize a slow-performing SQL query that involves multiple table joins?

Medium · Database & PL/SQL Development

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 difference between a clustered and a non-clustered index, and when you would use each.

Medium · Database & PL/SQL Development

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 are the differences between a stored procedure and a function in Oracle Database?

Medium · Database & PL/SQL Development

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 scenario where you would use a database trigger, and explain the performance risks associated with

Medium · Database & PL/SQL Development

Describe a scenario where you would use a database trigger, and explain the performance risks associated with 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?

What is the difference between ASP.NET MVC and ASP.NET Web API?

Medium · .NET & Application Architecture

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?

Explain the concept of Dependency Injection in.NET Core and how it improves code maintainability.

Medium · .NET & Application 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?

Describe how you secure an API endpoint in a.NET application.

Medium · .NET & Application Architecture

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?

Why do you want to work at Pt. Intikom Berlian Mustika, and how do you see your skills aligning with an IT sys

Medium · Behavioral & Cultural Fit

Why do you want to work at Pt. Intikom Berlian Mustika, and how do you see your skills aligning with an IT system integration model?

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?

One log partition stops advancing while the others drain

Easy · poison message · head-of-line blocking · consumer lag

Search results for a subset of tenants are hours stale; the rest are current. The projection consumer reports lag of zero on 15 of 16 partitions and 400,000 on one. Its error rate is flat and its CPU is idle. outbox_event has no pending rows older than a second, so the relay has published everything it holds. Identify the mechanism, give the ordered checks, and state what you do in the first ten minutes versus what you change permanently.

Approach

  1. Read the lag distribution first. A slow consumer lags everywhere; zero on fifteen partitions and 400,000 on one is not throughput. Idle CPU on the stuck partition means the consumer is not advancing its offset at all, which points at one message it cannot get past rather than at a rate problem.
  2. Exonerate the producer before touching the consumer. No pending outbox rows older than a second means the relay published, so the event exists in the log. This separates never sent from sent and never applied, which are different code paths and usually different owners.
  3. Read the message at the stuck offset and the handler's log lines for its event_id. A flat error rate with no progress has two explanations and you must distinguish them: the handler is throwing and the retry loop is swallowing it, or the handler is blocking on something and never returning. Idle CPU with no error lines favours the second.
  4. Mitigate before diagnosing further. Move the offending event to a dead-letter store and commit the offset past it. Adding consumers does nothing here, because a partition is consumed by exactly one member of the group, and the blast radius is every aggregate hashed to that partition, not only the aggregate that produced the bad event.

Follow-up

  • The dead-lettered event carried aggregate_version 7 and the projection had applied 6. What must the replay do differently if 8 and 9 landed in the meantime?
  • How do you show staleness to the user while the partition is behind, given the API already returns the projection's watermark?

Suggested practice checklist

Built from the rounds and topics Pt. Intikom Berlian Mustika candidates report.

Day 1 — Map the Pt. Intikom Berlian Mustika loop

  • Write out the reported sequence: HR Interview, Technical Evaluation, Medical Test, Contract Discussion.
  • 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 .NET Development

  • Spend the session on .NET Development, which Pt. Intikom Berlian Mustika candidates report being tested on.
  • Write one worked example in .NET Development and time yourself on it.

Deliverable: One timed worked example in .NET Development.

Day 3 — Work Oracle Development

  • Spend the session on Oracle Development, which Pt. Intikom Berlian Mustika candidates report being tested on.
  • Write one worked example in Oracle Development and time yourself on it.

Deliverable: One timed worked example in Oracle Development.

Day 4 — Work C#

  • Spend the session on C#, which Pt. Intikom Berlian Mustika candidates report being tested on.
  • Write one worked example in C# and time yourself on it.

Deliverable: One timed worked example in C#.

Day 5 — Answer out loud: Database & PL/SQL Development

  • Answer aloud, timed: Explain the difference between a clustered and a non-clustered index, and when you would use each.
  • Answer aloud, timed: How do you optimize a slow-performing SQL query that involves multiple table joins?

Deliverable: Spoken answers to 2 reported Database & PL/SQL Development question(s), under time.

Day 6 — Answer out loud: .NET & Application Architecture

  • Answer aloud, timed: What is the difference between ASP.NET MVC and ASP.NET Web API?
  • Answer aloud, timed: Explain the concept of Dependency Injection in.NET Core and how it improves code maintainability.

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

Day 7 — Answer out loud: Behavioral & Cultural Fit

  • Answer aloud, timed: Describe a time when you had to work with a client who had vague or constantly changing requirements. How did you handle it?
  • Answer aloud, timed: How do you prioritize your tasks when you are assigned to multiple high-priority projects simultaneously?

Deliverable: Spoken answers to 2 reported Behavioral & Cultural Fit question(s), under time.

Behavioural preparation

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

How do you handle transaction management and rollbacks in PL/SQL?

Medium · Database & PL/SQL Development

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 work with a client who had vague or constantly changing requirements. How did

Medium · Behavioral & Cultural Fit

Describe a time when you had to work with a client who had vague or constantly changing requirements. How did you handle it?

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 prioritize your tasks when you are assigned to multiple high-priority projects simultaneously?

Medium · Behavioral & Cultural Fit

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?

Tell me about a challenging technical bug you encountered in a previous role and the systematic approach you t

Medium · Behavioral & Cultural Fit

Tell me about a challenging technical bug you encountered in a previous role and the systematic approach you took to resolve it.

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?