I have second round at Eli Lilly tomorrow, not sure what it could be.

First round was on project understanding, technical related questions on SQL and logical reasoning and some basics of work culture of Eli Lilly. First round went very well.

Anybody has any idea what will be second round ? It is for Associate Consultant role for Omni channel department as per JD.

My total YOE is 3.5 as Business Analyst.

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

If you have any other offer, take that up.. Better to avoid Eli Lilly!

like

Hey what type of questions were asked in sql???

like

*Eli Lilly round 2* :

(SQL case study screensharing) :


Table : Customer details
Columns : Customerid, customername , contact, address, state


Table : Sales

Customerid, product , month, sales



1) Find the customer details who stays in New York state
2) Find the monthly wise sales
3) Find the customer details who didn't buy anything in January ( sales excluding Jan )
4) Find the customer details whenever the sales is greater than 30k
5) Find the products which only sold in month of January along with its sales column.



Difficulty level : Easy

likehelpful

How much CTC they are offering? approx no. will also work

like

I asked for 17LPA fixed, CCTC is 11

How your 2nd round went, Any other rounds? Was it an Assessment Test or 1 on 1?

like

It's sql case study which I already posted above , it's an assessment

like

Hey what were the questions asked in the second round? I have interview tomorrow for the same role and is there any further round after this?

How long it took for you to hear back from Hr after 1st round?

Related Posts

How did you find your job? LinkedIn? Employee referral?

Should I stay at Morgan Stanley or go for Walmart at 20% hike ?

Got few questions regarding LTI and business analyst role. 1:Does anyone have any idea how many rounds are normally conducted for LTI business analyst interview. 2.How how many days they take normally to release offer. 3. How much should i expect /ask for 4.8 yoe for business analyst role.

like

Hi Guys,

I've received offer for the position of Data engineer from Fractal, Gartner and Dunnhumby.
Fractal - 13.5 LPA
Dunnhumby - 15 LPA
Gartner - 15 LPA
Any suggestions on which company should I join ?

like
like

8 YOE in Ariba and sap mm. What’s the average pay for scon in ariba team at pwc.

like

Does anyone know is aware how much time Globant takes to release offer letter after finishing all the interview rounds?

HI Fishes, Anyone in Infosys working in client location ( Bfsi ) what clients to Infosys has in Gurgaon location. Any idea Infosys

like
like

How much % hike should I ask in Hexaware as a 4+ year experience in data scientist and 7 years of experience overall

like

Does project have any role to play in the hike % in Cognizant ? As in if my engagement is doing well financially for the organization will I get a better hike than others with the same rating as me but in other engagements that are not doing so well. I am in Cognizant Consulting.

like

Any pointers on ISMS implementation and GRC interview questions please.

Hi Fishes,
I recently joined EY-GDS but there was an ongoing interview process with my dream organization Microsoft.Thankfully I cracked that!
But now the problem is as I have already joined here , and resign and serve the 1 month notice and do everything legal, will there be chance to get blacklisted here in EY-GDS?

like

Does anyone have any insights into what work at stack adapt is like?
And the general salary ranges there?

like

Hello Fishes..need your advice. EY Technology Consulting or Infosys BPM Consilting. Infosys is paying 2 lacs higher. Need ypur advice keeping long term prospects

like

What would be a better choice bw Flipkart and Intuit if package is mostly same. I am asking in terms of work culture, project and growth opportunities

More Posts

Should I do the PMC at the Product school? Does it help when transitioning to product?

like

Hi Fishes,

I am thinking to diverting my career towards freelancing in accounting.
For that I have to resign from my current job in Pwc. I am thinking of starting a job as accountant and work as a freelancer as part-time.

Any thoughts or advice?

How is the Work Life Balance and growth in Axtria? Is it a good place to stay for a slightly long period( like 4-5 years)?

like

Hi fellow nurses! I am an Emergency Nurse with 3 years of nursing experience to include med -surg. I am looking to transition to a lower acuity position such as pre op, or honestly work remote as the work life balance is not fulfilling for me. Any recommendations on hospital jobs that are less stressful or any companies that offer competitive pay to work remote? I make 38/hr currently and would like to maintain that rate. Thank you!

like

New in San Diego and want to explore the city? Me too 😂 comment bellow. I’ll send a message 🙌

like

Can we buy out notice period in Infosys

Need 11 likes to unlock DM

Thanks 🙏

like

Am looking at exit opportunities and researching FAANG. Curious to understand why anyone would join Amazon which has the worst benefit of the FAANG? Can anyone share what’s better at Amazon that I am not aware of? Amazon and Facebook on sites lined up in January! So researching now!;)

like

Amazonians: is Amazon corporate totally freaking out about that center in Staten Island that unionized? Unions could kill Amazon.

likefunny
like

What does a 30% travel requirement mean in a job description? How often do they expect the candidate to travel ?

like

any suggestions for a clinical specialist of 7 years of exp in acute care to increase salary? or How should one have this discussion with ones director?

9/7: What are everyone’s plans for today?

For me- treadmill, chest and shoulders.

likeuplifting

Can some from Optum help me to fill self evaluation for common review. Iam new to Optum and not getting what to fill. If anyone shares what they filled , would do a copy paste.😂 Thanks Optum Tata Consultancy Deloitte

funnylike

Hi everyone can someone help me with how is the Work from office model being followed at optum..Are they allowing work from home also?

like

Hi Fishes,

I am a QA engineer in an edutech company. I have an experience of 7.5 years (manual testing- database, front end, mobile and api testing).

I want to move to a BA role. I have good communication skills and an analytical mind. Below are 3 of my biggest questions.

1. Is it too late to switch to a BA role?
2. What are the skills,tools or certifications required?
3. How should I approach a job opening, given that I have no work experience as a BA.

Pls do pitch in your thoughts

Hi fishes

What do we get as a diwali gift in Gartner? Do we have a Diwali Party?

like

Anyone looking for case partners for casing practice .Just to let you know I know basics of casing and their types but not much experience .Would like to partner with similar or experienced folks

like
like

One of the team member has applied leaves for continuous 3 days this month. Later she applied for a 15 days leave saying a medical emergency. Both the leaves were rejected from her manager saying connect with HR. though she is on leave without PM leave approval and this is not even prior notice to the team.
Now'what and all would be the consequences she might face. Is there any chance of these things are being escalated? Please advise!

like

Additional Posts in Eli Lilly company

What are the companies I can switch from Eli Lilly? Can I try for product based companies like Amazon and Uber?

like

Can anybody please tell me What is the hierarchy level in eli lilly. Recently Received an offer for Associate consultant position

Hi People! I need a referral in Eli Lilly.

Currently in ZS as DAA! Almost 2 YOE but total work ex 2.5 yr.

like

How much Joining bonus @eli lilly offers if joining in <45 days?
It has clause that we need to return amount if leaving before 1 year or 2 year?

Do they provide relocation bonus?

@eli lilly company

like

What are the various employee benefits that lilly offers?

Hi, what are the hierarchies in data and analytics side? How many steps above Data architect role?
Is the data architect role right for 11 years of exp?
What is salary range for this position?

like

What is the designation hierarchy in Lilly for IT solutions ? Can anyone please help with that information

Do they provide MacBook for work at Eli Lilly for data science team?

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