Lakshmi Punugoti

About Lakshmi Punugoti

I am a results-driven Data Engineer with 6+ years of experience designing and optimizing ETL pipelines, big data architectures, and cloud-based solutions. My expertise in Apache Spark, Hadoop, SQL, Azure data Factory, AWS, and Databricks has enabled me to. Migrate 1TB+ datasets to cloud platforms, improving efficiency and scalability. Reduce ETL processing time by 40% using Spark optimizations. Cut cloud costs by 20% through efficient data pipeline strategies. Automate data workflows, reducing manual effort by 30%.Key Expertise. Big Data & ETL Pipelines – Apache Spark, Hadoop, PySpark. Cloud Platforms – Azure Data Factory, AWS S3, Databricks. Data Architecture & Modeling – SQL, PostgreSQL, Data Warehousing. Performance Optimization – Query tuning, indexing, pipeline efficiencyI am actively seeking Data Engineer opportunities in the USA. If you\'re hiring, let\'s connect!

Experience

1. Software Engineer Lll

   Lenovo

   May 2023 — Present · US

   Designed and implemented end-to-end data pipelines on Google Cloud Platform using Cloud Storage (GCS), Dataflow, Pub/Sub, BigQuery, and Cloud Composer for orchestration. •Built ELT workflows in Dataform / DBT on BigQuery leveraging incremental models and modular SQL transformations to optimize refresh cycles and lower cost. Developed optimized BigQuery datasets using partitioning and clustering strategies that reduced query scan cost by 60 % and improved performance for analytical workloads.Automated data validation and reconciliation using Python scripts with the google-cloud-bigquery library, ensuring accuracy and schema consistency across stages. Implemented incremental load patterns (MERGE-based) and change-data-capture logic to support near-real-time updates across multiple business domains.

Education

• Vignan Institute of Technology and Science

  Bachelor's degree, Electrical, Electronics and Communications Engineering