Anyone have any idea of interview prep for Analyst / BI roles at FAANGS?

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

SQL. Lots of sql...

like

What role and what was your YOE when you interviewed?

like

Sql. At least Leetcode medium

like

SQL and product sense

Meaning question of tech product and relevant metrics

SQL window functions, joins, cte and python basic questions. Eg: fizzbuzz, Fibonacci series , strings, palindrome

What are these BI roles actually called at any specific FAANG. I am an SQL god so sounds interesting - based in EU though.

I would say BI related roles or even Product Manager if you have had some product owner experience in a project. Rest of the roles within analytics in FAANG could be machine learning engineer; data engineer etc. These definitely need good tech skills. Very strong Python/R and good cloud experience for deployment

Wait what’s the S in FAANGS? Is it Spotify?

Oh LOL gotcha!

Related Posts

Crossroads Toyota Motor Sales, USA, Inc. I have been with the organization almost 6 years and have accomplished achievement of my MSL (Masters Strategic Leadership) and LOVE the organization…BUT…I am not having any success in moving into a new position…my interviews are great experiences but it seems to be a pattern of not being selected yet encouraged to continue applying…received information from a mentor/manager to ask for candid feedback…when is enough…ENOUGH??

like

I’ve over 15 yrs experience and looking for job with no luck. Everyone telling me sending apps for senior roles (VP plus) doesn’t work.
Can anyone help me with reaching out to people via email. Formats/ content I saw online are for entry level people. How do I ask people to connect with me without asking for a job ?

PwC India Anyone who recently joined pwc India bangalore data analytics team can you tell me how’s the WLB and growth here !?PwC India PwC

like

What kind of sectors does Accenture S&C deals into How is customer service and sales strategy team within Accenture s&c

like

Recently offered Manager role at Deloitte UK with total comp of 86.7k and M4 as Grade.. Do you guys think it's a good offer? Moving to Deloitte UK from Deloitte US with spouse and 2 kids

like

Hello All

How's job security, work life balance, work pressure, work environment & Salesforce testing projects at Brillio?

like

Hi,
Only hdfc bank accounts can be given as salary account in Pwc AC ? Is it like that?
I have Axis Bank account.

like

Can anyone having any idea what will be the CTC range of mindtree for C4 grade with 9.4 YOE. And how much joining bonus can be claimed?

like

My offer discussion is going on with KGS, is it a good switch from EY India to KGS?

like

Citiustech Healthcare Technologies

How is Citiustech to work with and how is the work Life balance and security aspects here?

Hi all,

Im having 9.5yoe in java backend development( technical lead) and have not worked in devops till now. But recently i have started with a PG course in devops.
I am very much interested to move to devops. What kind of roles i can give interview for and what and all paths i can take forward.

like

What does a new band 4 bonus range look like at Bank of America?

like

how much i should expect from BGSW with yoe 6 into embedded, linux domain.

Also are they doing 5 days WFO?

like

Hey guys, Can anybody tell me how much time does it takes the location to be updated in Accenture. Its already been 3 weeks, and the Hr has no update regarding the same.

like

I had got offer letter from cognizant after that i had recieved a mail to initiate on boarding.
Is it mandatory to start the cognizant on boarding if not sure whether i am going to join it or not?

like

How is Telco team in Paytm? How is the work, WLB, Management and culture?

like

Hi can anyone tell me
How to get a job in EUROPE as sap successfactors learning/ learning and development specialist ???
I have tried on linked in but got no such reply yet ..no interview ..what should be my approch ??

like

Can anyone give an insight into how much HR Partners get paid at Tesla Fremont CA or Austin, TX?

like

what is the salary range of consultant in KGS ? What will be the role offered if I have 3.5 years of experience , consultant or associate consultant ?

More Posts

Looking for remote working opportunities as a Business Anlayst or Product Owner. Have 5+ years for work experience as a Business Analyst/Product Owner post MBA.
Please share any possible openings or referrals.
Thanks !

like

In Indonesia for a month and plan on downloading Gonek - does anyone have a Gojek referral code I can use?

Hi - Are have all productions halted during this time or do you know of anyone still shooting?

like

Anyone play QB in high school/college or just a good QB? My Rec flag football team needs a new QB. We have great players, just pretty average there. DM me if you’re interested.

likefunny

Guys, anyone knows when offices are opening again?

like

Hello folks.
Can someone please say how much reimbursement
Morgan Stanley is giving for buying laptop? I do not have a decent laptop currently. Or will they provide one? When to have this conversation and with whom? Morgan Stanley

I’m a newer registered nurse (2 years) and want to get into remote work. I keep getting denied due to lack of experience but to even get the job I have now (case manager) the company knew one of my family members and they gave me a chance to interview because of that. For these remote companies where I don’t have connections how can I transition over?

likehelpful

Currently, onboarding at HCL is conducted offline or remote(online) ?

like

Anyone know of companies looking to hire an Event Director? I feel like events jobs have been disappearing recently. Preferably remote.

like

I have newly joined KGS but still at home location wfh, i was told by a colleague that they received an invite for a New year party for all KGS employees on 20th dec, does anyone receive it? Can I attend it from a different office than the base branch?

like

Has anyone invested in any of the startup companies on Start Engine? Thinking by about investing in a few.

like

What’s making those of you who want to go back to India want to go? I hear the work culture and bureaucracy there are the main reasons people come to the US.

like

What is the process for getting a green card, if a US citizen marries someone already in the US on a student visa? Any tips

funnylike

What are the pros and cons of working for Progressive Insurance as a PIP examiner?

like

Do you feel, as members of our community in advertising (a privilege we share in having a voice in media but also cultural persuasion) that you should lean into brands taking advantage of the opportunity to capitalize on our community or steer them away from that but also refocus their minds to a more long term diverse creative solution?

like

If you had one night in Boston (staying at the W just south of Boston common) where would you go for drinks and dinner?

like

Current market salary for Data analytics manager in Bengalore ?

Hello All,

Can anyone help me to refer me in IBM for Java Springboot Opportunity.

Exp-4+ Yrs

Tech- Java,Springboot, Hibernate

I am an immediate joiner.

like

A little late here, but any suggestions/recommendations or watch outs for an automatic standing desk preferably with charging attachments? Looking to invest in a decent one around $2-300 !

like

Additional Posts in Data & Analytics Consultants

Has anyone else begun to resent data science?

like

What do you folks think about a monthly show and tell of anything data-related?
Open forum where anything relating to data & its applications would be fair game. E.g.:

-a visualization you made and/or like
-data pipelines for a personal website
-market analysis
-relevant memes
-scientific article
-data news
-what you'd like to see data driven but isn't

In a nutshell, a conversational experience. Introduce and discuss ideas. BYOB and at least 1 talking point, or if you really want a full deck

likehelpfulupliftingsmart

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

Just curious?

How many people have actually built a rigorous Model for clients? In this consulting/analytics consulting settings, do clients actually trust us as a modeling expert?

🤯🤯

Have you ever failed to deliver? What was it and why?

like

Thoughts on best way to break into KPMG lighthouse? Have all technical skills just need to get noticed...

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

like

Anyone in a non-technical analytical consulting roll?

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

How hard is it to get an interview for SWE at FAANG outside of on campus recruiting? I’m in GT’s OMSCS program right now, hoping to take advantage of career fairs this fall, but I don’t know if I’ll have enough time to prepare for the technical interviews before then. I’m worried about missing out on the recruiting opportunity and having to resort to applying online/LinkedIn afterwards. Any insights into this?

like

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

Can anyone from Blackstone share some insight about the Data Science Management Program? Looks like a fantastic opportunity!

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

I'm interested in data analyst remote positions.
Any suggestions on companies to apply to ?

like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



like

McKinsey & Company Does somebody have experience regarding
compensation differences between
QuantumBlack & McKinsey? I am in the process at
QB and disappointed with the salary that's
proposed. (New grad Data science from top
university applying for London) McKinsey & Company QuantumBlack

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