Have a Facebook interview for data engineering role. Does anyone have suggestions on prep materials for advanced MySQL and Python?

like
Posting as :
works at
You are currently posting as works at

Sc1 , sql experience is strong but haven't worked in mysql since long. Python is relatively new.

like

You don't need to know that much about sql, just your typical joins, aggregate functions and filtering. For python, I would start learning some more of that. Majority, if not all, of FB data engineers have more software experience. Their background and knowledge in sql/modeling land is pathetic; nobody knew what a surrogate key was lol

like

I interviewed for them the other week :) Don't worry about mysql-syntax. As long as you know sql, you should be fine

What's your experience with sql and Python?

Thanks slalom 1. What about analytical and recursive functions that are simpler in oracle than MySQL. Is using oracle sql syntax fine in that case?

Maybe if you'd called it a parent key they'd recognize it? Or is that something different? I've honestly never heard the term either.

Nope, I cannot think of anyone on my team who wouldn't know what a surrogate key is. Data engineering at tech companies is so different than what majority of companies are doing. It's essentially software engineers-turned folks working on data tools about 99%of the time

Well then maybe they could use some of my BI/DW and modelling skillz. 🤓

Related Posts

Anyone hiring Senior Finance roles in 2021?

Hi,
My current company is going out of business next week. I am rushing to get my next job lined up (probably won’t happen in time but I’m trying my best). My question is: should I be honest about why I’m looking for a new job? Is it wrong to not share this info during my interviews? Is this situation going to affect my interview process somehow? Please share your thoughts and wisdom! Thanks!

like

If I didn’t have to take the MPRE previously but looking to waive into DC, when do I need to take the MPRE? Prior to applying or can I apply and submit my score following submission of my application to get the background investigation going?

like

Made a career pivot to another agency. During the interview we talked about how it may start as initially a "step backwards" (pay/benefits) but has potential for more long term growth. First day was yesterday. Had no communication about when or where to show up, sat in an empty office for about half an hour before a couple people finally showed. No phone call or email. Sent an email to the founder, no response. I could easily get my old job back if wanted.

What would you do in this situation?

like

How much time Qualcomm take to release offer letter? I am a immediate joiner.

I got selected last week but till now didn't get my offer letter, HR told they will send the offer letter within a week.

After enquiring, now she is saying your offer is pending with India head, after that it will go to US office for approval?

How much time it really take any idea? How could I approach HR for immediate offer letter?

Any help?

For those of you who had an allergic reaction to the COVID vaccine, how did you get a vaccine exemption? I had mine last year, experienced vertigo for 3 days, but didn't go to the doctor (since it went away the 4th day). I checked the CDC website, saw vertigo isn't listed under normal symptoms, and cancelled my appointment for the 2nd dose. I had an interview recently for a hybrid role and they asked me how I'll get an exemption, since they aren't sure themselves how exemptions work

like

Been at my new role for 4 months. It’s been good but not great. I see my dream role out there reposted last week, is it bad to apply?

like

Hi - I'm looking for a referral for a family member in the LA/Orange County. Relative is a permanent resident (has been for 10+ years) and looking to apply for citizenship. Relative had a juvenile record which was expunged ( I think it matters for citizenship). They had this record before they applied for their permanent residency. Now looking to an attorney with immigration & crim experience. Thank you!

Can someone refer me for Tech Support Specialist role in Google. Please let me know.

like

I’ve interviewed at Tuck, Ross, and Fuqua — is it common to get rejected at all the schools you interview with? And if so, does that mean your application was strong but your interview gave them pause? To be clear I haven’t heard any decisions yet, just anxiety

like

How many pages is your resume/CV?

like

Are interview case studies difficult? Is it done live or is it take-home? What should I expect in terms of content/questions, duration, difficulty?

like
like

Hi Sharks, Can anyone please share about interview experience/questions asked at PayPal Paypal for java developer 3yr experience?
Is it general core Java based or heavy DSA based? Please help.
Thanks

like

Anyone that might be able to provide a referral for a job posting? I have resume, and job In hand . Thanks everyone!

like

First year post my consulting exit and I’m dreading the inevitable dwindling of my points… is this what separation anxiety feels like

likefunny

Hi guys
Has anyone attended
Nike for penetration testing role?
Need your inputs on something

Nike

like

Hello,

I received an offer from Amazon Canada for cloud support engineer 2 which is a L5 role and my compensation is 101k base+10,500+rsu

Is it fair compensation based on the Amazon's Canadian payroll?

like

Hi Fishes, Has anyone attended MAKE MY TRIP interview on the QA Automation side recently ? what kind of questions are being asked, any idea would be a great help

like

Tech company lay offs….are they soon to be inevitable?!

There is lots of companies really taking a hit in the tech space. Is this something that people are nervous about? Many seem to still be having a hiring push but with the button falling (IMO this is still just start we have a long way to go to bottom out) will that halt and layoffs ensue? And if so, which depts do you think will get hit the hardest?

Anyone have insight to what the plan is at UpStart for example?

like

More Posts

Would tech ib (m&a) be more affected than say Healthcare/pharma ib in an economic downturn?

funny

What kind of bonuses do EY, Deloitte and GT guys working in M&A Corporate Finance make in UK? I’ve got offers from the three - a mix of AM and M levels and would appreciate any insights. Thanks.Grant Thornton EY Deloitte

likehelpful

Anyone have fee based fiduciary financial advisors they’d recommend? TIA!

like

Anyone have insights into Capital One Corporate Strategy? What’s it like / how large / prestigious, competitive, etc. thanks!

like

Anyone know of remote work from home jobs located on the West Coast for Pharmacy Technicians?

like

EYP and Strategy& fishes, what sort of work do you do in the Life Sciences space (specifically Big Pharma)? And what sort of exits into industry have you seen your former colleagues make?

like

Any idea about google project in HCL ?

like

How are the ETL/BI projects at Kolkata location for PwC India ?
How is the WLB? Do they assign 2 or more projects simultaneously?

like

What's the pay at Deloitte for a CA fresher in Financial Due diligence.

Please tell for both Domestic and International.

Ty

Senior SE estimated OTE for Chicago/ Dallas? Thoughts on pre-sales role compared to consulting?

like

I have just got an options trader job at a prop trading firm. But I knew nothing about options/trading/finance. The firms said they’ll be officially training us once we start. But in the meantime, what are some books/resources that you would recommend to start learning first?

like

How is the manager role of Deloitte India for analytics and cognitive practice? Anybody from this practice who can help me on this decision please. How is wlb, I know mine is going to be client facing and that I would be expected to do more that just project work but does that mean I would have to work on getting projects for practice or how it will be?

likeuplifting

Today i got my variable bonus of 10k, i get 59k inhand every month in which 2k gets deducted as tax, today along with the bonus of 10k I got 67k inhand and tax deducted is 4.5k. I'm kinda lost. Can someone pls explain y this?

How many days of sick leave a recently hired analyst can apply for? and will it get deducted from the annual leaves that are there? I could not find any section for sick leave in talent hub. Thank you in advance.

like

How is WLB at Deloitte India? What are average working hours / day.
Have received 2 offers
1 from Deloitte , 1 from Nagarro
Also Deloitte yearly increment acha deti hai kya?

like

Thoughts on how the upcoming recession will affect the law industry?

like

When you successfully get away by using another client’s deliverable at your new client.

Post Photo
likefunny

Hi fishes

I am having 7+ years of experience and I have also done my MBA 3 years back. Wanted to know what CTC I should ask for if my current CTC is 17 LPA for a BA role

like

Hi Fishes, Wanted to know the work life balance and culture at Fractal Bangalore location . Got offer as an Analytics Consultant in the SupplyChain team. If anyone worked in the past or currently working please comment and hit the like button too 🙏. Thanks in advance ☺

like
like

Additional Posts in Consulting

Has anyone here ever had a sudden revelation that they hate leading a team? If so, what did you do about it?

likefunny

Think it's time to pivot. I'm in an internal services role (contracts) and am feeling antsy. I'm over remote work. I don't need pre-pandemic level of travel, but I need to not be 100% remote. I don't have have an IT background or business degree. Thoughts for next steps?

like

Dallas 🐠!! Question for you guys: moving out of the city. What is the best way to sell furniture prior to moving out? Not aiming to make a lot of money, just don’t want the burden of dismantling and packaging them🙈. And yeah, Offer Up is bust. Any other lead or advice is appreciated!! Thanks!

like

After a year using my home office setup, especially the 27 inch monitor, how can I ever go back to the traveling life with tiny laptop screen? 😔

likesmart

What are some ways you guys earn money in addition to your day jobs? Trying to identify some potential options in hopes of helping pay off significant student loans more quickly

like

Anyone else work in the service industry growing up? Worked at a Little Caesars for 4 years (youngest asst. manager ever thank you very much) and I maintain that I have never faced that level of pressure or stress in my professional career. Standing between a Karen-customer and their $5 pizza is not a feeling I’ll ever forget.

likefunny

Working with a non profit in my magic time and our volunteers work in Google Sheets - trying to help them make a spreadsheet more user friendly and freeze some columns, but it keeps shortening the width of the most important column in the frozen section so you can’t see it all, which defeats the purpose. Anybody have a troubleshooting tip?

like

New joiner. What should I get with my $250 wfh stipend? I already have standing desk, dual monitor, portable monitor, and good headset, not too sure what else I need, but it’s free money. Thanks.

like

Does the IRS $61,000 total contribution limit include IRA contributions? Or just 401k (employer, employee before tax or Roth, and after-tax)?

like

Did Evergrande default? Is this a Lehmann moment

like

How do I check my actual utilization (not the effective one). Mybusiness only tells me the effective utilization

like

Bain fish, does anyone know how utilization in North America is trending for this year?

like

Where is everyone going???

like

What firms would you consider to be top tier for implementation?

Would be interested in rationale/rating criteria or niche/segment if you do have opinion or insight - can include PI, Tech, Ops, M&A, etc.

like

For those that have switched from Big 4 to MBB, how was the switch and any advice?

like

Looking to get into Facebook privacy legal team. Have experience as a consultant at another FAANG company. Anyone willing to provide a referral or discuss further?

like

Moving from Deloitte to BCG soon. What can I expect as major challenges/differences when transitioning from big 4 to MBB?

like

Anyone else that has become a day trader now that we have the liberty of working from home? Im personally loving it as I can more than double my income!

like

To those starting the year on the beach: office or home office ...or actual beach?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal