Technical assessments during interviews…
what should I know when taking a take-home SQL assessment before my interview? What’s a good query editor to test your query before submitting? Any SQL gurus out here ? Any tips ?

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

Our technical screen for software engineers requires someone to join two tables and filter the results, displaying only a few columns from the table. I don't recall the details of the question, but the answer is something like this:

SELECT employees.first_name, employees.last_name, jobs.job_title FROM employees INNER JOIN jobs ON employees.job = jobs,id WHERE jobs.senority > 2;

Or something of that level of difficulty.

I suppose a candidate could set up a database to test their query, but I don't really expect that. If they decided to test, they'd probably get on just fine with the CLI.

like

We don't expect people to have an opinion about different types of indexes, side effects of certain database design on the filesystem, using EXPLAIN to understand how a query is run, or working with multiple instances of a SQL server.

But I'd be impressed if a candidate talked about those things.

like

Leetcode has a bunch of database problems

Remembering my interviews at G (sql was a hard requirement for the job) you can see difficulties as the following :

- easy: basic selects, aggregations, joins
- medium : subselects/or with, join back to a table, complex joins
- hard: medium +ranking and windows function ( dense_rank(), row_num())

like

What was the position?

Try app.bigtechinterviews.com! Best SQL interview prep platform out there.

Related Posts

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

Getting a lower title than what I interviewed for but the salary matches what I asked for. Would you go?

like

How are the client and project interviews for SAP in Capgemini? Are those tough?

like

Hey folks, question about applying for a role in Spotify (Sweden).
Does having a referral make a big difference to get your application reviewed?

I'm currently in Canada and planning to move to Sweden soon so applied for a few spots however I don't have even the slightest idea if
a) applying from Ca will actually get my application tossed out the window
b) I've heard there are gazillion ppl applying so if referral gets me on the radar, instead wasting time just find someone to refer me?

like

Hi..

I've been approached for a Manager - Technical Consulting position at Salesforce India.

How are the technical rounds on a quotient of 1-10(1 being very less and 10 being extremely technical)?
Should I prepare for something specifically?

And what is the current package provided by Salesforce for the same position?

Any help would be appreciated.

Thanks

Hello All - looking for links, resources , samples on interview prep/practice for sales , account management, partner management, practice management at FAANG companies like amazon, google, microsoft

like

What are your thoughts about putting an explanation for the current gap (as in, I haven’t been working for several months) on your resume, LinkedIn profile or cover letter? If you think it should be included in one of these places, how would you do it?

like

Hi Guys,

Please help me with relevant interview questions for bizops engineer in master Card

like

Any BCG folks have any insight to the Pymetrics test? Is it used to determine whether I get an interview and is it something I can prepare for before taking?

like

Got ghosted for one of the three interviews I’ve managed to land since covid started. Not even a lame excuse for why they couldn’t make it. Now I’m just bummed out.

like

Hi Fishes,

l interviewed for Deloitte (India not USI) in January, and accepted an offer letter with DOJ of 25th April, later HR asked me to join on 11th April for which I agreed. Now I haven't received the revised offer letter or any links other than BGV and Pre-Hire form from Deloitte and now the HR is not even picking my calls or responding to emails.

Any advice on what to do?

like

Bloomberg hi all! I applied for Bloomberg Analytics and Sales and passed the super day. I’m meeting with the manager tomorrow for half an hour. What can I expect? Thanks!

like

How are they paying for a 11+ yrs experienced candidate ?Can I expect 40 LPA? .
CTC is 23 LPA
How will be the interview rounds

like

Current SC with ~3YOE looking for a jump to tech. Just wrapped up interviews with AWS non-tech role slotted at L4. Current base is $115k. Can anyone provide insight into the band for L4 at AWS? I’ve provided the recruiter with my ideal range and am continually reminded to make sure I look at the “full compensation package”. Anticipate receiving offer within coming days. TIA.

like

How much time does Infosys takes to share the offer letter and proceed with documentation and stuff. I have cleared 2 rounds of interview and still waiting for HR to contact me.

like

15 years experience interviewed for BA4 grade in Barclays. Does it make sense? I thought BA4 is below manager grade and lower salaries.

I have a JP Morgan code interview happening soon for a data science position. Anything I should know before I get started?

like

Hi, What type of questions are asked in Partners round at Sun Life Financial
Please post few questions which were asked from you.

Tech: Java
YOE: 4+

like

Dress code for HBS interview day when I am not interviewing that day?

like

After asking for docs , how much days it will take in cognizant for further process ?
Please let me know

like

More Posts

Just out of curiosity: how many of you have had sex with co-workers? Is it common in your social circle? Did it happen at work or outside? How do you get to that point without being inopportune?

like

29M from Kerala, living in Chicago. Looking to find someone local to seriously date. Please DM if you’re interested!

like

Hi y'all
Anybody here pivoted careers completely? How did you go about it? How much time did it take for the transition ? What tools or online help(training/ coaching) did you take to make the switch??

like

What is the average bonus for an Associate within A&M BT PEPI? I got an offer with 100K€ basis in Europe and I m trying to figure out the average and potential bonus an associate can get. I know it varies but I’m looking for a ROM . Thank you in advance

like

Does anyone know how to get early release from the notice period I don't want to serve 90 days I need to spend 30 days only pls let me know what to do.

like

United employees give me hope this morning in BOS. 🙌

Post Photo
likefunnyuplifting

FAANG PMTs salaries?
Looking to hear about PMT/ Sr. PMT / Principal PMT Salaries

like

Can we go to any other Capgemini office temporarily if our base officer location is different.

like

12 years ex- Accenture. Certified Scrum Master, Product Owner and Salesforce Certified. In Kolkata (preferred), Open for Bangalore. Currently in Notice period. DM me for open roles.

like

Just got an offer to a BB. How do I popcorn this into more?

like

Steve Wozniak isn't afraid to critique Apple devices, and said he couldn't tell the difference between the newly released iPhone 13 and its predecessor, the iPhone 12.

like

My H1B is processing but after hearing stories that company won't provide any projects for US even after H1B approval , should u take a jump. Have a offer in hand for another company which pays 50% hike on current package

like

What is the best way to reach out to your in house agency ? I want to share our call for artists . Do I have go through HR? Or is there a place I can simply post an announcement ?

like

Hello fishes,
I have 5 years of experience. I have received offer letter for IN3 role (java developer) with 22LPA(fixed)+variable(4)+joining bonus(2)..Is this good package or are they lowballing me..?? Should i try for counter offer… will they increment in case of counter offer??

like

How is NTT Data for job security, growth and work life balance. I was asked to work in UK shifts, will I get any allowance for that??

like

EPAM system and EPAM anywhere ,both accept 90 days notice period

like

Busy season continues

Post Photo
likefunny

Can anyone help me understand this better?

Post Photo
like

How can I make $140K and above w/ 5 YOE in operations, program management, client delivery? Worked in NGO for 3 years then consulting for 2 years.

like

Additional Posts in Tech

Hi y'all
Anybody here pivoted careers completely? How did you go about it? How much time did it take for the transition ? What tools or online help(training/ coaching) did you take to make the switch??

like

Interested in cybersecurity companies. What are some other than Symantec?

like

Currently interviewing for Microsoft Sr. HW MFG PM. Could you tell me what is the package if I get offer at Washington ? Microsoft

like

Would putting out a lever referral link for my company on a public site (Reddit) be frowned upon? I get money for every hire.

like

Angel investors : What returns do you expect when investing? Also what’s your range of investment?

like
like

You did an interview and your interviewer apologized that the travel time 180minutes was much higher than 30minutes scheduled time for the interview and that It could have been done remotely, but she has to follow the process. I am still waiting for feedback though.

Is this just a humane demonstration?

like

I just got my first promotion! Start in the new role next week. Any general tips for hitting the ground running when you change orgs? I really want to make a good impression with the new team.

likeupliftingsmart
like

Virtual team building ideas?

like

My marketing people - does anyone else's company have a dedicated "Marketing Response Team" (MRT Team)? Or something similar? Might be called something else at other companies and I just have no clue.

I was contacted by a recruiter with a job in the EV market, which is something I've been wanting for a while. Im at a comfortable point in my current position where I can do my job very easily, change would mean starting from zero again. What should I do? Any advise?

like

Any suggestions on cracking a product management interview at a telecommunications company! I have been working as a software engineer for the past 10 years and now looking towards transitioning to product management. Any advice is welcome.

like

What are some things you guys wish you knew before you started your NetSuite implementation?

I’m at a small company that’s sort of becoming medium sized, and a new exec pushing to quickly implement NetSuite and I just want to make sure we’re not getting in over our heads, he’s trying to get this done within two months

We currently use Salesforce, quick books, and excel, we’ll be consolidating a lot of accounting and finance stuff into netsuite and integrating it with Salesforce

like

Serious question… if I am interested in becoming a CTO/CDO one day, what should I do for the next 5-8 years to prepare for this? Are there specific roles in tech that prepares you for a CTO role? I am currently in sales engineering with over a decade in consulting experience.

like

Google Hey I am finishing up 3rd round of google interviews, for software engineer position, does anyone know what the offer is for NYC? I have 2.5 YOE.

like

Have 6 YOE and currently a PM at a newly IPO’d company. Where / what level can I make 200k+ in base?

like

I've been approached about being an expert consultant. Has anyone done this before? I'm interested to hear people's experience.

like

I’m an L6 SDM at Amazon but a Meta recruiter sent me an M2 sdm job description. I have all the XP I need from previous job experience but does Meta keep your same level as Amazon? Meaning if I am an L6 at Amazon am I automatically interviewing at M1 or can I jump to an M2?Amazon Facebook (Meta)

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