i
Panorbit Services LLP
Filter interviews by
I appeared for an interview in Apr 2020.
Design a database for a university with colleges, departments, and students. Write a query to get students with maximum votes.
Use a relational database like MySQL or PostgreSQL
Create tables for colleges, departments, students, and elections
Use foreign keys to establish relationships between tables
Add columns for election details like candidate names and vote counts
Write a query to join tables and filter for maximum vot
Design a bit.ly URL shortening service with database choice, table design, and endpoints.
Use a relational database like MySQL or PostgreSQL for scalability and ACID compliance.
Create a table with columns for the original URL, shortened URL, and metadata like creation date and click count.
Endpoints should include URL shortening, redirection, and analytics.
Implement caching to improve performance and reduce database load...
posted on 18 Oct 2023
Database realted task
2 ( 1 medium + 1 hard ) coding questions , 2 ( 1 medium + 1 easy ) sql questions, 10 MCQS( os, cn, dbms, aptitude ).
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
CRUD Application using Angular
posted on 11 Sep 2023
I applied via Walk-in and was interviewed in Aug 2023. There were 5 interview rounds.
Section 1. 10 questions aptitude
section 2. 10 oops questions based on c++
section 3. comprehension
section 4. 10 questions English grammar
One coding question. it's like two lines of question, understand the question and write the code using any programming language.
Coding test was on reactjs and html
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.
It was a simple case study with a regression problem
The importance of data analytics lies in its ability to help organizations make informed decisions, identify trends, and improve overall performance.
Data analytics helps organizations make data-driven decisions
It allows businesses to identify trends and patterns in data
Data analytics can improve operational efficiency and performance
It enables organizations to gain insights and make predictions based on data
Data analyt...
Rank and dense rank are functions used in SQL to assign a rank to each row based on a specified column.
Rank function assigns a unique rank to each distinct row based on the specified column.
Dense rank function assigns a unique rank to each distinct row based on the specified column, but does not leave gaps between ranks.
Example: If we have a table of students with their scores, using rank function will assign ranks lik...
They will provide you with dataset and we need to find insights from that
I am passionate about uncovering insights from data and using them to drive informed decision-making.
I have a strong background in statistics and data analysis
I enjoy working with large datasets and finding patterns within them
I am excited about the opportunity to make a meaningful impact through data-driven decision-making
I am proficient in data visualization tools like Tableau and Power BI
based on 1 interview
Interview experience
Junior Software Developer
9
salaries
| ₹3 L/yr - ₹9 L/yr |
UI/UX Designer
6
salaries
| ₹3 L/yr - ₹4 L/yr |
Software Developer
5
salaries
| ₹3 L/yr - ₹8 L/yr |
Video Editor
4
salaries
| ₹2.5 L/yr - ₹4.8 L/yr |
Junior UI UX Designer
4
salaries
| ₹4.1 L/yr - ₹4.2 L/yr |
TCS
Infosys
Wipro
HCLTech