Instinct Innovations Data Engineer Interview Questions and Answers

It consists of basic aptitude questions and some coding output questions followed by basic SQL questions. Overall the difficulty level was medium.

Q1. They asked me to write code for 4 problems. All questions consists array medium level and then there are difficult SQL questions to solve. Unfortunately I couldn't passed this round. But it was a great lea...read more
Add your answer

It has general aptitude questions with moderate difficulty

It was mixed coding plus SQL question after the exam I had explain my solution.

Q1. Introduction about yourself
Ans. 
Data analyst with a passion for transforming data into actionable insights, skilled in statistical analysis and data visualization.
• Educational Background: Bachelor's degree in Statistics, focusing on data analysis techniques.

• Technical Skills: Proficient in SQL, Python, and data visualization tools like Tableau.

• Professional Experience: Worked at XYZ Corp, where I improved reporting efficiency by 30% through automation.

• P...read more
Answered by AI
Add your answer
Q2. Few bascis of python
Ans. 
Python is a versatile programming language widely used for data analysis, automation, and web development.
• Python is an interpreted language, meaning it executes code line by line, which makes debugging easier.

• It supports multiple programming paradigms, including procedural, object-oriented, and functional programming.

• Python has a rich ecosystem of libraries, such as Pandas for data manipulation and NumPy for numerical ...read more
Answered by AI
Add your answer

Q1. Spark architecture.
Add your answer
Q2. Narrow and wide transformations
Add your answer

First there will be a topic given to you to write an article of length 300-400 words in 15 mins. This article writing is to check your knowledge of English language.
Then there is a 45 mins round test in which 40 questions will be asked.
20 Technical and 20 Programming.
The programming questions will be from C++, and you are required to choose the correct output of the given C++ program.
The technical aptitude questions were medium to hard.

Q1. It's a 1:30 hr round. In this part, there will be 4 coding questions from arrays topic which you can solve with any programming language you know. Along with this, you will have 2 questions from SQL and e...read more
Add your answer

There was total of 40 questions
First 20: Aptitude based topics like time and work, profit and loss, speed and distance
Second 20: Programming MCQs based on C, C++ and python. Task is to guess the correct output and errors.

There were 4 coding questions based on array, 2 SQL queries and one article.
Coding questions were easy for batch 2 but difficult for batch 1. Star patterns are present in batch 1.
SQL queries were easy.
One article (200-300)words. Topics was Google maps.

Q1. Founder came and asked approach I used to solve coding questions in round 2. He then check the output for each question. Then he checked the SQL queries I have written, in which I had write two wrong queri...read more
Add your answer
Q2. He asked me about different approaches to solve a problem
Add your answer
Q3. He asked about the project I had done on Java Full stack.
Add your answer

Basics of C language

Q1. JavaScript coding
Add your answer
Q2. C language Coding questions
Add your answer