Amit Kaushik

Experience

• 

  HawksCode

  Jan 2014 - Aug 2016

  Software Engineer

  ▪ Created a database using SQL for an automobile major client.▪ Connected the data with on premise Java based UI for data visualization.▪ Requirement gathering from client, create objects like table, views, constraints, sequence using DDL and DML commands.▪ Data modelling, Design and maintain database schema.

• 

  WNS

  Nov 2016 - Aug 2017

  Sr. Program Analyst

  ▪ Oracle Database ETL Production Support and reporting▪ Data cleaning, Relational Transformation, and incremental loading▪ YTD, MTD, P/L reporting and visualization

• 

  WNS

  Sept 2021 - May 2024

  Analytics Lead Associate

  ▪ Collaborate with cross-functional teams to identify data requirements and develop data models for reporting and analytics.▪ Built and maintained efficient ADF Pipelines to extract, transform, and load data from multiple sources into ADLS Gen2▪ SQL, Python & PySpark coding in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to ready to tap data format.▪ Partitioning, Coalescing, joining techniques, and repartitioning to optimize the performance. Scheduling notebooks with ADF by applying dependencies between notebooks and passing the parameters.▪ Transforming and cleaning the DS tables in Databricks notebooks with SQL, PySpark, and Python code to generate the core layer (DWH) tables and storing them in delta format and using MERGE to UPSERT the data into the Data Lake tables. Show less

• 

  C5i

  Mar 2024 - now

  Senior Analyst

  ADE