I am a consultant trying to pivot career towards data analytics. Trying to apply for data related jobs recently and have been practicing SQL. Wondering if it matters if I practice in MySQL or SSMS? Have never done a tech interview before so I want to make sure I am prepping the right way

like
Share this 🔥 post

I’m interviewing for financial analyst roles at tech companies. I’ve used MySQL before and know some basic queries/statements such as create, select, join, where, like, etc. Any recommendations for SQL interview resources tailored for beginners or people that don’t have coding background?

like
Share this 🔥 post

Any advice on learning enough SQL in two weeks to pass a big tech Analytics role interview? Only know basic commands up to group by. Past roles I’ve only used Python exclusively and basic select queries to get data and have been doing horribly in SQL interviews which seem to be everywhere

like

Thoughts on Business Intelligence roles in industry? My experience has been a cross of management/strategy and analytics consulting (SQL/R/dashboard) at a T2. I have an interview at a social media company for a BI role, but I can’t decide if this would be a step backwards or position me poorly for an MBA. It seems like most of my future coworkers come from ex tech consulting, including body shops (ie Tata). I occasionally get interviews for Corp strategy/biz ops - better to hold out for those?

like

I desperately need to revisit and brush up my SQL and tableau skills. It’s for an interview and I don’t want to lose this opportunity. Can anyone please recommend any resources to learn and practice that would help me? I have some beginner level experience but haven’t had the opportunity to use or develop the skills for a while. Please help!

likehelpful
Share this 🔥 post

Doing a technical interview for a transactions group involving SQL and Power BI. I've brushed up on the two, but wondering if anyone has suggestions for practice cases or practical applications? Any sample cases would be very helpful, thank you in advance

like

Anyone know the best resources for practice SQL interview questions where you need to write the code? wife has a SQL technical interview with FAANG. thanks!

like

I have a big interview in an hr and half for a sql assessment. Which I spent the past week trying to learn sql. I am all nerves.

like

My sister got a second round of technical interview invite from e-bay for risk analytics. Does anyone know what the second technical round is going to be about? In the first technical round, she got questions on SQL.

What are some good SQL learning sites? Is it hard to learn before an interview? I have previous coding experience in python

like

Should I focus on developing skills (SQL, Agile certifications, etc) or keep on applying for jobs? I want to exit and do strategy. I’m nearing my two mark and coming from IT consulting and haven’t had the best interview luck lately :/

like

I have a Amazon DS interview lined up. Can anyone please suggest some good exercises to revise sql? I’m solving few leetcode problems,but is there a set of problems which covers all SQL functions? TIA

like

Does anyone have a site/resource they use for coding interview prep? Currently doing practice challenges to refresh my SQL on Hackerrank, but wondering if there's anything better.

like

Data Analytics interview on Tuesday. Comftorable using SQL to data capture/mine between different source systems, but feel weak when it comes to creating dashboards. Any tutorial recommendations?

like

Interview for a Data Analytics consultant role and have been told there will be white-boarding exercises. How would you prepare for this? I’m guessing it will mostly be SQL but don’t want to assume.

like

Quickest way to learn SQL for a FAANG interview? Know through joins, aggregations- but I’m a data sci consultant so 99% of my work is in Python. Interview requires CTEs and complex expressions

likehelpful

Love Accenture but my work blows. Dreamed of doing ML but now Im 3 years in (Digital consultant), same client doing 90% SQL. In final interview stages for a Data Scientist position at IBM. Thoughts?

likesmart

Just got a technical interview for a BI position at LinkedIn. Excel and SQL. Any advice? Types of questions? Etc. Any help would be much appreciated!

I have an on-site interview coming up. it's a business intelligence analyst position that requires advance SQL skills. how do I train myself in 10 days and crack the interview? my level is around 3/5.

like

Have a Facebook Data Science interview in a week. Any of you gone through the process - please share. They say it will be online SQL coding first.

like

Deloitte 🐠. How are the interviews at strategy and analytics, have one coming up in a month. Full day interview. Any prep & tips.

Good with python and SQL, have worked on creating data pipelines.

like

Anyone whose had a technical data analyst interview wanna share the difficulty of the SQL/Python questions?

like

Interview with Amazon for a Business Analyst position next week.
Will have a LiveCode technical round.
The requirements - SQL, Excel, Tableau
Any Advice?

like

MBB Folks, how to get a chance to interview, looking for data engineering roles. HR never replied on LinkedIn, I don’t know many at MBB.
Skilled in spark, good in python, okay at SQL and cloud.

like

How did you guys learn SQL or other analytics tools in order to be interview ready? My work hasn’t prepped me for it and most jobs require it

I know this isn’t the correct bowl but i figured there must be some individuals that can help. i have a sql interview coming up, what do you guys think i should know in particular.. also can cont...

Interviewing for FAANG job requiring some SQL experience. I have used it at work but in pretty basic ways, what would interview questions on it look like?

What are questions one can expect for a SQL interview? Position is for Sales Strategy and ops associate at Linkedin

like

SQL interview for FANNG? Anyone do that before?

like

A SQL interview coming up. Any resources or suggestions?

like

Struggling to get a good interview outside the big4’s. Interested in data (mostly SQL/relational database driven, but don’t know python or R) and product management. Any help fellow fish?

Just bombed a SQL interview with a startup. I'm never going to make it out of big D.....

like

Applying for an employee experience analytics role. Been out of touch with analytics and SQL for 4 years now but want to get back to analytics. Thoughts on what to prepare ? (Interview this Friday)

like

A SQL interview coming up. Any resources or suggestions? Please help! 😞

like

Hi….could someone please help me in preparing technical interview round require for a senior business analyst position..
what sort of advanced excel and advanced SQL i can expect…

like

Need Referral🙏

Just a week left to find a new job.🥲🥲
I was asked by my previous employer to look for a new opportunity in just 3 months after joining due to no projects. I was given 28 days to look for a job in which i tried my best, only got 2 interview calls but both HR ghosted me after clearing 1st round.

Skills - Data Science/ML, DL, NLP, Python,SQL, Aws and snowflake.
Yoe -2.5

Request anyone with relevant opportunities to please DM me.

like

Need Referral🙏

Just a week left to find a new job.🥲🥲
I was asked by my previous employer to look for a new opportunity in just 3 months after joining due to no projects. I was given 28 days to look for a job in which i tried my best, only got 2 interview calls but both HR ghosted me after clearing 1st round.

Skills - Data Science/ML, DL, NLP, Python,SQL, Aws and snowflake.
Yoe -2.5

Request anyone with relevant opportunities to please DM me.

like

Need Referral🙏

Just a week left to find a new job.🥲🥲
I was asked by my previous employer to look for a new opportunity in just 3 months after joining due to no projects. I was given 28 days to look for a job in which i tried my best, only got 2 interview calls but both HR ghosted me after clearing 1st round.

Skills - Data Science/ML, DL, NLP, Python,SQL, Aws and snowflake.
Yoe -2.5

Request anyone with relevant opportunities to please DM me.

Prefered location - Remote, Pune, Banglore.

like

I am working as Content Reviewer in Amazon, 1.4 years experience want to change stream to data analyst Skilled in Tableau, SQL.


I am applying to companies but not getting any interview calls? Please help. Any referrals?



Any mentors?

Tata Consultancy Accenture Infosys EY Cognizant

like

Hi fishes I’ve got an offer from Sapiens for the role Implementation engineer. Salary offered is 18lpa.
Currently I am working as Business Analyst and my experience in BA is 7 years and my salary is 9.3lpa.
Please advise if this is the technical role or a non technical role offered in Sapiens, however in the interview I was asked about SQL queries on Joins and DDL/DML statements.

likehelpful

Related Posts

Does pharma industry ask for references? I’m going through interviews at a few places. Fingers crossed, but what happens after I sign the offer? If references are needed, do people typically give their manager as a reference? Sorry for being naive, BCG is my first job.

like

anyone have any insight in Apple's work culture, workloads balance and benefits in genera? i'm in interviews with them right now + Twitter Apple

likeuplifting

Any advice for final round interviews for PE associate roles? Any unique questions you’ve seen? Any tips on how to standout?

like

Hey guys. I have a technical interview with AlixPartners restructuring and turnaround team. This is for their summer intern position. I didn’t come from a restructuring background. Does anyone have an idea of what might get asked in the interview? Is it going to be very restructuring specific or some general accounting/ finance/ operational sides of topics.

Is it acceptable to apply to multiple positions at large firms (ex. big 4)?
It feels like Im waiting a few months after applying to a position until I get a rejection. So would it be okay to apply to more than 1 position at a time instead of waiting?

Currently working at EY and recently promoted Senior looking to switch into a Business Transformation consulting role. Could anyone provide some insights on the day to day, as we as the interview process? Thank you very much.

Recruiter ghosting? My partner interviewed for a lateral position with a mid-sized firm in mid-December. Went through whole process, multiple interviews, etc. (see below)

like

does anyone have experience exiting after 1 year? any vengeful MD stories? my MD knows a lot of people and i’m scared if i interview or exit to one of these places that he has a connection at he might try to mess with my career...

like

In your experience, which companies had the most lax/conversational interviews?

like

Interviewed for dreamy job in dream city last week. Got a ton of buy signs from everyone I met with, especially CEO & CTO. HR said they would reach out early this week but I haven’t heard back yet

Interview tomorrow for a tax associate opening at RSM. Been working in a mid-size city (different firm) that is about 70 minutes from this new home office in a larger metro. How flexible is WFH or dual model going forward post Covid? Am interested in this position and going to tax, but not be able to relocate for family reasons. Don’t want to drive 700 miles per week M-F. What will dual model be like going forward? 1-2 times week, 4-5 month? Seems like tax was more flexible than audit pre-Covid

like

Interviewed for the 2023 Enterprise Strategy Senior Consultant role at IBM. Went through to the behavioral interview after the case and am waiting to hear back. Any idea how long it usually takes?

like

I’m applying for a job that requires a writing sample. I would like to submit a sample that was filed and used in a case. The problem is, all of the samples I can submit also include a partner in the signature block and were reviewed before filing. Any tips on writing a cover letter explaining that, aside from minor revisions by the partner, the writing is my own?

like

I was interviewed for Specialist Master role in Deloitte Oracle Practice. Can some one guide me what can be compensation range for this role. Planning to move from Minneapolis to Dallas

like

Interviewing at KPMG for a manager role in San Francisco. What salary range should I expect? It’s a drastic geography change from Big D where I’m at now

like

In the process of interviewing for a strategy/Corp dev position at an activewear/athleisure company and they want me to think of a couple tangential industries that may have companies for acquisition and do a write up. I’m stumped on what else an activewear company would buy besides other activewear companies. I can only think of home fitness (Lulu’s Mirror) or vitamins/supplements. Any thoughts?

like

I have an interview at a place in NY I’ve always wanted to work at. Any pointers or recommendations for how to prepare?

like

Recruiter shared post on-site feedback and she mentioned that she would like to do the team match and do 1-2 additional rounds of interviews because the feedbacks now are borderline and have a very low chance of HC. Any team here who's hiring SAP Program Manager role? Please kindly keep in contact with me :)

like

I’m working in a large fund; market neutral public market strategy funds; am about to be recommended for a promotion to associate. However, an analyst position just opened up internally in Credit, which is where I aspire to be for the next ten years. More growth and more intellectual challenge. I’m conflicted about applying for a lateral transfer and losing out on a promotion. Will I be missing out a promotion or should I negotiate a promotion as part of my application to this role ?

like

Big 4 Consulting interviews: do most people fail out of interviews at the behavioral interview part or the case interview part? Does anyone know statistics of job offers given once you make the casing portion of a Big 4 interview?

like

Additional Posts

Anyone here implemented NetSuite? I just did, but the impl. firm selected prior to my joining the team was awful. We’re looking at Phase 2 work now and I’d really like to switch consultants.

like

take job with long commute or stay at b4?

like

Partners, need some career advice. I'm in a niche BU at a big 4 focusing on risk related to certain cutting edge innovations in my industry (intentionally being vague). I'm being heavily recruited by a competitor firm to jump. I have just over 6 YOE, looking to promote in a little over a year (which would still be early at my current firm). To clarify, I'm not looking to leave, but will never say never. Firm looking to poach talks big game RE comp (potential to double my high 100s salary). Cont.

likehelpful

How much is the variable pay out for L9 employee if max of 27% is 450000, how much can we expect.

likehelpful

Heard that Accenture gave promotions to all in the name of Fastrack promotion tag in Dec 2021.. as the attrition rate is high currently.. is that true...?

likehelpful
like

Are y’all finding your white male bosses to be incompetent as hell or is just me? And they will milk you for all your brilliance and try to squeeze every ounce of labor out of you.

like

Any tips for someone trying to break into consulting in the GCC from the US? Applying blindly hasn't worked out. Head hunter recommendations would be great as well!

like

Hello! Will be receiving a $400 stipend from my new org for office setup. I currently have a 15” 2015 Pro, my husband has a Lenovo, I’ll be provided with a work laptop, we have a used office desk.

Any recommendations on what I should use the stipend for? Hubby was suggesting a printer because we don’t currently have one, but I feel like I don’t really print that much anymore and I’ll be working remotely.

like

Gripe in here about Legal Assistants (more in comments)

likehelpful

Any idea when the 2021 bonuses are getting paid out?

like

Fishes, how were the appraisals in general at Deutsche Bank for roles in Mumbai location? Understand that they got concluded only recently so it will be interesting to know. While it may vary from function to function but we will atleast got to know a ballpark figure. Also if you could add your designations, will be great.

like

Hi I am an Icwa with 15 years experience in accounts.i can do tally finalization tds and gst.I am looking for a job change

Who is looking for ADs? New York, Chicago or LA

I heard Deloitte won't apply Green Card till 2 years after joining. I'm 3 years from H1b max out. 2 years is too late for me. Any possibility to get an earlier start during offer negotiation?

like

anyone hear back about APMM program offers?

like

Need tips & encouragement for how you have gotten out of a slump in the past. I am 3.5 yrs in and have seen my practice growing (some quarters better than others ), but Q219 has been really tough.

like

Has anyone used Smart Asset for lead generation?

like

Anyone in the Houston area?

like

Anyone have any tips for how to heal a shoulder injury? Started working out pretty young and had bad form which probably lead to some long term injury in my right shoulder. Whenever I lift the pain is minimal at lower weights but brutal at higher weights. Also, any tips on how to properly warm up your shoulders would be greatly appreciated.

like
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