Have the first round of interview with hiring manager for Data Scientist role at Apple. Recruiter has mentioned general discussion and some live coding in SQL. Can someone guide for the preparation? What kind of SQL questions would be asked? What can I expect in the general discussion - behavioral or verbal technical? Apple

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

I'd recommend having a look at Glassdoor interview questions for Apple. There are probably a bunch of examples/helpful tips in there

like

Completely varies by the team and hiring manager. I would ask you simple joins/cte questions followed by window functions and data modeling

I’d also have you read a query, explain what it’s doing, and how to improve it

Thanks a lot!

Related Posts

We are hiring for the position of Sr SEO executive who handles all the operation of the overseas client. If anyone interested drop a comment.

like

Just became an ACD. Im in a limbo. Half of the time im being treated as a Super Senior AD and the other half im being treated as a Almost CD. Then when im scoped over work that my CD and I oversee, some people are asking me how does my role differ from the CD’s, as they tend to look at me as an unnecessary layer for approvals. In a way, i do the job so well that i get asked to do more AD projs and guide more projs — but then: wtf does my CD do? They mostly just 👍🏻what i direct n approve

likehelpful

Thoughts on KPMG Ignition?

like

Dear Fishes,

I am an MBA(HR) passout of 2021 and i have 1 year of experience in TCS as HRBP/Recruiter and recently i have joined EY GDS as consultant in June 2022. Currently EY is facing a lack in projects and i am not assigned to any.

It's a request to all if you can refer me to HR openings in areas of HRBP or recruitment, My notice period is 30 days and i am ready to join at the same package as of now.

like

Hi sharks, any hints on the VP salary at MS&C

Does anyone know salary estimates for an Associate role at Norwest Venture Partners?

like

Is equity research a possible exit opp from audit?

like

How long did it take you to find the right position the first time you went in-house? I am 5 months into it and regretting turning down the (lowball) offer I got a couple months ago.

like

One of my direct reports has asked about going part time. They currently manage special reports in a bi-weekly publication, working closely with sales, freelance writers, and an internal designer. Job duties are primarily project management and editing/proofreading. As the first read on articles, they need to have an understanding of the material (business/regulation). Has anyone had experience with job sharing in this type of a role?

Any BCG Platinion Cyber folks here?
What kinna work do you guys do? Planning to make the switch after 5 years with Uncle D. Wanna hear from you guys about culture, projects and areas of expertise.

like

Had an interview for an associate position at Citi. Interviewee was based in London and I’m in NYC. The only interview time that worked was 6am. I was barely functioning and feel like I truly messed up in my answers because I couldn’t not think clearly. I have another with the head of the division next week again at 6am (pre determined before this interview). It was also hard because the division’s core work is private enough that there was not much prep I could do beforehand. Tips?

Hi fiserv,
How is bench policy in mphasis. I have heard that if you are more than one month on bench, you will not get salary till you are not assigned with any project. Is it true.

like

Which firms have you been burned by in Charlotte in the past, whether in terms of experience working there, culture, interviews, or even as a buyer?

like

Looking for a referral at Dell. If anyone can help, pls comment or DM. Thanks in advance :)

like

Have you ever applied to a lower level position and convinced them to just give you the title you already have? Is it just a matter of salary and if they can afford you/your title?

Accenture India Hi I am looking for referral for Product management roles. Capgemini Amazon Amazon India Meesho Flipkart Lowe's Accenture India Accenture Cognizant

like

Hi, where or what types of companies should sophomores & juniors apply for next summer (2022) to recruit for IB the following summer (2023)? This summer BBs wrapped up SA IB recruitment, EBs even earlier, and a fair amount of my friends missed out big time.

Also, if a sophomore or junior doesn’t get a finance-related summer internship (I.e tech) and aims for an IB SA or FT position, is it harder to break in?

Appreciate any advice and insight, thank you.

like

Hi All, I am looking for job change and my Last working day is on 15th july. Let me know if any relevant openings for ETL/DWH testing in wipro. Experience: 3.7years .Location :Pune

like

Hi everyone

Being a self motivating person still feeling dejected it little demotivating.

Trying from all resources including Naukri ,LinkedIn,instahyre and many more ways includeind sending mail to the recruiters.
But not getting any desired role or company . Makes me feel disheartened,feels like will have to wait a very long to get something desired.

Total ex : 6.3 yr
Skill: functional,manual,API testing .
Notice period:30 days

Your generous suggestion n comment will help .

like

Any book recommendations for someone looking to get into a Product Owner / Manager role?

like

More Posts

My manager feeds me 100 chole bhature & then my tummy hurts so I ask her to give me a leave but then she declines my request and feeds me 1 more plate of chole bhature then I die because of excess gas formation inside my stomach, then I poop & become alive once again then my boss notices that im alive again and feeds me 109 plates of kadi chawal and this goes on and on and on and on

like

It’s my birthday today. Let’s have a party this week 🥳

like

Anyone stay at the W Costa Rica? Planning a trip to Costa Rica and trying to decide between that and the all inclusive Westin right next door.

like

Hi guys, i need referral for business strategy position in Microsoft. Microsoft . Please comment if you can provide me with referral. My DM is not enabled.

like

For those that have physical gold in their portfolio, what do you buy? What do you think is the best value? Coins? Bars? Other? And what weight increments do you usually buy?

like

Any veterans here still serving in the Reserve? Drill Hall is a new bowl here.

like

Hi Guys

Does anyone knows about Virtusa ? They are offering me considerably high offer compared to others but I am not sure as I don't know much about the company or anyone who works there ? Project is Legato Healthcare.

Any help will be appreciated.
Thanks in advance 🙏

YOE- 6
Skill - Dot Net Full Stack

like

What is the salary range for Senior developer with 5.5 yrs experience?

like
like

Want to know about TCS MLT program.
Can anyone guide where will get details and how to subscribe for this?
Also is there any advantage after completing this?

like

Working in Risk Management, looking into the FRM exams. Does anyone have any insight or advice?

like

From where to collect new joiner welcome kit in the office ? Any concerned team or floor where I can ask for this?

like

Any suggestions for good training courses for tech recruitment?

like

Has anyone attended HackerX events? I'm wondering how the experience was and if you felt you built a brand with good candidates.

like

Looking to pivot into managerial. Can someone take a look at my resume? Tips would be appreciated as well!

likehelpful

Any thoughts on living in the area around Madison and Morgan? Looking at an apartment there. That area seems pretty cool and not far from the heart of Fulton. Wanted to get other peoples opinions before moving forward with this place

like

I'm 10+ years experienced SAP ABAP consultant.

What should be my Designation in
1.TCS,
2.INFOSYS,
3.HCL,
4.ACCENTURE,
5.DELLOITE

like

Anyone working in Coimbatore IBM.. is there any openings for react developer's ?

Just received an offer with expected / standard salary for role but no signing or relocation bonus. They know I don’t have any other offers which is why I assume they didn’t offer any signing bonus - do I have any chance of getting one without “leverage”?

likehelpful
like

Additional Posts in Tech

Equifax What is the salary bracket for 6 years experience candidate at Equifax in Atlanta and also St Louis?

likefunny

Anyone at Meta willing to help with a referral. Found a req Im interested in and would greatly appreciate the help!

like

Any advice on moving from L4 to L5 in Amazon?

like

Hey everyone, I have my first interview coming for Project Management role at Meta. Any tips or recommendations? Does anyone know the layout of the interview?

likehelpful
like

Has anyone experienced non compete clauses? If I left a job after a week to work for a competitor, what happens? Is a week ok since I’m basically still being onboarded?

like

Hi everyone! I am working with my HR to improve our maternity/paternity leave policy. Currently I only get 2 weeks fully paid and then an additional 8-12 weeks at 60% pay (short term disability). I need some examples of companies with less than 100 employees and what your maternity/paternity policy is. Please include company name! Thanks!!!

like

Amazon or Wayfair?

Offers from both, same TC, and I’d be working in their Logistics Strategy teams (CGF/GSF).

Interested to hear Bowl thoughts.Amazon Wayfair

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

Apple laptop question: starting with Apple next week and just received their laptop, but it does not come with any pre-configured corporate credential. Is this normal that we have to set everything up from the scratch on day 1?

like

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

What have you found to be some of the keys to scaling succesfully, either in a business or a product or dept?

like

How easy is it to move from an investment bank firm to a tech company?

like

What’s the shortest amount of time it’s respectable to be in a job before leaving?

like

What can I be doing in my current entry level tech consulting job to make me a great candidate for promotions/raises or changing jobs in the next year or 2?

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.

Tinder vs Linkedin

Post Photo
likefunny

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

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