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

Finally after many rejection, i have an offer to me as BDR for a saas company that just setting up a new team here in my country. I count myself blessed though was through a recruiter that arranged the interview and offers. The Comp $55k base + OTE 40% of the base + Health coverage + 4days work week. What did you guys think?

like

I have my first round McKinsey phone case interview today and honestly feel nervous enough to throw up. Anyone done this type of screen before/have any tips or pointers to pass?

like

We are short staffed have been for over 6 months, those of us that are left are trying to keep up but we are struggling hard-core. We have had tons of interviews but everyone offered a position (which has been all of them) always says,'oh I have other interviews'. We can't be the only ones dealing with this.

like

After 13 years in government, really want to get out. Anyone have experience convincing the rest of the world you’re not a “government employee”? I think hiring managers see government work and assume I’m lazy. Ways to get around this?

like

My boss talks a lot about his inclusive hiring practices while not actually hiring anyone who would represent that. Is there anything we can do?

like

Is the Workday Payroll Certification really worth it?

Especially considering you can make a similar amount of money doing the other core HCM modules without having to learn about the Practitioner side of things in Payroll.

Also, if you want to exit to an internal role, 9/10 job openings that I see do not even list payroll as a requirement but you'll always see the core modules+ Absence & TT.

Please share your thoughts.

like

Guys , how much time EY takes to complete recruitment process , from 1st level interview to offer release . Thanks

like

If anyone with 1 YOE or higher (non-internship experience) is looking for a referral to EY's People Advisory Services (PAS) practice, DM me. Referring for Staff 2, Seniors, Managers, Senior Managers and above.

like
like

I have an opening in my team in Novartis India ... It's an Associate Director level role of solution designer in businesss. It's an analytical profile. Please let me know if intrested.

like

Recently got a job offer from Wells Fargo wealth & investment management (WIM) starting 60k in Charlotte NC. The position sounds appealing coming out of college but my friends doing the risk program are getting 72k compensation. I feel that the offer is on the low end? Anyone have any thoughts and guidance? What the exit opportunities look like etc!

like

Has anyone made it to Principal Software Engineering Manager position interview at Microsoft? I’m looking for some insight as I’m planning to apply.

like

On the job hunt now and interviewing. I've got a trip planned for the end of Oct. It would be idea if I can start before that. If I get an offer late sept is it ok to ask to start first week of November because of the trip?

like

Anyone has interview experience in PepsiCo ?

like

Does anyone know what kind of resources the MBB firms provide for entry level consulting staff to pursue business school? Like in terms of applying etc? Obviously anyone from McK would be the most helpful!

like

Can someone please help me with a referral for python developer role please? I have 3 YOE in total. In regards to python, 2 years. I have knowledge in Django as well. I can join in almost 45 days. Kindly help. Thanks in advance.

Put in my 2 weeks yesterday. No job lined up but 2 months of interviewing and I feel good enough about my flow that the right job will come.

It’s been crazy how many CONGRATULATIONS!!! For quitting that I’m getting.
Everyone is jealous and ready to follow suit. It’s crazy.

The stress of never getting promoted or recognized has been melting off and I got the best sleep ever last night.

Rocking interviews with a new confidence!

likeupliftingfunnyhelpful

I was recently laid off from a OEM start up in a 20% company wide work force reduction. I have had multiple interviews since then and almost all, except one have said I was being pushed to the next round. Out of the couple that I was told I was pushed to the next round, one or two have just vanished and won’t return emails or phone calls. I understand things can change (found someone better suited) but is this ghosting thing a norm now?

like

Best career option in tech for generalists?

I’ve been working for almost three years as a “data scientist” at a start up but basically been doing everything from gathering requirements from clients, doing UI/UX design, coding the front-end (angular), building and shipping ML models in sagemaker, and managing AWS infrastructure.

I’m planning to change jobs to find a role with clearer responsibilities. What role in tech suits someone who knows a bit of everything but is a master of none?

like

I am a PhD student in chemistry on my final year, with some publications but no industry experience. What advice could you give me to get Research Scientist positions at big companies? Considering that I am foreigner national, do companies even bother the hassle of applying for a visa for an employee without "industry" experience?

like

More Posts

What are the learning portals for deloitte india ?

like

Hey y’all, need some advice! I live in the DC area, but love being in CO and want to move out to the Denver area at the end of my lease. What are some positives to living in Denver? How is the job market? Cost of living? DC area is too politically charged, too expensive, and has too many federal jobs.

like

I am 6 weeks pregnant in a stressful job and it is making everything harder. Normally I handle it all well, but now I feel like a total space case, get stressed out more easily, and get so sick to my stomach and tired. This is after nearly a year of fertility treatments which as you know, are also incredibly stressful. How have you coped?

like

Hi Fishes,

Can anyone tell me how Brane Enterprises is in terms of culture?

It's a startup in hyderabad

like

I’m halfway through virtual parent teacher conferences. How are your conferences going and how are you sharing student work with parents?

like

I really love the weather today 😌 I would like this weather for the rest of August. Thank you!

like

Questions asked in the BA interview for insurance domain
1. Data mapping experience?
2. Data analysis done in previous company and tools used ?
3. Banking and insurance sector experience
4. Have you come across the unorganized data and how u managed it ?
5. Difficult situation came across as analyst and how you tackled it ?

like

How much do firms like AKLU and omnipoint mark up the rates actually paid to the consultant?

like

Hello Fishes,

Deloitte - 11.5 Lpa + 1 JB (yet to be asked for revision of ctc)
PwC - 12 + 1.5 JB (not ready to revise)
HCL - 14.5 fixed 2 Variable (Ready to give 16.5 fixed)
Virtusa - yet to be discussed about ctc
Last working day - 22 April

Interviews scheduled for - Bnp paribas , SS&C , Siemens TSPT

Please suggest which one should i select and which is good for long term growth?

Current ctc- 7.5 fixed

YEO - 3.9
Tech Stack - Automation Tester

like

"I like eating dark chocolate because it reminds me of a woman’s sensuality."

funnylike

Looking for a good eye doctor in the Boston area. I have bad but stable eyes (astigmatism, +4.75), and I’m considering getting lasik. Any recommendations are much appreciated!

like

Career advice please:

~10 years in IB ops transformation/data analytics (Python, alteryx, tableau, excel, some SQL)
~ some consulting experience
~ got all the buzzwords & c-suite tier decks
~ management experience
current TC ~£130k

What could I do with this?

like

Hi Fishes,

Currently I am working as Endpoint Security analyst. Can I switch to SOC as I am not satisfied with the level of work I am doing.

YOE: 5.9

Anyone work for Honu Services and able to refer me for a position

like

Need some creative thinking here on how to lose weight
1) Cutting carbs trigger my migraine 2) I do 16h intermittent fasting, DFGF 3) I limited to 60 min of being active a day. Working at the computer, and trying to spend as much time as possible with my son. He has cerebral palsy, so being active together is out of question. Him being active means being slow for me. If we go on a hike together he can only walk for 30 min, and he does it slowly. 4) I can’t stick to schedule

like

Any idea for EY GDS Strategy and Transactions profile Assistant manager package? Please let me know.. thanks in advance :)

likesmart

Who has an amazing marriage? I need a marriage mentor of sorts-I believe that an amazing marriage can be my marriage but I need help. I don’t have couple friends who are in amazing marriages. Most tolerate or are divorced. We have mentors for other big parts of our lives-career, being a mom…not really anything for marriage! I want to keep believing it can be a source of energy and comfort through life’s ups and downs.

likesmartupliftingfunny

Took a job specifically for experience in-house PE and also took relative paycut. Now thinking about leaving and going back to a firm to round out skills or asking for more $$$. Thoughts?

like

Working late and being the only person at the office is so weird and amazing. No shoes, shirt untucked, open beer on desk. Blasting inappropriate podcast and pooping with the stall door open. Truly this is how things should be.

likefunny

Additional Posts in Consulting

Anyone ever buy a mattress in a box? Thinking about buying one from wayfarer for about $250, seems cheap though reviews are all excellent. Thoughts?

like

This game is nuts!!!

like

2020: year that keeps on giving

Post Photo
like

Do any lady fish 🐟 use men's deodorant? It's just so much better than any women's deodorant I've been able to find...

like

Difference between utilization and adjusted utilization? Utilization is below 80% but adjusted is 99%.

like

Need to buy a suitcase, for hold travel - what's the best value out there? Travelpro, samsonite?

like

Rush hour path train is a disaster!! Can't wait to be on a travel project and avoid this!

like

Struggling to translate consulting projects into a resume. Most of my friends working in industry can say they did X with impressive Y metrics. 1) with only 2 yrs of exp, how do i balance what i

like

Any fellow consultants in the dc area have a beach or bay side rental in Bethany, rehobeth, etc available next week mid week? Also open to other areas within driving distance. Thanks!

like

What's your biggest regret in your consulting career so far?

like

Is Associate or Engagement Manager at McKinsey a more suitable target for a high performing second year SC from
Deloitte?

like

TSA agent patted my stomach and said your good bro as I walked out of the body scanner. 🤷‍♂️

likefunny

Any FSAs here? Is it worth it? Or ASA+MBA at Columbia?

like

On the beach bored:

Do you guys believe in aliens? As in intelligence life forms, not just bacteria.

like

🐳🐋 with 'Sunday Scaries'. How much longer are you guys planning to stay?

like