AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Fragma Data Systems Interview Questions, Process, and Tips for Freshers
Top Fragma Data Systems Interview Questions and Answers for Freshers
- Q1. What are different types of Joins?asked in Business Analyst interview
- Q2. What is the Difference between Union and Joinsasked in Business Analyst interview
Fragma Data Systems Interview Experiences for Freshers
3 interviews found
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
(4 Questions)
- Q1. Self introduction
- Q2. Windows function and how you used
- Ans.
Window functions are used to perform calculations across a set of table rows that are related to the current row.
Window functions are used in SQL to perform calculations on a specific subset of rows related to the current row.
They are often used with aggregate functions like SUM, AVG, and COUNT to calculate running totals, moving averages, and rankings.
Examples of window functions include ROW_NUMBER(), RANK(), LEAD(),
- Q3. Sql Coding questions. Window functions with joins.
- Q4. Pyspark code for how you connect the data to ADLS with doing partition
- Ans.
Use PySpark code to connect data to ADLS with partitioning
Use SparkSession to create a Spark application
Set the configuration for ADLS storage account and container
Read data from ADLS using Spark DataFrame API
Partition the data based on a specific column while writing back to ADLS
Selected
I appeared for an interview before Oct 2022.
1.ETL Pipeline
2.PySpark Code
3.SQL
(2 Questions)
- Q1. 1.sql easy question 2.pyspark easy code as I was fesher
- Q2. 1.query related to group by
(1 Question)
- Q1. 1.One tricky sql query 2.What is sqoop?sqoop performs which job - map or reduce?
Top Fragma Data Systems Data Engineer Interview Questions and Answers
Data Engineer Interview Questions asked at other Companies
I applied via Internshala and was interviewed before Sep 2021. There were 5 interview rounds.
I was given a pdf file containing 3 Problem statements along with the output for which I had to write SQL queries.
(3 Questions)
- Q1. Theoretical Questions related to SQL were asked like types of join, the difference between union and join, related to my project, and some behavioral questions.
- Q2. What are different types of Joins?
- Ans.
Joins are used to combine data from two or more tables based on a related column between them.
Inner Join: returns only the matching rows from both tables
Left Join: returns all rows from the left table and matching rows from the right table
Right Join: returns all rows from the right table and matching rows from the left table
Full Outer Join: returns all rows from both tables
Cross Join: returns the Cartesian product of b
- Q3. What is the Difference between Union and Joins
- Ans.
Joins combine rows from two or more tables based on a related column, while unions combine rows from two or more tables with the same structure.
Joins are used to combine data from different tables based on a related column
Unions are used to combine data from tables with the same structure
Joins can be inner, left, right, or full, while unions are always a combination of all rows
Joins can have multiple conditions, while ...
(1 Question)
- Q1. Scenario-based questions on SQL
(1 Question)
- Q1. Questions related to me like what my parents do etc. and their company profile.
Interview Preparation Tips
Skills evaluated in this interview
Business Analyst Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
Data Analyst Interview Questions & Answers
Rite Software Solutions And Services
Anonymous
posted on 18 Feb 2025
SQL AND POWERBI related questions
Interview Preparation Tips
upendra rao moyyila
Selected
I applied via Instahyre and was interviewed before Sep 2023. There were 2 interview rounds.
(1 Question)
- Q1. Reason for changing job and why should we hire you
- Ans.
Seeking new challenges and opportunities for growth. I bring a unique blend of skills and experience to add value to your team.
Looking for new challenges and opportunities for professional growth
Seeking a more dynamic work environment to utilize my skills effectively
Excited about the possibility of contributing to a new team and organization
Believe my diverse skill set and experience make me a valuable addition to your
(2 Questions)
- Q1. Real time DBA issues and scenarios
- Q2. Questions on HA and Always on
Software Developer Interview Questions & Answers
Pragmasys Consulting LLP
NISHANT KUMAR
posted on 21 Jun 2024
(1 Question)
- Q1. Describe oops concept.
- Ans.
OOPs concept stands for Object-Oriented Programming, which is a programming paradigm based on the concept of objects.
OOPs focuses on creating objects that contain both data and methods to manipulate that data.
It emphasizes concepts like inheritance, encapsulation, polymorphism, and abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation restricts access to certain comp...
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
PEN PAPER round consisting of three coding and c/c++ output based questions.
(2 Questions)
- Q1. OOPS concepts , javascript
- Q2. Projects related questions
(2 Questions)
- Q1. Behavioural questions
- Q2. Resume , internship related questions
Interview Preparation Tips
- Resume
Selected
I applied via cutshort and was interviewed before Sep 2023. There were 3 interview rounds.
Asked about JavaScript Topics
1. Promise
2. Clousure
3. Hoisting.
Create an Application Routes are protected by different roles in ReactJS
(3 Questions)
- Q1. What you want to join this company
- Ans.
I want to join this company because of its innovative projects and strong company culture.
Innovative projects in AI and machine learning excite me
Positive reviews from current employees about company culture
Opportunities for growth and learning in the tech industry
- Q2. Where do you see yourself in 5 years
- Ans.
In 5 years, I see myself as a senior software engineer leading a team of developers on innovative projects.
Advancing to a senior software engineer role
Leading a team of developers on projects
Working on innovative and challenging projects
Continuing to learn and grow in the field
- Q3. What is most important to company good culture or handsome package or both and why
- Ans.
Both good culture and a handsome package are important for a company as they contribute to employee satisfaction and retention.
A good culture fosters a positive work environment, promotes collaboration, and boosts employee morale.
A handsome package attracts top talent, motivates employees to perform well, and reduces turnover rates.
Having both good culture and a handsome package can lead to higher employee satisfaction...
Interview Preparation Tips
2. Should be able to what you have why you have chosen this way.
I applied via Company Website and was interviewed in Aug 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Explain different Testing scenarios
- Ans.
Testing scenarios include functional, performance, security, usability, and compatibility testing.
Functional testing ensures that the software meets the requirements and specifications.
Performance testing checks the software's speed, scalability, and stability under various loads.
Security testing identifies vulnerabilities and ensures data protection.
Usability testing evaluates the software's user-friendliness and ease...
- Q2. Smoke testing & sanity testing
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Port forwarding.Http service.Swap memory
Fragma Data Systems Interview FAQs
Tell us how to improve this page.
Fragma Data Systems Interviews By Designations
- Fragma Data Systems Data Engineer Interview Questions
- Fragma Data Systems Machine Learning Scientist - Big Data/NLP Interview Questions
- Fragma Data Systems Data Scientist Interview Questions
- Fragma Data Systems Technical Lead Interview Questions
- Fragma Data Systems Software Engineer Interview Questions
- Fragma Data Systems Informatica Developer Interview Questions
- Fragma Data Systems Senior Software Engineer Interview Questions
- Fragma Data Systems Business Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Fragma Data Systems Interview Process for Freshers
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fragma Data Systems Reviews and Ratings
based on 117 reviews
Rating in categories
|
Data Engineer
60
salaries
|  ₹3.5 L/yr - ₹14.8 L/yr |
|
Software Engineer
29
salaries
| ₹4 L/yr - ₹22.9 L/yr |
|
Business Analyst
23
salaries
| ₹3.5 L/yr - ₹6 L/yr |
|
Senior Software Engineer
20
salaries
| ₹7.8 L/yr - ₹33 L/yr |
|
Data Analyst
12
salaries
| ₹3.5 L/yr - ₹6.4 L/yr |
SE2 DIGITAL SERVICE LLP
Pragmasys Consulting LLP
Vowelweb
TantranZm Technologies
- Home >
- Interviews >
- Fragma Data Systems Interview Questions >
- Fragma Data Systems Interview Questions for Fresher
