Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

ADITYA KAMISHETTY

Catonsville,MD

Summary

Results-driven Data Engineer with 6+ years of hands-on experience (including academic and professional projects) in building scalable data pipelines, designing robust data architectures, and delivering high-impact insights across diverse industries. Skilled in leveraging modern technologies, including cloud platforms (AWS, Azure), big data frameworks (Apache Spark, Kafka), and advanced analytics to optimize data workflows and support strategic decision-making. Adept at collaborating with cross-functional teams to translate complex business requirements into efficient, production-grade data solutions. Proven expertise in ETL/ELT development, data modeling, and data visualization using tools like Power BI and Tableau, with a focus on migrating legacy systems to cloud-native environments and reducing processing times by up to 40%.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Engineer

Nationwide
05.2024 - Current
  • - Architected ETL pipelines using AWS Glue and PySpark, migrating Oracle data to Redshift, processing 2PB+ data and cutting migration time by 50% via Agile iterations.
  • - Implemented real-time streaming with Kafka and Spark Streaming, ingesting data to DynamoDB, enabling near-real-time analytics for investment KPIs and reducing latency by 30%.
  • - Optimized Snowflake warehouses with DBT models, running complex queries to analyze trends, resulting in 25% faster reporting for stakeholders.
  • - Built serverless solutions with Lambda, API Gateway, and S3, integrating CI/CD via GitHub and EC2 for scalable deployments, achieving 99% uptime.
  • - Developed Power BI/Tableau dashboards tracking equities, fixed income securities, and derivatives, supporting data-driven decisions and reducing manual reporting by 40%.
  • - Led Agile teams in automating unit and end-to-end testing frameworks, ensuring high-quality code and minimal production issues.
  • Environment: AWS Glue, PySpark, Redshift, Snowflake, Kafka, Spark Streaming, Spark SQL, Power BI, Tableau, Lambda, API Gateway, DynamoDB, Airflow.

Data Engineer

FannieMae
05.2023 - 04.2024
  • - Developed and maintained Amazon Redshift data warehouses, supporting complex risk assessment analyses and reducing query times by 35%.
  • - Led data quality checks and monitoring implementations, ensuring 99.9% data accuracy and compliance with regulations.
  • - Optimized processing pipelines using Spark and Hadoop, handling petabytes of data and cutting processing time by 40%.
  • - Collaborated with data scientists to deploy ML models for fraud detection, integrating with Kafka for real-time integration.
  • - Built cloud-based data lakes on AWS S3, automating extractions with Sqoop and performing transformations via Pandas/NumPy.
  • - Created Tableau/Power BI dashboards for KPIs, enabling self-service analytics and mentoring junior engineers on best practices.
  • Environment: Python, Spark, SQL, Redshift, Airflow, AWS, S3, Tableau, Power BI, Git, Sqoop, Kafka, Pandas, NumPy, Hadoop.

Data Engineer

Accenture: Client: Carlsberg
06.2019 - 12.2021
  • - Designed scalable ETL processes with Informatica PowerCenter, Talend, and NiFi, loading data into centralized repositories and improving workflow efficiency by 45%.
  • - Built Python/SQL pipelines for batch and near real-time processing, integrating REST APIs to enrich datasets for business intelligence.
  • - Optimized legacy ETL pipelines, reducing latency by 30% and implementing data quality validations with alerting frameworks.
  • - Maintained Snowflake schemas with partitioning/clustering, supporting high-performance analytics and regulatory compliance.
  • - Developed Kafka-based streaming for IoT data, collaborating with teams to deploy Tableau dashboards for executive visibility.
  • - Migrated workflows to cloud-native solutions using Docker, enhancing maintainability and deployment speed.
  • Environment: Informatica PowerCenter, Talend, Apache NiFi, Python (Pandas, NumPy), Tableau, SQL Server, PostgreSQL.

Data Engineer

Techno Reach
12.2018 - 05.2019
  • - Built scalable ETL pipelines with Azure Data Factory, Databricks, and PySpark, processing structured data and optimizing Delta Lake on ADLS Gen2.
  • - Provisioned Azure resources via Terraform, designing modular ETL frameworks with validations and audit logging.
  • - Integrated REST APIs and third-party sources, implementing data quality checks monitored via Azure Monitor.
  • - Enforced data governance policies, supporting analytics teams with cleansed datasets in Power BI and PostgreSQL.
  • - Automated workflows with Databricks Jobs and cluster scaling, reducing costs by 25%.
  • Environment: Azure Data Factory, Databricks, PySpark, Terraform, ADLS Gen2, Power BI, PostgreSQL, SQL, REST APIs.

Education

Master's - Data Science

University of Maryland Baltimore County
05.2023

Bachelor's - Computer Science

Sreenidhi Institute of Science and Technology
03.2019

Skills

  • - Programming: Python, Java, C#, UNIX Shell Scripting
  • - Databases & Tools: SQL, MySQL, PostgreSQL, MongoDB, NoSQL
  • - ETL/Orchestration: Apache Spark, Kafka, Airflow, Azure Data Factory, AWS Glue, Lambda, Informatica PowerCenter, Talend, NiFi
  • - Cloud Platforms: AWS (EMR, EC2, Redshift, RDS, Step Functions, DynamoDB, Athena, SNS, SQS, S3), Azure (Databricks, Synapse Analytics, Data Lake Storage, Blob Storage)
  • - Data Warehousing: Snowflake, AWS Redshift, Oracle Data Warehouse
  • - Visualization & Analysis: Power BI, Tableau, Matplotlib, Pandas, NumPy, Scikit-learn, Excel
  • - Other: Hadoop, Git/GitHub/GitLab, Jenkins, Flyway, Azure Monitor, AWS CloudWatch

Certification

AWS Certified Data Engineer – Associate (Link) | 2024-09 – 2027-09

Timeline

Data Engineer

Nationwide
05.2024 - Current

Data Engineer

FannieMae
05.2023 - 04.2024

Data Engineer

Accenture: Client: Carlsberg
06.2019 - 12.2021

Data Engineer

Techno Reach
12.2018 - 05.2019

Bachelor's - Computer Science

Sreenidhi Institute of Science and Technology

Master's - Data Science

University of Maryland Baltimore County

Similar Profiles

CREATE PROFILE
ADITYA KAMISHETTY