Data Engineer
Current• Involved in Requirement gathering, Design and Build • Designed and Build Data Vault Models by using ER Studio • Involved in snowflake Implementation on Azure Migration project from SQL Server • Involved in Design and building data pipeline for various applications by using Matillion• Involved in performance tuning, recovery methods, Travel & Cloning• Having Experience in building Orchestration and Transformations Jobs in Matillion • Experience implementing core Snowflake concepts such as data sharing, UDFs, zero copy clones, time travel, micro partition, stored procedures, data import/export, external tables, Tasks, Dynamic Masking• Experience implementing Snowpipes, CDC, SnowSQL, performance tuning, monitoring, etc as part of Snowflake implementations• Worked on Cache usage, Streams, Secure Data sharing and automating data pipelines through Snowflake.• Having good experience in implementing data modeling (dimensional and data vault 2.0)• Having good experience in building complex enriched views based on business metrics by using SQL, Procedures, Functions