Databricks SQL & data engineering
Layered CTEs, multi-source joins, customer primary-key unification, and verification against the live implementation. The bugs get found before the campaign does.
Rtvik Nambiar · Toronto · Canadian citizen
Technical Lead at HCLTech, running program management on a customer data platform migration for a Canadian credit card issuer. SAS CI 360 and Salesforce Marketing Cloud are going out. Databricks and Braze are coming in, across five releases. I still write the SQL.
Capabilities
Pipelines and analysis on one side, requirements and releases on the other. The chain is the point.
Layered CTEs, multi-source joins, customer primary-key unification, and verification against the live implementation. The bugs get found before the campaign does.
ELT approvals and go/no-go gating criteria for the final three releases of a five-release migration. Deployment days run on a briefed-stakeholder rhythm, not on hope.
Abstract segmentation rules become queries an engineer can build and an auditor can defend. Documented across 20+ acquisition use cases.
Access classification and source-to-target lineage for Customer 360 data, written so an audit finds answers instead of gaps.
Requirements gathered wide enough that the teams downstream of the platform stayed supported through a partial migration. Works in English and French.
Microsoft Copilot and Power Automate wired into daily delivery work, saving roughly 40% of documentation and reporting time. Tools change; the habit of automating the boring parts doesn't.
Selected work
A Canadian credit card issuer is replacing SAS CI 360 and Salesforce Marketing Cloud with Databricks and Braze, on a medallion architecture. I started in the data. I now run program management for the final three releases.
Acquisition campaigns moved first, setting the ingestion patterns every later phase reuses.
Pipelines hardened and edge cases closed before the higher-stakes ingestion began.
Customer-unification ingestion through the medallion layers. The release went out clean: stakeholders briefed at every milestone, in-flight systems supported through a partial migration.
The full base-customer population moves over. I run the ELT approvals and hold the gating criteria.
The old stack retires and the platform becomes the single source of truth.
Also built
A quote follow-up tool for trades businesses running on Jobber. It watches every open quote and texts the ones that go quiet until the customer answers. Anything ambiguous goes to a human, never a guess. No clients yet. I built it to find out whether I could take a real problem and ship something small that solves it.
A product, not a practice. For roles, use the email below.
About
I started as a data engineer, and that layer still anchors everything. When a release decision lands on my desk, I can open the notebook and check the logic myself. Business analysis taught me the other half of the job, which is that the hardest part of data work is rarely the data. It is agreeing on what the rules mean.
In between, I built BI and automation for emergency medical services, where shipping to non-technical users is the whole job. I studied Cognitive Systems at UBC, so I default to asking how a person will actually use the thing. English and French at work, Malayalam at home. I grew up across four countries, which mostly taught me to read a new room fast.
Where I'd like this to end up is the commercial and fan-data side of a football club. Clubs sit on some of the most fragmented customer data anywhere. I'm not there yet and I know what I still have to show.
Progression