Polestar Solutions & Services India Data Engineer Interview Questions and Answers

Aptitude test had few quant and verbal questions then SQL MCQs and 3 Coding question

Q1. Questions about guesstimates and puzzles
Add your answer
Q2. Which coding language is better and why?
Ans. 
There is no one 'better' coding language, as it depends on the specific use case and requirements.
• The best coding language depends on the project requirements, team expertise, and ecosystem support.

• For data engineering, languages like Python, Scala, and SQL are commonly used for their data processing capabilities.

• Python is popular for its simplicity and extensive libraries like Pandas and NumPy, while Scala is known fo...read more
Answered by AI
Add your answer

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Add your answer

Q1. HR question and family background
Add your answer

Q1. Basics - Background & knowledge
Add your answer
Q2. Technical case solving round
Add your answer

Q1. It wnt well basics of hadoop,spark and my project
Add your answer
Q2. Basics of sql and joins
Add your answer

Basics of sql and joins

Q1. Spark based questions and coding questions
Add your answer

General Aptitude Questions

Q1. Queries on SQL, Basic Statistic Question related to normal curve, Basic Python question(from python interview question list of any website)
Add your answer
Q2. Shape of normal Distribution
Ans. 
The shape of a normal distribution is bell-shaped and symmetrical.
• A normal distribution has a peak at the mean and tails that extend to infinity in both directions.

• The distribution is symmetrical, meaning that the left and right halves mirror each other.

• The standard deviation determines the spread or width of the distribution.

• Many natural phenomena and measurements in various fields follow a normal distribution.

• Example...read more
Answered by AI
Add your answer
Q3. Valuess of mean median and mode
Ans. 
Mean, median, and mode are measures of central tendency in statistics.
• Mean is the average of a set of numbers, calculated by summing all the values and dividing by the total count.

• Median is the middle value in a sorted list of numbers. If there is an even number of values, it is the average of the two middle values.

• Mode is the value that appears most frequently in a set of numbers. It can be a single value or multiple
Answered by AI
Add your answer

Q1. General HR questions
Add your answer

Q1. General discussion round with ceo and about projects
Add your answer

Q1. Tell about your previous projects
Add your answer

Q1. Tell about previous projects
Add your answer

Q1. Salary discussion
Add your answer

Q1. The interviewer asked all the concepts of pyspark, ETL and a code on dsa
Add your answer