Swapnil Pandey

Ebay Feb 24 - present

• Data Warehousing created DDL scripts using sql in sql developer to bring and store the data coming from source to stg layer and did standard transformations to process it in main tables using .ctl files to Load data from sqlldr, Load scripts to load the data from Stage to Main table. Worked on 12 such Interfaces and handled maintainance such when job failure occurs.
• Data Explorer Worked on Data Catalogue which will be used to track the data migration , created an Automation using Python to map the data given during load with the data in dictionary to identify patterns with data elements which are already present as key value pairs on success and on creating new entries automatically for new patterns. Also contributed in solving around 11 issues faced by the app.
• CMS API worked on generating tokens using CURL and successfully bring over Data from CMS warehouse over to Dhub using mashup API on WSL ubuntu or using Postman.
• Automating data Validation Worked towards successfully creating triggers ,making use of stored procedures and various other features of PL SQL to enable data validation on some pipelines simpler.