AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Freddie Mac Data Engineer Interview Questions and Answers
Freddie Mac Data Engineer Interview Experiences
1 interview found
I applied via Referral and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. What is class and an object
- Ans.
A class is a blueprint for creating objects, while an object is an instance of a class.
A class defines the properties and behaviors of objects.
An object is a specific instance of a class.
Classes can be used to create multiple objects with similar characteristics.
Objects can interact with each other by calling methods defined in their class.
Example: Class 'Car' defines properties like 'color' and 'model', while object '
- Q2. What is spark and pyspark
- Ans.
Spark is a distributed computing framework while PySpark is the Python API for Spark.
Spark is a fast and general-purpose cluster computing system.
PySpark is the Python API for Spark, allowing users to write Spark applications using Python.
Spark provides high-level APIs in Java, Scala, Python, and R.
PySpark enables interactive data analysis with the Spark SQL module.
Both Spark and PySpark are widely used in big data pro
(1 Question)
- Q1. Write a SQL query on windows functions
- Ans.
SQL query using window functions
Use OVER() clause to define window frame
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), etc.
Example: SELECT column1, column2, ROW_NUMBER() OVER(ORDER BY column1) AS row_num FROM table_name
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.
(1 Question)
- Q1. Project discussion, spark, python, sql, big data discussion
(1 Question)
- Q1. Project discussion and company profile alignment discussion
Data Modelling question and project discussion
Create an iOS project with given details
(1 Question)
- Q1. Discussion on the assignment that I submitted
(1 Question)
- Q1. Design Book Management System
- Ans.
Design a Book Management System for organizing and tracking books.
Create a database to store book information such as title, author, genre, and availability status
Implement a user interface for users to search, borrow, return, and reserve books
Include features like notifications for due dates, book recommendations, and user reviews
Skills evaluated in this interview
Software Engineer Interview Questions & Answers
Contizant Technologies
Anonymous
posted on 7 Jun 2024
(2 Questions)
- Q1. Spark architecture.
- Q2. Narrow and wide transformations
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
Hashmap related question, easy bfs
(1 Question)
- Q1. Asked some question related to parking lot and asked to draw all diagrams
Sql questions database modelling
Selected
I applied via Campus Placement and was interviewed before Apr 2022. There were 4 interview rounds.
There were 3 coding and 1 SQL question.
(1 Question)
- Q1. This was regarding the coding test on your approach and how you came with that answer
(1 Question)
- Q1. Some technical questions about programming were there to know about your understanding with coding
MCQ - OS,DBMS,C++,Python
STRING, ROMAN TO INTEGER
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Sep 2024. There were 2 interview rounds.
50 questions was and the duration was 45 mins
Dsa and development questions were asked, and computer fundamentals were also asked.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Easy to moderate general aptitude questions were asked
Easy to moderate questions were asked
Interview Preparation Tips
Freddie Mac Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Freddie Mac Data Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Practo
- Home >
- Interviews >
- Freddie Mac Interview Questions >
- Freddie Mac Data Engineer Interview Questions
