Senior Snowflake Engineer with 6 years of experience delivering cloud-native data warehouse solutions for enterprise organizations. Experienced in Snowflake architecture, ELT framework development, data migration, data governance, performance tuning, and analytics enablement. Strong hands-on expertise with SQL, Python, dbt, Airflow, Terraform, AWS, and Azure.
Expertise & skills
Cloud Data Warehouse
SnowflakeSnowpipeStreamsTasksDynamic TablesTime TravelZero Copy Cloning
Programming
SQLPythonBash
Data Integration
dbtApache AirflowAzure Data FactoryFivetran
Cloud Platforms
AWS S3AWS LambdaAzure Blob Storage
Data Modeling
Star SchemaSnowflake SchemaSCD Type 1 & 2
Reporting
Power BITableauExcel
Version Control
GitAzure DevOpsTerraform
Selected projects
Responsibilities
- Designed scalable Snowflake data warehouse architecture.
- Developed metadata-driven ELT pipelines using dbt.
- Implemented incremental ingestion using Snowpipe.
- Optimized clustering keys and virtual warehouses.
- Created reusable SQL transformation framework.
Certifications
- SnowPro Advanced: Data Engineer
- AWS Certified Developer – Associate
Education
Bachelor of Engineering (Computer Engineering)
Pandit Deendayal Energy University
Achievements
- Reduced data processing time by 54%.
- Improved dashboard response by 47%.
- Travel Booking Data Lake Modernization
- Responsibilities
- Migrated on-premise warehouse to Snowflake.
- Integrated booking, payment and customer data.
- Automated orchestration using Airflow.
- Implemented RBAC and secure data sharing.
- Improved reporting availability across business units.
- Utility Consumption Analytics
- Built dimensional models for energy analytics.
- Developed data validation framework.
- Created monitoring dashboards for warehouse usage.
- Reduced manual reconciliation efforts.
- Insurance Fraud Detection Data Hub
- Integrated claims and policy datasets.
- Implemented masking policies and secure views.
- Optimized complex SQL queries.
- Strengthened compliance and governance.
- Supply Chain Visibility Platform
- Developed near real-time ingestion pipelines.
- Built curated analytical marts.
- Implemented cost optimization strategies.
- Lowered compute costs by 28%.
Similar engineers
Other Data Engineering engineers with comparable experience.
