iamneo Internship Trainee Interview Questions and Answers

Round 1 Aptitude Test. They Ask Total 24 questions There are Aptitude and Verbal, One Codding question related To Sql Joins.

Arrange the number is fibonacci series

Discussion on Supply chain demand and production planning

Q1. Write SQL queries for given scenario
Ans. 
Writing SQL queries for a given scenario
• Use SELECT statement to retrieve data from tables

• Use WHERE clause to filter data based on specific conditions

• Use JOIN clause to combine data from multiple tables
Answered by AI
Add your answer
Q2. Simple queries initially, sub queries and CTEs will be touched in later part, window functions and extensive usage of joins will also be checked
Add your answer
Q3. Test test test test?
Add your answer

Q1. Engagement manager round will have a case study
Add your answer
Q2. Mostly case study related to some of the practice will be asked, mostly CPG
Add your answer

Online coding test with Sql and python questions

Q1. Details about project and experience
Add your answer
Q2. Pyspark and databricks questions
Add your answer
Q3. What is Spark context
Ans. 
Spark context is the main entry point for Spark functionality and represents the connection to a Spark cluster.
• Main entry point for Spark functionality

• Represents connection to a Spark cluster

• Used to create RDDs, broadcast variables, and accumulators
Answered by AI
Add your answer
Q4. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Allows for code reusability by creating a new class based on an existing class

• Derived class inherits properties and behaviors of the base class

• Supports the concept of polymorphism and encapsulation

• Example: Class 'Car' can inherit from class 'Vehicle' and inherit its attributes like 'color' and met
Answered by AI
Add your answer
Q5. What is sparkconfig
Ans. 
SparkConfig is a configuration object used in Apache Spark to set various parameters for Spark applications.
• SparkConfig is used to set properties like application name, master URL, and other Spark settings.

• It is typically created using SparkConf class in Spark applications.

• Example: val sparkConf = new SparkConf().setAppName("MyApp").setMaster("local")
Answered by AI
Add your answer

90 min coding test with 4-5 problems to solve

Q1. Technical rounds mostly goes around the project work ans some were based on the JD.
Add your answer

Aptitude test are basically asked from reasonable and patterns type questions.

Tooics are given from businesses and case study