Upload Button Icon Add office photos

Filter interviews by

Freddie Mac Data Engineer Interview Questions and Answers

Updated 1 Jun 2024

Freddie Mac Data Engineer Interview Experiences

1 interview found

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

I applied via Referral and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

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

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

  • Answered by AI
Round 2 - Technical 

(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

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

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

Round 1 - Technical 

(1 Question)

  • Q1. Project discussion, spark, python, sql, big data discussion
Round 2 - Behavioral interview 

(1 Question)

  • Q1. Project discussion and company profile alignment discussion
Round 3 - Case Study 

Data Modelling question and project discussion

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

MCQ - OS,DBMS,C++,Python

Round 2 - Coding Test 

STRING, ROMAN TO INTEGER

Interview Preparation Tips

Interview preparation tips for other job seekers - Do prepare well
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
-
Result
No response

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Questions not related or relavant to the role applied
  • Q2. Bad experience , not opted
Round 2 - Technical 

(1 Question)

  • Q1. Normal , spark and SQL basics
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Good very good have a nice day

Round 2 - One-on-one 

(2 Questions)

  • Q1. Very godo as well as very good
  • Q2. Very well manage the team as wells

Interview Preparation Tips

Interview preparation tips for other job seekers - dsfiasdfuasidfa aspdfaspod psdfasdpf pasdos dpf asdpfspfo[
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Assignment 

Attempt full listening test

Round 2 - Technical 

(7 Questions)

  • Q1. Techincal quations
  • Q2. Lock in the fundamental
  • Ans. 

    Locking in the fundamental means ensuring that the basic principles and processes are securely in place.

    • Ensure accurate data entry by double-checking entries

    • Follow established protocols and guidelines for data entry

    • Regularly update and maintain databases to prevent errors

    • Implement security measures to protect sensitive information

  • Answered by AI
  • Q3. What are your techincal certification
  • Q4. What are some of your weekness
  • Q5. Why do you want to work with us
  • Q6. Where do you see your self in five years
  • Q7. Tell me about a time you made a mistake

Interview Preparation Tips

Topics to prepare for Contizant Technologies Data Entry Operator interview:
  • Advanced Java
  • Data Analysis
  • Database Testing
Interview preparation tips for other job seekers - Data scientist
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
-

I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Coding Test 

Write a code for HTML DOM

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Jan 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
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
Round 2 - HR 

(1 Question)

  • Q1. More than technology,a senior recruiter asks where you stay which gali you stay,which temple is near by,what your husband do,getting into more personal and final he will ask your janam kundali and tell you...
Round 3 - One-on-one 

(1 Question)

  • Q1. Senior recruiter will ask more personal questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Girls and ladies please don't join this company as it is more into priest kinda,they check your caste,class rather your hardwork it seems. This so called senior recruiter totally flirts with you if you are single,divorce,seperarated and also heard his eyes rolls on always girls upper part,no matter whatever she is wearing. I heard after complaining also higher authorities didn't taken the action. Now you people only imagine how is it safe for a girl to work in that disgusting atmosphere. And in any MNC company if the complain is raised the higher authority should take an action but still they kept him then think what kinda company is this. INDIA HR cgs is worst the worst. They are not giving you secured job,HR are saving there job to close that position and you are bakra,who will be paid with very less salary comparative outside and also you are treated like a dog. Think twice thrice to take the decision.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Monster and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - Assignment 

Question are hard in panel

Round 2 - HR 

(3 Questions)

  • Q1. What is the current ctc
  • Ans. 

    I am currently earning a salary of $60,000 per year.

    • My current annual salary is $60,000

    • I am earning $5,000 per month

    • My total compensation package is $60,000

  • Answered by AI
  • Q2. What is the company name
  • Ans. 

    The company name is XYZ Corporation, a leading data analytics firm specializing in providing insights for businesses.

    • XYZ Corporation is a data analytics firm

    • Specializes in providing insights for businesses

  • Answered by AI
  • Q3. Gammon India Ltd
Round 3 - Case Study 

It is very good in study for
Further studies.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Automation testing with testing tools
  • Ans. 

    Automation testing with testing tools involves using software to execute tests and compare actual results with expected results.

    • Automation testing saves time and effort compared to manual testing

    • Testing tools like Selenium, Appium, and TestComplete are commonly used for automation testing

    • Automation testing can be used for regression testing, load testing, and performance testing

    • Automation testing requires programming s...

  • Answered by AI
  • Q2. Integration with automation Devops process
  • Ans. 

    Integration with automation DevOps process is crucial for efficient software testing.

    • Automation testing tools can be integrated with DevOps tools like Jenkins, Git, and Docker.

    • Continuous integration and continuous delivery (CI/CD) pipelines can be set up for automated testing.

    • Test cases can be triggered automatically with each code commit or deployment.

    • Test results can be reported back to the development team for quick...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good experience with hr interview process and communication

Skills evaluated in this interview

Freddie Mac Interview FAQs

How many rounds are there in Freddie Mac Data Engineer interview?
Freddie Mac interview process usually has 2 rounds. The most common rounds in the Freddie Mac interview process are Technical.
What are the top questions asked in Freddie Mac Data Engineer interview?

Some of the top questions asked at the Freddie Mac Data Engineer interview -

  1. What is class and an obj...read more
  2. Write a SQL query on windows functi...read more
  3. What is spark and pysp...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Freddie Mac interview
Referral
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

Exl India Interview Questions
3.5
 • 98 Interviews
Deltax Interview Questions
2.8
 • 85 Interviews
Wayfair Interview Questions
3.7
 • 53 Interviews
Busibud Interview Questions
4.0
 • 42 Interviews
GAMMON INDIA Interview Questions
3.9
 • 29 Interviews
CGS Interview Questions
3.5
 • 26 Interviews
View all
Compare Freddie Mac with

Exl India

3.5
Compare

Amazon Sellers Services

4.1
Compare

Primus Global Technologies

4.0
Compare

GAMMON INDIA

3.9
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