AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
InFynd
Compare
Filter interviews by
InFynd Data Engineer Intern Interview Questions and Answers
InFynd Data Engineer Intern Interview Experiences
1 interview found
ABISELVAM B
I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.
Intermediate questions
Basic sql queries- written
(2 Questions)
- Q1. Difference between delete, truncate, drop
- Ans.
Delete removes specific rows, truncate removes all rows, drop removes entire table.
Delete is used to remove specific rows from a table based on a condition.
Truncate removes all rows from a table but keeps the table structure.
Drop removes the entire table along with its structure and data.
Delete is slower than truncate and drop as it maintains logs for rollback.
Truncate is faster than delete as it does not maintain logs...
- Q2. 10 keywords in sql
- Ans.
Keywords in SQL are essential for querying databases efficiently.
SELECT
FROM
WHERE
JOIN
GROUP BY
ORDER BY
HAVING
INSERT INTO
UPDATE
DELETE
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Rohit Kulkarni
Interview Preparation Tips
Experience: Relevant experience matters, a lot!
Round: HR Interview
Experience: Nothing specific. Just resume based.
Round: Technical Interview
Experience: 7 rounds. Across SQL, Python, Shell Script (bash), platform architectures and Amazon web services (AWS).
Tips: Prepare well - SQL and data architectures for various use cases.
Round: Behavioural Interview
Experience: On Amazons leadersh
Kishor Kunal
Selected
I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.
Simple sql and python basic questions was asked.
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Aug 2024. There were 5 interview rounds.
I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions
(3 Questions)
- Q1. Data model e commerce application
- 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.
- Q3. Event session data modeling
(1 Question)
- Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
(1 Question)
- Q1. This was hiring manager round. Detailed discussions on project and previous experience
(1 Question)
- Q1. Strength, weakness and why myntra
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Jun 2023. There were 3 interview rounds.
1 hr medium level DSA questions
(2 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
- 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...
(2 Questions)
- 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
- Q2. About the company
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- 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 '...
(1 Question)
- Q1. 1) scenario based question like , if a. job is launched with single executor will there be shuffling
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before Mar 2023. There were 4 interview rounds.
Hackerrank test with medium level DSA and SQL questions
(3 Questions)
- Q1. SQL joins and window functions
- Q2. Big data optimisation techniques
- Ans.
Big data optimisation techniques involve strategies to improve the performance and efficiency of processing large volumes of data.
Use of distributed computing frameworks like Hadoop and Spark to process data in parallel
Implementing data compression techniques to reduce storage requirements
Utilizing indexing and partitioning to optimize query performance
Applying data pruning and filtering to reduce unnecessary data proc...
- Q3. DSA Medium level
(2 Questions)
- Q1. Big data Eco system
- Q2. SQL and Python related
(1 Question)
- Q1. Managerial round on a specific use case designing
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Question on sql and other stuff
(1 Question)
- Q1. Question on sql and other stuff
(1 Question)
- Q1. Question on sql and queries
Interview Preparation Tips
(2 Questions)
- Q1. Explain data architecture of your project
- Q2. Explain data lake
I applied via Job Fair and was interviewed in Jun 2024. There was 1 interview round.
Duration - 3 hours, DSA
Interview Preparation Tips
InFynd Interview FAQs
Tell us how to improve this page.
InFynd Interviews By Designations
- InFynd Data Engineer Interview Questions
- InFynd Software Developer Interview Questions
- InFynd Data Engineer Intern Interview Questions
- InFynd Data Analyst Interview Questions
- InFynd Data Entry Operator Interview Questions
- InFynd Trainee Interview Questions
- InFynd Junior Software Developer Interview Questions
- InFynd Junior Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Science Intern Interview Questions
- Data Analyst Intern Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Data Scientist Intern Interview Questions
- Senior Data Engineer Interview Questions
- Show more
InFynd Data Engineer Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Data Analyst
9
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Junior Software Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Market Research Analyst
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Engineer
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Flipkart
Amazon
Paytm
Snapdeal
- Home >
- Interviews >
- InFynd Interview Questions >
- InFynd Data Engineer Intern Interview Questions
