In your experience, how many SQL questions per interview?

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

Select stupid question from data scientist

likefunny

Recommendations would go against “SELECT * …” and what’s with omitting the “;”?!
Also, generally recommended to use indentation for readability 🙃

For an hour long technical exam, 2-4. At least for the “advanced analytics” spectrum of data science roles.

like

3-7. As an interviewer I have enough questions to fill the hour. As an interviewee I haven’t noticed more than 7

like

Best answer

I interviewed for a SE role at a FAANG and had a full on SQL exam to take

like

Anywhere from 1-10

like

For what role and what company?

10

Thankfully none lol. They care more about concept than coding language in my experience.

Related Posts

Is Epsilon people are lazy or what there have kept an interview late night and none have joined, I called recuiter who organise also not lift the call. Unethical people

Currently applying to a government position for the army corps of engineering. Does anybody have experience working for the government?

like

Bain & Company How come the application process for Bain is very general? For example, I can only apply to “Consultant” roles instead of “Healthcare consultant”? Bain & Company

like

Does Deloitte USI respond back after the salary negotiation.HR told like she can only give an update on Monday and no response after that.is it normal like delayed response or ghosted ?

like

Which recruiters do you all find have the best connections to in-house job opportunities? I am DONE with agency life. TIA!

like

Is there anyone on here that tips on how to do a resume for a Federal position on USAJobs? Anyone has knowledge on having a Schedule A letter considered?

like

Had two rounds of interviews for an in house role and really like the company/job. I followed up Friday regarding next steps and was told they are still interviewing and should be wrapping up soon. Advice on how to stay calm? I want the position and need to know if there’s a way to speed up the process.

like

Hi all-my idea pool has officially run dry. Trying to explore new ways to market per diem
nursing. Besides, clinician spotlights, social posts, and video interviews, any other thoughts?

Has anyone been fired? How’d you bounce back? How did you approach it when applying for new jobs? I’m legitimately worried I’ll be fired and could use some advice.

like

ZS fish, possible to come in and work 50-55 hours a week? Or should I expect 60+? Interested in firm & work but just can’t keep working from 9-10 every day anymore. Wondering if I should apply or just hang up the hat and go to industry

like

How many days does it take to hear back for a final round of interview from KPMG.

like

Hello,

I have cleared interview with Wipro a month ago and after 15 days I received a simple mail from HR saying you are selected.

Since that day, there is no communication from HR team of Wipro . I tired of sending multiple emails and when I tried to call he always declines my call.

Between director of respected technology is reaching me and he wants me to join ASAP and take over the project work.

What should I do now?

Thanks

It's appalling how bad new associate excel/ppt skills are. There needs to be a way of judging 'readiness' during the interview process.

like

I'm working in the US under H1B, I got a chance to face an interview for another company. My current company started the PERM application also and results will be out within the next 3 months. Is it okay to transfer my H1B to a new company? Can my H1B transfer be denied? How long will my green card application delay if I move to a new company and start to apply for a green card from scratch?

like
like

PwC Anyone went through a direct admit Partner process? I am being approached and have some questions (process, timeline, interviews experience, compensation etc.) Thank you!

like

Hello LTItes, i joined LTI a month back.
I attended a client interview last week and was selected for the same. Now they are asking to join within a day or two. I'm having my mom's surgery this week. How to safely refuse to join this client project for at least 10 days. I can't take leave for 10 days.
Can anyone please help me with this? I'm confused and scared.

Thanks

like

Anyone at A&M in the digital finance group care to share their experience before applying?
I am working in finance transformation at kpmg (formerly accounting advisory) and am very interested

like
like

Hey there, just got a mail from a recruiter at Bain to discuss a potential specialist consultant opportunity. Any tips on what the interview process might be like , indicative comp and WLB? I have 7 years experience in the releavnt field (Acc & Big 4) so will be joining laterally.
TIA

like

More Posts

Hey Fishes,
Anyone from Mass Mutual India / Legato Health Tech in backend development?

like

I feel like all of my friends who work in tech are very open about their starting salaries and the increases each year. I am going to work in public accounting and I feel like when I look up how much I will make after being promoted or early promoted it’s very cryptic. Can anyone tell me the standard salary % increase in PA after your first, second, third promotion?

like

Non target looking for MBB consulting. All feedback is appreciated. Thanks

Post Photo

Got two offers: PwC 68K, GT 70 plus 2K bonus. Which one should I take?

like

Other than providing insights and reporting, how does your analytics team help drive business KPIs, find new ways to look at audiences/businesses situation or have a huge impact on planning?

like

Anyone have a link or a list of companies that RIAs can use for VAs?

like

What grad school program(s) are you in? How much longer do you have? What do you hope to pursue once you've finished your degree?

like

Curious to see other producers’ opinions. How often should an agency producer ask for a raise? And what % raise seems reasonable in NYC if title isn’t changing?

like

Anyone looking for a HR Intern in the Detroit area? I would prefer a remote internship but I will do a in person internship

like

When should a stub start getting worried about not having much work and low billable hours?
I’ve asked for work but no luck. I know they say this is normal for a stub but when should I start getting worried and consider looking for exit options? Fyi, I like my practice group, so I don’t want to change to a different group within my firm, hence would have to lateral, if I have to. Also, other co-1st years are churning in high hours.

like

I gotta stop having sex dreams about partners.

funnylike

Any Navy Nukes in this bowl?

like

Can you ask your legal team to follow up with DOL regarding your PERM (9089) status, if dol website is showing that they are processing March 2021 and your case was filed on Feb 2021 ?

like

Hi , how the value momentum company would be??

like

Just received a verbal offer from KPMG in Atlanta for FDD as an experienced associate. 75k salary and 5k signing. Is this a reasonable offer? Should I try to negotiate for more? Given the crazy market i feel like 75k is kind of low. KPMG

like

Best interview tips?

Experience with keeping the account once your client gets acquired? Does the account get moved to the bigger company’s agency?

like
like

Let’s talk poverty in BigLaw! Do you think it exists?Have you heard of any stories that would indicate some partners in your law firm are living paycheck or paycheck? Years ago, we had an equity partner pass away, and their windowed spouse was seeking contributions for the kids’ college education, suggesting the partner hadn’t saved for college... Still haunts me to this day.

like

Additional Posts in Data & Analytics Consultants

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

How is Deloitte’s Analytics and Cognitive practice doing? Saw a couple of open Data Science roles open on their website, are they actively hiring

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

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

Single book recommendation for user research?

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

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

Mεntal mαth in iηtervieωs. Thoughts, tips, rants, grievances?

like

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

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

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

today I choose violence

Post Photo
funnylikesmartuplifting

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

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

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

Anyone have any tips or material on effective storytelling to leadership? I have to present an analysis and recommendation to a VP and really need to put together a good story. Thanks!

like

Is anyone working with Elastic at DoD?

What’s the best/simplest way to understand Sets vs Groups in tableau?

like
like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

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

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