Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by InFynd Team. If you also belong to the team, you can get access from here

InFynd Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

InFynd Data Engineer Intern Interview Questions and Answers

Updated 14 Aug 2024

InFynd Data Engineer Intern Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Intermediate questions

Round 2 - Coding Test 

Basic sql queries- written

Round 3 - Technical 

(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...

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Data Engineer Interview Questions & Answers

Amazon user image Rohit Kulkarni

posted on 21 Sep 2015

Interview Preparation Tips

Round: Resume Shortlist
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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Coding Test 

Simple sql and python basic questions was asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for basic sql and python interview questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Aug 2024. There were 5 interview rounds.

Round 1 - Coding Test 

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

Round 2 - One-on-one 

(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.

  • Answered by AI
  • Q3. Event session data modeling
Round 3 - One-on-one 

(1 Question)

  • Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
Round 4 - One-on-one 

(1 Question)

  • Q1. This was hiring manager round. Detailed discussions on project and previous experience
Round 5 - HR 

(1 Question)

  • Q1. Strength, weakness and why myntra

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Adv SQL, Spark, data modeling, data engineering system design
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jun 2023. There were 3 interview rounds.

Round 1 - Coding Test 

1 hr medium level DSA questions

Round 2 - One-on-one 

(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

  • Answered by AI
  • 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...

  • Answered by AI
Round 3 - HR 

(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

  • Answered by AI
  • Q2. About the company

Interview Preparation Tips

Interview preparation tips for other job seekers - This was an on-campus interview, everything was done in one day

Skills evaluated in this interview

Round 1 - Technical 

(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 '...

  • Answered by AI
Round 2 - Technical 

(1 Question)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - look into spark architecture in details . how to assign executors and cores effeciently etc

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Mar 2023. There were 4 interview rounds.

Round 1 - Coding Test 

Hackerrank test with medium level DSA and SQL questions

Round 2 - Technical 

(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...

  • Answered by AI
  • Q3. DSA Medium level
Round 3 - Technical 

(2 Questions)

  • Q1. Big data Eco system
  • Q2. SQL and Python related
Round 4 - Technical 

(1 Question)

  • Q1. Managerial round on a specific use case designing

Interview Preparation Tips

Interview preparation tips for other job seekers - For Big data related interviews, Be very good with spark optimisations and SQL

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Question on sql and other stuff
Round 2 - Technical 

(1 Question)

  • Q1. Question on sql and other stuff
Round 3 - Technical 

(1 Question)

  • Q1. Question on sql and queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join. I personally found it very unprofessional.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain data architecture of your project
  • Q2. Explain data lake
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Job Fair and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Coding Test 

Duration - 3 hours, DSA

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare DSA very well because it is very difficult

InFynd Interview FAQs

How many rounds are there in InFynd Data Engineer Intern interview?
InFynd interview process usually has 3 rounds. The most common rounds in the InFynd interview process are Aptitude Test, Coding Test and Technical.
What are the top questions asked in InFynd Data Engineer Intern interview?

Some of the top questions asked at the InFynd Data Engineer Intern interview -

  1. Difference between delete, truncate, d...read more
  2. 10 keywords in ...read more

Tell us how to improve this page.

InFynd Data Engineer Intern Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Paytm Interview Questions
3.3
 • 752 Interviews
BigBasket Interview Questions
3.9
 • 359 Interviews
Myntra Interview Questions
4.0
 • 214 Interviews
Blinkit Interview Questions
3.7
 • 181 Interviews
Nykaa Interview Questions
3.5
 • 114 Interviews
Snapdeal Interview Questions
3.8
 • 75 Interviews
View all
Data Analyst
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Software Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Market Research Analyst
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare InFynd with

Flipkart

4.0
Compare

Amazon

4.1
Compare

Paytm

3.3
Compare

Snapdeal

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview