Results-driven Snowflake Developer with 2 years of experience in designing, developing, and maintaining cloud-based data warehouse solutions using Snowflake. Skilled in data migration, ELT development, SQL optimization, data modeling, and cloud data integration. Hands-on experience with SnowSQL, Snowpipe, Streams, Tasks, Time Travel, Zero Copy Cloning, and AWS cloud services. Strong understanding of data warehousing concepts and Agile software development practices.
Expertise & skills
Cloud Data Warehouse
Snowflake
Programming Languages
SQLPython
ETL / ELT Tools
SnowpipedbtMatillion
Cloud Platform
AWS (S3IAM)
Data Formats
CSVJSONParquet
Snowflake Features
Virtual WarehousesStreamsTasksTime TravelZero Copy CloningSecure ViewsData SharingStored ProceduresUser Defined Functions (UDFs)
Version Control
Git
Project Management
JiraAgile / Scrum
Core Skills
Snowflake Data WarehousingELT Pipeline DevelopmentSQL Query OptimizationData ModelingCloud Data MigrationPerformance TuningData Security & GovernanceAnalytical Problem SolvingTeam CollaborationAgile Development
Selected projects
Customer Sales Data Warehouse
SnowflakeSQLAWS S3Snowpipe
Responsibilities
- Designed Snowflake databases, schemas, and tables.
- Developed automated data ingestion pipelines using Snowpipe.
- Built SQL transformations for data cleansing and business reporting.
- Created secure views and optimized query performance.
- Configured virtual warehouses based on workload requirements.
- Performed data validation and quality checks before production deployment.
- Collaborated with business users to gather reporting requirements.
Retail Analytics Platform
SnowflakedbtSQLPython
Responsibilities
- Developed ELT pipelines using dbt and Snowflake.
- Designed dimensional models for analytical reporting.
- Implemented Streams and Tasks for incremental data loading.
- Created stored procedures to automate data processing.
- Optimized SQL queries and warehouse utilization.
- Supported deployment and post-production monitoring.
- Prepared technical documentation for data pipelines.
Insurance Claims Data Migration
SnowflakeMatillionAWS S3
Responsibilities
- Migrated enterprise data from legacy systems to Snowflake.
- Developed ETL jobs using Matillion.
- Performed data reconciliation between source and target systems.
- Implemented role-based security and access control.
- Automated validation reports for migrated datasets.
- Supported UAT testing and production rollout.
- Resolved data quality and transformation issues.
Banking Reporting Data Mart
SnowflakeSQLPython
Responsibilities
- Built reporting data marts for banking analytics.
- Developed SQL procedures for daily reporting.
- Automated workflows using Snowflake Tasks.
- Utilized Time Travel for data recovery and auditing.
- Optimized compute resources to reduce operational costs.
- Monitored scheduled data pipelines and resolved failures.
- Assisted BI teams with reporting requirements.
Certifications
- SnowPro Core Certification (Training)
- Snowflake Hands-on Workshop
- SQL for Data Engineering
Education
Bachelor of Engineering (Computer Engineering)
Gujarat Technological University
Similar engineers
Other Data Engineering engineers with comparable experience.
