← All openings

Business Analyst - First Mile S&OP, S&OP

Amazon · Bengaluru, Karnataka, IND

FresherFrom Amazon's careers sitePosted 18 Nov 2026

Sign up free to apply and see Amazon's interview prep

The apply link, the hiring process, the test pattern, what to study and interview questions for Amazon.

Sign up freeLog in

Company

Amazon

Role type

Fresher

Location

Bengaluru, Karnataka, IND

Apply by

Open now, apply early

About this job

Who can apply: Fresher

The candidate would be responsible for creating/maintaining complex SQL queries and scheduling/refreshing ETL jobs. They would be required to automate manual tasks and simplify them using Python. They would also be required to build data pipelines/dashboards, take up dive deep requests, make changes to existing analytical framework and provide data support to concerned stakeholders. The person should have a good understanding of a business requirement and the ability to quickly get to the root cause of a particular reporting/BI/data issue and draft solutions for resolution specially during high demand period like peak planning. The ideal candidate would be high on attention detail, show bias for action and keen interest in analytics/BI/automation. Key job responsibilities Some of the key result areas include, but not limited to: Own the design, development and maintenance of ongoing data pipelines, queries, metrics, reports, analyses, dashboards, etc. to drive key business decisions. Ensure data accuracy by validating data for new and resources. Work closely with stakeholders (internal/external) to understand and automate/enhance the existing processes. Should be open to learn and develop skillsets in the latest data and analytical techniques Should be able to solve a business problem through a solution driven by data. Should be able to come up with innovative ideas for new work or to improve existing work. Basic qualifications - 1+ years of data analytics or automation experience - 1+ years of capacity planning, operations planning, business analysis or similar experience - Bachelor's degree - Knowledge of data pipelining and extraction using SQL - Knowledge of SQL and Excel at a moderate or advanced level - Experience with data mining tools like SQL, SAS, SPSS, or similar Preferred qualifications - 1+ years of business analysis (dealing with large complex data) experience Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.

From Amazon's careers site, posted 18 Nov 2026. Apply on Amazon's own page; HireSol never charges to apply.

Interview prep

How Amazon hire freshers

Amazon tests coding and, just as much, its Leadership Principles. Every interviewer asks for stories about times you showed them, so prepare examples as carefully as you prepare DSA.

The usual process

  1. Online assessment: usually 2 coding problems plus a work-style or work-simulation section
  2. 2–3 technical interviews: DSA problems and Leadership Principles questions in each
  3. One interviewer is often a "Bar Raiser" from another team who checks you raise the hiring bar

Online test pattern

Coding
2 problems, about 90 minutes, medium difficulty
Work style
Situational questions mapped to the Leadership Principles

What to study

  • •Arrays, strings and hashing (two pointers, sliding window, prefix sums)
  • •Linked lists, stacks and queues (monotonic stack, LRU-style design)
  • •Binary search, including on the answer
  • •Trees and binary search trees (traversals, lowest common ancestor, views)
  • •Graphs: BFS, DFS, topological sort, shortest paths, union-find
  • •Heaps and greedy (top-k, intervals, scheduling)
  • •Dynamic programming (knapsack, LIS, grid paths, partitions)
  • •Amazon's 16 Leadership Principles, with a STAR story for each of the main ones

Interview questions to practise

  1. 1.Tell me about a time you took ownership of something outside your responsibility.

    How to answer: Ownership principle. Use STAR: situation, task, the action you took, and a measurable result. Say "I", not "we".

  2. 2.Tell me about a time you disagreed with a teammate. What did you do?

    How to answer: "Have backbone; disagree and commit." Show you argued with data, then fully backed the final decision.

  3. 3.Tell me about a time you had to deliver with incomplete information.

    How to answer: Bias for action. Explain the risk you judged acceptable and what you did to limit it.

  4. 4.Find two numbers in an array that add up to a target.

    How to answer: Start with the O(n²) idea, then improve to O(n) with a hash map. Say the complexity out loud before coding.

6 more questions with answers, free

Sign up free to see them all, get the apply link, and get new openings every morning.

Sign up free

Based on what candidates commonly report; companies change their process every season. Always check the official notice. HireSol isn't affiliated with Amazon.

More openings at Amazon

All Amazon openings →

More openings in Bengaluru

All openings →