facebook data engineer, infrastructure strategy phone interview
my phone interview is scheduled with facebook for data engineer, infrastructure strategy role, what to expect ? recruiter said 2-3 sql questions and 2-3 coding questions in 45mins. as per glassdoor for data engineer role 5 questions in each area (sql...
i thought facebook allowed you to select the team of your choice?
it's facebook. go for it buddy. how can you be so sure that you'll get the job? appear for the interview, at least. Hi there!


It depends, from a few days up to 2-4 weeks or so. If longer, you can contact HR directly and ask.


Was it helpful?


All the best,
GB hi,

there is no one-fits-it-all framework that you can use. viktor cheng approach is good but oversimplified.  you should be flexible enough to come up with your own approaches and it comes with practice. 

i recommend the following approach:

1) start with "case in point" book - you can download this book for free everywhere. it's not the best guide on how you should approach the cases, however, it will give you the basic understanding.

2) start practicing cases with partners here or find them locally. !!! find experienced partners or coaches who can provide a good feedback!!!

3) purchase and read viktor cheng book (amazon kindle store) and listen to loms (his website). i recommend to reread the book and listen to loms every 15 cases. every time, having more experience, you’ll be finding something new.

4) practice fast math


 learn how to multiply double digit numbers (https://www.youtube.com/watch?v=6ndkkpzyjho)
 learn the division table up to 1/11 (i.e. 5/6 = 83.3)
 learn how to work with zeros (hint: 4000000 = 4*10ˆ6)
 use math tools (mimir math for ios), math tool on viktor cheng website to practice


5) below you can find a list of the most common case types and some high-level recommendations on structuring:


 market sizing - structuring from the supply or demand side. structuring using a formula or using an issue tree
 profitability - basic profitability framework. remember about different revenue streams and product mix
 market context cases (market entry, new product, acquisition, etc). always start with the big picture "market". finish with something specific to the case (e.g. how to enter?"). structure it as if you are defining the work streams for the real project.
 operational math problem (e.g. should we increase the speed of an elevator or just buy a second one? how should we reduce the queues? etc.) - structuring as a process / value chain, with inflows, operations, and outflows
 cost cutting - i provided the recommendations on structuring it here: https://www.preplounge.com/en/consulting-forum/operations-cases-mck-1105#a2134
 valuation - purely financial structure with cash flows, growth rate, wacc / hurdle rate, etc.
 synergies - revenue synergies (price, qty, mix) and cost synergies (value chain).
 social / economics cases (e.g. how to improve the quality of life in the city? how to increase the revenues of the museum?) - huge variability. practice 3-5 social cases before the interview


6) also, i would try to focus on the most common industries in the following priority(sorted by probability of getting a case): 1-retail and cpg; 2-airlines; 3-telecom; 4-banking; 5-natural resources; 6-tech

7) ! important: don't forget about the fit interview part. crafting you stories and backups stories will require a couple of weeks!

ps

here is a good list of articles regarding the different parts of the case:

1) start with clarifying questions:

https://www.preplounge.com/en/consulting-forum/clarifying-questions-1786#a3956

2) communicating while structuring. here is a long post by me on how to communicate the structure during the case study:

https://www.preplounge.com/en/consulting-forum/how-to-communicate-its-structure-for-the-case-study-1313#a2806

3) using hypothesis. i made a post about hypothesis here:

https://www.preplounge.com/en/consulting-forum/how-to-state-a-hypothesis-and-match-to-the-structure-1156#a2268

4) communicating while making calculations: 


 always tell the interviewer your approach
 check with the interviewer that your approach is correct
 come to the interviewer with some preliminary answers
 check your assumptions with the interviewer


5) communicating during the analysis of graphs / tables


 take a minute to look at the graph. read the graph title. look at the graph type and define the type (pie chart, line chart, etc). look at the legend (ask for clarifying questions if necessary). identify whats going on on the graph. look for: trends, % structures. look for unusual things - correlations, outliers,
 make 3-4 conclusions from the graph. think out loud on potential hypothesis on what could be the root cause / what are the consequences
 prioritize the most important for your current analysis and move forward with the case


6) communicating while having questions on creativity


 ask an interview for a minute to think
 think of several buckets of ideas (e.g. organic growth / non-organic growth / differentiation). remember to think as big as possible
 narrow down to each bucket and generate as many ideas as possible
 present the structure (buckets) and then your ideas


7) communicating your conclusion. you can find a good example i've posted here:

https://www.preplounge.com/en/consulting-forum/how-much-answer-first-should-the-conclusion-be-1231#a2493

8) communicating your fit stories

use the top-down approach while communicating your stories. "the pyramid principle" is the must-read by ex mckinsey on this topic.

i recommend using the star framework:


 in situation, you should briefly provide the context, usually in 1 or 2 sentences
 task usually includes 2 or 3 sentences describing the problem and your objective.
 then you provide a list of specific actions you took to achieve the goal. it should take 1 or 2 sentences per action (usually 3-4 actions). note that the interviewer can stop you any minute and ask for more details.
 the results part should have 1 or 2 sentences describing the outcomes. this part is finalizing your story - make sure it can impress the interviewer and stay in the memory.


best! Manuela 

Hello, Manuela!


In order to find questions asked for the FIT part in the Spanish offices of BCG, I would recommend going through Glassdoor and evaluating the information written under interviews. 


To save you same work, here it is: https://www.glassdoor.com/Interview/Boston-Consulting-Group-Madrid-Interview-Questions-EI\_IE3879.0,23\_IL.24,30\_IM1030.htm


If you want to go the extra mile, I would (1) segment the information per role (2) evaluate frequency of questions. 


Good luck :) i am not a salesforce expert, but checking this video here: <https://www.youtube.com/watch?v=c2vnmg4f4ho> , it looks like you will need to setup several fields in the http post for campaign builder.

the salesforce form has several hidden and text fields that need to be mapped accordingly. the hidden… Hi


In **consulting interviews** you may have **two types of M&A cases:**


1. Commercial due-diligence of the target company
2. Synergies calculation of two merging companies


There are **two ways to identify the exact type of a case:**


* The interviewer will tell you
* In the beginning, while asking clarifying questions you ask what is the objective and if we have any other company in the portfolio that can have potential synergies


**1. For commercial DD** you can use the following structure:


**Market**


* Size
* Growth rates
* Profitability
* Segments
* Distribution channels


**Competition**


* Market shares of competitors and their segments (see the next point)
* Concentration / fragmentation (Fragmented market with lots of small players is less mature and easier to enter from a scratch. Concentrated market is hard to enter but has potential acquisition targets)
* Unit economics of the players (Margins, relative cost position)
* Key capabilities of the players (e.g. suppliers, assets, IP, etc)


**Company** 


* Unit economics (Margins, costs) in current or target markets
* Brand
* Product mix
* Key capabilities


**Feasibility of exit**:


* Exit multiples
* Exit time
* Existence of buyers


**2. For Synergies Calculation** you can use the following structure:


1. **Revenue synergies** - here you calculate the synergies in price and quantity (depending on the case it may be new geographies, new products, new distribution channels, bigger share on shelves crosselling opportunities, etc.)
2. **Cost synergies** - typically you use a value chain structure tailored to the industry (e.g. supply-production-distribution-marketing-after sales support)
3. **Risks** - major risks that can decrease the synergies (tip: don't underestimate the merging companies culture factor)
4. **Total synergies potential** in $, adjusted by risk (probability of failure)


**In private equity interviews,** the cases will be much more detailed in financial part. Depending on the company you'll need to:


* Find the relevant information in P&L and Balance sheet
* Do the simplified valuation using NPV: calculate cash flows and make assumptions about growth rate and discount rate
* Do the valuation using comps - you'll have to explain which comps you will use and why


Good luck! http://en.wikipedia.org/wiki/environmental\_engineering

you would probably be looking at 4-5 years of college. most environmental engineers are actually civil engineers. as i noted learning javascript is a good place to go as it’s used to make webpages more dynamic! the front end engineer career path may work well for you as the lessons you have already done will be completed, but there’s a lot of extra notes and such in it for html and css, as well as adding in the… The answer to the question is available in the PDF file https://www.assignmentexpert.com/homework-answers/programming-answer-5048.pdf Anonymous A 

Hello!


When you say experienced hired, this can still mean 2-3 different tenures. Can you specify? Precisely the bonus is the part that changes most as you go up in the org. 


ME is rather frozen, but again, could you specify office?


Hope it helps!


Cheers, 


Clara