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

Deloitte fish, asking for a friend on salary expectations for Deloitte GPS senior consultant, manager role?

Thanks!

like

I’m a second year in M&A and I have two interviews this week with Wilkie and Freshfields and I don’t know much about either. Any insight on their workload, hours, culture in the NY office (or in general) or any other topic would be greatly appreciated!

like

Hi Fishes,

I have 2 offers,
1. UBS mumbai as X amount, bonus as discretionary. Probation: 3mnth
2. @BP Pune as same X amount, bonus as 18% . Probation: 6month

Which one is better ,and why?

Can anyone share the interview process for salesforce business transformation architect? Would there be a case study or presentation?

like

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

like

Hi I am a care coordinator for a big insurance company. I recently graduated with my MSN LM and want to transition into the business side, analytics most likely.. I have no specific job experience with analytics. Is this a deal breaker when applying to these jobs that “require experience in analytics”

like

Hello all,

Hope you are doing well.

I have a condition and want to know your opinions. I have given a particular date 30th May of joining in offer letter
Legato Health Technologies , but now they are saying that the joining will be delayed by a day Or two.

I am getting confused about this and also getting a little bit afraid as well as I have already says no to other offers and now this happens...

Request you all to please help me on this.

Thanking you all in advance.

Can anyone provide me a ballpark number for M1 salary at PwC AC Bangalore in US advisory ?

like

What is the approval cycle for EY LLP?
When do we get the revised compensation letter, when is bonus credited and from which month is revised compensation applicable?

like

Compared to facilities which company (Samsung and Intel) provides best facilities? I know Intel has lot of benifits like free cab, child day care reimbursement, telephone bill reimbursement, 15% discount on shares purchase, very good leave structure, Free UDEMY for developing skills, Intel wiki for lot of knowledge gathering etc... Any idea about samsung? Intel Corporation Samsung

likehelpful

Any thoughts on Sangamo (e.g., Business outlook, their Zinc Finger tech, their CAR-Tregs platform, leadership, company culture, compensation, etc.)?

smart

So I keep applying for leadership roles (supervisor and manager level). Keep making it to final interviews and I am not chosen. The feedback I get is they were very impressed with my interviews and they forward my resume to there colleagues for another leadership opportunity and I end up with the same results. They do include that they went with someone that had mgmt experience. The emails aren’t generic I may add. However I am not sure what else I can do to land a spot? Thoughts please!

like

Hello Folks -
In dilemma - I have two offers from Europen region -
1) IT Industry - 85K Euros annuly for Finland &
2) Manufacturing Firm- 105K annualy for Germany- Near to Frankfurt location ( kind of bond for 3 years)

Both have 10% bonus component involved

Prefrences -
- Work life balance
- Family status as would be traveling with kid.
- Living conditions & Indian community
- Money post taxation

Any pointer on the above suitation would be helpful in deciding me further.
🍻

like

Should I ask to interviewer that how I performed in an interview at end?

like

i gotta job interview at amazon is it a good place

like

I am currently a technical recruiter in gaming, I am actively interviewing with Amazon. I said my salary expectation was 80k, however my company just restructured and we are being offered 92K which is a significant increase for me either way.
Should I ask Amazon to match? I would love to work for them but am perfectly happy in my current role as well.

like

Any tips for Microsoft project manager interview? Possible questions/scenarios to be prepared for? Would be for dynamics implementations.

like

What is a JL6 PM salary range in Infosys?
What is the yearly bonus component in it.

like

I am about to join Nagarro next week as a Staff Engineer - Angular. Recently I have seen many posts that people are not getting projects and are on bench for almost couple of months! So my question is - do they have enough projects on Angular? Nagarro

like

More Posts

Currently, I’m searching for a new position in the Accounting industry. How should I approach the recent two year gap in my resume? This came due to being I’ll from a condition I have. I was in and out of the hospital and my health was my top priority at the time. I am just now beginning to reach out and spread my resume. Any insight would be highly appreciated!

like

Anyone know any great market research agency that would be a good fit for a smaller brand?

Is Capgemini Invent know for “digital” or just for “tech”? I’m concerned that if I accept an offer I’ll end up being far more down the tech implementation route than the digital strategy route I’m after.

like

Yesterday I read a Reddit thread about how expensive it is to be poor. Some of the responses were truly heartbreaking. Made me realize how incredibly lucky we all are

likeupliftingfunny

APAC Kearney employee here. Have an opportunity to shift to Bain, but have been in the firm for only a few months. Any thoughts? Should I shift? Or stay back longer?
Shifting will push me back 6 months.
Any advice is appreciated. Thanks!

like

Hi Fishes,

I need 11 likes to unlock DM feature.

Thanks in advance!

like

Hello, newbie here

like

For those console players, what sensitivity do you play on?

like

81 Members in this Bowl...and yet...No girls I guess

like

I am currently interviewing for a management position, this will be the first management position I hold. I hold a masters degree and about 7 years experience in the business. Any advice on how to show I am ready/can handle this position? The only qualification from the job description I don’t hold is the management part.

Any advice?

Does anyone in the DC area have a cleaning service they recommend?
To create better work-life balance, I’m starting to delegate some things in my personal life and cleaning is at the top of the list. Appreciate the recos in advance!

like

Pagani Museum pictures

Post Photo
likeuplifting

Can you transfer H1B to a different employer? How does it work? Would you have to do the entire process again, including getting your case selected in the H1B cap lottery?

Is there a performance/rating scale at Alvarez and Marsal at year end?

like

How easy it to ask for a title change if your responsibilities have changed? Is it easy for a leader to make that change off cycle?

like

“I don’t do colons”
- AD

likefunny

What is your agency’s maternity or paternity leave policy?

like

Just moved from the Midwest where the concept of carpool lanes is non-existent. On the 405 today I saw at least half the cars didn’t have 2 or more people. For my knowledge, is the rule enforced?

like

Hello everyone.
I have only 1 offer with me with
15 days remaining of my notice
period.
Ideally I would have joined the
company, but the company is
EPAM.

I have been seeing many posts
here about layoffs.
Can anyone please help me
with a referral?
YOE: 6 years
Tech Stack: Python backend

Note:
Few friends here have helped me with a referral. Though not for all the interview is scheduled, I am very thankful to them.

like

Noir Thursday. Happy almost weekend watch lovers.

Post Photo
like

Additional Posts in Data & Analytics Consultants

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

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

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

DM for referral at a boutique consulting firm:

- fully remote
- good WLB
- hiring all levels with above average pay
- 3+ YOE with experience in analytics/BI in financial services background preferred

likehelpful

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like
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

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

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

like

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

like

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Would working with a data lake be valuable experience? Was offered that as my next project.

like

What's the expected pay bump from leaving big4 to the industry with 2.5 years experience and senior consultant?

like

Anyone else has the feeling data science consulting is over glorified? Projects are so small they have little bottom line impact.

like

DC folks: how’s Clarabridge (company)? Thanks

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

I’m interested in going back to school for an analytics degree. I have a math & stat undergraduate degree and have been doing data science in my projects. Does anyone have recommendations for...

like

Any recommendations for resources to learn intermediate / advanced Tableau? All the firm-provided resources I could find seemed very basic

like

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

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