About
GCP Data Engineer with 2 years of experience building production ETL/ELT pipelines that process large-scale customer data using BigQuery, PySpark, Python, and SQL. Delivered cost and performance improvements on BigQuery workloads through partitioning, clustering, and query optimization, while orchestrating reliable pipelines with Apache Airflow. Strong foundation in dimensional modelling, Snowflake schemas, and data-quality validation, with hands-on exposure to dbt and Apache Beam for modern transformation workflows. Comfortable owning the full pipeline lifecycle — ingestion, transformation, orchestration, and governance — across landing, staging, and history layers.
Skills & Expertise
No skills listed yet
Work Experience
Data Engineer
Cloud Storm Software Private Limited
Jan 2025 - Present
Built a Customer Data Ingestion solution for a Google Cloud Data Warehouse, supporting ETL extraction and transformation across 126 Teradata data sources. Developed scalable ETL/ELT batch pipelines using PySpark, Python, and SQL to ingest and transform 500M+ customer records (~1.5 TB of data) into GCP BigQuery. Managed 25+ GCS and BigQuery objects across landing, staging, and history layers, supporting historical and file-based loading of ~5 TB of data. Improved BigQuery query performance by ~25% and reduced processing cost by ~20% through partitioning, clustering, and optimized SQL. Orchestrated production pipelines using Managed Apache Airflow, reducing manual monitoring effort by automating dependency management, failure alerts, and reruns across 15+ DAGs. Implemented automated data-quality checks (null detection, duplicate handling, schema validation, source-to-target reconciliation), reducing data discrepancies reaching downstream teams by ~25%. Applied fact/dimension modelling and Snowflake schemas; built Authorized Views to enable secure, governed self-serve access for 5+ downstream teams. Used dbt and Apache Beam for transformation workflows alongside Git-based version control and Cloud Shell/Unix scripting for environment automation.
Business Intelligence Intern
Null Class Edutech Private Limited
Aug 2024 - Jan 2025
Processed and cleaned 100,000+ Twitter engagement records using SQL and Excel, improving downstream reporting accuracy and consistency. Built an interactive Power BI dashboard tracking impressions, likes, retweets, and engagement KPIs, cutting manual reporting time by ~4 hours/week. Applied Power BI forecasting on time-series data to project engagement trends 12 months forward. Designed relational data models in Power BI to support efficient multi-table querying and visualization.
Education
Bachelor of Commerce in Business Analytics - St. Ann's College for Women, Osmania University
2022 - 2025 · Afghanistan
Certifications
No certifications added yet
