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

I am on Bench for the past 2 months in
IBM and I got 2 interview calls but it doesn't suite my profile/requirement and my band is 6B And how many calls I can attend in IBM ? Can I wait for some more time or shall I look for other opportunities? is IBM bench is safe now a days ? IBM Tata Consultancy Infosys Accenture

like

Is Nagarro accept 90 days NP?

like

Hi Fishes,
I am currently working in
Citrix for past 6 months with a CTC of 32L+3L+(5L stock options).
Recently got an offer from Wells Fargo for 40L+4L.
Please provide some insights about the work culture in Wells Fargo like WLB, leaves, job security and so. Is it good to join?

like

🚀How much salary range for VP - K grade in bnym technology department? Skills - Java microservices Expr - 13 yr

like

Iam 5 month pregnant , thinking to get release from project due to health issue and taking maternity leave from april 1st, at this situation can I be in bench for 3 months and go in maternity leave ? Will this affect my job in Accenture? Will the organization allow to be in bench for 3 months? If iam in bench during maternity leave will i get variable pay

Hi, currently making 10.5 lakhs fixed as AM ( recently promoted) , have an offer from KPMG for consultant for 15.5 fixed. Should i take demotion from AM to consultant. Also if i resign now , will miss out on 1.3 lakhs rupees bonus which will get in September. Also please tell about DT-CDSG team at KPMG India. TIA

like

JPMorgan Chase recently introduced a policy change to increase the notice period to 60 days. I'm a 602 and resigned recently and yet my LWD is showing up as 30 days from now. Anyone recently resigned can confirm if they are facing the same or new policy is in effect. This is causing confusion with the next companies I'm interviewing with.

like

So I'm not a top performer. Definitley not the smartest guy at big 4. But some of the questions I get from very experienced seniors are just so basic.

like

Hi Fishes,

Can you please confirm how long does the joining offer ( provided by PWC ) remain active in workday portal?

How long does it typically take to get a verbal offer from ZS Associates (Strategy Insights and Planning) after the final interview?

like

Anyone know if any of the MBBs are hiring experienced hires in India?

like

Hi Everyone,
1.I had two offers one is with Cognizant with 11.55LPA fixed + 45,000 variable pay. I was offered L1 position(designation - Associate).
- Only day shifts(no rotational weekoff's) + I get afternoon shift allowance around 5k per month.
-As per the Manager mention it's mostly WFH we need to come to office at least one month in every 6months(duration).

2.HCL offered L2 position with 10LPA(Around 1.5 Variable pay is included)
-No shift allowance
-Rotational shifts including night

like

Any Amazon counsel or other FAANG attorneys willing to share how their comp review has worked? I’m really happy with my offer(lower base, really high signing bonus and decent RSUs) and was told their would be yearly comp reviews but wondering how that plays out the first few years...

like
like

I have created Algorithmic Product/System for the client to take out inventory not-in-demand for long time to save storage expense and also provide an approach to prioritize Work Orders based on Market Demand. It’s more like an Manufacturing Plan. I want to get into Product Analyst/Lead role. What approach I should take? Any books to start with? Any events to attend? Any groups to join?

like

Hi, after each interview, the recruiting agency will call me to get feedback and ask me if we're still good on X salary?

What's a good way to not agree on a set number on these calls until I get my offer?

like

Because of this sub, every time I see a dog now, I subconsciously think the owner is going to ask me for a referral.

funnylike

Hi, I am done with 2 rounds of interview in CGI. Waiting for second round result from past 4 days . Daily I am dropping remainders to the team. But no response. Can I consider it as negative?
CGI

like

Hello LTItes, i joined LTI a month back.
I attended a client interview last week and was selected for the same. Now they are asking to join within a day or two. I'm having my mom's surgery this week. How to safely refuse to join this client project for at least 10 days. I can't take leave for 10 days.
Can anyone please help me with this? I'm confused and scared.

Thanks

like

Any tips for a candidate who is currently in working in a bank in IT operations and interviewing for a tech company for a role they don't have technical experience at all? Moving from a BA position to another BA role but tech is completely different...

like

More Posts

For those of you coloring your hair at home, do you color your whole hair each time or just your roots? Also has anyone tried Herbatint products?

like

Are salaries negotiable at performance review and/or promotion?

like

Is it possible to get job in US by applying from india,if yes can you please share the process

likefunny

This bowl has been quiet and I see partners commenting on odd posts around fishbowl so I figure you need more fodder: partners, did any of you have parents that travelled as much as you do?

like

37 weeks today! We are excited :)) the waiting period is weird though. When will baby come???

like

Any handsome guys in LA? I’m so lonely

likefunny

Does Steve Ballmer own up to his mistakes at Microsoft these days?

like

I've been trying to figure out why TikTok is so popular. I mean, I get it: it's easy to use and fun, but what's the ROI?

like

What are the prospects of being hired into a company you failed the first round of interviews (not the HR one)?

like

Hi everyone...

My role was impacted as part of the layoffs in my last Org.. bitter truth to digest.

So I am looking for a new role and I would appreciate your help and support.

Can anyone share Hyderabad or Remote based PM/ Sr. PM jobs.

like

What is average year on year hike in Adobe?

like

Why is Latham’s website so ugly?

likefunny

I’ve been approved for a transfer to the AUS office. Early 30s couple, no kids, small dog. Wife will work for the state but doesn’t have an office assigned yet. Looking for a SFH (that isn’t soullessly modern) in the 600-700k range that will suit our interests: walk to a grocery store, maybe a restaurant or two, commute to work in <30 min. Where should we look?

Any Flipkart fishes here to chat about these roles?Flipkart

Post Photo
like

Hi all, NEED REFERRAL in Accenture ⚠️
~ Analyst Roles ~

(Navi Mumbai or Mumbai office, priority in that order)

For more background I'm a Fresher with internship experiences in major startups.
Please help since I've been applying for jobs for over 4 months and no progress yet.

like

Can’t wait to move to Dallas area. Flower Mound is likely our first choice. Getting out of Chicago for better schools without dominant unions, low taxes, and better public safety

like

Hello all, I work for a small consumer goods company as Ecommerce Director. I’m pretty much the only one managing our Ecomm store, no direct reports but manage a marketing and Amazon 3rd party agencies for the brand. I’ve been with company almost 2 years and have significantly increased sales. In the middle of salary negotiations and just curious on what everyone thinks would be comp salary for this position: Ecomm director/ manager hybrid role. Thank you!

like

Exit opportunities from SALT - partnership focus? Starting to get worried that the opportunities are too slim and debating leaving for a federal position (even if at a lower title) to gain experience. Anyone have experience with this? I feel like my only options right now are the same jobs just at different cpa firms.

like

Hi team, thanks for joining lets grow together.

like

Hi Fishes,

Can any one let me know what benifits we will get if we join/work in ADP india?.
#adp #wfh #wfo

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?

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
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

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