Hello! I’ve an upcoming phone interview with Meta for Data engineering role: 45 min sql and coding and 45 min for ETL. I’ve been out of touch for python. Could someone please advise on how best to prepare ?!

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

Know SQL well- joins, aggregate functions etc. Practice Leetcode medium. For coding- know basic data structures and how to work with them- Strings, dict, list.
For ETL, for a given use case, design the data model and talk about the ETL process. Study SCD. Be prepared to write queries to get to a metrics

Related Posts

Hi Friends, i attended 2 client interviews and both went wrong. I don't know what to do. I am new to EY GDS......Is anyone faced the same ?

like

What does comp look like for a Commercial AE at Zoom?
What’s the commission payout? Zoom

like

What would be the best method to transition from a financial advisory role to a more financial analyst focused position? Is this type of move unheard of/too difficult to do?

How do physical science PhDs fair in applying to and receiving offers from MBB?

How do they do once they are there? Do they struggle to make the transition?

like

Is it common to negotiate software engineer salary at smaller companies? I know it’s common at FAANG, but what about for companies with around 200 engineers? I have a counter offer from my current company and on-site interviews scheduled for end of July with google and Amazon, but I’d prefer to go with the smaller local company if I can negotiate the salary (from offer letter) up another 5% or so.

like

Any experienced nurse practitioners in NYC area looking for a hospital based NP position in Manhattan, DM me. Pay from 130-150 ish. Great benefits

like

Chubb anybody at Chubb knows the range of salary? Being in grade 24 means what range?
Thanks in advance

like

Anyone joining genpact in november last week or december first week.

like

Anyone at EY willing to talk about their experience and potentially refer for a salesforce senior dev position ?

I have one query, i received survey mail from ey gds regarding joining date and location preference, so it mean iam selected or any other round happens? Because i give self recorded video interview on 7th feb and i recive survey mail on 7th March which i filled on same day and in joining date there are two options 25 March and 25 April ,wheres i select 25 april but there is no communication after survey mail so what should i do?

like

Hi Sharks,

Please let me know what is the current situation in cognizant related to the revise offer letter?

Already holding an offer from CTS and I am expecting one more offer from another organization, so CTS will match that offer or not?

CTS Offer :- 17 LPA
Offer from another organization :- 23 LPA

Please give your inputs.

like

I have been interviewed in EY GDS.
Hiring manager sounds positive.
Can anyone suggest, in how many days feedback will be given?

like

Hi Fishes,
I have cleared L1 round interview with LTI, can anyone tell me what can I expect in L2? Is it going to be technical round again?
It's for Angular Developer position.

Thank you!

like

Hi Everyone !!!

This June I completed my 9 months at Career Level 12 and Sub Level 3 I.e, CL 12.3 at
Accenture Operations. My Annual Talent Discussion and One-on-One with People Lead is complete as of last week.

I have 3 questions now :
1. When can I expect to move to 12.2 ?
2. What is the general hike I can expect ? And when it is reflected ?
3. When will be the variable pay will be paid out ?

Can anyone here help me with this performance cycle part ? I am really confused.

Accenture

like

If a headhunter approaches someone for c suite position but you know a friend who knows key decision maker/chairman. Do you just bypass headhunter? Its in round 3 shortlist.

like

Offered a salary of 92K for a Business Analyst position at Facebook NYC in the Marketing Intelligence team. What’s the typical range? I have more than 2 years of work experience

like

Hi,

Is this a good time to join HP? As they have recently announced 6000 layoffs in 2 years.

like

Hello,

I have offer from

Optum, Harman Connected Services, CGI, WIPRO, Concentrix and LTImindtree

All of them are giving package of around 18 lpa. And location for optum and wipro is Hyderabad others are in Bangalore

My joining date is near can you please help me in choosing one of the best from these.

YOE : 3.9
Skills : Java, Springboot, Microservice, Azure Cloud with React Js

like

Hi folks. I need to prepare for se3 position for Google . I have 45 days time, please help a fellow techie of how, what and why🥺🥺🥺 Google

More Posts

Thoughts on a m340i? I might just pull the trigger.

like

Daily Quordle 76
9️⃣7️⃣
5️⃣4️⃣
quordle.com
⬜⬜⬜🟩⬜ ⬜⬜🟩⬜🟩
⬜⬜⬜🟩⬜ ⬜⬜🟩⬜⬜
⬜⬜⬜🟩⬜ 🟨⬜🟩⬜⬜
⬜⬜⬜🟩⬜ 🟨⬜🟩⬜⬜
⬜⬜⬜⬜⬜ ⬜⬜⬜🟩🟩
⬜🟨⬜⬜⬜ ⬜⬜🟩🟩🟩
⬜🟩⬜⬜⬜ 🟩🟩🟩🟩🟩
🟩🟩⬜🟩🟩 ⬛⬛⬛⬛⬛
🟩🟩🟩🟩🟩 ⬛⬛⬛⬛⬛

🟨🟨⬜⬜🟩 ⬜⬜🟩🟩⬜
⬜⬜⬜⬜⬜ ⬜⬜🟩🟩⬜
🟨⬜⬜⬜⬜ 🟩⬜🟩🟩🟩
🟨⬜⬜⬜⬜ 🟩🟩🟩🟩🟩
🟩🟩🟩🟩🟩 ⬛⬛⬛⬛⬛

For those of you that have returned to school in some manner, what are you doing in class? I find it troubling not to work on breathing.

Are you working small ensembles? Modified, limited instrumentation, or flex model pieces?

like

Does your firm regularly adjust rates? I read an article suggesting it should happen annually. Curious how regularly firms adjust attorney rates.

like

What is the difference between an associate and an assistant?

like

Any recommendations for good improv clubs, places that teach comedy writing, or joke writing resources in general? Trying to punch myself up while we’re still WFH.

like

What's your favorite "healthy" meal you make at home that is also delicious and cheap? Mine is Thai papaya salad

like

A very privileged question, but do any of you expect significant inheritance? And if so, how has that affected your retirement planning?

like

My last post created quite the debate lol and searching through fishbowl i saw that there is a Desi singles bowl but no arab/mena one so I decided to create one 😂. It is still fresh and new but feel free to join

likeuplifting

Love this bowl! Here's my memorial day avotoast + taters

Post Photo
like

For those in the SCM industry, what is your job title and your daily responsibilities?

like

What's the maximum budget in 7A BAND in IBM?Anyone got above 20LPA?

like

Anyone working/has worked remotely outside the US during covid? What are the legal/tax/IT implications to be aware of? I’ve been in India for a few weeks and wondering how long I can continue working from here.

like

Who’s running diligence for this TikTok deal?

like

When putting in notice, do you set up calls with your MD and manager separately? Or both on the same call?

On the beach for a short bit so no meetings set in a usable timeframe. I have a good relationship with both but they usually aren't on the same calls. Oh, and before anyone says to do it over email, and I've already decided to do this over a call. So let's leave that out of the way.

like

Received an offer from RSM as a supervisor. Coming from B4 not quite sure what the title entails (i.e., the difference between that and a manager). Currently a SA. Can someone from RSM explain? TIA!

like

How do people feel about their new compensation statements?

like

Hi fishes,
After joining, both laptop and desktop is sent. Is it done for everyone or for specific domain? And does this mean the flexibility of working from anywhere ceases to exist?

like

Hi, what is an entry level salary, or what would be a fair pay for someone starting in a Cyber security consultant role, without any experience in the field, with a Comptia A+ certificate and getting training on the new job? Thank you

like

I am looking for a job

like

Additional Posts in Facebooker / Ex-Facebooker

Completed interview and will likely get an offer from Facebook for an IC7 position. I would really appreciate any insights on the cultural aspects I have to focus on the first 100s days at the company.

like

I just had an interview with a rep from Meta and I am to be placed in a Level 6. What are the salary range for this level? I also need some guidelines for the final interview.

like

Interviewing for a product designer IC job at Meta, I was told by the recruiters that final panel would be 2 ICs and 1 manager. My schedule has 3 managers, no ICs and no other functions. I asked - told it was just due to scheduling constraints. I think managers just naturally have more experience and more stringent standards (generally). Is this worth asking to set up the more standard panel for me even if it takes longer to schedule? Or is this a non-issue? Just want an equitable experience

like

Hey everyone! I’m considering an offer in the hardware group working on AR/VR products and the compensation is very heavily stock based so I wanted to get opinions on how risky do you think it is?

Especially curious how y’all felt when the stock fell more than 50% this year and did Meta do anything for the employees in order to make up for that huge loss?

Thanks!

like

Anyone in here have experience with L&D or global ops? I’m trying to pivot career fields and make my way over to Meta. Any info appreciated.

like

Had 2 loop interviews today - first one went well, second horribly. What are you my chances of succeeding?

like

When will L4 headcount opens up? Recruiter said currently there is hiring freeze for L4

Interviewing fo FB for their content designer role! Got a couple questions:
1. Does FB sponsor visas? i'm on the E3, which is much easier to get than the H1B. No lottery involved.
2. What is the salary for a content designers with 4 years of experience? Glassdoor is saying ~135K. Is that right?

like

I am Doing an interview for Product Designer role and I need advice on the critique app interview please? I want to get the job!

I saw a posting on the meta career site for a data solutions analyst. Is this a role similar to a data analyst or solution architect. The job description fits both data science, data engineer or solution architect. And what is the total comp for this position? I can't seem to find this role online or on sites like Glassdoor or levels. It's a remote position.

like

Anyone who has/ heard of fbookers who successfully switched roles and gotten a promotion (L3 to L4)?

Context I am planning a switch from analyst to data scientist from a non US location to US. However, L4 is needed for this jump (prob due to visa issues). With the current revamp in PSC cycle, I am not sure if I can successfully get promoted by next year and make the jump. To do so, I heard there needs to be 2 EE (for this half and next half).

YOE 5, BASE 100K

like

Any data engineers from meta , get 3 SQL and 2 python in their phone screen interview. The questions were pretty simple , I just ran out of time on the last ones , but explained my process.
I'm trying to see if I still have a chance for on-site.

like

Hi everyone! I’m on the last round of interviews for an EA position at META, would any of you be willing to provide your hourly base pay? The recruiter gave me what seems a very low base pay. Thank you!

like

Hi guys, Anybody from Facebook (Meta) open to sharing a referral?
Please let me know.

like

Anyone here an EA for Meta willing to talk about their Salary & how many exec they support. I’m feeling super lowballed 😩

like

Hi all. Anyone here willing to refer me to Meta? I’m looking for DS roles. I’m currently at Amazon

Hi All, I have an interview with the Quality team coming up next week and would love to hear any interview pointers and/or work experiences you can share about this team. I'm super excited for the opportunity. Thanks!

like

I’m joining Meta next month and as a parent and someone who would like to puts family first, I worry about finding a team with a healthy WLB. I read Ads are typically bad at WLB. What other teams/orgs are known for their good or bad WLB?

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