10+ years of Experience as a Seasoned Data / Data Warehouse Engineer, ETL developer. Experience in End to End EDW implementation & BI Solutions across various business functions like Finance (FP&A), Traffic, Customer information and Core business processes by partnering with various business & technology stakeholders. Extensively worked on delivering critical business insights catering to senior level VP & executives in eBay Marketplaces by implementing the most critical data warehouse with respect to deriving key metrics & financial numbers. In-depth technical expertise in Dimensional Modelling, Reporting & on very large scale data sets. Have designed complex data engineering pipelines on large scale Data Warehouse applications that addresses varied data requirements on Massively Parallel Processing (MPP) systems (Teradata). Involved in developing a new ETL framework to facilitate instant click reporting by implementing storage and rendering of data using NoSql i.e. MongoDB. Setting up process using Shell scripts & ETL components to extract data from external sources (outside of eBay i.e. Keynote & Competitor data) along with email automation of financial numbers and display these datasets on dashboards. Extensively worked on Agile (Scrum) and water model methodologies. Partnered with data architects, application developers, product managers, business partners and senior management in order to collaborate on project involving multiple teams.

Senior Data Engineer @ AWS Redshift, Kettle Penthaho, Python, Linux, Shell scripting From February 2015 to Present (11 months) Senior Software Engineer @ Worked as a Data Engineer for eBay Marketplaces team responsible to deliver key metrics like GMV, GMB, Bought & Sold items, checkout revenue that shows complete view on performance of Marketplaces to top level executives on a daily basis. Dimensional modelling of backend structures catering to reporting needs and writing complex ETLs on large scale Data Warhouse applications on Massively parallel processing (MPP) systems (Teradata). Setting up data engineering pipelines to extract from various acquisitions of eBay like Half.com, Stubhub, Tradera & from external sources (outside of eBay i.e. Keynote & Competitor data) and incorporate their numbers on the financial dashboards. Implementation of various backend structures facilitating BI needs to show growth / comparison of financial numbers like quarterly YoY growth across various regions, durations and dimensions. Involved in developing a new ETL framework to facilitate instant click reporting by implementing storage and rendering of data using NoSql i.e. MongoDB. From September 2011 to February 2015 (3 years 6 months) Data Warehouse Technical Lead @ Worked as an ETL Engineer for Capital Group Companies, one of the largest investment management firm in the IDW (Investment Data Warehouse team). Developed ETL transformation using Informatica Powercenter (mappings, session, workflow) in creating various mappings focusing on SCD2 and SCD1 implementation to pull data from legacy systems on the new implementation. Scheduling of jobs using Autosys tool for triggering workflows to load dimensional data. From January 2011 to August 2011 (8 months) Datawarehouse Consultant @ Worked as an ETL Engineer in the accelerated Teradata migration project for Cisco System, inc to migrate data from Oracle to Teradata. Part of the EDW transformation projects for Telstra Corp. Created ETL jobs using Data Stage and writing ELT scripts on Teradata. Extensively worked on performance tuning on ETL scripts and eliminating redundant structures and generating an efficient pipeline for data flow. Construct data monitoring processes to alert engineering & business teams in case of any abnormality. Partnered with data architects, application developers, product managers, business partners and senior management in order to collaborate on project involving multiple teams. From March 2006 to January 2011 (4 years 11 months) Analyst @ Worked as a Pl/Sql developer for A.com application of Agilent Technologies. Developed various stored procedures & Scripts catering to the needs of the applications. Handling production related incidents and supporting them with root cause analysis. From August 2004 to March 2006 (1 year 8 months)

Certificate Program, Statistical Analysis with R Programming @ University of Washington From 2013 to 2013 Master's Degree in Computer Application @ University of Mumbai From 2001 to 2004 Bachelor's Degree in Science, Mathematics @ St. Xavier's College From 1997 to 2000 Kartik S. is skilled in: Data Warehousing, Informatica, Teradata, Business Intelligence, Business Objects, Datastage, ETL, SQL, PL/SQL, SDLC, Oracle, ETL Tools, Data Warehouse Architecture, Toad, Data Modeling