Akash Varma

Software Engineer

Bangalore Urban, Karnataka, India6 yrs 10 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in Snowflake cloud data warehousing.
Proficient in DBT for data modeling and transformation.
Strong experience in handling complex data sets.

Stackforce AI infers this person is a Cloud Data Engineer specializing in Snowflake and data integration solutions.

Contact

Skills

Core Skills

SnowflakeDbtSnowflake CloudSql

Other Skills

AWS S3Informatica PowerCenterFive TranPL/SQLcloud data warehouseSNOWSQLSNOWCLISnowflake AdminCloud Data engineersap bodsAzure Data FactoryAzure SQLAzure DatabricksplsqlSnow flake data warehouse

About

Having 6 Years of professional IT experience in this area of snowflake cloud data warehouse and snowflake developer. Handling large and complex data sets like json, csv files from various sources like AWS S3. Created Clone concepts to maintain zero copies in Snowflake. Good exposure in Snowflake Cloud Architecture and Snow SQL and SNOWPIPE for continuous data loading. Hands-on experience in bulk Loading and Unloading data into Snowflake tables using COPY command. Implemented incremental models within DBT to optimize data processing efficiency. Incorporated comprehensive testing mechanisms within DBT to validate data quality and ensure compliance with business rules. Documented DBT models and transformations to provide detailed insights into their purpose, logic, and business context. Designed and automated data ingestion processes into Snowflake using DBT. Developed DBT models, materializations, and seed concepts within the DBT development IDE.

Experience

Kpmg india

Snowflake developer

Oct 2022 – Present · 3 yrs 5 mos · Bangalore Urban, Karnataka, India · Remote

Create Integration Objects to connect various Cloud Storages such as AWS s3, Azure Blob.
Created Snow pipe for continuous data ingestion when a file lands to cloud storage
Created internal, external stage and transformed data during load.
Cloned Production data for code modifications and testing and used time travel to recover the
data.
Handled large and complex sets of JSON, and CSV from various sources and databases
Responsible for designing, development and maintenance of Snowflake database objects such
as tables, views, stored procedures, and SQL scripts.
Developed and maintained DBT models, including incremental and full load models, macros,
and conducted testing using SQL.
Implemented data replication and integration processes using Five Tran.
Designed data models including YAML models, snapshots, watermarks, dimension tables,
fact tables, and views using data build tools.
Managed version control and project tasks by creating development branches, pull requests,
and work items using Azure DevOps.
Created IICS Mapping jobs to Compare Data from Source to Target.
Converted SQL Server Stored procedures and views to work with Snowflake.
Assisted Team for SIT testing of the IICS jobs and Data validations.
Worked on Raising incidents Service now and assist in the incident Lifecyle (Asses, Build
and Test, CM Review, Cab review and approved)