College Vidya Interview Questions and Answers

To check experience with spread sheets or Excel

Q1. Technical on SQL & previous work experience
Add your answer

Two Medium DSA problem to solve

Q1. Design scalable Streaming pipeline and
Ans. 
Design a scalable streaming pipeline for processing large volumes of data.
• Use a distributed streaming framework like Apache Kafka or Apache Flink for real-time data processing.

• Implement data partitioning and parallel processing to handle high data throughput.

• Utilize cloud services like AWS Kinesis or Google Cloud Pub/Sub for scalability and reliability.

• Include fault tolerance mechanisms like checkpointing and data repl...read more
Answered by AI
Add your answer

Q1. LLD round , write classes and its methods
Add your answer

Q1. Salary and benefits discussion
Add your answer

Q1. Previous orgranization contributions
Ans. 
Contributed to previous organization's growth by improving processes and implementing new technologies.
• Developed and implemented a new project management system resulting in a 20% increase in efficiency

• Streamlined the hiring process by introducing an applicant tracking system, reducing time-to-hire by 30%

• Led a cross-functional team to identify and resolve bottlenecks in the supply chain, resulting in a 15% reduction in...read more
Answered by AI
Add your answer
Q2. Case scenario on growing revenue based on certain parameters.
Add your answer

Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
Add your answer
Q2. Sql joins questions based on three tables, complex joins
Add your answer

Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Add your answer

Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...read more
Add your answer

Q1. Was asked basic HR questions
Add your answer

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer