I have a SQL assessment to complete with Home Depot for a Senior Analyst position for Inventory Solutions department and a little nervous for it as I have not touched SQL in over a year and a half since my previous role. Does anyone happen to have any tips or insight on the assessment? What functions are commonly asked, etc. thanks in advance. Looking at YouTube and LinkedIn tutorials at the moment to freshen up.

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

I am interviewing soon for a senior analyst position, Can you please share your experience and also was there a case interview as part of the interview process?

like

Group by, coalesce, cast, proper key creation, create table, data types, converting tms, inner outer left joins

How did this go? I have this same one coming up soon.

Related Posts

Looking to help a first year attorney lateral to a firm in LA that specializes in L&E defense, or has a good practice team. Any recommendations on teams that have a hiring need?

like

Hi all! On 28thjuly, i completed my managerial round at Deloitte and HR responded that she will update by EOD or Friday. But i haven't received any call yet. Can anyone let me know how many days will it take for HR to call to update status of Managerial round?Deloitte

like

Hi! Anyone successfully use Zoom or Teams to record interviews that will get spliced with other footage? Any best practices or pitfalls to avoid?

like

Hello recruiters! How do you feel about people reaching out to you directly on LinkedIn?

I am a 15+ yr digital marketing/comms guy trying to be proactive about my next job without being weird. There are a few companies I would LOVE to work for and frankly just want to tell them.

I’ll post a draft note of what I was thinking in the comments so you get a sense of how I would approach this.

thanks in advance for any advice.

like

Dear Friends, I am looking for an IT Project Manager job. Let me know if you have any opening for this role. Work experience: I have 13years of experience in the IT industry.

Key Skills: Project Management, Customers and stakeholders management, worked on Cloud migration project, worked on new customer transition, Transitioning project to BAU,IT operations

Technical Skills : AWS, Azure, VMware, Windows Server 2012/2016/2019

like

Is it worth it to go back to school for a better track to a FAANG company? The division I’m currently in seems like there are no good opportunities, and I have the funds available to finish my undergraduate full time (Canada). I applied to Amazon before for a highly senior position and made it to final interview so I think I would have a better chance for a new grad type role.

like

Hello all,

I am trying to move product management role
My current experience is mechanical tender department with 3 years 4 months running . I am interested in Pm . I just want to what the pros and cons of product management
And without course can we apply with present technical experience

like

Any senior producer openings?

like

Cvent, Gurgaon - Opening Associate/ Senior Associate. Looking for candidates with SQL + Tableau 2-6 yrs experience. Interested ? Please share your resume

like
like

Can anyone refer me for java developer role 3.11 yrs exp

like

I had very positive feedback on my interviews for a S&O role but the team hired someone internally. If I interview again for a differenr role, would I have to do all the interviews again or can I use some of the scores from previous interviews. I understand doing RRK again makes sense but what about GCA, googlyness or leadership . Thank you

like

Hello Fishes,

Am a digital marketer with around 12+ years of experience well placed in an SMB. Haven't given any interview for past 5 years. Am now looking forward to my next level of career adventures. Anyone with an opportunity/referral/connection would be highly helpful.

Present designation: Head of marketing

☺🙏

like

Has anyone had successful using the c0ff3e thing on LinkedIn? Landed interviews/gigs?

like

Hello Sharks,

I had my first round of technical interview in
Barclays on 9th June. I have not yet heard from the HR and the status on the portal "Interview Process". How much time do they generally take to reply back? IBM Barclays Deloitte Tata Consultancy

like

Hey Guys,Can anyone who is a Data Engineer and working with Big Tech Companies share some light on how you guys are preparing for interviews?How are you learning so fast/so much?Can you please share some plan or guide me on what resources you are following?There are too many things. And in my current organization I am not able to learn those.I want to learn fast and more.I see profiles on LinkedIn that are filled with big data techstack.Please guide. Adobe Amazon Walmart Expedia, Inc. American E

like

For those looking to get into tax technology at Deloitte, let me know. I’ll take a look at your resume and see if it’s a good fit!

like

During my job search, I am getting a lot of recruiters asking for me to answer right to represent emails. These particular recruiters follow a same pattern and seem unprofessional. Shall I be aware and not sign these right to represents? Are they a scam? Or is it a cultural thing… can someone advise me, I’m based in the USA

like

I Am yet to get offer for Full Stack Position as Senior one, having 7+ years of experience can I know whats the company benefits and the benefits.

like

More Posts

When does the recruitment cycle for the top20 firms end? I applied to many, heard back from one(which i later got rejected for). Do i still have a chance of hearing back?

like

Anyone was an account rep/ account executive at Uber? Or know anyone who was? I’m thinking of applying to have Uber on my resume, but don’t know what they do.

like

One of the team member has applied leaves for continuous 3 days this month. Later she applied for a 15 days leave saying a medical emergency. Both the leaves were rejected from her manager saying connect with HR. though she is on leave without PM leave approval and this is not even prior notice to the team.
Now'what and all would be the consequences she might face. Is there any chance of these things are being escalated? Please advise!

like

Have any of you enrolled in or completed the Penn MCIT program and be willing to chat about your experience?

like

Strongest FS DD practices?

PwC question: Is there any small wiggle room (+/- 5 - 10k) in the cohort pay band you're assigned to or is it dead set on a number? Fully understand between cities and non/MBA the numbers are different

like

Chicago what's app group has been created. Dm me name and number if you want to be added!

like

Fiancé’s milestone birthday coming up. We both love experiences and enjoy the city. Welcome all the help to make it special for her!

like

Is it wise decision to stay in cts if pkg matched. Not so sure. Have offer from other service based. What diff it will create comapred to cts all service based are same.

like

So I had been working as medical interpreter up to the early part of this year. Today, during an interview, the Director with whom I was interviewing genuinely urged me to consider pursuing a career as a PA or even attempt to go to medical school. I had considered it in passing before but today was about the third or fourth time that someone had earnestly nudged me in that direction. Has anyone here made such a career pivot before? I love working in healthcare, there’s nothing like it.

like

Need your to unlock DM
Pls like my post

like

Hi , I'm 9 YOE, working as technical test lead on banking products and platforms.

Skills: Unix, SQL, shell scripting, ETL (Abinito), API's.

Please like and comment if there are any opportunities that I can apply for.

like

FAANG salaries and tc on Glassdoor seem way too low? Thoughts?

How can I get resignation acceptance mail stating my lwd from HR? I got acknowledgement mail though but I need resignation acceptance mail to show to the new company

like

What is the most funny “what do people think you do” meme for management consulting that you’ve seen?
I’ll start with mine

Post Photo
likefunny

What should be the salary package for senior research analyst from a Gurgaon based company

like

Parents- do you have UTMA/UGMA accounts for your children? Pros/cons over 529?

like

looking for a Salesforce developer job role. i have overall 2.5 years of experience and 1.5 years in Salesforce development experience.

like

So I know it's kinda late in the game but are there still summer internship openings for someone who is a sophomore in college with computer science major? Asking for my brother. He is studying Java and Python.

I am planning to apply for PM and TPM roles at Amazon. Is there a slowdown in hiring or hiring freeze in place for these roles

likehelpful

Additional Posts in Interview Tips

What kind of questions should I except in an interview for an e-commerce role at a beverage company? Would really appreciate any advice, currently work in sales

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?

I am interviewing for nCino as a entry level Support Engineer. They ask for 2 years experience in the financial services industry and knowledge of Salesforce. I have over 1 year experience in the financial industry and 2 years working with Salesforce. I live in Louisiana and it's Remote. What salary should I be aiming for? Total compensation also if you can! What do other Support Engineer get paid

like

I’m shooting for the moon and applying to jobs I am mentally ready for and can qualify for but my resume is very short sweet and to the point because I’ve worked at the same place for 6 year and climbed the ladder & wanting something new. How do I explain that to my future employer?

like

Is it a red flag when a recruiter talks about unrealistic benefits like getting a chance to fly to another state just to visit the client HQ all expense-free? Or is it really a thing? Let me know if you have experience like this.

like

I hope I don't sound foolish, but I was asked to "please attach a CV?" What is that?

like

Hello everyone. I’m currently interviewing with Oracle for a program director role and I’m nervous. Any tips or pointers you guys can help me with to secure this role would be certainly appreciated.

Thank you Oracle

like

Hello. I have a job interview coming up. When asked the question by the interviewer, “Why do you want to leave your current employer for us?” What is the best answer?

like

I need some insight. Just had a phone interview for a management job in healthcare. I felt comfortable and felt like the interview went well. I ask questions and the ACNO said that I asked great questions. They said that they had other interviews to do as well but said the next step is to bring me in for an on-site interview (I live 1,000 miles away) and that the recruiter would be reaching out. Thoughts? I’m going to drive myself crazy analyzing everything.

like

I am a regional controller for a hospitality group. I began looking for a job in a different industry, but have hit some roadblocks with trying to communicate transferable skills and management style (decentralized). Any recommendations?

like

Got a job offer with a lower base salary but a guaranteed bonus structure that puts me ahead of my current pay at the end of each year. Has anyone moved to a position with a compensation structure like this? Was it hard to adjust when it came to your monthly finances?

like

Me: 4.5 years in audit, Big 4, interviewed and accepted an offer in industry. You can let me know if your background differs and I can help tailor my responses to you.

like

On average how long have folks found the job search take in this market? I’m interested in project management roles and have 7yrs of PM a experience.. getting discouraged, sigh !

like

What are some questions you always ask during your interview? I feel like I need to be asking more.

like

Got offer and accepted but other firm that I applied ask for additional interview. Please advisd how to tell them "no" nicely ?

like

Does anyone have question suggestions for a final interview with skip level boss? Big picture, vision for the role + team, growth strategy type questions! Thanks :)

like

Hi everyone. I applied for a couple of roles at a tech company, I have a panel interview coming up but since that’s been arranged another HR coordinator has reached out to do a screening interview for the 2nd role I applied for.

How do I approach this, the screening call is a couple of days before my panel interview?

like

How does a panel interview feel like? Is there anything that I should be prepare for it? Any tips?

like

I was just informed after the third round of interviews they’d like at least 5 references, two must be supervisors. My last job was a temporary remote job where I didn’t really interact with my supervisor and the jobs before that were at my family’s business (I do not speak to any of them for serious personal reasons.) Anything before that was grad school and I haven’t kept in contact with any professors from over five years ago. What should I do? 😕

like

Anyone here interviewed at or work for Nice? Would like to hear your thoughts/experience. Thanks in advance!

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