Prathusha Yanda

Prathusha Yanda

Data Engineer
United States of America

About Me

Over four years of experience as Data Engineer with proficient in building and maintaining robust data pipelines for processing large-scale structured and unstructured data.

• Proficient in Cloud Technologies with extensi…

Experience

Data Engineer

PNC Financial Services
Jan 2024 - Present · 2 years 6 months

Designed and implemented ETL workflows using Apache Spark and Python, resulting in a significant reduction in data processing time and improved accuracy.
Developed a Power BI dashboard to visualize key business KPIs, streamlining reporting processes and saving 2 hours weekly.
Led the execution of data engineering projects annually, leveraging Python, PySpark, Apache Airflow, Databricks, Redshift, Snowflake, and AWS to ensure robust and scalable data pipelines.
Utilized Spark SQL for efficient loading of 10 tables into HDFS, achieving sub-3-second query response times.
Implemented AWS Data Pipeline workflows to optimize data extraction, transformation, and loading, reducing processing time by 10%.

Data Engineer

Draxo Infotech
Jan 2019 - Dec 2022 · 3 years 11 months

Established real-time analytics capabilities in Snowflake, enabling agile decision-making for business stakeholders.
Spearheaded the optimization of ETL workflows using Apache Spark and Python, achieving a 30% reduction in data processing time.
Implemented performance enhancements in Snowflake, including materialized views and data masking techniques, resulting in 25% faster queries and improved data security.
Managed and automated ETL pipelines using AWS Glue, ensuring seamless data ingestion and transformation across complex data environments.
Enhanced PySpark scripts to streamline data ingestion from various sources, reducing execution time by 20% while maintaining data integrity.
Deployed Apache Spark workloads on Databricks, realizing a 30% cost reduction compared to on-premise clusters through efficient resource management.
Optimized Spark Streaming processes for real-time data processing from Kafka, integrating state-of-the-art transformations for actionable insights.
Implemented automated data processing workflows on AWS Athena, enhancing scalability and processing efficiency by 24%.

Skills

Hadoop Spark Apache Hive Apache Pig Kafka NoSQL Redshift S3 Scala Python SQL Eclipse IntelliJ IDEA PyCharm Jupyter Notebook Visual Studio Code MapReduce Hive HDFS Apache Spark Apache Kafka PySpark Apache Airflow Sqoop Flume Databricks NiFi Oozie Zookeeper Apache Flink AWS EMR EC2 RDS Glue Lambda SDK DynamoDB Elasticsearch Pipeline QuickSight Kinesis Athena VPC CloudWatch CloudFormation Route53 Docker BigQuery Cloud SQL Cloud Composer Cloud Storage Dataflow Data Fusion Dataproc
Report this Profile?