Pruthviraj Ganji

Sr Data Engineer @Bank of America

NY, US

Led the design and implementation of cloud-based data solutions, ensuring high availability, scalability, and cost-efficiency for large-scale data processing environments. Architected and optimized ETL pipelines for seamless integration, transformation, and loading of data from various sources into cloud data lakes and warehouses. Designed and developed highly scalable data pipelines using AWS services such as EMR, Glue, Lambda, and S3, optimizing data workflows for real-time analytics. Automated data infrastructure deployment using Terraform, enabling faster provisioning, consistent environments, and reduced manual intervention. Leveraged AWS Redshift and RDS to implement high-performance data warehouses and relational data stores, improving data accessibility and query performance. Implemented cloud-native solutions using serverless architectures such as AWS Lambda and Azure Functions, optimizing for cost and scalability. Designed and developed data lakes on AWS S3 and Azure Blob Storage, enabling efficient storage and retrieval of massive datasets. Designed data models using Star and Snowflake schemas in Redshift and Azure Synapse Analytics, optimizing for analytical workloads. Led the integration of machine learning models into data pipelines, enabling predictive analytics using AWS SageMaker and Azure ML. Enhanced data fetching and query performance by optimizing SQL queries, indexing strategies, and data partitioning. Developed complex SQL scripts for data transformation and aggregation, improving efficiency in large-scale data processing. Integrated and optimized data lakes with AWS Athena and Azure Data Lake Analytics for faster querying of raw, unstructured data. Automated data validation and cleansing processes using Python and Airflow, improving data quality and reducing manual intervention. Created custom data reports and dashboards using Power BI and Tableau, enabling business users to visualize data trends and key metrics.

JNTUH College of Engineering

Bachelor of Technology - BTech