1 of 34

Ninjacart Data Strategy

Vijaykumar Shenbagamoorthy

2 of 34

Ninjacart is India’s largest Fresh Produce Supply Chain Company.

​

We source fresh vegetables and fruits from farmers and deliver them to kiranas and businesses across the country within 12 hours by leveraging innovative technology.

OUR VISION

​

We are pioneers in solving some of the hardest supply chain problems of the world.

​

We are focused on using our innovation to build a more efficient supply chain to improve the lives of farmers, businesses, and consumers in a meaningful manner.

Who are We?

3 of 34

Our Solution

4 of 34

Ninjacart Product Portfolio

Kirana/Retailer App

BNPL

Agri Fintech

Global Trade Platform

Cross Border Trade

Agro Advisory

&

Mandi News

B2B

Supply Chain

Management

5 of 34

Content

  • Data Domains
  • Data Platform Architecture
  • Data Platform Reference Architecture
  • Lego Blocks of Data Platform
  • Lakehouse Adoption
  • Unified Data Platform – Overview
  • Defensive Data Strategy towards Governance
  • What's Next?

6 of 34

Data Strategy

7 of 34

Data Domain Overview

​

DERIVED

3

RFM Calculation

Customer Churn

Product Sentiment

Fraud Detection

Customer Segmentation

Churn Prediction

Sentiment Analysis

Risk Management

OBSERVED

2

Family & Business Relationship

Transactional Data

Social Data

Purchase History

Complaints

Product Reviews

Claims

Payment

ASSERTED

1

John P. Iyer

Vinod Iyer

Vinod Iyer

Account

Customer

Product

Location

Farmers

Organization

8 of 34

Analytical Platform Reference Architecture

9 of 34

Layers of Data Platform

10 of 34

Lakehouse Adoption

11 of 34

COW vs MOR

  • Copy-on-Write: With COW, when a change is made to delete or update a particular row or rows, the datafiles with those rows are duplicated, but the new version has the updated rows.

12 of 34

COW vs MOR

  • Merge-On-Read : With merge-on-read, the file is not rewritten, instead the changes are written to a new file. Then when the data is read, the changes are applied or merged to the original data file to form the new state of the data during processing.

13 of 34

TPC-DS (Transaction Processing Performance Council Decision Support)

14 of 34

Iceberg

Folder

Structure

15 of 34

Multi-Dimensional Sort

ZOrder - Deltalake

// read as delta format

DeltaTable deltaTable = DeltaTable.forPath(inputMapper.getSparkSession(),"/tmp/ds-partition/");

​

// Do Zorder Partition

dataset = deltaTable.optimize().executeZOrderBy(cols.stream().toArray(String[]::new));

16 of 34

Data Platform Architecture

Yesterday’s data architecture can’t meet today’s need for speed, flexibility, and innovation

17 of 34

Focus Areas

  • Reference Architecture – Stick to Booze Allen Reference Architecture
  • Data Domain based Tech stack selection
  • 3rd or 4th Generation Data Platform
  • Automated Data Ingestion & Mapping - Rapidly load data from anywhere, in any format, at scale using Apache Spark.
  • Data Catalog - Secure, organize and govern all your data.
  • Enterprise Knowledge Graphs - A semantic layer to link and contextualize your data
  • Discovery & Analytics
  • Easy of use – Data Engineering and Data Analytical Team

18 of 34

Ninjacart Data Platform | Architecture

19 of 34

Ninjacart Data Platform | Technical Architecture

20 of 34

Data Platform - Components

Data Product

Alternatives Considered

Selected Alternative

Data Catalog

Apache Atlas, Metacat, OpenMeta, Datahub

Open Metadata

Data Deduplication

Custom Development, Zingg.AI

Zingg.AI with Custom Coding

Data Reconciliation

​

Custom Development

Lakehouse

Deltalake, Hudi, Iceberg, Carbondata

Iceberg

Distributed Query Engine

Dremio, Apache Trino

Apache Trino

Authorization

-

Apache Ranger

ETL & ELT

ADF, Cloud Fusion, NIFI, CDAP, Metorikku etc...

Custom Development (Spark 3.3.1)

GraphDB

Neo4j, ArangoDB, Janus Graph ..many more..

Neo4j

Data Quality

Apache Griffin, AWS Deeque

Customized AWS Deeque

Orchestration

Lugi, Airlow, Oozie, Dagster ..many more..

Apache Airflow

21 of 34

Application and Platform Integration with Data Platform

22 of 34

GEMS – Generic Entity Micro Service

Codeless Microservice Platform

Asserted Data

23 of 34

Workflow Events to Data Platform

Observed Data

24 of 34

Unified Data Management

25 of 34

Unified Pipeline Architecture

Industry First Unified Data Pipeline Framework

  • ETL/ELT
  • Deduplication
  • Reconciliation
  • Data Quality/Profiling

26 of 34

Data Governance Strategy

27 of 34

Pillars of Data Governance

Data governance focuses on the daily tasks that keep information usable, understandable, and protected

28 of 34

Defensive vs Offensive Approach

  • Defensive data strategy focuses on minimizing risk. The activities associated with this include:
    • Regulatory compliance mandates like data privacy and financial reporting laws
    • Detecting and mitigating risk of fraud and theft
    • Identifying, standardizing, and governing authoritative data sources
  • Offensive data strategy supports business objectives. These activities include:
    • Gaining insight about customer needs
    • Integrating customer and market data for planning future business goals
    • Supporting the sales and marketing pipelines
    • Operational efficiency and process improvement

“When it comes to choosing your data strategy, it doesn’t have to be an either-or decision between offense and defence,” says Willem Koenders, a renowned consultant in the field of data strategy.

29 of 34

What’s Next?

30 of 34

What’s Next?

  • Domain Centric Data Mesh Architecture – New Consumption Access pattern based on GEMS with support for Ask APIs 🡪 Where we define clear bounded context and expose Data Products for consumption
  • Data Exchange Platforms
  • Attribute Based Access Control (ABAC)

​

31 of 34

1

2

3

4

5

Ninjacart Data Platform Evolution – Quick Recap

32 of 34

Data Platform Architects

Surya Prabhakar

 

Karthik K

Vijay

33 of 34

  • Data Domain
  • Reference Architecture – Data Platform
  • Different Terminologies used in Data World
  • How to Design Data Platform
  • Implementation alternatives available
  • Data and Governance Strategy

​

​

34 of 34