How to prep (and what to expect) for an interview on Excel, SQL and R? I have a final round coming up which includes 30 minutes assessing my “technical skills” which the recruiter implied would be the skills listed on my resume (these 3 were also listed in the job description). FWIW I listed my R skills as “basic” since all I’ve ever done is a short online course, and for SQL I’m fairly comfortable with your standard queries (JOIN, WHERE, ORDER BY, etc.). This is for a strategy role.

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

Give me the lambda calculus on the following query:

SELECT * FROM * WHERE * = *;

😂

In all seriousness, prepare to talk a little about how you would optimize queries and make things SPROC friendly.

Post Photo
likefunny

Then yeah, you should be fine. Just make sure you know how to approach getting the data you need in an analysis friendly format.

Wing it and hope for the best

like

🤭

Some things I might ask.

Write fizz buzz in R.

What are your favorite r packages?

How do the apply functions work in R?

What is the difference between the where and having clause?

Define a left join, inner join, and full outer join.

But for strategy I’d be more worried about killing whatever case interview you might have.

Thank you very much!

like

Related Posts

Hi guys, I'm looking for role where I'd get an opportunity to work with Alteryx, Tableau/PowerBI. I have 2.6yrs of exp with 1yr of relevant experience.
Alteryx core certified.
Please reach out to me if you have any vacancy or referral.

Hi, I’m currently looking for a job as I was laid off during COVID. If anyone is hiring, please let me know!

like

Hi fishes, How will the below assessment in hexaware
DA_ Selenium_Java_Automation Testing_HTD_2021

It was scheduled for tomorrow.
My experience in 2.11 years in automation testing

like

Hi everyone! I’m currently open to a new role after working for 5 years at my agency. Most of my work at the agency has involved management, community engagement, data analysis, communications, and visual design.

I’m curious about trying something new, but feel a bit directionless. Any advice on what could potentially be of interest?

like

L&T Infotech is hiring Pan India for below roles: Interested people can drop their email id's and Names with respective Job Id's .

Post Photo
like

Hi Fishes,
Any one looking for a role as SCM Business consultant - Product management.

Min YOE: 3
Skill set: sql database (oracle prefered), versed knowledge in supply chain.

If any one intrested kindly dm your name and mail id with current role and experince. Will try to help on the possibilities

like

How reliable is the Gartner Career site where you can see the status of an application? 2 weeks after an interview, and I haven’t heard anything but the status still says In Process.

like

Manufactruing process improvements tips - for interview prep what all points one should say ?

like
like

Hi Amex peeps, how much time does it usually take to declare the results of 1st round of interview for lateral hires?

Thanks in advance 😊

like

3L with mostly A’s and B’s. I am having the worst luck trying to find work for after school and my experience working with lawyers has left me completely dejected. I cannot get an interview to save my life. I was so excited to get an externship summer after 2L with a small business and IP firm only to get yelled at on the phone a few times for not doing an assignment correctly. Mind you, I was working FOR FREE as it was a school connected externship. That made me never want to work in the law.

like

Waiting on offer from Deloitte for Cyber Digital Identity Manager - Microsoft Azure Active Directory
7 YOE
Present TC- 130k
What is the ideal salary ask for this position and joining bonus at Deloitte ?#it

like

Hello all!

I have my final interview which is a 1-hour presentation this week for an AE role. Any tips please? Thanks!

like

Hi fishers,

I'm a Programmer Analyst with over 2.8 years of experience in SAS and SQL.
My preferred location is Chennai/Bangalore.
Currently I'm looking for a job switch and it's kind of urgent.
Can someone please refer me if your company has any opening for SAS and SQL.

Thanks in advance..

like

Can anyone help me with the referral for a Area Manager (Gurgaon) JOB ID- 6154 at Swiggy?

like

Guys can someone help me with How to apply or interview procedure in Barclays . I am looking for python developer related roles in Pune. YOE - 3 at Bank of America

like

Does anyone have a tool/ site that calculates what the offer would need to be to leave a current role, all things considered? Of course, it’s anything more than you’re making now, but I’m looking for something that accounts for LTE, the hassle, risk, etc.

like

Hi, I have 2.5 years of Experience in big data.
How much can I expect for Azure data engineer role.
And do they consider current CTC or that's irrelevant?

More Posts

Hi I have offers on both gavs and broadridge on which gavs is giving me higher package. Which one should I choose

like

ACCENTURE is HIRING..!!!

Hello Fisher's,

Those who is looking for job change and have min 2.5 YOE and more then you can DM me for referral.

likehelpful

What do you think about Vice President who forgets what’s discussed in the last meeting and have to start the business story from the scratch again? Attending a meeting unprepared every time. I don’t know where he uses his brain for. So uninspiring.

likehelpful

Does Globant terminates the employment of certain trainees after their probation(3 Months) based on their performance in the training period? Some of the fresher trainees were laid off this morning without giving a notice or reason.

We were told that the probation period is a training period & not an elimination one. It was shocking as a few of those trainees were actually good.

like

Just raised my first snapshot.
We can't see the review?

like

Anyone else think big end of day drop? Scary weekend to hold long through

like

What is the slary range for level 25?

like

Hello All,
Is Atos better than Concentrix Catalyst ?

I am supposed to join Atos in July.

like

It's been 10 days i have not recvd any mail & neither my manger or supervisor told me to come to office!!

In TCS what is happening right now?

like

What are your thoughts about OMSCS course by Georgia Tech?

like

In my third year of real estate practice. Run the gamut between leasing, acquisitions and sales, financing and everything in between. Enjoy where I'm working but (continued in replies...

Entering my 2nd year as a medical malpractice (insurance) defense litigator. My billables are 2200 per year, even during WFH and COVID while the courts are moving very slowly. Any advice as to what I should look into for an exit? I can’t hit those billables while maintaining my sanity.

like

How do find a recruiter in the legal field? Have been looking for a job for a year now and trying to transition into another practice area. Applied to more than 20 jobs and still no offers. I feel like I might need some help.
Also, I have no idea how these arrangements work. Do you pay the recruiter to look for the jobs or do you pay them when you get the job? Or does the employer pay them?

like

Is it just me or with the rise of attacks on "essential workers", it's scary nowadays to work a public-facing job? I've seen so many videos of workers getting attacked for doing their job, some of them have even lost their lives.

like

Has anyone had experience working with their AD to help procure watches from brands the dealer doesn't carry?

like

general question, about how long after submitting an online application should one assume that they aren’t getting an interview?

like

I’m curious what YOUR proposed 60/40 schedule looks like? Have you been given a start date for this new schedule?

helpful

Hi DUSI fishes,
I am working from Hyderabad office and I’m not able to meet my finances and my parents are also old and hence they need me at home in Mumbai.
I joined D. 3 months back and wanted to know how can I change my office to Mumbai location.
How’s the procedure going to be?
If someone can help, it’ll be a great thing!
Please guys🙌🏻

like
like

Additional Posts in Consulting Exit Opportunities

Does studying for top consulting firms’ case interviews help in any way for interviews with other firms (e.g., FAANG case interviews) ?

like

After you got an offer (from Industry), if you are interested in another role, would it be ok to interview (but retain the offer) till you get a decision?

like

Should I be worried about exiting from a senior associate at kpmg to an associate in strategy in industry? They stated they are hiring associates based on 2 - 4 years experience and I have 2.5 years

like

4YOE @Amazon & trying to lateral to a similar role @FAANG. Have my undergrad GPA (3.8/4) on resume from top 15 school but colleague says to take it off (looks silly). If it’s a good school & high GPA, why ever take it off your resume? Even if 10 YOE...can’t hurt?

like

Felt that I had a great conversation but didn’t get the final round. Recruiter said that it was a tough decision and it might be that I should shoot for a higher level than the one I applied. Has this happened to you before?

like

Have been interviewing at cvs health. Any ideas how the marketing and analytics teams are?

like

I am not people person and having tough time as I am moving from 1 short project to other with no long term vision or goals . Every month new project new face and by the time I am settled , it’s time to move on . Have anyone had same experience and how do you deal with it

like

If you’re a software engineer at a tech company a half step below FANG, does it make sense to consider BCG Gamma? I was in Big4 before and am undecided whether I want to return to consulting long term. 2 YOE and recently exited but recruiters have been messaging me so thinking about 2-3 years down the road

like

How do the Consulting levels (1YOE > analyst, 2YOE > consultant) measure to industry levels (associate, manager, director)?

like

How bad is reneging a week before I start? Have an offer with FAANG but the role is sales. Got a dream job with Disney in Analytics & Strategy with comparable salary. Should I stick with FAANG?

Better manager & culture & benefits at FAANG, better role & opp at Disney

like

Senior Manager Retail at Apple anyone?
Wondering what a SM would do in retail, by exiting from consulting.
Got interview next week.

likehelpful

Bain & Company Moving to strategy consulting!
Looking for recommendations for how I can transition back to consulting and mainly MBB.

Background:
10 yoe with healthcare consulting with Strategy& in APAC, Middle East and Australia on varied health insurance consultations working as a director leading data science teams.

Feel like I am losing my MC mojo and want to get some years of experience in MBB McKinsey & Company, Bain & Company, Boston Consulting Group

Is there a way without cutting back on pay?

like

Any ZS 🐠 here willing to chat? I’m interested in a few positions and need help understanding the org structure.

like

Anyone know if any Tech/FAANG companies hiring in Sourcing and Supply Chain management roles?

like

Taking my shot in tech sales. Consulting was great experience but enjoyed the relationship and BD aspect more and didn’t see myself climbing to partner. Starting in a junior BD Rep role to learn prospecting and earn quota history. Took a big paycut for the potential future earnings as an Account Exec. Did I dun goof? Probably. But I’ll regret it forever if I didn’t take my chance now when I’m still single and young-ish.

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
like

Why do recruiters leave you on read until you tell them you have an offer then they start responding in 3 seconds 😂

likefunny

If you’re a QA Engineer with 3-5 yrs of strong Automation experience and experience with Selenium, Python, MySQL; and are looking for growth opportunities, please feel free to DM.

like

What are the best consulting firms to have a clear path to exit into big tech?

likefunny

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