For those that have done a sql test as part of a product analyst interview, what kind of questions should I expect? I only know simple statement structures (no joins) so I think I need to do a crash course

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

Joins, cte, window functions, mostly lead lag ones, partitions, when to use row number/ dense rank, etc.

likehelpful

Mode analytics has a good crash course

like

You should definitely know joins.

like

Other recommendations?

Use Leetcode as a resource to practice

like

Joins

Make sure you're comfortable with subqueries (3+ nested ones)

The reason I love CTEs.

Related Posts

The job market is great however i am having hard time to get an interview. Most of the times I get rejected in HR screening for either - we don’t sponsor or visa / or relocation is must. I am at a point where I have to find a job in next 3 months. Any tips from visa dependent folks ? I have 12+ years of experience

like

Hello

I've been interviewed by @Amazon on 8th July and even after multiple follow up emails, there's no update. Any suggestions?

like

Hi fishes, I have an interview tomorrow with factset for Client Solution Advisor. Any tips for the questions they'll be asking? And if ajy of the factset employee can tell me the work we will do in this role will be good.

Single book recommendation for user research?

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

like

Is there anyone who is @cvshealth who would not mind giving me a referral? I have applied to a Senior Manager Quality Improvement Actives position. I would love an opportunity to interview to better demonstrate the value I can add to the organization. Thanks I’m advance!

like

How many days it will take to release offer in HCL after HR discussion????
What will be the process after HR interview in HCL???

like

Why is it some companies make you reapply to a role when you’re towards the end of the interview process?

Does it look bad in my resume to resign after less than a year at a job? writing here the time I’ve spent at each company since graduating college:
- 2 years at company 1 (resigned to move back to home country)
- 2 years at company 2 (resigned and moved back to the US)
- went back to company 1 (it had grown exponentially after 2 years so came back at higher position) (resigned after 1 year to join a startup at director level)
- 6 months at startup and I want to quit with nothing lined up

like

Currently interviewing for corporate development manager at a PE portco and would appreciate insight on reasonable comp expectations. TEV is ~$4b and they close about a dozen LMM deals per year. TIA!

like

Interviewing for BIOLIFE today and looking to gain insight from anyone who works for the company.

Hi everyone,
I want to learn Salesforce Tableau CRM (formerly known as Einstein Analytics) and switch to a different organisation. In my current company stuck in a project where there's no learning scope, no growth and work culture is toxic. Now I'm only going through Trailhead, YouTube playlist videos and practicing hands on in my free personal org. Are these enough to crack interviews or not? I don't have real-time project experience.

How and when in the interview process would you go about asking about a company's philosophy on/commitment to Diversity, Equity, and Inclusion (DEI)?

I'm actively interviewing with 5 companies right now, but the one that seems most likely to give me an offer is also the only one where I've so far only been interviewed by 3 white men Is there a delicate way to ask why there aren't women and BIPOC involved in the hiring decision process / whether leadership at the company is more inclusive?

like

Hey everyone - I could do with some advice. Not sure what I am doing wrong, but I am having a hard time getting interview calls. I am trying to pivot from consulting to the industry and targeting project/program management roles. I have been doing this work for 7+ years now (total YOE 12 years) so certainly have the right skillset. I have tried a couple of referrals too but that didn’t help either. Any advice you guys could provide would be helpful. Thanks!

like

Tips for applying for a PM role, being a software engineer my whole life! Much appreciated!!!!

like

I'm working with EPAM, 7.8 yoe as dot net full stack with ctc 26LPA.
Fed up with my current tech stack now project want on call support over weekend. no one knows project. No one is supporting.
Thinking abt current situation I'm bit worrying.
Somehow given interview in EY and selected. HR ask me CTC, NP and expected CTC. I told 20% and 60 days NP. She said, will check with business and get back to me.
It's been 3 days no response, when I called her today she didn't pick. Is it normal in EY?

like

Hello Deloitte 🐟,
After three rounds of interview, recruiter wants to have a call with partner as a final round. What is the intervw with a partner like ? What is the role of a partner in Deloitte. I am interviewing for specialist master role for cyber security. What is the ask for compensation for this position at D and what is the signing bonus and target bonus like ? 7YOE and 135k TC

like

I have passed the nagarro online assessment test, when can I expect the call from recruiter , it's already 2 days now.

like

About to do my first interview for an in house job (coming from a midsize firm).
What are some questions typically asked, and good answers to those questions?
What are some good questions to ask?

like

I’ve been working for a company for 25yrs, looking for advancement. I’m considered an SME, managing people, Vendors and working on large system conversions. Have provided long term goals. When requesting feedback I’m told I’m on the right path, no suggestions on what to improve. I asked about timelines for advancement and not being given anything concrete. Recently interviewed with another company as a Vendor Mgmt partner. Individual contributor, high visible position with potential. Thoughts?

like

Any recruiters here that do onboarding? Also, to what extent.

like

More Posts

Finally hit first million in crypto assets. Surviving the crypto winter has its blessings. Hopefully I can peace out of rat race 2023

Edit: for everyone that survived the crypto winter with me I hope you all made it too or soon.

Post Photo
likeupliftinghelpful

I'm looking to get in to pharma sales and have a sales background but in medical device. Has anyone made this switch? Would you be willing to offer any advice?

like

Morgan Stanley friends - how are your bonuses looking today?

like

Hi Fishes,
I am working as Automotive Engine R&D engineer for past 6 yrs. I have total experience of 6 yrs. I want to switch to consulting. Do suggest me how to take this career transition.
I would appreciate if anyone can share the right opportunity with me.
Thanks!!

P.S. I am mechanical engineering graduate from tier 1 institute in india. Good knowledge of excel and other microsoft products.

like

I have appeared the first round for an ui angular position in HPE. Have anyone recently appeared for similar interview. How long is the interview process? @HPE

like

How much CTC we can expect in Capgemini for Automation testing SELENIUM WITH JAVA .

YOE: 5.3 Already holding offer for 17 LPA WITH ATOS

like

Just a discussion thread, but I feel like this is a good bowl to ask this. Does anyone else look at the vast majority of folks around you and think “damn, we are so over leveraged as a society?” Or am I just crazy?

like

I’ve noticed a lot of job applications have a field for a website in addition to LinkedIn…this is new to me. what kind of websites do people put here? What’s on the website? Is it like a campaign/platform of themselves as a brand?

like

Has anyone started/considered starting an individual/small business income tax preparation side gig? What were the challenges juggling w/ a Full Time job and getting clients?

like

Where my McKinsey EA's at??

like

Trying to find a video example of where a person stays in the same place in the frame but a new scene is revealed by a wipe or mask. So it’s the same person but their wardrobe and set will change around them. TIA

like

My last therapist keeps coming up in my mind. I left her when I moved to a new area before COVID dug in and frankly it felt like leaving a girlfriend. She also disclosed in the final session that she was a member of AA and knew several of the people I occasionally discussed from the rooms. Her knowledge of the program certainly built trust with me early on, but it has been two years. I discussed it with my current therapist but she’s still in there. Any advice?

like

Hi everyone. Looking to see if anyone would be willing to network as I would like to transition to HR in tech. Any help or advice is appreciated. TIA 😊

like

Has anyone come to you for help?

Remember that these people asked Allah first, and Allah gave them your address for you to help them.

like

How much does an associate scientist make at Pfizer-Groton? (I have 1 year experience out of college but have published 2 papers first author, ample experience during university, internships and have an bachelors in biochemistry with honors).

like

Best places to stay in Vietnam, Cambodia, Malaysia? Who has had a great experience in these places and what made it special? : )

Any book recommendations to gift my cousin sister? She studied (masters) psychology and is a trained classical dancer.

like

Anyone know what Greenberg Traurig is starting at for entry level positions outside NYC? Can’t seem to find a source

like

How many people earn a degree in Engineering but don’t pursue a career in it,for whatever reason?I know at least one and I don’t know why they spent all that time and money if they weren’t going continue in it

likehelpful

Had an interview yesterday and the interviewer wanted to understand what I did - even 1 month gap between jobs - from 2009 to present 🤪 Not interested in the job anymore tbh

likefunny

Additional Posts in Consulting Exit Opportunities

What is the best path to reach C-suite in later stage startups?

like

How well does 1 year in a top 4 looks on the resume when trying to look for a software development role?

likefunny

I was a Manager at a Big4 doing PM fed work earlier this year. I decided to join a small firm to pursue cloud sales. However, the position is extremely technical in nature and I'm required to speak tech ( kubernetes, openshift, CICD) to potential clients.
While I have learned from the exposure, I dont intend to continue in a tech role & looking to exit. I'm thinking of Customer/ Partner Success Manager roles with one of the CSPs. Are there other non tech cloud exit opps in industry to consider?

like

Hey 🐠 Fam! Moving to DC in 6 months. I’m an org development and effectiveness consultant for a mid-size firm. Would love to get introduced to firms that do similar work. Message me for LinkedIn info

like

Two years into MBB post MBA, I realize my passion lies in technology. Although to progress in tech, you need to be a product manager. I have no prior product experience so will have to start from scratch. Have I wasted my two years at MBB when I could have recruited for product roles in business school?

like

About to start my first PM job! Any tips to be prepared and ramp up quickly? Books to read, courses to take, etc.. any tips are appreciated! Currently in ops consulting. No tech background.

like

Ex-consultant now in marketing. Used to be an avid follower here and got great insights on companies when trying to exit consulting so thought I’d try here for advice. Outside of FAANG, what are good large CA-based tech companies that provide good pay, WLB, and culture? DD has great people and WLB, but pay is low and you’re not given the tools and resources to succeed + truly make an impact. Google and Apple are ideal but need backups. Like is Salesforce still good? A company along those lines.

like

Did anyone put a two week notice and was asked to leave immediately because you were on bench? Not leaving for a competitor

like

Can anyone give insight into interviewing at Uber? Specifically in their Internal Audit or FRM group? Uber

like

If you have generalist skills, what types of jobs should you be targeting? I have some skills relevant to bizops, pmo, marketing, but can’t seem to land a job in any field. 3 YOE.

like

Got a verbal offer today. waiting on paperwork to come. Cannot wait to get out. Playing a timing game between signing offer letter and getting off the bench. Shine down on me staffing gods

like

Let me paint you a picture.

like

Anyone witness slackers who got into companies you have no idea how? Had a coworker who does jack chit at work besides chatting on Facebook yet lands at a faang company? I guess if he brings the same work ethic he will be spit out for sure. Or maybe he just had no interest in doing project work.

like

What are the chances of Amazon (or FAANG in general) allowing you to apply/interview again for a position that you did not get in the past?

like

Is 1YOE way too soon to start looking for jobs? What would you say is the minimum number of years for cool opportunities to start becoming accessible?

like

Does anyone have advice for how to make time go through recruiting while working this job? I am really struggling on how I can possible look, apply, and prepare for interviews other places when I’m working 65 to 70 hour weeks.

like

Has anyone had an interview where the interviewer only asks 1-2 questions (with one of them being “tell me about yourself?”). The first round was the same and I made it through, so don’t think (cont.)

like

do companies generally send you a company computer if you’ve started a new job?

like

Top companies for brand manager exits

like

What books would you recommend for someone wanting to get better at sales?

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