InFynd Data Engineer Intern Interview Questions and Answers for Freshers

Simple sql and python basic questions was asked.

I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions

Q1. Data model e commerce application
Add your answer
Q2. Higest nth rank and lowest rank if no of employees less than 2
Ans. 
If number of employees is less than 2, highest and lowest rank will be the same.
• If there are less than 2 employees, both highest and lowest rank will be the same.

• For example, if there is only 1 employee, their rank will be 1 which is both the highest and lowest rank.
Answered by AI
Add your answer
Q3. Event session data modeling
Add your answer

Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
Add your answer

Q1. This was hiring manager round. Detailed discussions on project and previous experience
Add your answer

Q1. Strength, weakness and why myntra
Add your answer

Q1. Study DSA SQL PYTHON
Add your answer

Q1. Study spark sql data warehousing
Add your answer

Q1. Hr managerial round
Add your answer

They didn't score properly on the assessments for theoretical answers. Types of Data Modeling is a basic question with just 3 types but they marked the answer as wrong. I did not argue with the interviewer but yes, didn't feel comfortable after the process.

Q1. 1) What is internal mechanism in spark . 2) tungsten project in spark explanation 3) sql problem to check where last two transaction belongs to particular retail
Ans. 
Questions related to Spark internals, Tungsten project, and SQL problem for retail transactions.
• Spark's internal mechanism includes components like Spark Core, Spark SQL, Spark Streaming, and MLlib.

• Tungsten project in Spark aims to improve the performance of Spark by optimizing memory usage and CPU utilization.

• To solve the SQL problem, we can use a query to filter transactions for a particular retail and then use the '...read more
Answered by AI
Add your answer

Q1. 1) scenario based question like , if a. job is launched with single executor will there be shuffling
Add your answer

1 hr medium level DSA questions

Q1. DFS in tree Data Structure
Ans. 
DFS (Depth First Search) is a traversal algorithm used in tree data structures to explore as far as possible along each branch before backtracking.
• DFS starts at the root node and explores as far as possible along each branch before backtracking.

• It uses a stack to keep track of nodes to visit next.

• DFS can be implemented recursively or iteratively.

• Example: In a binary tree, DFS would visit the left child of a node before
Answered by AI
Add your answer
Q2. SQL normalisation types and explanation
Ans. 
SQL normalisation types include 1NF, 2NF, 3NF, BCNF, and 4NF, each with specific rules for eliminating data redundancy.
• 1NF (First Normal Form) - Each column in a table must contain atomic values, and there should be no repeating groups.

• 2NF (Second Normal Form) - Table should be in 1NF and all non-key attributes should be fully functionally dependent on the primary key.

• 3NF (Third Normal Form) - Table should be in 2NF an...read more
Answered by AI
Add your answer

Q1. Preferred Location
Ans. 
I am open to opportunities in various locations, depending on the job offer and company culture.
• Open to relocation for the right opportunity

• Prefer locations with good work-life balance

• Interested in cities with strong tech communities
Answered by AI
Add your answer
Q2. About the company
Add your answer

About your tech stack along with 2 Programming question basic DS Problems, and 2-3 SQL Queries moderate level.

3-4 SQL queries medium to high level and 2 programming question moderate level

Data modeling and Data warehousing questions along with SQL queries Hard level

Q1. Create a Data model for the use case like CCD, Pizza hut and questions from that Data model
Add your answer
Q2. Data Warehousing and Big data related problems Data pipelines and ETL related Question Cloud computing related questions
Add your answer

Q1. Techno manager round on case studies to come complex problems.
Add your answer