Open to opportunities

rajesh ranjan

@rajeshranjan

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

India

Message

What I'm looking for

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.

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

Work history, roles, and key accomplishments

Current

Snowflake Data Lead

Current

Enquero

Oct 2021 - Present (4 years 7 months)

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

Snowflake Matillion Azure Data Factory SQL RBAC Data Migration Data Reconciliation Star Schemas

Snowflake Lead Developer

Deloitte Consulting USI

Sep 2020 - Oct 2021 (1 year 1 month)

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.

Snowflake SnowSQL RBAC Data Masking Teradata SQL Cost Optimization Warehouse Design Data Validation

Big Data & Snowflake Lead

Zensar Technology

Feb 2020 - Jul 2020 (5 months)

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.

Snowflake Teradata Hive Erwin Dimensional Models Cluster Keys Materialized Views SQL

Senior Data Engineer

Cognizant Technology Solutions

Aug 2016 - Jan 2020 (3 years 5 months)

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

Erwin Teradata SQL Explain Plan Index Tuning Hadoop Data Modeling ETL

Teradata Developer

Exilant Technologies Pvt. Ltd.

Apr 2015 - Aug 2016 (1 year 4 months)

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.

Teradata BTEQ SQL Stored Procedures ETL Regulatory Reporting Technical Documentation Data Pipelines

Data Engineer

UST Global Pvt. Ltd.

May 2013 - Apr 2015 (1 year 11 months)

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.