Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
Personal Information
Timeline
Generic

Aditya Pawan Kumar

Hyderabad

Summary

Accomplished Big Data Engineer with a proven track record at Oracle, enhancing data accessibility by 25% through innovative ELT pipeline development. Proficient in PySpark and SQL, I excel in data engineering and pipeline design, demonstrating strong leadership and problem-solving skills in high-stakes environments.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Big Data Engineer

Oracle
Hyderabad
06.2022 - Current
  • Company Overview: Project Title: Oracle LSGBU - ClinicalOne Datahub.
  • Worked extensively on developing and maintaining ELT data pipelines for extracting, loading, and transforming data from various sources into the target, resulting in a 25% increase in data accessibility.
  • Experience with tools such as PySpark SQL, Databricks, Oracle SQL Developer, and Hive.
  • Performance tuning of pipelines and databases for efficient analysis, and creating table schemas using extract, transform, and load (ETL) methods.
  • Key achievements: Supported 11 new sources of data brought into the data warehouse over a 30-month period.
  • Project Title: Oracle LSGBU - ClinicalOne Datahub.

Big Data Developer

Brillio
Bengaluru
06.2021 - 06.2022
  • Managed Bayer project at IQVIA, leading a team of 12 to deliver on key performance metrics.
  • Tools: Hadoop, Hive, Impala.
  • Have worked in Extract Transform and Load in Big data on Hadoop using Hive.
  • Good experience in using big data tools like - Hive, Impala, Spark through Scala for day to day activities.
  • Additionally, have used other applications such as JIRA, putty, DBeaver.
  • Performed batch-processing of huge data based on the requirements using Hive.

ETL Developer

Cognizant
Chennai
01.2014 - 05.2021
  • Worked on various ETL development projects in Healthcare and Banking sectors.
  • Led fund accounting data warehouse project for Client Northern Trust to re-engineer platforms for enhanced client reporting, focusing on operational data extraction and management from GIO (Invest One) - [VSAM and DB2] and AIP.
  • Utilized Datastage for data extraction, leveraging configuration tables for extract generation and employing Data Stage for staging table loads and schema file creation.
  • Designed and implemented staging process to load data into ODS tables, ensuring data integrity and consistency.
  • Have experience of working with Informatica for HeathFirst Insurance Company for all the ETL tasks and day to day basis that was later used by reporting team.
  • Created shell scripts to fine-tune the ETL flow of the Informatica workflows.
  • Building and updating store procedures based on new requirements and updated acceptance criteria.

Education

EEE - Electrical and Electronic Engineering

GRIET
Location
05.2019

12th - Math and Science

Board of Intermediate
Hyderabad
01.2009

Skills

  • Databricks
  • Data engineering
  • Data warehousing
  • PySpark and Scala
  • SQL and Oracle SQL Developer
  • Shell scripting
  • Data pipeline design
  • ETL processes

Certification

  • Diploma certification in AWS Cloud computing
  • Certified scrum master
  • Microsoft certified: al-100 azure fundamentals

Accomplishments

  • Bagged 'Xtra mile award' for the Q2, 2018, a recognition provided in regards to delivering the project along with the updated requirements within the deadlines.

Languages

  • English, Advanced
  • Hindi, Advanced
  • Tamil, Beginner
  • Telugu, Advanced

Personal Information

Title: Data Engineer

Timeline

Big Data Engineer

Oracle
06.2022 - Current

Big Data Developer

Brillio
06.2021 - 06.2022

ETL Developer

Cognizant
01.2014 - 05.2021

EEE - Electrical and Electronic Engineering

GRIET

12th - Math and Science

Board of Intermediate

Similar Profiles

CREATE PROFILE
Aditya Pawan Kumar