How to prepare for Amazon Livecode interview?

For this round of interview it will be on SQL livecode
Any resources one must have used for livecode interview prep?

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

Ok idk wtf people here are saying. Hit up leetcode. Get up to be able to do at least the medium levels and you should be good.

like

Good luck!

Nothing but basic syntax

like

Whichever you are comfortable w/ as long as you are vocal of the solution and know what you are doing. They don’t grill you for function names or arguments, in fact you can even ask interviewer the syntax usage.

If that really matters to you, their code pad is based of Postgres,like redshift.

Just anyone will be fine. MySQL. It's not that difficult.

like

Hi same question as yours. How did you prepare livecode sql test? What is the format of livecode sql test? via a phone or whiteboard?

like

I am worried that they are gonna ask very complex queries...
I am comfortable with SQL but not sure what my approach should be to prepare for the interview in terms of SQL and Excel
Btw this is for Business Analyst role and I was told that there will be Livecode on SQL

Someone with half a brain can pick up to LC medium in like a week. Might as well do it to be 100% prepared.

Related Posts

Hello friends,

How is stratacent as a company to join?

like

Any Directors, Assistant Director, Executive Director from PwC. I need some information regarding the final round/ED round mentioned in my email.
PwC

like

Hi All- I’d love to hear from the community what the focus areas are for Tier 2 firms in the region Are there certain sectors the various firms specialize/ focus on? It seems like everyone focuses on public sector and tmt. Currently interviewing at a few and would be great to get some feedback. Thanks!

like

Best way to approach networking with MBB if I am planning to apply for roles in Jan 2024 (1 year from now). Do people start with their school alum and get referred to partners?

like

When I was a device driver developer with 2 years relevant experience I had got calls from Nvidia and Qualcomm. Unfortunately I wasn't able to crack the interviews back then.

For next 5 years I worked mostly on application development and broadening my exposure. I am not getting even a single call from such companies now.

Is it a good idea to rebrand myself as a device driver developer so that I can get calls again?

like

How is the work culture in Volkswagen IT? I have the offer but still m rethinking because of the hybrid working model, all other companies are still offering WFH .

Can somebody please suggest? What all perks I can get if i accept the offer?

I have a counter offer with more package than the Microsoft. Do they have a policy of blacklist the candidate if I change my mind after accepting the offer?

like

Does Amazon give yearly cost of living raises?? Like the 3-5% that other companies give? What typically happens at the comp review with your manager? And what avg percentage increase did employees see this year? Amazon

likehelpful

Anyone have insights into Zions investment bank?

like

How can I best leverage my Deloitte experience to secure an offer from another employer? What advantages does Deloitte experience provide a candidate that I can emphasize?

like

Hi friends I have offers from HSBC as well as Visa Inc. what would you recommend to join from better career perspective and brand ?
Software engineer with 3+ YOE

uplifting

Senior Business Development Role at 360Learning:

Anyone have tips for cover letter/resume to stand out?

They are huge on not negotiating salary there based on their blog.

Anyone know the base salary/expected commission? - It requires you to answer on the application. I would be so thrilled to work at the company I just want to put what they start out at.

like

Almost a week with On-site interview and it’s been a radio silence from my recruiter. Should I reach back to them or is it normal? Not at all impatient, just trying to know what’s the norm.

like

What’s the culture like at Waystar Royco? Its an UMM fund focused on media

likefunny
like

New to Fishbowl, currently working on a career pivot! I graduated in May with my MBA and have experience as a Director of Operations as well as recruiting and HR experience. I am looking to move more into Change/Project Management or Director of People Operations roles. I have been at the application game now for two months with only two interviews and over 20 applications sent out each week. Any advice would be greatly appreciated!! Feeing a little defeated over here. Thank you!

like

What are the health insurance benefits provided at SAP India ? What is the base cover and how much can it be extended to ?

like

What are the yearly hikes for NTT consulting division?

Hi fishes

What should be the salary for ERP consultant on H1B at Spartanburg SC, USA?

I am being offered 84K Base annual.

like

More Posts

like
like

Anyone have idea on below companies. Which is better in terms of WLB & hikes? Both offering almost same CTC.
1)EPAM Systems
2) FactSet

like

Got an offer from Capgemini for 10LPA fixed and also I got an offer from HCL for 11LPA (includes variable pay but mentioned it will be paid monthly basis) , which one is good to join to develop my career growth. Having 4YOE in network security , vulnerability management and selected for the role of vulnerability management in both the firm's
Please suggest me.

like

Moving to Philly Nov 1, just signed a lease in Queen Village. Coming from LA where I was part of a volleyball group and had a lot of options at the beach. Suggestions on making friends and being active (while still being respectful of covid rules & health of all)? 36 F

like

Reading the Security Permission Report for Proxy management

#SAP #SuccessFactors #HXM #ProxyManagement #Audit #Security

Post Photo

Let's say through a combination of aggressive saving, high income, and savvy investments, I manage to save several million by the time I'm 40.

If at that time I decided to pursue my passion and go to law school so that I can be an affordable attorney for worthy causes, will my age hold me back from getting into law school?

likeupliftinghelpful

What are some of your favorite ways to stay active and maintain a healthy lifestyle, especially those who are fully remote?

like

Does sopra has hire and fire policy . (My client interview is not done . They have released the offer without second round )

Anyone do work with school districts or companies that work with schools? I work with schools reviewing tech contracts and data privacy protocols, but I’d like to make a jump to a firm where the money is a bit better. It doesn’t necessarily need to be a firm that does school work, but that is where my current experience is.

Hello! I would like to get into the Tech field does anyone have advice on how where to start or any open entry level attorney positions. Thank you!

like

For practice area purposes, all this metaverse/web3/nft legal work should be categorized on firm websites as "Cringelaw"

likefunny
like

Anyone here working in the tech consulting practice in the NE unit easily able to get local clients in the city?

like

Can someone help me with the in-hand salary?
I assume Its 1.24 including taxes. 20k is reserved for Performance pay, I believe they will atleast pay 50% i.e 10k per month.

Is this good offer for 4.2EOY?

Post Photo
like
like

Am torn between: Master of Business Administration with a Concentration in Operations and Supply Chain Management and Master of Business Administration with a Concentration in Human Resource Management. Can anyone of my wise peeps give some insights? Good, bad?

like

My professional life at the moment is far from ideal. I’ve been on quarantine (long story, but a good one) for the last seven years. Royalties from my books don’t pay the bills. My entrepreneurial pursuits remain hampered. For the interim, I’ve been looking for a remote opportunity where I can leverage my skills in marketing, sales, social media, and elsewhere for a decent sum. I have a social media presence which, in recent years, reached millions. There has to be something exciting I can do.

like

How do you split income/expenses with your spouse? Wife earns about 75% as much as me. Don’t have kids yet. Do you have a joint account for everything or do you split common expenses 50-50 or in proportion to income? Something else? This has caused some contention so want to benchmark. Thanks!

funny

Any Deloitte recruiter in here to help me on my application? I am stuck on submitting the application because it is saying ''there is an existing application by this phone number, so log in continue", but I can't see any continue option!

Additional Posts in Data & Analytics Consultants

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

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

Anyone who has done masters in business analytics Singapore? Could you help on courses, Scholarships and careers and jobs. Looking for help.

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

Anyone made the jump from EY DnA to Bain AAG (or vice versa)? I’m wondering how they stack up across technical capabilities, project mix, WLB, etc.

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

Single book recommendation for user research?

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

like

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

like

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

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

Anyone have recommendations on the best app/site to learn Python? 🐍
I’m a complete beginner.

like

I am finishing up a project and I’m trying to document what I’ve done for my resume. What are some good metrics for someone who mainly created user stories, created dashboards, interacted with the client and developed statistical models? One of my dashboards got deployed to production but it’s to early to see the impact. My other dashboards are almost done but I’m moving on to something else.

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

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

like

What tech companies are best for Data Analysts? Looking for $120k base + equity that’s gonna be worth a lot + other great benefits + possible remote.

funny

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

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

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

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