Shivansh Kumar Email & Phone Number

Bengaluru, Karnataka, India

Bangalore Urban, Karnataka, India

Working on a long running project for European pharmaceutical giant as a Data Engineer and Business Analyst.Developing and maintaining PySpark SQL pipelines-Created and maintained pipelines for ingesting data from S3 buckets, processing the data to convert them to business usable metrics and load them onto S3 again for further processing.Preparing data requirements for business use cases-Coordinated with the client data team to create and maintain Technical Requirement Document for each Dataset used for ETL process based on the business requirements.SQL views creation for analysis-Writing complex SQL queries to create the views in Hive which are further utilized for ad-hoc analysis and finding insights.Providing UATs for clients-Performed end to end acceptance testing of pipelines. Co-ordinated with client teams to validate the test and integrate any feedback into the pipeline process.Main lead for implementing Change Requests for the existing ETL processes-Acted as sole point of contact for gathering requirements for CRs from client team, implementing the CRs and validating the changes with client team.