Hi! Interviewing for analytics manager at FB, sql coderpad round included. Any tips on prep? Leetcode ?

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

Know how to manipulate dates really well. Leetcode is the way to go. But honestly, the sql isn't as important as the metric questions. So unless you have never used sql dont spend too much time on it. Good luck

likehelpful

Windows, indexing, and self-joins

like

Do you mind sharing your background ?

OP please post some questions asked! :)

Related Posts

I recently had an interview with the hiring manager and they did 95% of the talking. It was the weirdest interview I’ve ever had. I didn’t know whether to interrupt and get a question and some comments in or stay quiet and listen. I couldn’t even gauge how it went. Has this happened to you.?
Also on average how many jobs do people typically interview for before they get an offer?

likesmart

Anyone have any first hand experience of seeing the benefits of putting Big 4 on resume?

like

What will be the in-hand salary??? KGS

Post Photo
like

I have a first round interview at TikTok for a head of business development role. I REALLY want the job but don’t want to price myself out or under…does anyone know of a range?

like

I have got an offer from NTT managed services. Is this completely different from NTT data ?
What is the maximum salary that we can expect for soc analyst profile for a 3y exp

Hi Folks,
I really want to join Deloitte USI Kolkata, any role that involves SQL, Spark,Azure cloud ( any one skill set is also fine for me)

Yoe - 3.2
Available within a month to join.

Really need your referral guys, never appeared for any interview at USI.

🙏🏾🙏🏾🙏🏾

like

Has anyone received an offer letter from EXL (Inductis India Pvt Ltd) that was extremely restrictive and reading which felt like one is signing up for going to prison rather than get employment? No leave policy mentioned, hundreds of paragraphs of worst case scenarios, pathetic salary breakup, etc. ?

like

How is it like working as a Senior Credit Analyst (C11 grade) at Citi bank's nirlon knowledge park office in Mumbai? Work culture, benefits, negatives, any info would be helpful.

like

I have an offer from BOSCH, but the location is Coimbatore. Im based out of Kerala. Does Bosch allow a wfh option?

like

What is the compensation bracket for Technical Solution Engineer (Networking) in Google Waterloo at level 3 and level 4 for 10+ years of experience? Thanks Google

like

I have final round of interview tomorrow with Commonwealth Bank for Technical Business Analyst role. What type of questions can I expect?

Anyone from NYC Health & Hospitals? How are the benefits?

like

Hi All, I got one offer from EY GDS, in the offer letter, it's mentioned as TC_IN_GDS_QE. Does any idea about the section? Is it worth switching from Tcs to EY? also WLB, the Work culture in EY compare to TCS ?

like

Hi everyone, hoping and wondering if I could get any help with the deal memo part for O1 ? It’s hard explaining the recruiters about it.

Hi Fishes,

Can someone give an idea of annual package NTT offers at an Advisor position (Grade - 10)?

Hello Everyone!!

Hope you all are doing great.

I will be joining NTT Data, Gurugram soon.

Please help me in knowing:
How is the company's work culture?
Is it currently WFH/WFO?
Anything that you want me to check before joining.

Thankyou!

like

I have a job interview on zoom today. My mom will be in the living room with my six month old son and I’ll be in my bedroom. I feel so anxious that they’ll hear my son in the background if he cries or something. I keep thinking they might think I’m unprofessional. Writing this out to let my anxiety out a little.

like

Would like to move into business development and marketing role at a law firm but not sure what my resume should look like. Can anyone recommend someone that specialises in resumes?

Hi fishes, Is there any HR or any developer from cognizant who can help me to contact congnizant HR, i have cleared my L1 round and HR told me that i will shortly get a link for L2 round and having interview today at 3:00 PM but still i didn't received any interview meeting link. Cognizant

like

Hi Nagarrians, it's been 45 days now since I joined Nagarro I was assigned a team at the time of joining but since then I am waiting for interview to take place. Is this normal procedure? Although from day 2 my project manager asked me to fill the timesheet corresponding to one project which is no billable. I am having concerns now as I don't know if this is normal ?

like

More Posts

What do your agencies or clients have planned for Pride? We are working on some fun community activities, educational sessions, and a social campaign. Pride is NOT cancelled!!!

likeuplifting

Our company is considering offering a 401K employer match to attract, retain and stay competitive in the market. We’re a 300 employee tech VC company. What does your company offer?

like

During my job search, I am getting a lot of recruiters asking for me to answer right to represent emails. These particular recruiters follow a same pattern and seem unprofessional. Shall I be aware and not sign these right to represents? Are they a scam? Or is it a cultural thing… can someone advise me, I’m based in the USA

like

I just received an offer on a job I would really like to accept. The salary offer is about 25% higher than my current salary, which I am happy about, but is also the low $ on the range I had expressed to the recruiter and the exact $ that I put on the online application (I had to put a $ figure). Am I being greedy trying to negotiate for a bit higher? Do they expect me to counter? I have been burned by NOT negotiating in the past but who can be mad at a 25% increase??

like

Martin Scorcese can never complain about Marvel movies again.

likefunny

Anyone work with Acorn company? Seems like one of the bigger players in the space (maybe not?). Curious to learn about personal experiences working there.

Has anyone's joining postponed in Tcs due to bgc scheduled status in ibegin portal? I have my joining and it's status on ibegin is showing as bgc scheduled.

So what companies should I work for to be considered successful? MBB, FAANG, what else?

funnylike

Watch enthusiasts - Which model is this?

Post Photo
like

what is the role of supervisor level 1 in tcs? can I change my supervisor level 1 as I dont have a good relation with him because of some issue we had and I am afraid that he will not accept any of my approval requests, also he doesnt want to talk to me on call and just want me to text, please help me

like

Looking for advice.. I’ve been on a management training programme on the lowest salary possible for just over a year and will soon be finishing the programme for a promotion. I know the average salary of my coworkers in the same role I’ll be going into and was wondering if anyone had advice for negotiating higher? We live in central London for context and due to the inflation are all struggling to manage our finances!

like

Anyone else at an agency where account has no appreciation or understanding for what we do? To be fair, it’s only one AD who constantly gives me a hard time but I’m so sick of it.

like

Question for fellow attorneys:

I applied to a credit card with Chase a few months ago and within 7 days I was told it was rejected and they would send a letter explaining why.

Chase has recently calling to say it expired (they said it wasn’t rejected but I was told on the recorded line that it was).

Isn’t this against the law (fair credit reporting act)?. I’m not a lawyer so I’d love to hear your thoughts

Agency: Now more than ever is the time for productivity.

Me:

Post Photo
likefunny

After 18 years, I lost my art room to a classroom this year in order to spread out kids due to Covit19. They said we can’t hand out papers.. kinda thinking art is remote for all. I will do lessons on google classroom with live lesson to classrooms and home. I was told special area teachers may be “repurposed”. We will be used like a TA. One class will be spread out two rooms.Aday teacher in one room, I help in other room. B day teachers switch 😳😷☹️.. I know I’m lucky to have a job but.

Is my perception that Clin. Ops. is the lowest paid role within an Global R&D level right? Comparing to clinical, medical, stats, safety etc

like

Hey Fishes, any remote opportunities within Canada ? Let me know please

What opportunities does Tax M&A experience lead to?

like

Is Barclays in India called as Barclays Global Service Centre Pvt Ltd?

like

COMMENTS REQUESTED!

In the past, lawyer wellness and lawyer discipline/character fitness for bar applicants have existed in silos. I’d like to finally form a bridge between lawyer disciple and lawyer wellness and focus on prevention. When we think of lawyer discipline, we automatically think of outrageous behavior like stealing money. Those are extreme. The common cases are too stressed out and forgetting deadlines or death of a loved one and not having time to call clients back. Cont’d

like

Additional Posts in Data & Analytics Consultants

Is making a switch from consulting firm to a tech firm in 1 year a bad move?
Does it look bad on a resume?
FYI my previous switch was within a year,

I do not like the long hours and quality of work. It is very manual in nature.

Trying for companies like apple, amazon, google etc.

like

Can someone explain what’s the difference between EDM technology/tool and DWH?

like

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

Can anyone please provide the best recommended training link to study for the AWS Cloud Solutions Architect Associate Certification? I want to study for it end-to-end and complete it within a few weeks!

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

Anyone heard of the Math company Analytics start up? They just got $50m funding in January? Good company or not?

like

AWS big data specialty exam worth taking? Does it involve any coding?

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

I interviewed for a product analytics DS role at Fb/Meta last week and haven't heard back since. Not sure if I event want to take up the role but nevertheless wondering if I am already rejected? Been about a week.

like

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Interviewing for a data scientist role. They gave me a week for a case study where I’m asked to clean data and then derive data insights (python), and then make a PowerPoint to present my process and results. Any case study samples out there I can reference to? Much thanks!

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Back end or front end?

Post Photo
funnylike

Looking to move from consulting to chill DS/analytics role. Don’t care too much about TC ($150k is fine), but WLB is paramount for me. Anyone have any thoughts as to where I can get this?

like

Analytics 💵 transparency thread!


Format:
Title level (standardized title/job level)
Economic area (Bay Area, Midwest, etc)
Salary + bonus + liquid equity
Anything else you think would help

likesmarthelpful

Lunch discussion at the office, curious to hear your thoughts: Does one need to learn data science first to be a good data engineer / architect? Why / why not?

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

Wanting to get out of fed space. I am a data scientist with 5YOE. What are good companies to look for in DC area that’d hire someone with gov consulting experience?

like

Has anyone here taken the Nike SQL assessment via HireVue? Wondering what to expect.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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