Aditya Pawar is an experienced Software Engineer specializing in data warehousing and ETL processes. He has expertise in implementing data solutions using Snowflake, SQL Server, and AWS. His skills include developing dynamic ETL pipelines using Python and JavaScript, and optimizing data loads, as demonstrated during his tenure at ValueLabs.
Experience
Senior Software Engineer
ValueLabs
Worked closely with project manager to develop Enterprise Data Warehouse implementation on Snowflake. Implemented Sql Server migration to Snowflake. Designed and engineered data extraction from SQL Server using SSIS. Built automation script for schema conversion from MSSQL to Snowflake. Developed dynamic ETL in javascript for data loading to snowflake from AWS S3 stage. Automated Data ETL monitoring using python to collect details from MSSQL and snowflake to send mail notifications. Developed SSIS package to Extract and load data from OLTP to ODS for full and incremental loads. Led the pair programming and code review session, enforcing coding standards and best practice. (JavaScript, SnowSQL, Python)
Software Engineer
ValueLabs
Management and implementation of Fraudulent Insurance provider detection using SQL Server and Tableau BI report. Achieved ETL data load pipeline optimization by 60% of run time. Developed SSIS package for profiling tables for constrains, Special characters and delimiters. Created custom snowflake DDL handlers.
Education
MIT, Pune, Savitribai Phule University, Pune
B.E.
Computer Science & Engineering
Licenses & Certifications
SnowPro Core Certification