Freddie Mac Interview
What does Freddie Mac do? Explain the process. - answerFreddie Mac is building a
better finance system for homeowners, renters, lenders , and taxpayers.
The basic premise works like this. When the borrower submits a loan application with a
lender such as a bank, the lender underwrites the loan and provide the loan to the
borrower. Freddie Mac purchases those loans, thereby keeping the mortgage capital
flowing, allowing the lender to offer more loans to qualified borrowers.
Freddie Mac pools those loans and sells them in the market as mortgage backer
securities.
What is the Single Family Credit Analytics team's business challenge? - answerThey
require faster access to usable loan application and delivery data. Because gaining
access to this semi-structured data enables the Single Family Credit Analytics Team to
perform
1) Risk Monitoring
2) Customer Management
3) Innovation
4) Quality Control, Sampling, and Fraud Analytics
Need for this data is growing exponentially as they launch new products.
What time of data is being collected by the homeowner? - answerBorrower income,
assets, appraisals of the property
This data comes in different formats and different types as XML, JSON, word, CSV
After analyzing this data from these sources, they need to be able to integrate this data
with our rules engine system which shares data using xml files. All our upstream
application are XML.
They also need to integrate with third party data sets to generate even more insights.
What are the key components of a common data engineering framework? - answer1)
Ingestion - Ingestion source XML data are stored in external HIVE tables as raw XML
files
2) Data Discovery - XML and XSD data is processed using a Python library to generate
the data dictionary/discovery of all attributes of XML
What does Freddie Mac do? Explain the process. - answerFreddie Mac is building a
better finance system for homeowners, renters, lenders , and taxpayers.
The basic premise works like this. When the borrower submits a loan application with a
lender such as a bank, the lender underwrites the loan and provide the loan to the
borrower. Freddie Mac purchases those loans, thereby keeping the mortgage capital
flowing, allowing the lender to offer more loans to qualified borrowers.
Freddie Mac pools those loans and sells them in the market as mortgage backer
securities.
What is the Single Family Credit Analytics team's business challenge? - answerThey
require faster access to usable loan application and delivery data. Because gaining
access to this semi-structured data enables the Single Family Credit Analytics Team to
perform
1) Risk Monitoring
2) Customer Management
3) Innovation
4) Quality Control, Sampling, and Fraud Analytics
Need for this data is growing exponentially as they launch new products.
What time of data is being collected by the homeowner? - answerBorrower income,
assets, appraisals of the property
This data comes in different formats and different types as XML, JSON, word, CSV
After analyzing this data from these sources, they need to be able to integrate this data
with our rules engine system which shares data using xml files. All our upstream
application are XML.
They also need to integrate with third party data sets to generate even more insights.
What are the key components of a common data engineering framework? - answer1)
Ingestion - Ingestion source XML data are stored in external HIVE tables as raw XML
files
2) Data Discovery - XML and XSD data is processed using a Python library to generate
the data dictionary/discovery of all attributes of XML
