I've seen quite a few people start rushing Koddi's opportunities recently, and I've put together a list on my side Koddi Koddi, a growing company in the ad tech space, has a strong focus on data-driven ad placement and optimization, and is hiring at a pretty fast pace. Many students noticed the OA test when they were brushing up on koddi careers jobs. This level mainly examines logical thinking and programming foundation, and the overall difficulty is medium, but there are still a lot of stuck points. The following is a combination of real experience, take a look at the Koddi OA process and types of questions, I hope to help students who are ready to submit.
OA Distribution of questions
Koddi's OA's are typically conducted on the HackerRank or Codility platforms and take about 90 minutes, distributed as follows:
Coding (2 questions)
There will be two basic programming questions of about LeetCode medium level of difficulty. The types of questions are common, such as array processing, string manipulation, and hash table applications. The overall is not tricky, but the time is relatively tight, especially pay attention to the boundary conditions, many people will turn over here.
SQL (1 question)
The SQL part is usually one question, and the common test points are window functions, grouping and aggregation, and sorting. The topic scenarios are also quite popular, such as "find the top N users", "calculate the conversion rate" and so on. The writing style is flexible, but if you are not familiar with the syntax, you will lose points very quickly.
Logic/Analytics (1 question)
This question is biased analytical thinking, give you a small data table, let you see the trend, than indicators, make comparisons. In fact, quite close to the work to do, the test is your data sensitivity and logical reasoning ability.
Overall, Koddi OA doesn't come up with any particularly cold algorithmic questions, it's mainly a combination of Coding + SQL + Analytical Thinking.
1. Coding: Ad Campaign Effective Revenue Calculation
Task
Calculate each ad campaign's valid click count And total effective revenue per rules.
Valid click: Click date within campaign's [start_date, end_date] + traffic source not in blacklist (["bot", "invalid", "test"]. "invalid", "test"]).
Revenue per valid click. bid * (1 + bonus_rate) (bonus_rate=0.2 for "mobile", 0 otherwise).
Output sorted by total revenue (desc) → campaign ID (asc); round revenue to 2 decimals.
Inputs
campaigns: campaign_id (str), start_date (date), end_date (date), bid (float)
clicks: click_id (str), campaign_id (str), click_date (date), traffic_source (str), device_type (str)Output
Table with columns: campaign_id, valid_clicks, total_revenue2. SQL: Ad Channel ROI Analysis
Task
Calculate Mar 2024 ROI for each channel (ROI = (total_revenue - total_spend)/total_spend * 100). Rules.
- Round total_spend/total_revenue to 2 decimals, ROI to 1 decimal; mark ROI=0 if total_spend=0.
- Format ROI as "X.X%".
- Include channels with spend/conversion records; sort by ROI (desc) → total_revenue (desc).
Tables
channel_spend: channel_id, date, spend (float)channel_info: channel_id, channel_name (e.g., "Google Ads")conversion_revenue: conversion_id, channel_id, date, revenue (float)
Output
Table with columns: channel_name, total_spend, total_revenue, ROI
3. Logic/Analytics: Ad Budget Allocation Optimization
Background
Total budget = $10,000; allocate to 3 campaigns to maximize total conversions.
Campaign A: CPA=$20, max conversions=300
Campaign B: CPA=$25, max conversions=200
Campaign C: CPA=$15, max conversions=250
(Conversion = Budget allocated / CPA; ≤ max conversions)
Questions
- Optimal budget allocation for each campaign?
- Total conversions under this allocation?
- Remaining budget (if any)?
Koddi Glassdoor FAQ
Q1: How does Koddi OA difficulty compare to the big players?
A: Medium overall, easier than Meta/Google OA, but not to be taken lightly.
Q2: Can I apply for Koddi OA repeatedly?
A: There is no hard and fast rule, but it is generally recommended to wait 6 months before investing.
Q3: What are the main skills that Koddi OA looks for?
A: Coding fundamentals + SQL proficiency + data analytics mindset is a common combination for ad/data driven companies.
Q4: What test points do SQL questions favor?
A: Mainly a combination of group by + order by + limit, sometimes with a window function (ROW_NUMBER, RANK).
Q5: What is the approximate pass rate for Koddi OA?
A: According to experience, about 30-40% can pass. The main elimination is in the Coding part.
Koddi Careers Submission Must See: OA Question Explanation + No Trace Assist Tips
Although the overall difficulty of Koddi OA questions is at a medium level, they cover Coding, SQL and Logic, so when you are really on the field, you will have the biggest challenge of time constraints, lots of details and easy to panic. It often happens that Coding forgets to consider special inputs, SQL writes wrong join or date range, Logic calculates CTR/Conversion Rate and makes a mistake when it is nervous, and in the end the result is affected because of a small mistake when it is obvious that you are strong enough.
We are in programhelp In the assisted cases, many students rely on our on-line ghostwriting without trace + remote voice reminder to stabilize the situation at critical moments. For example, when the SQL part was written directly on behalf of a correct solution without any trace, and when the Coding was stuck in complexity optimization, we prompted them to switch their thoughts quickly by voice, and they finally completed the Koddi OA successfully.
If you are following koddi careers The chances are that you don't want to get stuck with OA, and you can absolutely take the help of professional remote untethered support. This not only avoids low-level mistakes, but also keeps up the pace in a tense exam atmosphere and gets you an interview faster.
