Pavan Chari Rachakonda

Google Cloud Certified Professional Data Engineer with 4+ years of experience delivering enterprise-scale data modernization and migration solutions on Google Cloud Platform (GCP). Expertise in migrating large-scale workloads from legacy platforms including Teradata and SQL Server to BigQuery-based cloud architectures. Skilled in designing scalable ETL/ELT pipelines using BigQuery SQL, Python, Cloud Composer (Airflow), and Dataproc-based distributed processing frameworks while maintaining strict data quality, validation, and reconciliation standards.

Cloud Data Engineer (Developer) at Accenture (2022-02 – Present)

• Executed Enterprise Data Warehouse (EDW) modernization initiatives for the Health Insurance sector, migrating TB-scale workloads from SQL Server and Teradata to GCP BigQuery.
• Built, optimized, and operationalized ELT pipelines using BigQuery SQL, Python, and Cloud Composer (Airflow), enabling the daily processing of millions of records.
• Designed full-load and incremental ingestion strategies leveraging BigQuery and Dataflow & Dataproc-based distributed processing approaches, including CDC-based ingestion mechanisms to optimize migration windows and reduce processing overhead by ~30%.
• Optimized complex BigQuery workloads using partitioning and clustering techniques, improving query performance by ~35% and reducing overall cloud operational costs.
• Developed and implemented automated data validation, reconciliation, and quality-check frameworks to ensure data consistency, completeness, and migration accuracy across enterprise datasets.
• Managed source code via Bitbucket and engineered CI/CD pipelines using Jenkins to fully automate the deployment process.
• Assisted in implementing event-driven ingestion patterns using Pub/Sub to support scalable and near real-time data processing workflows.
• Supported the seamless transition of legacy IBM DataStage ETL workflows into cloud-native BigQuery architectures and assisted in post-migration stabilization activities.
• Supported metadata management and governance initiatives using GCP-native cataloging solutions for improved data discoverability and lineage tracking.
• Designed reporting dashboards in Looker to visualize migration metrics, pipeline health, and operational KPIs for key stakeholders.

Bachelor of Technology in Computer Science Engineering (CSE) – Sreyas Institute of Engineering and Technology (2017 – 2021)