Section 1 — Candidate DetailsFull Name *Email Address *Mobile Number *Current City *Relevant Development Experience *Please select an optionUnder 1 year1–2 years3–5 years6–8 years8+ yearsCurrent Employment Status *Currently EmployedFreelancingOn a Career BreakAvailable ImmediatelyAvailability to Join *Please select an optionImmediatelyWithin 15 DaysWithin 30 DaysWithin 60 DaysMore Than 60 DaysExpected Monthly Compensation (INR) *Enter expected gross monthly compensation in Indian rupees.Open to a 30-Day Paid Trial? *YesWould Like to DiscussPrimary Backend Technology *Please select an optionNode.jsPythonPHPJavaOtherPrimary Frontend Technology *Please select an optionReactNext.jsVueAngularOtherSQL Experience Level *Please select an optionNoneBasicIntermediateAdvancedUpload Resume (PDF, maximum 5 MB) *PDF only. Please do not upload identity documents.Choose FileNo file chosenDelete uploaded fileGitHub or Portfolio URLStrongest Relevant Project (describe your personal contribution) *Mention architecture, integrations, debugging and what you personally owned.0 / 750Section 2 — Technical assessment (5 multiple-choice questions)Q1. A CSV import contains a negative quantity and two rows with the same product code. What should the import service do? *CARBON is a Bengaluru-based menswear business. We sell clothing online and through retailers. For these questions, SKU means a unique product/variant code; available quantity = on-hand stock minus reserved units and quality-hold units; a catalogue displays products to customers. No apparel experience is needed. State reasonable assumptions.A. Convert the negative number to positive and accept both rows.B. Ignore errors because the data came from an employee.C. Validate records, report row-level problems, and avoid applying invalid data.D. Publish the file first and fix errors afterward.Q2. An application tracks products in many colors and sizes. Which database design is most maintainable? *A. Store each product and all size quantities in a single comma-separated text field.B. Use products, variants, and inventory records connected by identifiers and appropriate unique constraints.C. Create a separate database for every color.D. Store quantities in a frontend JavaScript object only.Q3. An external API returns HTTP 429 while synchronizing records. What is the most reliable response? *A. Retry continuously without delay.B. Mark the request as successful.C. Respect rate limits, use bounded retries/backoff and record unresolved failures.D. Permanently delete the record.Q4. Two employees have different responsibilities: one views records, another manages integrations. What is the safest access approach? *A. Give everyone the same administrator password.B. Store the administrator password in source code.C. Allow unrestricted access on the internal network.D. Use role-based access and least privilege, with server-side authorization checks.Q5. Business context: A product variant has 50 units on hand, 12 reserved for orders and 3 on quality hold. There is no other buffer. How many units are available for new orders? *A. 50B. 38C. 35D. 62Section 3 — Applied engineering questions (5 written answers)Q6. CSV/Excel import: A file has 2,000 rows with missing identifiers, negative quantities and duplicate product codes. Design a safe import process, including validation, error reporting and how you avoid partial or repeated updates. *0 / 2000Q7. SQL: Given inventory(sku, on_hand, reserved, qc_hold), write a SQL query that returns each SKU and its total available quantity, showing only SKUs whose total available quantity is greater than zero. Available = on_hand - reserved - qc_hold. *0 / 2000Q8. API integration: Your service sends an inventory update to a third-party API, but the request times out after being sent. Explain how you would detect whether it succeeded, avoid applying it twice and handle recovery. *0 / 2000Q9. Debugging: A web catalogue shows 20 available units for a product, while the source inventory system shows 8. Updates occur through a scheduled API sync. How would you investigate, correct and prevent this mismatch? *0 / 2000Q10. System design and security: A company maintains inventory in Excel and wants a website showing only currently available products. Outline the database tables, backend endpoints, frontend, access controls, tests and deployment approach you would use. *0 / 2000Section 4— DeclarationRecruitment Privacy and Original Work Declaration *I confirm that my application and assessment reflect my own experience and work. I understand that CARBON will process these details for recruitment, assessment and interview purposes, subject to the recruitment privacy notice linked on the careers page.Submit Application
