Upload Button Icon Add office photos

Filter interviews by

Fragma Data Systems Data Engineer Interview Questions, Process, and Tips

Updated 27 Sep 2024

Top Fragma Data Systems Data Engineer Interview Questions and Answers

  • Q1. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
  • Q2. What are the optimisation techniques you have used in your project ?
  • Q3. SQL: To calculate the difference in marks for each student ID and marks across different years?
View all 8 questions

2 Fragma Data Systems Data Engineer Interview Experiences

13 questions found

Sort by: Popular

Data Engineer Interview Questions

user image Anonymous

posted on 27 Sep 2024

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 Not Selected

I applied via Naukri.com and was interviewed in Aug 2024.

1 Interview Round

1

Technical Round (10 Questions)

  • Q1. Tell me about yourself, and project architecture. What are your day-to-day responsibilities?
  • Q2. SQL: To calculate the difference in marks for each student ID and marks across different years?
  • Q3. SQL: Statewise which gender purchase is the most?
  • Q4. What is ADF ??
  • Q5. Pysaprk Coding Question?
  • Q6. What is DAG ??
  • Q7. What is Lineage ??
  • Q8. How does Spark handle fault tolerance?
  • Q9. There are four cores and four worker nodes in Spark. How many jobs will run in parallel?
  • Q10. What are the optimisation techniques you have used in your project ?

Skills evaluated in this interview

Data Engineer Interview Questions

user image Anonymous

posted on 10 Oct 2023

Interview experience
4
 Good
Difficulty level
 Easy
Duration
 Less than 2 weeks
Result
Selected  Selected

I was interviewed before Oct 2022.

4 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2

Coding Test Round

1.ETL Pipeline
2.PySpark Code
3.SQL

3

Technical Round (2 Questions)

  • Q1. 1.sql easy question 2.pyspark easy code as I was fesher
  • Q2. 1.query related to group by
4

Technical Round (1 Question)

  • Q1. 1.One tricky sql query 2.What is sqoop?sqoop performs which job - map or reduce?

Get interview-ready with top interview questions

Interview questions from similar companies

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

I applied via Referral and was interviewed in Sep 2024.

3 Interview Rounds

1

Technical Round (17 Questions)

  • Q1. What was your role and responsibilities in your previous company?
  • Q2. Key features of Java 8.
  • Q3. What is multi-threading and how have you used it in your application?
  • Q4. What are the compatible features of Java?
  • Q5. Can you explain what ConcurrentModificationException is and how to resolve it?
  • Q6. What is Spring Boot?
  • Q7. What are microservices?
  • Q8. Do microservices contain transactional data?
  • Q9. How can microservices be updated with new data?
  • Q10. What technologies can be used to update microservices with data?
  • Q11. How do you configure login in Spring Boot?
  • Q12. How do you handle multiple data sources in Spring Boot?
  • Q13. Do you filter out duplicate employee records from a list?
  • Q14. How do you identify an object in a collection?
  • Q15. What is a REST API?
  • Q16. How do you implement an authentication service in an application?
  • Q17. How does REST service return data and in which format?
2

Technical Round (9 Questions)

  • Q1. What is the role of the Spring Boot actuator?
  • Q2. How can you secure a spring boot application, especially in the context of a banking application? what are the basics of spring security?
  • Q3. How can you integrate Spring Data JPA with Spring Boot?
  • Q4. Can you explain the concept of Optional in Java?
  • Q5. Do you have any experience with job scheduling?
  • Q6. How does microservice architecture differ from monolithic architecture?
  • Q7. What is the use of the CI/CD pipeline in software development?
  • Q8. What technologies you were using to create the UI side of your springboard application?
  • Q9. What do you know about Vaadin?
3

Technical Round (24 Questions)

  • Q1. What is the difference between JDK and JRE?
  • Q2. Can we run a program without JRE?
  • Q3. What is the internal working of HashMap in java?
  • Q4. What happens if I have a key with a null value in HashMap and where it will get stored?
  • Q5. Difference between fail-fast and fail-safe? which one is synchronized?
  • Q6. HashMap vs LinkedHashMap?
  • Q7. Load factor in HashMap?
  • Q8. What is a Daemon thread?
  • Q9. Concept of multithreading in Java and how does it work?
  • Q10. What is the Executor framework in Java?
  • Q11. Name some methods in Executor framework?
  • Q12. What is the join method in Java?
  • Q13. Explain one-to-many and many-to-one relationships in Hibernate.
  • Q14. What is an ID in Hibernate and how it is used?
  • Q15. How do you create custom queries in Spring Data JPA?
  • Q16. Name different annotations used in Spring Boot.
  • Q17. How to create a repository interface in Spring Data JPA?
  • Q18. How to define custom queries in the repository interface?
  • Q19. What is the difference between @Controller and @RestController?
  • Q20. What is DispatcherServlet in Spring Boot?
  • Q21. What are microservices?
  • Q22. How does communication happen between microservices?
  • Q23. Internal working of messaging between microservices.
  • Q24. Coding problem - Find the maximum and minimum sum after removing one element from an array. (what is the time complexity of the program?)

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure to have deep knowledge about:
Core Java, Java Generics, Spring Boot, Web Services, ORM, JMS, and Microservice Architecture.

Good to know about CI/CD and Vaadin.

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What are different KPI's
  • Q2. Differentiate loc and iloc in pandas
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Assignment Round

Basics of python , java ,oops, dbms

Interview experience
2
 Poor
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Job Portal and was interviewed in Feb 2024.

3 Interview Rounds

1

Aptitude Test Round

30 mins Aptitude Question

2

Coding Test Round

30 mins - 3 Coding Question

3

Technical Round (2 Questions)

  • Q1. Describe Rest API
  • Q2. What is various Response code. Diffenrence b/w 200 & 201, 400 & 403

Skills evaluated in this interview

Software Engineer Interview Questions

Centelon user image sangramsinh Tanaji katare

posted on 7 Oct 2023

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 Not Selected

I applied via campus placement at Tatyasaheb Kore Institute of Engineering and Technology, Warananagar and was interviewed in Sep 2023.

3 Interview Rounds

1

Aptitude Test Round

1 hour test tha focus on the logical apti que.

2

Coding Test Round

1 hr for complete the code and pass the test case.

3

Technical Round (3 Questions)

  • Q1. Depth knowledege about sql , oops concept , project and logics of programming language.
  • Q2. Tell me about your project
  • Q3. Tell me about your internship experiance.

Interview Preparation Tips

Topics to prepare for Centelon Software Engineer interview:
  • SQL
  • C++
  • Java
  • HTML
  • CSS
Interview preparation tips for other job seekers - Focus an the deep knowledge on logic.
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (1 Question)

  • Q1. SQL queries like search last element
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via cutshort and was interviewed before Sep 2023.

3 Interview Rounds

1

Coding Test Round

Asked about JavaScript Topics
1. Promise
2. Clousure
3. Hoisting.

2

Assignment Round

Create an Application Routes are protected by different roles in ReactJS

3

HR Round (3 Questions)

  • Q1. What you want to join this company
  • Q2. Where do you see yourself in 5 years
  • Q3. What is most important to company good culture or handsome package or both and why

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Keep good understanding React and JS
2. Should be able to what you have why you have chosen this way.

I applied via Naukri.com and was interviewed in Sep 2021.

3 Interview Rounds

1

Coding Test Round

I was asked t solve 2 coding questions got 20 minutes for each, both were on DS and Algo moderate problems. 1 on trees and second on linked list.

2

Technical Round (1 Question)

  • Q1. System design round where i was asked to design a parking lot followed by few DB questions
3

Technical Round (1 Question)

  • Q1. Then there was a UI round where i had to answer few Typescript questions and then was given a case study which i had t solve and propose a UI/UX solution.

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall i felt moderate difficulty so if you are prepared for DS/Algo you will have an offer from Apptio.

Fragma Data Systems Interview FAQs

How many rounds are there in Fragma Data Systems Data Engineer interview?
Fragma Data Systems interview process usually has 2-3 rounds. The most common rounds in the Fragma Data Systems interview process are Technical, Resume Shortlist and Coding Test.
How to prepare for Fragma Data Systems Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Fragma Data Systems. The most common topics and skills that interviewers at Fragma Data Systems expect are SQL, Spark, Azure, Big Data and Data Warehousing.
What are the top questions asked in Fragma Data Systems Data Engineer interview?

Some of the top questions asked at the Fragma Data Systems Data Engineer interview -

  1. There are four cores and four worker nodes in Spark. How many jobs will run in ...read more
  2. What are the optimisation techniques you have used in your projec...read more
  3. SQL: To calculate the difference in marks for each student ID and marks across...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Fragma Data Systems interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Fragma Data Systems Data Engineer Salary
based on 57 salaries
₹3.7 L/yr - ₹15 L/yr
21% less than the average Data Engineer Salary in India
View more details

Fragma Data Systems Data Engineer Reviews and Ratings

based on 8 reviews

4.2/5

Rating in categories

3.4

Skill development

4.3

Work-Life balance

3.5

Salary & Benefits

4.1

Job Security

4.7

Company culture

4.1

Promotions/Appraisal

3.7

Work Satisfaction

Explore 8 Reviews and Ratings
Data Engineer
57 salaries
unlock blur

₹3.7 L/yr - ₹15 L/yr

Software Engineer
32 salaries
unlock blur

₹4.1 L/yr - ₹14.7 L/yr

Business Analyst
24 salaries
unlock blur

₹3.5 L/yr - ₹6 L/yr

Senior Software Engineer
20 salaries
unlock blur

₹6.2 L/yr - ₹25 L/yr

Data Analyst
12 salaries
unlock blur

₹3.5 L/yr - ₹6.4 L/yr

Explore more salaries
Compare Fragma Data Systems with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview