What sorts of SQL questions are typically asked in interview questions for senior data analysis jobs? Like is knowing SQL from freecodecamp enough or should I look into taking a course online?

I’ve unfortunately not gotten the chance to use SQL in my current position so I don’t feel like I have enough experience in it, but have experience in everything else (Python, tableau, storytelling, etc)

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

It depends on the company, but I've had a few that required a live coding demo - basically a leetcode/hackerrank SQL challenge that I had to do for the panel interview. If you want to practice, I'd say leetcode is good for interview prep.

like

Oooh this is really good to know. I was wondering this myself. I didn't know they ask for live coding demos. I will def need to practice this.

If you know what specific company you'll be interviewing with, Glassdoor "interviews" usually has intel on that sort of thing. Super helpful.

like

Agree with the suggestions above. I can’t imagine they would ask much more than joins, group by, and maybe nested queries and partition by. Other than that, most of your data analysis should be done outside of SQL, and you should tell them that 🙂

like

I'll add that for my last DA role I had some questions about stored procedures. I'm not sure if this is typically for a DA though - I thought it was more on the engineering side

like

Best case scenario is you get a take home assignment. For the most part most sql interviews are mid level so your joins, case when, percentages, etc. The hardest question I’ve had was utilizing a row clause in a windows function.

Also something to keep in mind is that you generally won’t be able to run any of your queries since they’ll usually just give you table names & fields but no actual data in the tables.

like

DA1 and A1, I’ll look into those. Thanks!

Related Posts

My friend had technical interview with Infosys How much salary Infosys will offer with 3.5 years of experience in DevOps Infosys for banglore location

like

Hi all i am working in azure data engineer stack i am actively looking for a job change.

But in infy it is 3 months notice period and my role is specialist programmer

i have 1.9 years of experience and getting almost 10LPA

No company is approaching due to that?

i coudnt put paper as well as i dont have any offer inhand?

Any suggestions how to overcome my issue?

like

Who here has been interviewed or hired by Amazon for a marketing role? A recruiter just reached out to me on LinkedIn and it sounds like it could be intense, but worthwhile for professional growth.

like

Are there really no H1B visa interview appointments available in Mumbai until January 2020?

What else can I negotiate for a Sr level TA role besides Salary? It's for a smaller tech company (not a startup), the role is always remote. Thanks in advance

like

What salary to expect from Microsoft for SDE 2 role (noida, 4.5 YOE)?

like

First time poster here!

After spending 4 years as a mid-level ops manager, I tried to break into HR through talent acquisition. Now after 6 years in TA, I've had a hard time getting out of it. My goal was always to get into a more broad HRBP position, but I've since worked for smaller orgs without a solid HR career path. When I ask about my career goals, they keep telling me, "Soon!" Or "Maybe in 6 months!"

I'm testing SPHR in June. Any advice for securing the type of role I'm aiming for?

like

I’m a bit self-conscious about what people think of me, and I feel like this is hindering my ability to act the way a manager should. It’s my first time in this type of role and I’m realizing I have some growth to do if I wanna keep the job.

like

Anyone know of an agent in Denver or the surrounding areas that may be hiring? I’ve been working with agents for the last 20 years. I have been with my current agent for 10 years. I haven’t had a raise since I started, and I currently run the office myself. The agent is never there. I’m making 20 an hours and I’m wondering if agents pay more?

like

Hi All, i had my 2rounds of interview with tcs on friday. Will they come back and hr send rejection email if there is budget issue or they will simply not send any communication.?

like

Hi fishes, can you please help out.i have an offer of these companies. Which one to join for growth and learning?

Bajaj finserv , SBIcard , Cognizant, Evaluserve, or EXL services
for data science position .

likeuplifting

Have a google strategy and ops interview. Any tips for the interview and prep? Usual questions? Would like to connect with folks who’ve done this! Thanks all!

like

I applied for a director role, and didn't get it. The agency came back with an offer for a manager role (and lower salary), with a verbal agreement that I would be working toward a promotion "in the next few months after I had been shown to be coachable".

If I take the offer, it's a true lateral move. The agency is a good one doing exciting work though.

Ahhh I have no idea what to do.

Does anyone have guidance?

like

Any Vets work in PE or IB and could help me out with a referral? I'm trying to get back into the PE space.

like

So I was asked to do a take home test in order to move on to a 2nd interview. I took a look at the test and it’s a lot. They give you up to 4 days to do it. I don’t know if I’m overthinking it, but man, it’s a full campaign with design to match. I know that’s the job, and wouldn’t have a problem if I was being paid, but I’m not. IDK.

like
like

Tata Consultancy TCS
Hi All,

I have given interview in TCS and 1st round cleared and in second round they took my id card screen shot with me after the interview .
Now what will be next thing .Not yet received any call.

like

Who's working in a consulting role at a product company? What kinds of products? Were you already an expert in the space before you got your current gig, or more learn on the fly coming from other roles/responsibilities?

like
like
like

More Posts

Hi All,

What is the onboarding process in FIS
global.Do they ask for background verification before joining or after joining?
FIS Global

How's variable pay in IBM? Will they pay 10 percent variable pay which is not mentioned in offer letter

like

Is the dress code in TCS the same even after the pandemic???

Are they going to cut some slack for business casuals every day???

Joined TCS recently and going to Siruseri campus. How is it there?

like

Sometimes when I’m putting together insights, I find that I don’t always have the answers...sometimes there are a lot of unknowns. Do you experience this? Do you find it discouraging?

What’s your guys’ take: will the US Supreme Court, even with a conservative majority, completely strike down abortion?

like

I’m trying to break into tech as a UX designer with 6 years in architecture design.

like

Can someone help me understand difference between old and new regime? Which one is better and why?
I have contacted CA but he is asking 10% of all saving that I'll receive... Seems heavy... Don't you aggree🤔

like

These interns in here on a Tuesday watching YouTube . I 👀 you .

like

Just got laid off. Came out of nowhere.
Now back to the hunt. Any CW roles in NY?

Considering an all ETF portfolio as follows, any thoughts? No real plans for the money, not needed short term. I’m 28 years old
US Broad mkt 60%
US bonds 10%
Int’l Equity 20%
REIT 10%

how BCG treats its internal staffs who support in developing and testing of the internal applications BCG Digital Ventures ? Are they offered opportunities to study further ? does they have opportunities to connect with the consultants ?

like

We are forming a group snap! Looking for a few more before we get started. Msg me if interested :)

like

Have diamond on Delta and need to take a personal coach flight on KLM. Any chance I can use Delta miles for an upgrade?

like

Need 11 likes for DM. TIA.

like

Pyr in a pool

Post Photo
likefunnyuplifting

Hi All,
I have got Offer from Publicis Sapient, CTC 14LPA, Permanent Remote work. However I have heard recently they are firing lots of resources , they are engaged in hire and fire policy.

Not sure how true is it !! So should I consider my other offers (Mindtree , CTS ) instead of Sapient ? Do they revise offer and match !! Please suggest.
Skill set - QA Automation

Hi all anyone working in Accenture operations analytics team...how is the projects scope....is it bpo job?Accenture

like

Best delivery services to do as a side hustle? Is food delivery always worth more than groceries?

like

Ladies — do you wash your hair everyday? I’ve been told it’s bad for you but I feel gross not washing it after every workout.

like
like

Additional Posts in Data Analytics & Data Science

Can people post their salaries and how many years of experience they have? Also are you in a HCOL area or LCOL?
I am making $73k with one year experience living in a medium to high COL area. I am not sure if I should try to negotiate more or if that is fair

like

I have been seeing all of these "studies" saying that many people prefer working in the office versus working from home... I'm doubting these results and want to conduct my own little poll.
Do you prefer:
A) Working from Home
B) Working from the Office
C) Hybrid

likesmart

Hello all,

I am a recent college grad that has been struggling to transition & find a good entry QA role. Does anyone know a remote entry level Quality Assurance Analyst or QA Specialist roles hiring? I live in Washington, DC so I can be on site as well. TIA and open to any advice or referrals as well!!

like

Does anyone here have experience building product analytics? I am the first product analyst in my team and I work with approximately 6 PMs. Any help is appreciated

like

Would like some opinions about how likely it is to make product analytics self serve by PMs? Anybody have success here? Or is it hopeless to think that product managers can pull their own data, look at their own dashboards, and do basic data tasks themselves?

like

Can someone refer me to a DS position at their company if they’re hiring? I’m looking for a DS role in tech. YOE: 5+, located in Canada.

like

I like to pursue in the data science field. I have business Analyst experience but to switch to data science field could you guide me on what should I learn? Where should I start?

like

Hi there,
I’m a bit newer to data science and recently read through a few academic case studies on ethical fairness in ML/modeling. Would love to start a thread to hear some more from data scientist/ML perspective.
The most harmful example I came across was bias in ML for the criminal justice system.

Is anyone currently in a data science/ML position willing to share their thoughts/maybe an example based on experience? Thinking about how to actively prevent this kind of bias in future models

like

I’m doing my first ever take home data analysis case study and they asked me to present it. For those who have done these before, how do you present your findings? Is a PowerPoint presentation common, or do you have a word document with the questions/answers and visuals?

Im using tableau to create a dashboard with my findings, should I just present with that?

like

Is standardizing or normalizing feature(s) for SARIMA(X) modeling necessary? I know it is for normal linear regression, but not 100% sure if it is for auto-regressive time series models. Interestingly, I'm having trouble finding anything online on the topic. TIA for the help!

like

Senior to Manager-level Data Scientists, what is the minimum set of skills and experience you require someone to have in order to train them to be a Data Scientist?

I have a handful of people from BI and Marketing who want to learn how to be a "Data Scientist" where some of them have stronger SQL knowledge and ability than others, but some of them have more exposure to languages like Python and R, and a little bit of machine learning exposure.

Appreciate the input in advance.

This bowl is crickets and I think we should make it much bigger. Anybody have any ideas how to get more people in his bowl?

like

How many folks here have gone from data science into ML? And how many folks here have gone from data science into product management, or want to? Would love to hear some views here about career paths for data science people.

like

Here is my go-to interview question, "What is the difference between data science and data analytics?"

What questions does everyone else include when interviewing or is the best question you've been asked in an interview?

like

I have worked with Forbes top companies, for-profits, non-profits, & startups. I consider myself a solver of complex & complicated problems requiring mixed method research & novel solutions. This has led to issues in self-referencing title. I’ve been project manager, data engineer, developer, modeler, analysts, principle DB developer, etc. Most of my w2 work has been from offers of 1099 clients so I am usually asked to define my own title. Any T-shaped data people who run into this?

like

What is the market like for entry level data scientists/ data analyst. I have a graduate certificate in data science and have spent the last 27 years as a mainframe dev so I have great SQL skills.

like