Hi all, I am having my onsite soon with Facebook and I am very nervous(first time with FAANG) . This is a generalist role and looking for someone having exp for 2yrs with DW, sql, coding.
I am expecting below format
1) 2 etl Round - product sense, etl, sql and coding
2) 1 data modeling round
Any pointer would be helpful. How they present a case study is what I am curious about.
#data #dataanalytics #facebook
Want to see the real deal?
More inside scoop? View in App
More inside scoop? View in App
blind
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
FOLLOWING
Industries
Job Groups
- Software Engineering
- Product Management
- Information Technology
- Data Science & Analytics
- Management Consulting
- Hardware Engineering
- Design
- Sales
- Security
- Investment Banking & Sell Side
- Marketing
- Private Equity & Buy Side
- Corporate Finance
- Supply Chain
- Business Development
- Human Resources
- Operations
- Legal
- Admin
- Customer Service
- Communications
Return to Office
Work From Home
COVID-19
Layoffs
Investments & Money
Work Visa
Housing
Referrals
Job Openings
Startups
Office Life
Mental Health
HR Issues
Blockchain & Crypto
Fitness & Nutrition
Travel
Health Care & Insurance
Tax
Hobbies & Entertainment
Working Parents
Food & Dining
IPO
Side Jobs
Show more
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
comments
Next, practice mocking out some charts that could be rendered on a dashboard to present these metrics.
Next, write down some hypothetical star schemas that could be used to store these metrics.
Finally come up with 2-3 questions to measure specific things, or answer specific questions based on that data in that schema, and write appropriate SQL queries.
And then repeat the same work assuming all that data is held in some python collection, and write a python script to come up with the same answer.
If you repeat this process for 2-3 different types of companies, that should be good prep.
I'm still having one question. Do we get any files to load into tables? My recruiter also mentioned about streaming data, does it mean we get live data feed?