Data engineering in Chennai
A Chennai hospital group with several branches runs each one on its own mix of hospital information system, lab system, pharmacy software and billing. Management wants simple answers across all of them: bed occupancy, theatre use, waiting times, revenue by speciality. Today each branch exports its own spreadsheet, each counts slightly differently, and the group report arrives weeks after the month it describes.
We build the pipelines that bring those systems together. Data is pulled from each branch's systems on a schedule into a warehouse, ClickHouse, Postgres or one you already run, definitions such as occupied bed or theatre utilisation are agreed once and versioned, and patient identity is handled with the care health data demands. Freshness is shown next to every number. FM360, which serves a healthcare estate, syncs a third-party system every hour and checks that dashboards are current.
Chennai is where Indian SaaS learned to sell to the world. Zoho is headquartered here and has grown without venture capital. Freshworks was founded here in 2010 by two former Zoho employees, and Chargebee was started in a Chennai apartment a year later by a team with Zoho roots, with Freshworks as an early customer. That lineage produced a distinctive kind of company: product-led, careful with money, selling to small and mid-sized businesses on several continents from offices in Chennai. Chennai's SaaS teams tend to be strong on product and short on specific capacity, not on talent in general.
The city's second identity is industrial. Chennai is often called the Detroit of Asia, with vehicle plants including Hyundai's and BMW's on its outskirts, a large base of component and electronics manufacturers, and a major port. Those firms have the same problem as manufacturers everywhere in India: their operations have outgrown the spreadsheets and older systems that run them, and their information arrives late and in the wrong format. Around the port, freight forwarders, customs brokers and warehouse operators face the same problem with paperwork instead of parts, and the cost of a lost document is a container that sits on the quay.
Its third is healthcare. Chennai is often called the health capital of India, and hospital groups such as Apollo Hospitals and specialist centres such as Sankara Nethralaya draw patients from across the country and abroad. Healthcare software here has to earn trust. Health records are among the most sensitive data there is, and hospital systems increasingly need to exchange data with each other and with the national digital health stack rather than sit in isolation. Referrals, international patient coordination, patient apps and group-wide reporting all need building. Getting consent, access logging and integration right matters more than the interface.
We are in Bengaluru and share your time zone, so the working day is the same on both sides and a question asked in the morning is answered that morning. You talk directly to the engineer who writes the code. Most of the work happens in your repository, your issue tracker and a shared chat channel, which suits teams used to working in writing, and the runbooks and architecture notes are written as we go.
We are the right fit for a defined piece outside your team's usual specialism, a migration with an end date, or the gap while your next hire serves their notice. Start with a fixed-price two-week piece and judge us on what ships. Chennai agencies and product studios can also bring us in white-label, under their own name.
Four ways this arrives.
Two definitions of the same metric, computed in two places. We pick one, write it as a tested model in version control, and point every report at it, so the argument moves from whose number is right to what the definition should be.
A job reports success while the report still shows yesterday. We give every table a written freshness guarantee, monitor what the reader actually sees rather than the job that feeds it, and alert a person when the guarantee is missed.
A CRM, an ERP or a work-order tool reachable only through its API. We build the sync with retries, rate limits and normalisation at the boundary, and keep append-only snapshots so last Tuesday is a query rather than a restore.
Analytical queries running against the application database at the worst possible moment. We move them to a columnar store, keep Postgres for transactions, and feed one from the other by change data capture or scheduled extracts, whichever the freshness requirement calls for.
A nightly work-order extract into append-only ClickHouse snapshots, with a verifier that reads the live Tableau dashboard to prove it shows the newest data.
Read the write-up →Asked by Chennai teams.
How do you work with teams in Chennai?+
We are in Bengaluru and share your time zone, so calls, reviews and releases fit inside your normal working day. We work in your tools, Slack, GitHub and Linear or whatever your team already uses, and most of the conversation happens in writing, where it lasts. You talk directly to the engineer writing the code, from the first 30-minute call onwards, and runbooks and architecture notes are written into your repository as we go.
Can you work inside a mature SaaS product without slowing our team down?+
Yes. We read your code and conventions before changing anything, follow your review and release process, and take a defined piece of work, such as a billing migration, a new integration, a performance problem or an infrastructure move, so the changes stay in one place rather than spreading across the product. We work in Node, Python and TypeScript, inside your repository, and leave runbooks and architecture notes for your team.
How does your rate compare to hiring in Chennai?+
PayScale puts a mid-career software engineer in Chennai at about ₹12 lakh a year. Our published rate is $35 an hour, with a $5,000 minimum. That buys a senior engineer who writes the code, works in your Slack, GitHub and Linear, and starts within days, with no recruiting round, notice period or employment overhead. Begin with a fixed-price two-week piece at $2,800 and judge us on what ships.
Can you build software for Chennai's hospitals?+
Yes. FM360, the platform we built for a healthcare estate, runs its facilities and maintenance in production. For hospitals and diagnostic chains we build referral and patient-coordination platforms, patient apps in Tamil and English, and warehouses that join every branch's systems into one set of numbers. Consent is recorded per purpose, every access to a record is logged, and integrations use standards such as FHIR where the other side supports them.
Do we need a data warehouse yet?+
Maybe not. If your reporting runs comfortably against a Postgres read replica, a warehouse adds a second system to pay for and keep in step. The signs you need one: analytical queries slowing the product, data from several sources that has to be joined, or history you must keep that the application overwrites. We will tell you which side of that line you are on.
Why ClickHouse rather than Snowflake or BigQuery?+
Not always. For steady, high-volume analytical work, ClickHouse is fast and cheap to run, self-hosted or on its managed cloud, and we run it in production. Snowflake and BigQuery ask less of you operationally and suit ad hoc querying across a large team. If nobody on your side wants to operate a database, we will recommend the managed option even when the invoice is larger.
What does a freshness guarantee actually mean?+
A written statement per table or report, such as "never more than an hour behind" or "reflects yesterday's close by 07:00". Each one has a check that measures it and an alert that fires when it is missed. Without it, stale data looks exactly like correct data until somebody makes a decision on it.
Can you work with the tools we already have?+
Usually, yes. If you already run dbt, Airflow, Fivetran or a BI tool your team knows, we build inside it. We suggest replacing a tool only when it is the cause of the problem you hired us for, and we show you the evidence before asking you to fund a migration.
How do you handle personal data in the warehouse?+
We decide what should reach the warehouse at all before building the pipeline. Identifiers can be hashed or tokenised at ingestion, sensitive columns restricted by role, and retention enforced by the pipeline itself. Every field is documented from source to dashboard, so anyone can see where a number came from and who can read it.