cd /news/developer-tools/intuit-oa-2026-guide-code-sql-bash-q… · home topics developer-tools article
[ARTICLE · art-81942] src=dev.to ↗ pub= topic=developer-tools verified=true sentiment=· neutral

Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

Intuit's online assessment for software and AI engineer candidates includes three questions covering coding, SQL, and Bash scripting. The coding problem involves counting valid assignments for arrays with zeros, solved via combinatorics and interval decomposition. SQL requires parsing string capitalizations and aggregating by sector, while Bash counts strings with uppercase letters.

read3 min views1 publishedJul 31, 2026

The Intuit Online Assessment (OA) has started rolling out again, and the format remains very similar to previous years. Most candidates receive three questions covering coding, SQL, and Bash scripting. We've helped candidates preparing for both Software Engineer and AI Engineer positions, and overall the assessment is quite manageable if you're familiar with the patterns.

Below is a complete breakdown of the three questions together with the solution ideas that helped candidates successfully pass the OA.

You are given an integer array where some positions contain 0

, representing unknown values, while all other positions already contain fixed integers. Replace every zero with any integer so that the absolute difference between every pair of adjacent elements is at most one.

Return the number of different valid assignments modulo 1,000,000,007

. The problem guarantees that at least one element is non-zero, and the array length is at most 1500.

The key observation is to process each consecutive block of zeros independently. Existing numbers naturally divide the array into multiple segments, and each segment contributes independently to the final answer. The total number of valid arrays is simply the product of the number of valid assignments for every segment.

For one zero segment, the left and right boundaries (when they exist) are fixed values. This becomes a constrained walk from one endpoint to the other, where every step can increase by one, decrease by one, or remain unchanged.

Since the total displacement between the two endpoints is fixed, we enumerate how many +1

, -1

, and 0

moves appear in the segment. Every valid distribution can then be counted using multinomial (multiset) combinatorial formulas.

Special attention should be paid to:

Although it looks intimidating initially, this is essentially a combinatorics counting problem combined with interval decomposition.

Write a SQL query that groups companies by sector

and calculates the total market capitalization for each sector.

The output should contain:

sector

total_capitalization

The capitalization should:

The original capitalization values are stored as strings such as:

Only companies with both a valid sector and a valid capitalization should be included.

The solution is mostly string parsing followed by aggregation.

n/a

.SUM()

grouped by sector.The biggest pitfalls are unit conversion, preserving decimal precision, and formatting the final output correctly.

Given an array of strings, count how many strings contain at least one uppercase English letter, then print the result to STDOUT.

This is a straightforward Bash scripting question.

Iterate through every string and use a regular expression such as:

[A-Z]

If the pattern matches, increment the counter.

Remember to consider:

This question can typically be solved in just a few lines of Bash.

Compared with many other big tech online assessments, the Intuit OA is relatively friendly. The questions are practical and emphasize implementation rather than obscure algorithms.

Candidates who have practiced common counting techniques, SQL data transformation, and simple shell scripting should find the assessment very manageable.

Recruiting is still active across many major technology companies, including Amazon, Google, Microsoft, Meta, and TikTok. Besides online assessments, technical phone screens and virtual onsite interviews are also ongoing.

If you're preparing for upcoming interviews, Interview Show provides realistic mock interviews, OA guidance, and one-on-one interview coaching based on actual interview experiences from North American software engineering hiring processes.

Visit our website to learn more:

You can also browse more interview experiences, OA breakdowns, and preparation guides here:

Good luck with your Intuit OA, and hopefully we'll see you in the interview rounds!

── more in #developer-tools 4 stories · sorted by recency
── more on @intuit 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
Live at https://your-agent.zahid.host
Get free account → Pricing
from €0/mo · no card required
LIVE [news/intuit-oa-2026-guide…] indexed:0 read:3min 2026-07-31 ·