Data Lakehouse Services

Techjar Technologies Pvt Ltd

1
 Techjar Technologies Pvt Ltd is a leading provider of
innovative data solutions, cloud solutions, DevOps
services, cloud security, IT Infrastructure Solutions and
machine learning services. Headquartered in Mumbai,
Techjar Technologies serves a diverse range of industries,
About us including banking, NBFC, and fintech.
Pioneering the integration of data lakes and data
warehouses into a unified data Lakehouse architecture.
Tailored solutions that cater to the specific needs of our
clients, ensuring maximum ROI.

2
Data Offerings
With Solution & Domain Knowledge

3
Offerings - Data Solutions

• Data Management:
• Data warehousing, Data Lake & Data Lake house Platform integration, customization and management. We are
aligned with OEM’s Like Snowflake, Databricks, Amazon Redshift, Microsoft Azure Synapse, Azure Data Lake
Storage, and Apache Hadoop.
• Data Integration, we use Apache NiFi, Talend, Informatica, Spark and Apache Kafka for data ingestion,
transformation, and integration.
• Master Data Management is done using Informatica MDM, Snowflake or Databricks.

• Data Analytics and Business Intelligence:

• visualizations and dashboards is done with power BI, Tableau. Statistical Analysis and modeling is
done using R/Python. For Predictive Analytics & Text Analytics we use RapidMiner

4
Offerings - Data Solutions

• Data Governance and Security:

• Data Catalogs is done using collibra and Informatica Axon. Varonis, and Protegrity ensure data security,
compliance with regulations and protection against unauthorized access. Talend Data Quality, and Informatica
Data Quality assess and improve the quality of data through cleansing, enrichment, and validation processes.

• Snowflake & Databricks: These platform provides integrated solution covering all the required aspect,
offering scalable data processing, machine learning, and collaborative analytics. It facilitates real-time data
integration, advanced analytics, and seamless collaboration, making it a powerful choice for big data and AI-
driven projects.

5
Other Offerings
IT Infra and Application

6
IT Infrastructure
Network Infrastructure Data Platform & Cloud
• Active and Passive Network Infrastructure.
• Data Democratization & Cloud –
• Design, Supply, Implementation and Architecture, ETL, Data Lake,
documentation Datawarehouse, Cloud Migration,
Data Center Solutions Optimization and Security
• Data center solutions including Servers, Services
Storage, Virtualization End to end design,
deep dive into the solution with minute • FMS & Managed Services across location
security and optimization option. with automation and monitoring tools

Cyber Security
• Edge, endpoint, cloud security options –
Total security solutions and Audit services.

7
 • Cloud Integration
Services
• Digital Application
Development & QA
Testing
• Mobile Application
Digital Cloud Development &
Support
Applications • Cloud Migration
• Power Platform
Services
• Cloud DevOps

8
 • BOT Platform that
automates all manual and
repetitive tasks.
• Customer Support
Productivity
Improvement Services
(KM Search, Chat GPT)
RPA & Generative • Digitalization
AI Enablement Services
(OCRs)
• Developer Enablers -
Copilot for VS, Chat
GPT 3.5

9
Introduction To Practice
Focusing on Skills and Domain

10
 Presence & Skill
• Cloud-born, Data and AI consulting firm
• Focused on Snowflake & Databricks Partner
• Presence in India, Dubai, Sweden & NJ, USA
• Operations in India – Mumbai, Pune and Bangalore

50+ 70+ 4 3+

Global Consultants Certifications Marketplace

Solutions Industry Verticals
Domain Expertise

Regulatory Compliance: Ensuring data solutions meet all banking regulatory standards and
compliance requirements.
Risk Management: Advanced analytics to identify and mitigate risks effectively.
Fraud Detection: Implementing real-time monitoring and detection systems to prevent fraud.
Customer Insights: Leveraging data to gain deep insights into customer behavior and
preferences.
Operational Efficiency: Streamlining operations to reduce costs and improve service delivery.
Data Governance: Robust data governance frameworks to ensure data integrity and security.
Scalable Solutions: Designing scalable solutions that can grow with the bank's data needs.

12
Products
Inhouse Products

13
 • We understand your business

Lokibot process. We identify value-add

scope. We build a robust
automation solution.

14
Lokibot Uses

• Intelligent Automation
• Chatbot and conversational AI
• Document understanding AI
• ML based forecasting and Predictive Modelling
• Image and Video Analysis
• Emotion AI
• 3rd Party cognitive APIs
• Ready-To-Use Bot
• Automation Engineers

15
Data Load Solution Accelerator
Data load solution accelerator is a low-cost, simplified, low-code ELT/ETL framework​on top for
effortless ELT pipelines. With this framework, our team of experts spends less time creating and
configuring ETL/ELT jobs with minimal code required providing high scalability, flexibility, and security
to data integration projects.

Config File Meta Data Orchestrator

Pipeline1 Pipeline2 …Pipeline n

Postgres S3 Snowflake DB
AWS EC2
Others Execution Engine

Data Sources
Data Load Accelerator

16
Data Chime - Modern ELT Framework
Layer

Pyspark
Source Systems Snowflake Raw
Pipleline
(Ex: SQL server, AWS S3 Zone
Post gre .etc., Snowpipe

Data Chime is a modern ELT framework that automates the planning,

modelling, and integration steps throughout the entire lifecycle of datasets Snowflake transient
in a data lake. Layer

• Reusable metadata framework helps to automate dimension loading

SCD Type1 Stored
Meta Data
Procedures
SCD Type2
• Snowflake stored procedures developed with parameters referenced Snowflake
from metadata tables Datawarehouse
layer

17
Insurance Analytics

•Insurance Analytics is a comprehensive platform that helps insurance leaders to

access and manage the necessary data for informed decision-making.

•Key Features
• Reduce the cost and complexity of providing operational and management
information to decision-makers, analysts, and data scientists.
• Strengthen distribution channels
• Proactively cross and up-sell current customers
• Improve customer and agent experience
• Increase visibility into operational performance
• Enhance statutory and market conduct reporting
• Streamline core business processes
• Identify fraudulent claims in a timely and effective manner
18
 Swetha M

Thank you VP - Customer Centric Services

Swetha@techjar.in