Can anyone comment on the Sql assessment for CARFAX

Just wondering if they are extremely hard

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

Comments don’t have any impact on the code you write. 🤣 🤣

funny

I appreciate this joke so much more now 😂😂😂🥺

Well everyone I passed.
60 percent 😭😭.
I have 1 more round of interviews

like

Can you please tell if it was a live or take home?

Not on that, but I'll give you my sql checks...

Can you tell what the difference between a inner, left, right, and outer join?
How can I accidentally turn an outer join into an inner join?
If I put rownumher() and partition over why is the sort order important and what is the full syntax for that?
How many rows are there
How many nulls are there
Concatenate these two cells (heads up, there is at least one null value in the mix and the specification is intentionally vague to force you to ask me a question. You still have to solve it
How is this table skewed and what can I do to fix it if it is
Stored procedures!
Write a subselect to do the following...
Let's convert these strings to numbers or ask you to do datetime arithmetic on strings

helpful

50% puts you squarely in analytics. Not all those are necessary skills for analytics.

A buddy of mine passes people for his Spark test (PySpark, SparkSQL, and Scala) at a 34%. An assessment that you can't or shouldn't be able to complete tells me what your skill level is.

like

Find fun ways to sharpen skills. SQL murder mystery or Sololearn are fun.

like

Was that a take home test or a live test?

Related Posts

Anyone had good multiple offers and had one the hiring managers pressure you into taking the offer after asking for additional time to think about it?

like

I was asked to submit documents for BA4 role. Id verification was done via MS TEAMS video call, when can I expect offer ?

like

Hi fishes,
How many days Accenture takes to declare results after technical round.
Will they inform even if we are not selected?
Thanks

like

I currently have a job interview for a position at bank as a client relationship consultant and I was wondering what kind of questions I’d be asked to answer and how to go about answering them.

like

where can i find free resume template , I have checked the outlook template but those are not impressive..any website, please advise ?

like

Bad idea to reneg on an internship offer for a better offer?

like

Have you used a resume writer? Was it worth it?

My SO is trying to jump from non-profit to corporate & has not found success with his current job app approach - he’d be a great candidate (obviously I’m biased) but it would take someone to take a chance on an applicant that doesn’t have a traditional background.

We started thinking a professional resume writer might have a better approach on how he should present himself in job searching

like

I was recently offered a Zoom interview. The school had 10 interview slots for me to choose from. Three were one day this week and the rest are next week. I chose the first time slot available. Should I have waited until one of the last slots so I was fresher on their mind when choosing a candidate? I am just sitting here stressing out until I here something. Also, do interviewers still appreciate a hand written thank you for the interview?

Hi I have 5+ yrs of bedside clinical research nurse experience and have been trying to pivot to the CRO world. I have applied to over 40+ positions and keep getting rejected. I have reformatted my resume to ATS but that doesn’t seem to be working either. Why is it so hard to get into the CRO industry and why is my hospital experience not translating? Thanks

If a senior partner referred me, and I still haven't heard back after 4 weeks, what could be the reason as to the delay? Am I not getting an interview?

like

After rejecting big companies like Infosys,Wipro, etc. I've joined EPAM Anywhere due to wfh permanently and it's perks. But after spending 1 and half month HR called me to search the opportunity outside of EPAM, means they're laying off people. It's unfair behaviour of the organisation. I've given some interviews they're playing interview interview with me, for the hiring process technical interview then for project - technical interview, client process - starts from 1st Round.EPAM Systems

likehelpful

Does anyone offer any resume writing services? Or willing to let me use theirs as a template? I have 6 years of CS experience & a Masters degree but I am having no luck with landing a CSM position within the 6figure range, it’s seems like these companies are not even looking at my resume. Any help would be greatly appreciated!

like

Hi all, for anyone that’s gone through associate level interview at McK, can you speak to the turnaround time for offer after final interview?

like

Hi everyone,
Past the first meet and greet-interview, now scheduled for the next one- any idea what to expect considering I am transitioning from a clinical focus role to a non clinical focus role as an Business Analyst.Any feedback will be highly appreciated.
With thanks!

like

Why do recruiters never tell you which agency they want to talk to you about until they get you on the phone? I don’t want to waste anyone’s time and it would be helpful to know this info from the initial outreach. My experience with this only applies to healthcare, but would imagine it’s the same in consumer as well. Anyone?

like

Huron case interview coming up...any tips or resources I can use to practice? Healthcare consulting associate role.

like

I finished final rounds 2 weeks ago and haven’t heard back. I followed up with the hiring manager and he said he hopes to give me an update within a week. Does this mean I’m rejected or they’re still interviewing other candidates?

like

SQL DBA INTERVIEW TIPS

* Nowadays interviews are more inclined towards

* Cloud knowledge AWS/AZURE (mostly on prem to cloud migration)
* Performance tuning
*Always On

More Posts

How valuable or important are scrum skills in the current market?

like

Hi All- I’m looking for a super simple time tracking platform to integrate with Asana for a team of 5. All we need it for is to see how much time is going into different projects that our department is managing. That’s it. No billing/invoicing/don’t care about time sheets, etc. We just need the ability to track and pull a report at the end of each month. Anyone have recommendations?

like

Anyone have any good contacts at ARC? I’ve been trying to get in with no response ( account management)

Can I take sick leave in my notice period in wipro?

like

Which one should i join
@Optum
@nagarro
@sapient
@ericsson

CTC is almost same and technology is java
Please help me in choosing.

like

What's everyone thoughts about whats happening in Nigeria? It seemed there was more condemnation with Geroge Floyd from other african leaders.

likefunny

Hi All.
I am looking for Salesforce Functional BA roles in Accenture. I am currently working with Persistent Systems. Please let me know if there are any relevant openings.

I am about to accept an offer with Deloitte Digital. Curious to see what the timeline for H1B transfer looks like. Has anyone been thru it recently and can give me an estimate.

like

No FSW draw what's happening!?

like

Anyone planning to go out this weekend?

like

Hello Folks,

What is the remuneration for a candidate who has around 10 years of experience in presales consulting and cybersecurity ? (Roles in India)

This query is specific to product based companies/OEMs ?

Thanks in advance for your insights.

Anyone working as Patient Recruitment Assistant?

like

I am relatively new to the world of good whiskeys and don’t know all that much! These were on allocation today at a NC ABC store, so I decided to grab ‘em. Anybody had these and have any thoughts?

Post Photo
like

5 year salary progression in Salesforce ecosystem, MCOL city.
2016 - $45,000 (non profit)
2017 - $65,000 (in house admin)
2018 - $80,000 (consultant)
2019 - $98,000 (Sr. Consultant)
2020 - $130,000 + 15% bonus (Sr. Consultant)
2021 -$175,000 + 12% bonus (delivery manager)

likeuplifting
like
like

Job offer for attorney position in Raleigh at USCIR. The offer is 65k and the hiring attorney indicated that 65 is the max. Has anyone had success negotiating higher salary or increased benefits (eg maternity leave, PTO, WFH, etc) - 3 years of experience in immigration law

like

Is there any interview after probation period?

like

Earnings for next week.

Post Photo
likehelpful

Additional Posts in Data & Analytics Consultants

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

When industries refer to business intelligence engineers, are they looking at a senior level or entry level? Some of these job descriptions seem rather outlandish in terms of years of experience required like 5+

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

How is Deloitte’s Analytics and Cognitive practice doing? Saw a couple of open Data Science roles open on their website, are they actively hiring

like

Has anyone else begun to resent data science?

like

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

Is there a good online course on storytelling with data? Something that can help structure your thought process and design choices when creating visualizations and Dashboards in Tableau, Power BI etc.

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

Have a lay-off meeting lined up, and now look for next opportunity. My background is around building machine learning models, data wrangling, visualization, feel confident with python. Open to any industry. Appreciate any lead on job opportunity. 3yrs of work experience

like

What biotech stocks are yall trading right now?

GILD, INO, MRNA

like

Meeting with a recruiter at one of the FAANG companies. I won’t be able to move jobs because of H1b /GC at least for the next year. Any idea if I should start off with that or should I just try to understand the work that they have been doing?

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

McKinsey & Company Does somebody have experience regarding
compensation differences between
QuantumBlack & McKinsey? I am in the process at
QB and disappointed with the salary that's
proposed. (New grad Data science from top
university applying for London) McKinsey & Company QuantumBlack

like

Anyone here work or has interviewed for a data science role at DataRobot? Would love to get some insight. Third interview coming up.

like

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

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