Venkata Ashok Akkim
Hyderabad
Summary
IT professional with 4 years of experience in Data Engineering with strong hands-on exposure in Python, SQL, Pandas, Matplotlib, NumPy, PySpark, Airflow, and Databricks. Experienced in building end-to-end ETL pipelines, data validation frameworks, Delta Lake architectures, and AWS-based data processing solutions. Skilled in DBeaver, Redshift, data formatting, data manipulation, and validating large volumes of data. Strong ability to learn new technologies and adapt quickly in fast-paced environments.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer
Amgen
10.2024 - Current
- Automated ETL processes for Multi-Channel Marketing (MCM) analytics, improving efficiency, data accuracy, and reporting capabilities across millions of records.
- Automated ETL workflows using Databricks, Airflow, S3, and Redshift reducing manual work.
- Ingested data from SQL sources and Salesforce API using Python, creating analytical data views.
- Analyzed and reproduced production issues while collaborating with source teams.
- Responsible for data cleaning, formatting, loading, and validating data between source and target systems.
Data Engineer
Amgen
06.2023 - 09.2024
- The purpose of the project is to collect vendor-uploaded files from S3, process them to create a transformation layer with audit columns, and then apply business rules to generate an enrich layer.
- Final enriched S3 outputs are delivered to downstream teams.
- Ingested vendor files from S3 and created transformation layers enriched with audit metadata.
- Applied business rules using joins, window functions, and aggregate transformations for Enrich layer creation.
- Delivered enriched datasets to downstream consumers via S3 integration.
- Handled production pipelines, resolved on-the-go production issues, and ensured stability.
- Connected with stakeholders to gather business rules and convert them into PySpark logic.
- Contributed to enhancements and performance improvements in ETL workflows.
Data Engineer
Amgen
01.2022 - 05.2023
- Migrated and transformed clinical and operational data from an on-premises CDMS network folder into Databricks using an S3-mounted path.
- Built Delta Lake tables to enable scalable, version-controlled storage.
- Created logical views for analytics and reporting teams including SAS integrations.
- Ensured faster data access, improved reliability, and seamless downstream consumption.
- Designed and implemented pipelines to ingest raw CDMS files into Databricks via S3 mount.
- Created and managed Delta Lake tables supporting ACID transactions and schema evolution.
- Built logical business views on top of Delta layers for analysts and SAS developers.
- Automated ingestion processes using PySpark notebooks and Databricks workflows.
- Implemented robust data validation and QC checks ensuring consistency and accuracy.
- Collaborated with analytics teams to align data models with reporting needs.
- Performed performance optimization for PySpark and SQL workloads.
- Ensured adherence to data governance, audit requirements, and access control policies.
- Amgen is a global biotechnology leader specializing in biologic medicines.
Education
B.Tech -
VEL TECH Deemed to be University
12.2020
Skills
- Windows, Mac, and Linux
- Data visualization with QuickSight and Tableau
- Programming in Python and PySpark
- Database management with SQL, MySQL, and PostgreSQL
- Cloud services with Amazon Web Services (AWS)
- Data processing with Databricks
- Storage solutions using S3
- Data warehousing with Redshift
- Compute services with EC2
Certification
- Databricks Certified Data Engineer Associate
- AWS Certified Solutions Architect Associate
- PCEP - Certified Entry-Level Python Programmer
Timeline
Data Engineer
Amgen
10.2024 - Current
Data Engineer
Amgen
06.2023 - 09.2024
Data Engineer
Amgen
01.2022 - 05.2023
B.Tech -
VEL TECH Deemed to be University