Vajro Data Analyst Intern Interview Questions and Answers

Easy to medium level question

Q1. Easy to medium sql queries
Add your answer

Q1. Design the generic tool or package using pyspark which allows to create connections to multiple databases like mysql, s3 or api. Fetch the result and do transformations like handling null values and then s...read more
Ans. 
Design a generic tool in pyspark to connect to multiple databases, fetch results, handle null values, and store output in another database
• Use pyspark to create a tool that can connect to databases like mysql, s3, or api

• Implement functions to fetch data from the databases and perform transformations like handling null values

• Utilize pyspark to store the transformed data in another database

• Consider using pyspark SQL funct
Answered by AI
Add your answer

It was time based task and was very well instructed it consisted questions for all in one like apti related to sales and excel all in one go.

Q1. My first question after my introduction was about b2b and b2c marketing
Add your answer
Q2. It was about what i understand by lead genration
Add your answer

Assignment to develop a prototype

Q1. Face to face questions
Add your answer
Q2. Java Question Technical & coding
Add your answer
Q3. Mongodb & Mysql Question
Add your answer

Will be given Requirement to write code for Restraunt. Based on that have write code for delivering orders by delivery boys.

Q1. OOPS Concepts, Java Basics, Collections, MultiThreading
Add your answer

2 questions, Easy and medium based

Q1. Stacks queues and array questions
Add your answer

Q1. Technical questions on projects
Add your answer

Q1. How to tackle any uncertain situations? Behavioural questions
Add your answer

It was a live coding round where expectation was to come up with a framework in Java from Scratch

Q1. It was a DS/Algo Round
Add your answer

Q1. Design Round in HLD
Ans. 
Design Round in HLD involves creating a high-level design for a software system.
• Identify the main components of the system and their interactions

• Define the architecture of the system including layers, modules, and interfaces

• Consider scalability, performance, security, and maintainability

• Use UML diagrams like class diagrams, sequence diagrams, and component diagrams

• Document the design decisions and rationale
Answered by AI
Add your answer

Coding questions were easy, not clear about shortlisting process

Q1. Basic DSA questions on arrays, linked lists
Add your answer

Q1. Self introduction
Add your answer