Add office photos
Filter interviews by
Freddie Mac Interview Questions and Answers
Freddie Mac Interview Experiences
2 interviews 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
Data Engineer Interview Questions asked at other Companies
I was interviewed in Oct 2021.
(2 Questions)
- Q1. What all issues you faced during the project? What specific tool or technologies are you using in the project and explain?
- Q2. Asked about a basic programming question
Interview Preparation Tips
Junior Associate Interview Questions asked at other Companies
Interview questions from similar companies
Selected
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
General basic assessment.
(1 Question)
- Q1. They will give you few PDFs to read and then MCQ from that.
Interview Preparation Tips
On the starting date you'll again message one person(Yashima Kamra) on Skype, they'll give you 'Zulip'(it's an open source chat system, interface is kind of like Discord but too basic) access. Now you need to message in an assigned group in Zulip. The Zulip part is 'Training' in real but good luck getting any support from the other person. He/she will just give you commands, and if you ask any questions or ask for assistance to understand the new process they'll simply ignore that.
Then if you're lucky like me one day they'll report that you're ate fault, you haven't reported so they've revoked your Zulip access.
I have joined there or you can say hoped to work atleast(as it was 4 hours/day job) but that's not possible it seems.
If you're looking for jobs here I'd suggest to give it a try ofcourse so that people can actually know about this company's rubbish people.
E-Commerce Executive Interview Questions & Answers
Amazon Sellers Services
Anonymous
posted on 3 Jan 2025
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
(3 Questions)
- Q1. How to work in Amazon
- Q2. What the salary
- Q3. How to work in e-commerce
(2 Questions)
- Q1. How to work in Amazon
- Q2. What the salary
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about yourself
- Q2. SQL query related to Uber
(1 Question)
- Q1. Question related to Tableau and one SQL question
Interview Preparation Tips
I applied via Campus Placement
It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.
There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.
(5 Questions)
- Q1. Email validation question from coding challenge
- Q2. Binary Search on rotated arrays
- Q3. About projects (reason behind using the mentioned database)
- Q4. Use of package.json file
- Q5. What are scripts in package.json file
Interview Preparation Tips
Selected
(1 Question)
- Q1. I have around 9 rounds interview in span of 2 months
(1 Question)
- Q1. Everyday one round interview
(1 Question)
- Q1. Same as above .it is too much
(1 Question)
- Q1. Same as above .it is too much
(1 Question)
- Q1. Same only .it is too much
4 member team interview
(1 Question)
- Q1. One on one interview
(1 Question)
- Q1. Reference . through referral I sent my resume
(1 Question)
- Q1. Salary discussion
(1 Question)
- Q1. It is too much
(2 Questions)
- Q1. Graph theory questions related
- Q2. Programming,data structure and algo
(2 Questions)
- Q1. Intro about your self
- Q2. Mostly focused on CSE fundamentals
I applied via Job Portal and was interviewed in Oct 2024. There was 1 interview round.
(3 Questions)
- Q1. SQL question ( window functions) dense_rank
- Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
- Q3. Some question on spark optimisations
Interview Preparation Tips
(5 Questions)
- Q1. Salary why not time being paid ?
- Q2. Without any evidence how blaming staff ??
- Ans.
Blaming staff without evidence is unprofessional and can damage morale and trust within the team.
Avoid jumping to conclusions without concrete evidence
Encourage open communication and transparency
Focus on problem-solving rather than assigning blame
Provide constructive feedback and support to help staff improve
Lead by example and take responsibility for mistakes
- Q3. Company always carried out theft staff ?
- Q4. No one professional staff in office and overall company ??
- Q5. Why directors board unseen to thefts??
- Ans.
Directors may not always be aware of thefts due to lack of oversight, trust in employees, or focus on other priorities.
Directors may not be directly involved in day-to-day operations where thefts occur
There may be a lack of proper oversight or monitoring mechanisms in place
Directors may trust their employees and not suspect them of theft
Directors may be focused on other strategic priorities and not pay attention to pot
Interview Preparation Tips
Hr team non capable and non educated people
Freddie Mac Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Associate Interview Questions
- Design Engineer Interview Questions
- Business Analyst Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Test Engineer Interview Questions
- Senior Software Engineer Interview Questions
- System Engineer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Exl India
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Calculate your in-hand salary
- Home >
- Interviews >
- Freddie Mac Interview Questions
