ION Group Production Analyst Interview Questions and Answers for Experienced

SQL Based Test - Joins, Order of Execution

Q1. Basic Excel based Questions
Add your answer
Q2. Basic SQL questions
Add your answer

Case study on how you would place a shop outlet in an airport?

Q1. What are scrum ceremonies?
Ans. 
Scrum ceremonies are regular meetings held in Agile project management to facilitate communication and collaboration among team members.
• Sprint Planning: Setting goals and planning tasks for the upcoming sprint.

• Daily Stand-up: Short daily meetings to discuss progress, roadblocks, and plans for the day.

• Sprint Review: Demo of completed work to stakeholders for feedback.

• Sprint Retrospective: Reflection on what went well, w...read more
Answered by AI
Add your answer
Q2. How do you define sprint?
Ans. 
A sprint is a time-boxed period during which a specific amount of work must be completed.
• Sprints are typically 2-4 weeks long in Agile methodology

• At the beginning of a sprint, the team plans the work to be done and commits to completing it by the end of the sprint

• Sprints end with a review and retrospective to discuss what went well and what could be improved for the next sprint
Answered by AI
Add your answer
Q3. How do you make story points?
Ans. 
Story points are estimates used in Agile methodology to measure the complexity and effort required for a task.
• Story points are typically assigned based on the perceived complexity, risk, and effort involved in a user story or task.

• They are not based on time, but rather on relative sizing compared to other tasks.

• Common scales for story points include Fibonacci sequence (1, 2, 3, 5, 8, 13, etc.) or t-shirt sizes (XS, S, ...read more
Answered by AI
Add your answer
Q4. Scenario-based questions on stakeholder manager
Add your answer
Q5. How is product management different from project management?
Ans. 
Product management focuses on the development and marketing of a specific product, while project management involves overseeing a specific project from start to finish.
• Product management is focused on the entire lifecycle of a product, from ideation to launch and beyond.

• Project management is focused on the successful completion of a specific project within a set timeframe and budget.

• Product managers work closely with c...read more
Answered by AI
Add your answer

They asked a guesstimate case question. The question was, If you are the manager of McDonalds, where would you place it in the international chennai airport (Arrival or departure).
What will be the yearly revenue McDonalds if all items are priced at Rs.100.

Q1. Advanced Excel Based questions
Add your answer
Q2. Basic SQL based questions
Add your answer

Q1. Previous experience
Add your answer

Q1. Why did you left previous job?
Add your answer
Q2. What is the reason you want to join this company?
Add your answer

Q1. My manager asked to Describe the room in which my interview was conducted.
Add your answer

Q1. My director just asked about my studies & last job. Also, gave short description about new company.
Add your answer

Q1. Advanced Excel - xlookup, data types, pivot analysis
Add your answer
Q2. Sql - syntax
Add your answer

Q1. Java basics, servlet, oops concepts
Add your answer