Devender Dagar

Experience

• 

  Titan Company Limited

  Jul 2018 - Jun 2021

  SQL Support Engineer

  • Provided technical support for server database environments, including testing, installation and upgrades along with backup and recovery of existing SQL Server databases.• Responsible for creating SSIS Package.• Responsible for maintaining and developing database.• Processing large batches of data on daily and weekly basis.• Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work.• Provided extensive Application Support.• Executing sql query to update data of table as per user request. Show less

• 

  Pine Labs

  Jul 2021 - Aug 2022

  Data Engineer

  • Batch processing of large datasets in Snowflake.• Data migration from SQL Server to Snowflake.• Creating end to end ETL pipelines using Snowflake.• Data Warehousing using snowflake.• Using Snowflake utilities like Snowsql, Streams, Tasks, Time Travel, Zero copy cloning.• Creating an ETL script in python using Pandas.• Experience in creating SSIS packages using proper control and data flow elements with error handling.

• 

  VAMANI OVERSEAS PRIVATE LIMITED

  Sept 2022 - May 2023

  Data Engineer

  • Data migration from SQL Server to Snowflake.• Creating end to end ETL pipelines using DBT.• Creating Snowpipe for continuous data ingestion.• Data Warehousing using snowflake.• Using Snowflake utilities like Snowpipe, Snowsql, Streams, Tasks, Time Travel, Zero copy cloning. • Working knowledge of AWS services(S3,DMS,SNS).• Create Dashboards on Trevor.io.• Data migration from Salesforce to MySql using Stitch.