Could someone tell me what type of SQL assessment will be in TIGER ANALYTICS?

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

Importantly, you might have to write your queries in a text editor, and you cannot run and verify them. Will be easy if you know rank, dense_rank, row_number, and joins.

Like Accenture1 pointed out, understand the question completely. I missed a small thing in one of my answers, and it was pointed out during the final director round when I noticed it. He then asked me what problem would occur and what could be done to correct it. Barring such careless mistakes, the test should be easy.

like

True

It would be best to look up on joins, indexes, views

like

Thank you

like

They were easy questions

Doing inner joins, aggregate functions, dense_rank


Some easy queries, listen the questions properly

like

Thank you

Related Posts

like

I’ve been with my company for 4 years and I’m thinking about applying for a new job. For references, I would like to use my coworkers but I also don’t want to bring up the fact that I’m applying to other places. How should I handle my references when it comes to applying or interviewing with other companies?

like

Does Exl Pvt Ltd provides its shares to employees or do they have any ESOP program where an employee can invest at discounted price? Exl consulting EXL Service

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

Hello,

I just joined
IQVIA, wanted to know how much variable is paid and when? Joined in FEB month. IQVIA

like

Looking through big 4 transparency salaries… does Baker Tilly just have awful pay for tax or is it just too small of a sample? Why do they pay 10-25% lower than all other firms?

Can anybody speak to how much they pay tax managers MCOL?

like

Deloitte audit Vs. Grant Thornton Tax. I have an offer from Grant Thornton and From Deloitte as an Intern this summer. Deloitte is the bigger name and pays a bit better but Grant Thronton has way nicer people and known to have a way better cultre and work environment. What should I do? Where should I go?Deloitte Grant Thornton

like

What do folks here think of working at Vanguard?

like

What will the effect of EY split on employees? Will there be any growth impacts or change in pay scales or anything like that?EY

like

PwC Anyone went through a direct admit Partner process? I am being approached and have some questions (process, timeline, interviews experience, compensation etc.) Thank you!

like

Hi Fishes,
Any news of hikes in OSSI?

like

Hi Folks
How many rounds of interview conducted at Oracle for SeniorSystem Administrator position?
I have cleared first round . But they are telling there are other rounds too. I am curious please clarify if anyone from Oracle or recently joined .

like

Hi guys, want to know how is the work policy in IBM as of now?
I mean is it work from home of hybrid? Also, do they force you to come to office?
IBM

like

Hi All,

I have 2 offer please suggest which 1 to go with.
1. CTS 9 ( 8.55 Fixed 45k Variable)- Tech Lead
2. Vodafone 9 same as CTS they matched plus JB-50K - Band I
Exp 3.9
Skills: Oracle DBA
Your inputs will be highly appreciated to choose best comparing WLB and Job Security.

likeuplifting

What’s the work-life balance at Strategy& and EY-Parthenon in the London offices? At the moment I’m averaging around 50-55 hours at my boutique - higher or lower?

like

When will google hiring resume?

like

Larsen & Toubro Infotech Is the lti Noida location up? Any idea anyoneLarsen & Toubro Infotech

like

Hi Fishes,

What percentage hike can I negotiate in the HR round of Accenture if I have a second offer of 17 lacs (CTC) in hand and a relevant experience of 2 years?

Inputs from people who are working or have worked in Accenture would be really appreciated. 🙂

Anyone in a remote equity research or asset management role that they found as a result of working with a recruiter?

If so, what company did you work with?

Does anyone recommend a particular recruitment agency? The local ones by me are not great, I do not want to move though.

like

At what level/years of experience do you become competitive for recruiters to reach out to you?

like

More Posts

Hello folks,
I'm looking to get any references for SAS technical role. I have 10+years of experience in Banking industries. Have worked various roles from SAS Programmer, senior programmer, SAS SME, SAS Senior Consultant, Credit Risk analyst, Fraud monitoring, Data analyst, etc. with multiple SAS tools a banking, capital market, investment, credit risk domain. Please let me know if anyone can refer me for any SAS related opportunities.

like

Anyone from PwC SDC. /AC?
Need referral for Data Scientist or Machine Learning roles.

like

Any company is hiring EU citizens and helping with visa? interested in moving to USA. I'm lawyer, cissp, cisa, cipp/e and specialized n data privacy, cybersec ops and risk management with 8+ years exp

Hey everyone! I’m looking to move out to London, I lost my projects due to COVID and if anyone could help me out with a referral in the UK or Europe I’d be very grateful! I can offer a good wine and dine in exchange! 🍾🍱

like

Hyperbolic, yes, but it got a chuckle out of me nevertheless

Post Photo
likefunny

When are august raises / bonuses / promos typically communicated at bdo?

like

How is Atos as per wlb, projects, management. What is the role of GCM4 level and C/S band.
Please help me here, thnx

EY -TAS , S&O . We are hiring. If interested, reach out...

likehelpfulfunny

Accenture Corporate Development team is it a good place or no? I havent hear anything about it

like
likeupliftinghelpful

How is work life balance at Deloitte India?

Hello Fishes,
I am currently interviewing at EY GDS and HR discussion is done.
But the HR is saying they can offer only 36% hike.
YOE: 6
CCTC : 12 LPA fixed.

How should I proceed with this.

like

I'm planning to do my PGDM in Canada
Which College/Universities should I consider to get recruited into top consulting firms (Also the preferred courses) ?

like

Hello folks,
I'm actively looking for a job in the "content marketing/internal communications/marketing communications" space in Pune. I have 17+ years of overall experience. Are you aware of any opportunities? Please do let me know. Thank you.

like

9 years at the firm, 3 as a manager and I just broke $100k in the Northeast region. Maybe it's time to explore my options.

like

Is it wrong to work low budget favors from the small local production/post shop and never give them a chance at a regular budget job?

Curious to hear how others create a SOW for a video where the concept isn’t created yet. e.g. a startup asks for a proposal/estimate for a 60-second brand video with little input and a vague budget range. We’ll create the concept and produce it. My Co. seems to have challenges with getting the SOW right: either goes very basic or doesn’t scope enough because creative development is baked in but eats up time. How do you do it?

like

How do some agencies take all the awards yearly while others get severely shafted?

like

Has anyone lived in the Louis, 880P, Sonnet, or Âme apartment buildings? Moving from Arlington to DC and want to maintain the amenities I have now but can’t tour in-person. 2 bedroom, if that matters

like

Do you ever think that this is a futile process?

like

Additional Posts in Consulting India

Hello Fishes.

How is prodigitalworx company to work with !!??
It's a Blore based IT firm..

like

Need a guidance here, my LWD in accenture is in May. But they are ready to give me the chargeability only till March end. They are saying they need to relieve me early in this case. And my joining in the new company is on 25th may. What should I do in such case? I cannot afford to lose 2 month salary.

like

Hey Guys ,

How is Connectwise in terms of work culture and wlb ? I’m in a process of getting an offer

like

I have 2 offers in hand from company A and conpany B. I have made my decision to join company A. But want to keep the offer of company B as a backup. Incase anything goes wrong with company A.

I am completing all the joining formalities of company A and company B too.

When should I say no to company B? On last working day or once I receive laptop from company A?

Company B is calling me regularly just to check if I will be joining them. Please advise.

like

Pg in Chennai how to find. Im moving first time from Delhi

Would like temporary 1 month stay in single occupancy, meanwhile i can search for apartment

like

Do companies benefit from hiring sap certified employees? I mean how do companies utilise these certifications?

like

I have cleared my first round of CTS this monday. 1. When can I expect the call of the cts HR....
2. What should be my CTC demand to CTS?
YOE 16.5 year present CTC :27 lakh skill.set: Oracles epbca and fccs...

like

Can I get 12 likes?
Thanks in advance:)

like

How many days did it take for you to get your Australian work visa?

like

Anyone from Fractal?
I recently joined Fractal, wanted to know the avg increment % which I can expect?

Hi Everyone, Received an offer from CapgeminiCapgemini

YOE:7.4 years
Technology: Product Testing
Role offered: senior consultant/C1
Package offered: 18LPA(including Variable)

Is the given offer is good as per organisation standards/market Standards?

like

PwC Deloitte EY Accenture KPMG

Post Photo
funnylikeuplifting

Any one here from optum Hyderabad, Looking to get a referral for operations manager role.

like

How many days IBM will take to match my counter offer?

like

Infosys Tata Consultancy Accenture
Given below two options
Senior Consultant - cloud in a UK based company on Skilled Worker VISA
Technology Manager in Infosys Australia holding Australian PR.

Which one would you choose ?

like

Kisi ke pass Adidas se offer aaya kya..???

Mujhe kuch urgent poochna tha… pls comment

like

I recently join a new firm Its been 2 days,
Manager has still not called me.

What should I do should I do? Shall I call him o/w if I don't they he/she might scold me for not being proactive.

Please advice.

funny

Looking for tips to redesign my CV it is of 3 pages want to make it to 2 page to apply for product based companies, can someone share some format which could be helpful.
Yoe - 5 years tech-salesforce
TIA.

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