Sharath Chand Zakkam

• Built and maintained ETL/ELT pipelines utilizing Cloud Storage, BigQuery, SQL, and Spark transformations.
• Implemented incremental loading strategies with watermarking to enhance pipeline stability and eliminate duplicate processing.
• Designed partitioned and clustered BigQuery tables, achieving 30%–40% improvement in query performance.
• Processed millions of records per load cycle for analytics datasets, prioritizing correctness and scalability.
• Developed analytics-ready models and curated datasets according to dimensional modeling principles.
• Created views and consumption layers to streamline access for reporting and analytics teams.
• Introduced data quality validation and reconciliation checks, cutting data-related production issues by approximately 35%.
• Identified inefficient query patterns and storage layouts, resulting in ~20% reduction in cloud query costs.
• Participated in production support and incident management, performing root cause analysis for data pipeline failures.
• Automated repetitive tasks to enhance workflow productivity

• Assisted in building and maintaining batch data pipelines on Google Cloud Platform under senior engineer guidance.
• Executed data ingestion from Cloud Storage into BigQuery using SQL-based ELT patterns.
• Developed SQL transformations to clean, standardize, and load data into staging and curated tables.
• Supported implementation of incremental data loads utilizing ingestion dates and watermark logic.
• Created and managed partitioned BigQuery tables to enhance analytics capabilities.
• Performed validation and reconciliation checks to ensure accuracy of loaded data.
• Identified and resolved data quality issues stemming from source inconsistencies or schema changes.
• Documented pipeline logic, table definitions, and data flow for knowledge sharing.

Progressed from Test Analyst to Technical Test Lead, overseeing enterprise-scale application testing.

Executed functional, integration, and regression testing for large-scale enterprise systems.

• Designed and implemented test strategies and plans based on business and release requirements.
• Built and maintained test automation frameworks, enhancing test coverage and confidence in releases.
• Led QA teams, managing task allocation, reviews, and defect triage across multiple releases.
• Facilitated collaboration among development, business, and QA teams to clarify requirements.
• Owned release sign-off and quality metrics to ensure stable production deployments.
• Developed expertise in root cause analysis, risk assessment, and resolving production issues.