# rajesh ranjan

rajesh ranjan is a remote worker on Himalayas, Snowflake Data Lead at Enquero, based in India.

Source: https://himalayas.app/@rajeshranjan

```text
Senior Snowflake Data Lead who architects enterprise migrations, optimizing cost, performance, and data quality in production.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | India |
| Authorized to work in | India |
| Job categories | Snowflake Technical Lead, Data Engineering, Data Warehouse Engineer, ETL Developer, Team Manager, Lead Snowflake Delivery Solutions Architect, Data Lead, Cloud Data Architect Lead, Data Engineering Lead, Senior Data Engineering Leader |
| Skills | Snowflake, SnowSQL, Snowpipe, Time Travel, Streams and Tasks, Clustering, RBAC, Data Masking, Matillion, Azure, Informatica PowerCenter Architecture, Talend, Pentaho, AWS Glue, Azure SQL Database, Azure Synapse, Databricks, Teradata, Oracle, SQL Server, IBM DB2, Hadoop, Erwin, Dimensional Models, Star Schemas, SCD Type 1, SCD2, SQL, Python, Linux Shell Scripting, BTEQ, S3, EC2, BigQuery, Azure DevOps, Git, Power BI, Agile Scrum, Column, Linux |
| LinkedIn | https://www.linkedin.com/in/rajesh-kumar-ranjan-49053956 |

## What I'm looking for

```text
I’m looking to lead Snowflake and enterprise data platform migrations—owning architecture, ETL/ELT delivery, and governance (RBAC/masking)—while driving measurable cost and performance wins through strong team leadership.
```

## About

```text
I’m a Senior Manager & Snowflake Data Lead with 4+ years of deep Snowflake expertise and 13+ years in enterprise data engineering & warehousing. I’ve architected and delivered large-scale on-premise-to-cloud migrations (SQL Server, Oracle, Teradata, Hive → Snowflake) using Matillion and Azure ADF, owning end-to-end platform architecture and client stakeholder engagement.

I build layered Snowflake platforms (Raw → PSA/SCD2 → Consolidation → Conformed star schema) and lead cross-functional teams up to 12 to deliver measurable outcomes—like 40% compute cost reduction and 60% query performance improvement—while strengthening RBAC security, dynamic data masking, and data reconciliation. My work has been recognized with the Gold Cheers Award (2025) and other performance awards for migration leadership, delivery excellence, and technical impact.
```

## Experience

### Snowflake Data Lead (current)

Enquero. Oct 2021 - Present

```text
Led an end-to-end on-premise SQL Server and Oracle to Snowflake migration using Matillion, owning the platform architecture, delivery, and stakeholder engagement as Snowflake Data Lead. Architected a 4-layer Snowflake platform (Raw, SCD Type 2 Persistent, Consolidation, Conformed star schema), improved customer master/hierarchy consolidation, and defined standards for RBAC, error handling, and rec
```

Skills: Snowflake, Matillion, Azure-Data-Factory, SQL, RBAC, Data-Migration, Data-Reconciliation, Star-Schemas

### Snowflake Lead Developer

[Deloitte Consulting USI](https://himalayas.app/companies/deloitte-ireland). Sep 2020 - Oct 2021

```text
Led a 12-member cross-geography team to migrate 500+ Teradata objects to Snowflake with zero data loss, validating via row-count, hash reconciliation, and business-view comparisons. Reduced Snowflake compute costs by 40% through multi-warehouse architecture and right-sizing, and implemented zero-copy cloning plus RBAC with dynamic data masking and row-level security.
```

Skills: Snowflake, SnowSQL, RBAC, Data-Masking, Teradata, SQL, Cost-Optimization, Warehouse-Design, Data-Validation

### Big Data & Snowflake Lead

Zensar Technology. Feb 2020 - Jul 2020

```text
Directed Teradata and Hive data marts migration to Snowflake as primary technical decision-maker for architecture choices. Improved query performance by 60% using cluster keys, materialized views, warehouse right-sizing, and SQL rewrites (window functions vs correlated subqueries), while applying Erwin-based dimensional modeling and team mentorship.
```

Skills: Snowflake, Teradata, Hive, Erwin, Dimensional-Models, Cluster-Keys, Materialized-Views, SQL

### Senior Data Engineer

[Cognizant Technology Solutions](https://himalayas.app/companies/cognizant). Aug 2016 - Jan 2020

```text
Designed Erwin conceptual/logical/physical data models for an enterprise corporate banking platform and led a full-cycle migration from legacy EDW to a Hadoop-based architecture, mentoring junior developers. Improved Teradata query performance by 50% using explain-plan analysis, index optimization, and workload management tuning, translating reporting requirements into data models and ETL specific
```

Skills: Erwin, Teradata, SQL, Explain-Plan, Index-Tuning, Hadoop, Data-Modeling, ETL

### Teradata Developer

Exilant Technologies Pvt. Ltd.. Apr 2015 - Aug 2016

```text
Built a self-service SOX and PII re-accreditation/compliance automation tool, reducing manual compliance effort by 80%. Developed BTEQ scripts, stored procedures, and ETL frameworks for regulatory reporting pipelines and authored technical design documentation.
```

Skills: Teradata, BTEQ, SQL, Stored-Procedures, ETL, Regulatory-Reporting, Technical-Documentation, Data-Pipelines

### Data Engineer

UST Global Pvt. Ltd.. May 2013 - Apr 2015

```text
Designed Informatica PowerCenter workflows and Teradata data marts supporting healthcare analytics for ECoC R2/EHP product integration. Served as an end-to-end solution provider to ETL, QA, and support teams by authoring technical documentation and deployment procedures.
```

Skills: Informatica, Teradata, SQL, ETL, Data-Marts, Technical-Documentation, Deployment, Healthcare-Analytics, Data-Integration

## Education

### Rajdhani Engineering College

Bachelor of Engineering (B.E.). Grade: 73%

```text
Earned a Bachelor of Engineering (B.E.) in 2012 with 73% marks.
```

## Tech stack

- Matillion
- Talend
- DB
- Hadoop
- IBM DB2
- Gmail
- Databricks
- Azure DevOps
- Linux
- SQL
- Dynamic
- Column
- Jan

To contact rajesh, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Gayathri Bowshya](https://himalayas.app/@gayathribowshya): Data Engineering Lead , Infosys
- [GANESH KRISHNAN](https://himalayas.app/@ganeshkrishnan): Senior Data Engineer, Cognizant
- [Ramchandra Kulkarni](https://himalayas.app/@ramchandrakulkarni): Senior Data Engineer, Jade Global Inc
- [Neeraj Dale](https://himalayas.app/@neerajdale): Senior Consultant (Snowflake), ACS International India
- [Shubhranshu Mishra](https://himalayas.app/@shubhranshumishra): Platform Engineer, EPAM Systems
- [Avi Garg](https://himalayas.app/@avigarg1): Senior Data Architect, Kipi.ai
- [Amit Patil](https://himalayas.app/@amitpatil4): Lead Software Engineer, Persistent Systems
- [siddhesh rane](https://himalayas.app/@siddheshrane): Acting Analytics Lead, Netskope
- [Saurav Panda](https://himalayas.app/@sauravpanda): Data Architect, Happiest Minds
- [Paramjeev Kumar](https://himalayas.app/@paramjeevkumar): Data Architect & Data Engineering Manager, Cognizant Technology Solutions
