Hi! Getting ready to interview with EY and have a SQL coding assessment for first round. Anyone have any tips on how to study or prepare? The role is for the government and public sector data analytics team staff consultant position.

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

Hacker rank or similar. Never been through the EY interview but I have been through the fb one. Can't be that different.

like

Just focus on joins, unions and aggregate functions. Can’t imagine it’s more difficult than them. Hackerrank or leet code should help

like

What did you get? Any suggestions?

Related Posts

Hello all!

Any thoughts on interview process, compensation, culture etc. at ADQ in Abu Dhabi?

All feedback would be helpful!

Thanks :)

like

I’m thinking of applying to UnitedHealth Group as a senior accountant. The position is fully remote. Does any know what it’s like working for them? Also, does anyone know what the compensation looks like for this position in Arizona? Thank you.

like

Is Salesforce on a hiring freeze for all positions? I feel like I still see postings for openings going up?

like

Anyone need assistance hiring for Q4? Comment below and I’m happy to assist!

Anyone with Deloitte Risk and Financial advisory? I’m looking at a consultant role that might be a good fit, but I’m curious for examples of projects being done? Can DM you if it’s easier? Thank you!

like

Senior associate with 3 YOE at 130k TC (115 base). Final interview for a PM role at a small company coming up, is 140k base too much to ask for? The opportunity cost of leaving my connections, fast progression, brand recognition, etc makes it hard to justify leaving for less.

like

Late stage analyst 1 at a mid-market heavy TMT focused M&A boutique in London. Keen to increase exit opps and realise it may be worth trying to lateral to a BB / name brand. Any opinions / advice on achievability? If low, what’s the best move here.

like

Looking for a referral in Deloitte, I know the job id, Let me know if anyone can refer

like

Our client, a Manhattan pharmaceutical digital advertising agency is looking for a VP or SVP Brand Strategy.. Needs experience working on a brand with multiple indications in the oncology space (ideally) and be actively working on approx. $7 mil. of revenue.
1st. round of interviews will be internal. Candidate will be asked to present to the agency, then meet the client. On-going work will be remote. The salary range is $165 to $210++ negotiable
Contact us for job description
Stay Safe

like

I’m reviewing my resume getting ready to start my job search and have a question for recruiters, hiring managers. I’m looking for a role brand-side not agency side. Specialist roles aside, such as digital, when you see someone describing themselves as a “generalist marketer” is this a resume you’d pass on? My past roles have been such that I do a lot of marketing projects, tasks etc. but I’m not a specialist. I’m worried if I use this terminology I won’t even be considered for a role. Thank you

like

Asking for a friend:
My friend received two job offers for Account Executive roles: a Mid-Market role with Confluent and an Enterprise role with ThoughtSpot. He’s conflicted because Confluent is a more established company, ThoughtSpot is Pre-IPO. Confluent is a lucrative product to sell and has established SDR reps so there’s a good blend of inbound and outbound sales. Thoughtspot is more of a startup culture where most of the sales comes from outbound and it’s a tougher sell.

like

Hi Fishes,

I am trying to explore and obtain a career opportunity in UK or Europe. Could you all help me with how to go about it or any suggestion how to get an interview and move to UK for work.

like

Hello Team,

Please let me know how to remove CID from Accenture portal. I appiled in Accenture through a referral but now status is showing as " we don't have suitable position". Thanks

like

Any finance/Accounts manager job opening in chennai/Kanchipuram/Coimbatore?

like

Hi Folks. Switching from product base to service base at level 9 in accenture in SAP Domain .
Can some1 explain how the journey starts from day 1.
Heard Noise abt client interviews , bench process,layoffs etc etc.
Need Serious Comforting advise.

like

Hi Sharks,
Can anyone please refer me in Deloitte India pune ?
I have 12+ years experience in telecom domain.
Skills Unix , shell scripting, SQL,plsql, microservices , keycloak,apiman,kibana,redisrabbitmq installation and configuration, problem solver and good communication skills , project deliveries in agile methodologies and consumer interaction.
I am looking for senior business analyst or senior technical lead position.
Appreciate any help!!

like

Hi folks,

I have been offered a position on Senior Consultant/ Deputy Manager at Deloitte India for 4.5 years of exp.

Is this position/role normal for years of experience I hold?

like

What is the salary range for c12(avp) in Technical role (Java Backend)

like

I and two other workers were offered the same position at the same time. I was offered 23 an hour while the other was offered 24. Can I renegotiate?

like

6 months pregnant and just laid off. And 40% of my severance was just taken in taxes .. I just spoke with paid family leave and I no longer qualify even though I had been paying into the program (thanks NY).. I already applied for unemployment but doctors are telling me I’ve got 10-14 weeks left in this pregnancy.. so stressed having twins and being unemployed, no maternity leave, no paychecks coming in, and I’ve been applying but not a single interview.. just ugh. 😭

like

More Posts

de Blaiso says we’re on track to hit orange zone of restrictions post Thanksgiving which means no more indoor dining among other things.

The metric they are using is % positivity rate.

My question is this - is this a fair metric and if not what is a better metric to compare if it’s getting worse and we need social controls?

I only got tested when I traveled out of state for wedding and thought I was at a high(er) risk for exposure. Tested positive but I was already expecting that. (Contd)

like

Why does the right constantly want to push for hydroxychloroquine? There’s been zero significant evidence to support this treatment option. Is it just to offer some “good news?” Never seen politicians

like

Hot take: for better or for worse, the pro-Israel bipartisan consensus in the US is going to come to an end this decade. I don’t see how the next generation of the Democratic Party in any way is going to be so pro-Israel.

likesmart

I currently work in a Chief Internal Auditor role. I want to get a certification focused on IT audit both for knowledge, gaining credibility with my stakeholders in the IT audit space, and for when I look for a new role. I don’t have / won’t be able to get sufficient IT audit experience for the CISA designation at this stage. What designations, courses, or other options would you suggest?

like

For any real estate investors

22 years old and currently focused on using my left over income to invest and pay off my debt. I am set to pay off my college loans by next year and, when I do, I want to look into investing into real estate. Does anyone have any suggestions on how to get into/learn more about real estate investing? Or how I can have enough knowledge on the topic to be able to invest wisely when the time comes?

Any books? youtubers? etc. How did you all learn about it?

like

Just took FAR for the fourth time today 😂 LOTS of not for profit questions and even sims were not for profit!!!!! Definitely more than 5-15% Becker said!!! I got like 60% was based on NFP!

helpfullike

If promoted to senior associate through internal job move in Cognizant , then increment is done according to new role or old one?

like

Anyone able to refer @ Kearney Dubai pls? ~10 yrs strat consulting experience in Western Europe.

like

Hi, has anyone ever committed to a long time client but received a more enticing offer somewhere else and taken it? Curious to how to go about it without burning bridges.

like

Looking for Java, Springboot Developers. Kindly DM if you looking out for change if having experience in these Skill-set.

Location is not a constrainst as hiring PAN-INDIA.

Flexible work culture with Prominent WFH.

P.S: Currently hiring very aggressively, can offer better CTC as per the market standards.

like

Hello Team,

Please need 11 likes to chat directly with users. Please do the needful.

like

I am starting personal investment now- please tell me if this plan looks good:
- Already have a 401k plan with max matching form my employer
- invest in 5000$ in S&P ETF
- invest 5000$ each in AAPL, AMZN, GOOGL,MSFT
- invest 1000$ each in Netflix, ADP and Home Depot
- invest 500$ each in Intel, Nike,Walmart and T-Mobile
- small amounts 100-500 in Merck, GE, Coca Cola , Altria and Samsung.

Thoughts? I plan to invest a little bit each month (200$) in ETF. Any suggestions?

like

Any body aware about central excellence in cognizant?

What insights can you give me about working at Grey Lion Capital? Good/bad?

like

@Bain folks (London office) - What is the salary for Associate Consultant (Experienced Hire) after the recent hike. Is it same as AC (Graduate hire)?

I have 2.5 years of experience.

like

Anyone Hiring or willing to refer for a new role Within industry/strat consulting for TMT (Telco,Media and Tech)

Background : 8YOE (7 for TMT)
4 years in telco strategy (industry)
2.5 years Ex MBB
Currently at Boutique (TMT focus)

LOCATION: UK/London
Thanks!

like

Trap, trap money Jamie
JP got me in my feelings
Gotta close deals wit it

like

I moved from construction to coverage and I absolutely loathe the work. Is it unreasonable for me to want to enjoy the work I do?

helpfulfunny

Is 13 lpa fixed a good offer for 1.5 yoe ?

Also how can i negotiate when hr is not willing and I dont have counter offer?

like

Additional Posts in Data & Analytics Consultants

1) Hypothetically if you were looking to sabotage a colleague, can you code an excel document to throw off their numbers or calculations, (if you send them that document and they download it for use)?

like

Docket + R - I have an container running a rocker image and I’m trying to launch a bash terminal and the RStudio server (/init) at the same time. Is this possible? I tried adding CMD [“/init”] too.

like

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Have you ever failed to deliver? What was it and why?

like

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

Looking for an entry-level data analyst position in the DC area. Have a BA in economics & certification in Computer Science. Also 3 years of professional work experience as a full time marketing manager which I performed while attending school full time. I’m a self-starter and extremely driven. I also have a passion for data and statistics, and plan on pursuing my MS in data science within the next year. Please let me know if you know of any positions! Thank you.

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

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



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

Folks,

Any resume site / recommendations for an analytics focussed resume I could get some inspiration from?

Been on my job for 7+ years - a bit lost as to articulating my experience effectively. I have a resume, but don't think it strikes a chord with recruiters.

Please help!

like

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

Any BCG Gamma fish? Can you please share what kind of analytics projects do you guys do?

likehelpful

How’s EY’s hiring/interview process structured for data and analytics roles?

like

What do you folks think about a monthly show and tell of anything data-related?
Open forum where anything relating to data & its applications would be fair game. E.g.:

-a visualization you made and/or like
-data pipelines for a personal website
-market analysis
-relevant memes
-scientific article
-data news
-what you'd like to see data driven but isn't

In a nutshell, a conversational experience. Introduce and discuss ideas. BYOB and at least 1 talking point, or if you really want a full deck

likehelpfulupliftingsmart

What is Accenture’s data scientist interview process like?

like

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

Looking at a job in Kobo (Rakuten) for Data Analyst, any insights as in the technical portion of the interview ? Also, any recommendations regarding the company? Thank you!

like

Has anyone else begun to resent data science?

like

Anyone in a non-technical analytical consulting roll?

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

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