i
Jio
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
HLOOKUP is a function in Excel used to search for a value in the top row of a table or an array, while a pivot table is a data summarization tool.
HLOOKUP function searches for a value in the top row of a table or an array and returns a value in the same column from a specified row.
Pivot tables are used to summarize, analyze, explore, and present data in a spreadsheet.
HLOOKUP example: =HLOOKUP(lookup_value, table_array,...
I applied via Walk-in and was interviewed in Oct 2021. There was 1 interview round.
I was interviewed before Jan 2024.
I applied via Naukri.com and was interviewed in Jan 2022. There were 3 interview rounds.
I applied via campus placement at College of Engineering ( Formerly Pune Instiute of Enginering and Technology ), Pune and was interviewed in Nov 2024. There were 2 interview rounds.
Aptitude test contains Logical Reasoning Questions, Analytical Skills questions, and some general Questions, there are no coding questions for it
I applied via Walk-in and was interviewed in Dec 2024. There were 5 interview rounds.
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration
I have 5 years of experience in analyzing business processes and identifying areas for improvement
I am proficient in using data analysis tools such as Excel and SQL
I have a proven track record of successfully implementing process improvements that have
I was responsible for analyzing business processes, gathering requirements, creating reports, and providing recommendations for improvement.
Analyzed current business processes to identify areas for improvement
Gathered and documented business requirements from stakeholders
Created reports and presentations to communicate findings and recommendations
Collaborated with cross-functional teams to implement process improvement...
Logical and reasoning questions.
Introduce the topic area of the report, outlining the purpose of the case study. Summarize the key issues and findings without providing specific details, and identify the theory employed.
Ensuring data accuracy in MIS is crucial for making informed decisions, improving operational efficiency, and maintaining credibility.
Accurate data ensures that decisions are based on reliable information, leading to better outcomes.
Improves operational efficiency by reducing errors and minimizing the need for rework.
Maintains credibility of the organization by providing accurate and trustworthy information to stakehol...
I have successfully managed a complex MIS project involving multiple stakeholders and systems integration.
Led a team of analysts and developers to design and implement a new MIS system for a large financial institution
Coordinated with various departments to gather requirements and ensure alignment with business goals
Managed project timelines, budgets, and resources to ensure successful delivery
Implemented change manage...
I am currently earning a competitive salary based on my experience and skills.
My current salary is in line with industry standards for my level of experience.
I am open to discussing salary expectations for this new role.
I believe my compensation should reflect the value I bring to the company.
I typically issue salary raises ranging from 2-5% based on performance and market standards.
Salary raises are typically based on performance evaluations and market standards.
Raises can range from 2-5% for average performers, higher for exceptional performers.
Consider factors like company budget and industry benchmarks when determining salary raises.
I applied via campus placement at VNR Vignan Jyothi Institute of Engineering and Technology, Hyderabad and was interviewed in Aug 2024. There were 4 interview rounds.
Round 1: HackerRank Test (100 Minutes)
1 DSA question (medium level, binary search on answers)
20 technical questions (OS, DBMS, CN, and other CS fundamentals)
15 general aptitude and communication questions
Static binding is resolved at compile time while dynamic binding is resolved at runtime in Java.
Static binding is also known as early binding.
Dynamic binding is also known as late binding.
Example of static binding: method overloading.
Example of dynamic binding: method overriding.
Sorting a linked list involves rearranging the nodes in a specific order.
Iterate through the linked list and compare each node with the next one
Use a sorting algorithm like bubble sort, merge sort, or quick sort to rearrange the nodes
Update the pointers to connect the nodes in the sorted order
JAR files are Java Archive files that store multiple Java class files and related metadata.
JAR files are used to package Java classes, resources, and metadata into a single file.
They are commonly used for distributing Java libraries or applications.
JAR files can be created using the 'jar' command in Java.
They can also be executed using the 'java -jar' command.
Example: mylibrary.jar contains all the class files and reso
A Singleton class is a class that can only have one instance created at a time.
Singleton classes are often used for managing resources that should only have one instance, such as a database connection.
To implement a Singleton class, you typically make the constructor private and provide a static method to access the single instance.
Example: Singleton class for logging system where only one instance of the logger is nee
CAP Theorem states that in a distributed system, it is impossible to simultaneously guarantee consistency, availability, and partition tolerance.
Consistency: All nodes in the system have the same data at the same time.
Availability: Every request gets a response, even if some nodes are down.
Partition Tolerance: The system continues to operate despite network partitions.
Trade-offs: In a distributed system, you can only h...
wait() and signal() are functions used for synchronization in multithreading.
wait() is used to make a thread wait until a certain condition is met
signal() is used to wake up a waiting thread when the condition is met
Example: Producer-consumer problem where producer signals consumer to consume when a new item is produced
Airport Management System schema and ER diagram design
Entities: Airport, Flight, Passenger, Employee, Schedule
Attributes: Airport (code, name, location), Flight (number, destination, departure time), Passenger (name, age, contact info), Employee (ID, name, role), Schedule (flight number, date, time)
Relationships: Airport has many Flights, Flight has many Passengers, Employee works at Airport, Flight has Schedule
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Identify the functional dependencies in the table
Eliminate partial dependencies by breaking the table into multiple tables
Eliminate transitive dependencies by further breaking down the tables
Ensure each table has a primary key and all non-key attributes are fully functionally dependent on the primary key
REST is an architectural style for designing networked applications
REST stands for Representational State Transfer
It uses standard HTTP methods like GET, POST, PUT, DELETE
Resources are identified by URIs
Data is transferred in JSON or XML format
Example: GET request to 'https://api.example.com/users' to retrieve a list of users
PUT is used to update or replace an existing resource, while POST is used to create a new resource.
PUT is idempotent, meaning multiple identical requests will have the same effect as a single request
POST is not idempotent, meaning multiple identical requests may have different effects
PUT is used to update an existing resource at a specific URI
POST is used to create a new resource under a specific URI
Example: PUT /users...
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
I was interviewed in Jan 2025.
Interview experience
based on 3 reviews
Rating in categories
Assistant Manager
5.5k
salaries
| ₹1 L/yr - ₹10.5 L/yr |
Deputy Manager
3.5k
salaries
| ₹4.2 L/yr - ₹13.7 L/yr |
Manager
1.8k
salaries
| ₹6 L/yr - ₹22.5 L/yr |
Senior Executive
1.5k
salaries
| ₹1.8 L/yr - ₹8 L/yr |
Senior Manager
1.4k
salaries
| ₹10.3 L/yr - ₹32 L/yr |
Jio Platforms
Bharti Airtel
Vodafone Idea
Bharat Sanchar Nigam