Have an Amazon BIE II tech interview coming up. Recruiter said:

15 min Data Viz (projects, dashboards, metrics, Tableau/Power BI)
10 min Leadership Principle (Dive Deep or Deliver Results)
40 min Advanced SQL (live coding)

Questions:

What kind of Data Viz questions to expect?
SQL difficulty level on LeetCode?
Other good SQL practice sites?

Amazon

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

For SQL they are testing speed and ability to explain intuitively more than trying to fool you with complexity. Claim to have 4 years of SQL experience? Great! Pull 3 basic queries and explain your logic for each without getting stumped or tripping up. It should come naturally with that much information experience, right? (Working under pressure and not googling or checking past code is the tough part.)

There will be moderate difficulty extractions and transformations. Expect a series of 2-3 questions that ask you to join about 4 tables together and to use the HAVING and a few window functions, and date functions.

likeuplifting

Thanks a lot.

Related Posts

JPMorgan Chase Hi,
Does my manager know which location I logged in from…on the monthly reports? Please advise.JPMorgan Chase

like

Hi all I'm looking for an opportunity I have experience of documents review on relativity with 3yrs and also looking a switch in kyc aml..

like

Anyone prepping for the SHRM-CP test? I’m taking a prep course this fall and would love tips or to know if there are any study groups out there!

like

Hi All,

How is epam anywhere different from epam systems ?

Can switch to epam anywhere from epam systems ?

like

I’ve bought Arrid Extra Dry cream deodorant by the case for decades, and they’ve stopped making it! Using Mitchum now and I don’t like the smell, I sweat through Secret... what do you all use?

For those of you taking Nutrafol, do you also add in collagen supplements to your routine or has the Nutrafol been helpful in itself? Thanks!

like

I’m interested in pursuing cosmetic dermatology (possible Botox and laser treatment) for the first time. I’ve done a ton of research and the derm I’m most interested in going to charges a $150 consult fee but does NOT apply that cost to any treatments you get, whereas from my research it seems like derms in my city usually do apply the consult fee to the treatments. Would you pass on her due to that additional cost, or consider it worth it to see the derm you want to see?

like

Can anyone recommend a good place to get Botox in SF?

likefunny

Is it okay to disappear from friends & family to work on career change goals (several months)? I want to focus and not get distracted by friends & family needs to see me or attend certain things as it takes up a lot of time. If I focus for a short time, I can quickly achieve my goals to switch. I can hangout with them after all of that. What do you think?? Any feedback will be appreciated.

like

For those who were diagnosed as an adult can you provide some insight into how you were able to obtain a diagnosis. I went to my primary care dr who referred me to another dr who specialized in mental health. He asked me about 5 questions before telling me I should see a neuropsychologist for an official assessment. The referral he gave me is super pricey and apparently isn’t covered by insurance. Is that normal?

likehelpful

Anyone here who made the exit from Big 4/MBB consulting to a VC? If so, I’d love to hear about how the experience is so far. (Not to mention the WLB and comp!) I’m considering a career change but have no one in my network I can go to for insights. Thx! 🙏🏾

like

Do MBB firms usually give temporary accommodation to look for a place for people relocating from outside?

smart

Anyone recently completed their visa process with PwC? Please advise on time taken by PwC for CoS alone and overall visa.

likehelpful

What is the reason behind - so many folks joining BDO Rise in the last 12 months ? any specific reason? feel free to pot your thoughts

like
like

Would you take a freelance gig that would be a promotion (with potential to join full time) with a smaller company whose values you really agree with, OR a full-time offer for a lateral move with a larger company with teammates you know and trust? Of course factoring in all the nuances of covid. TIA!

like

At my uncles wedding in Madrid I remember lying down on the grass in the courtyard after their first dance and crying, my Dad came and saw me, laid down in his suit beside me and asked what was wrong.

“I know my boyfriend wouldn’t dance with me like that at our wedding”

And we just lay there as I cried, and then got up. Had a drink.

Said boyfriend left years ago, and now I have a wonderful man who just asked me what type of dance lessons I want for our wedding next year.

Don’t give up.

likeupliftingfunny

Looking to transition out of a clinical role to a “clinical data/tech role” to help bridge the gap between healthcare tech and implementation to healthcare companies/field clinicians. Any recommendations to look for healthcare tech companies or getting started for a clinical data training?

likehelpful

Working remote with next to none human interactions, masking and social distancing in public. When will this end 😩

Post Photo
likefunny

Do you like humor incorporated into resumes? Why or why not?

like

Additional Posts in Data & Analytics Consultants

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

Folks applying for Data and Analytics roles in the industry at M, SM, D Levels, what technical/functional topics do you prepare for on the Analytics side?

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Bowl show and tell this Saturday at 12-1 EST! Put it on your calendar so you remember us brainy people 📆
Zoom details will be posted on this thread, FB team is working provide an account.

Bring a talking point: anything data or analytics related, from memes to case studies of your side hustle to firm stuff we should know about to anonimized work projects. This is DaTa bOwL LiVe!! I can't promise we'll get through everyone, but we'll see. We can go overtime if y'all are enjoying 🍿🦁🎪🤡

like

Any BCG Gamma fish? Can you please share what kind of analytics projects do you guys do?

likehelpful

How’s EY’s hiring/interview process structured for data and analytics roles?

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

Folks,

Any resume site / recommendations for an analytics focussed resume I could get some inspiration from?

Been on my job for 7+ years - a bit lost as to articulating my experience effectively. I have a resume, but don't think it strikes a chord with recruiters.

Please help!

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

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

like

Can anyone from Deloitte provide anymore insight to the differences between the Applied AI and Strategic Analytics divisions within GPS? I am in the data analytics and science space and have had two separate recruiters reach out. Thanks

like

Looking at a job in Kobo (Rakuten) for Data Analyst, any insights as in the technical portion of the interview ? Also, any recommendations regarding the company? Thank you!

like

could i dm someone to criticize/suggest feedback on my resume? i’d like to believe i have good experience but unsure why im not receiving any bites

like

The longer I do this job, the more I want to accept a tech job... no travel, same / better pay, no annoying clients...

like

Being a data engineer can be so defeating. Put together a pipeline for a client I was really proud of, had to overcome a lot of challenges due to the clients dated tech stack.

Just for a non technical manager to be like “why did it take so long” 😒

likefunny

Anyone works/heard of DMV Group? Mind if i shoot some questions about them?

I have been working in healthcare clinics and health techs for a few years now. I’m an independent consultant. Bust, a friend of mine referred me to a big bank job. The role is of data governance manager. What should I know for the interview, or how can I prepare for it? Any thoughts? They told me I don’t need financial background. Data is data, but they wanted to know metadata management and how do I build frameworks/implement enterprise systems.

like

What are some of the best online resources to learn Power BI?

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