Data engineering in Delhi NCR
For the NCR's consumer companies the most contested number is what an order actually costs. It is spread across the order system, the payment gateway, the courier partners' invoices, refunds, discounts and the cloud bill, and each team calculates it from its own slice. Growth wants one figure, finance another, and the board asks which is true when the company is trying to reach profitability.
We build the pipelines that give you one answer. Every source is pulled on a schedule into ClickHouse, Postgres or the warehouse you already use, joined at the level of a single order, with the definitions of revenue, cost and margin agreed once and versioned in dbt. Freshness is monitored and shown next to the number. On FM360 we sync a third-party system every hour and check that what the reader sees is current, not just that the job ran.
Delhi NCR is not one market but three, joined by expressways and a metro. Gurugram is where much of India's consumer internet grew up: food and grocery delivery, travel, logistics, home services and fintech, alongside the Indian offices of many multinationals. Noida has a different mix, with large IT services firms, edtech, media and healthcare technology companies selling to hospitals in the US. Delhi itself holds the government, and with it every company whose customer is a ministry, a state department or a public sector undertaking.
The consumer companies share an operational problem. Their software coordinates people in the physical world, riders, couriers, technicians and sellers, on cheap phones and busy roads, and the backend has to cope with status updates that arrive late, twice or out of order. Many of them are now past the stage of growth at any cost and into the stage of unit economics, which turns engineering questions into money questions: what does each order cost to serve, and which part of the cloud bill is paying for nothing.
Companies that sell to government need software shaped like the organisation it serves. Access follows the organisation chart: a district sees its own records, a state sees its districts, a ministry sees all of them, and every approval has a proposer and an approver. Noida's healthcare technology companies need something similar for hospital customers abroad, with each customer's data kept firmly apart. Across all three cities the hiring market is crowded. The consumer companies, the multinationals and the IT services firms compete for the same senior engineers, so a defined piece of work often waits months for someone to own it.
We are in Bengaluru and share your time zone, so the working day is the same on both sides, and a problem raised in the morning gets a response that morning. You talk directly to the engineer who writes the code. Most of the work happens in your repository and a shared chat channel, and the decisions, runbooks and architecture notes are written down as we go for everyone who was not on the call.
We are the right fit when an NCR team needs senior capacity quickly: a defined build, a backend that has to stop losing orders, or the months while your permanent hire works out their notice. Start with a fixed-price two-week piece and judge us on what ships. Agencies and IT services firms can bring us in white-label under their 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 Delhi NCR teams.
How do you work with teams in Delhi NCR?+
We are in Bengaluru and share your time zone, so calls, reviews and releases happen inside your normal working day, whether you are in Gurugram, Noida or Delhi. We work in your tools, Slack, GitHub and Linear or whatever your team already uses. You talk directly to the engineer writing the code, from the first 30-minute call onwards, and the decisions, runbooks and architecture notes are written down in your repository as we go.
Do you build for delivery and logistics companies?+
Yes. We build the systems that coordinate riders, couriers and technicians: order and shipment state that stays correct when events arrive late, twice or out of order, partner apps that keep working offline and upload proof of delivery when the network returns, and reconciliation that catches what still slips through. We also build the data pipelines that finally give everyone one answer to what an order costs to serve.
How does your rate compare to hiring in Delhi NCR?+
PayScale puts a mid-career software engineer in Gurugram at about ₹16 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 take over a platform another team built?+
Yes, and it is a common way in. We start by reading the code and writing down what it actually does: the services, the background jobs, the parts only one person understood. The fixed-price two-week piece is usually the failure that costs you most, fixed and documented. At the end you have working code, a map of the system and a written plan for what comes next, all in your repository.
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.