Hi Fishes,

Recently I was asked an interesting question in a system design round for a company. Please take a look and help me understand how do you solve the problem?

Question - Design an sms service to send messages to 1 million customers

Requirement - upload a csv of 1 million contacts and on clicking send send the sms.

Limitation - 1000 contacts/minute

How would you design this system, considering we have a hard limit of 1000 contacts/limit?

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

You can not load all 1 million customers contact in memory at once... You would have to load the contacts in chunks... Also need to remember offset to understand how many contacts we have loaded overall so far

Related Posts

Anyone from EY UK could help out that would be great.
I applied to the EY UK Elevate program Audit Senior. My application was rejected and immediately I got another email, confirming my application for Audit Senior - UK wide program.
I logged into my portal and saw that for the Audit Senior - UK wide program it was written "Forwarded as Applicant You have been added as an applicant to this requisition."
Has this ever happened with anyone? Is it a good sign?

Post Photo
like

What is the average adoption assistance benefit at big law firms?

like

I have ADD and occasionally make small mistakes in my work, like leaving a word missing when editing sentences, small formatting errors or leaving an internal comment in drafts sent to clients. All partners have been very understanding and care about the quality of my work, and no client has ever complained. Partners and clients praise my work.

But now, one partner has become super mad and when I explained ADD, he said:

likefunny

Can anyone else not sleep right now? So stressed and exhausted with everything but can’t fall asleep

likehelpful
like
like

Hi all we have openings for below positions. DM me if you are interested.

Post Photo
like

Hi all, insurance question - anyone know which is better in CO -Aetna or Anthem?

Hi,
I m working as a Project Manager for OFC network and EB work. My CTC is 8L per annum. Total experience is 15+ yrs and since 4+ yrs in current company, so pls help to switch and grow

like

If you are looking for exciting opportunity, Kindly share your resume to patelprachi2128@gmail.com with subject as referral code for which you want to apply.

And update the details below:
First name
Last name
Email id
Mobile number
DOB
Job id
Preferred location
Current/last employer
total exp
Have u applied in last 6 months

Post Photo
like

Hi all,
I need your favour here.
Do anyone has job referral for Business Analyst profile?

About me: 3.4yrs of workex-
Worked as a Sales Manager and across sales-Ops. 75% Team management+ 25% Data analysis and interpretation
Want to shift towards more data driven role.
I know advance Excel and SQL fundamentals.
Last drawn Ctc: 14lpa fixed

Any leads/suggestions would be helpful.

Thankyou :-)

like

Check the overtime laws for your state!!

I just recently worked 58.6 hours in a week, weekly pay, nice OT profit right? Depends on where you live.

In Iowa, there is no Overtime pay mandate, the overtime pay is at the discretion of the business. I received 58.6 hours of base pay for the week.

If the company makes less than $1 million per year or does not engage in intercontinental sales, the company is not required to pay the overtime rate of time and a half, just your base rate.

like

My team and I are looking at upgrading our invoicing system for catering gigs as our catering popularity is growing in our area.
Looking for BEO/invoicing/contract software that’s easy to use, saves menus, and not too terribly expensive. Recommendations?

like

Have offer from deloitte india and kpmg global with almost same package. Which one is better

like

Let's say you work remotely full time in private/group practice. Mental health or Wellness.
What's your maximum client load for a week? 20? 30? ... 10?

like

Hi Fishes
I am looking for a SAP FSCM or SAP FICO position with any product based or Big 4 company.
I have 7.5 years of experience in the same domain. If anyone has any leads, please share.
It would be greatly appreciated.
Thanks

like

Did any other HBS R1 interviewee just get that email from Chad Losee with the eBook? My heart literally dropped but it just seems like a nice email with access to a leadership eBook?

like

In Capgemini, having position for Team Lead, Team Manager, Operation Manager, Engagement Manager, Senior Engagement Manager.
If anyone wants to refer please drop your email id in comment.

like

Additional Posts in System Design Interviews

Question 1

Best way to approach a system design interview?

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