Siddamreddy Satheesh Reddy

As a Senior Data Engineer, I am driven by a pragmatic ambition to master complex data challenges, always seeking to optimize systems and processes. My diligent and resourceful approach ensures I consistently deliver logical, high-quality solutions, reflecting my commitment to continuous improvement and practical outcomes.

Experience

Senior Data Engineer

AION-TECH SOLUTIONS LIMITED · Present

Not yet confirmed

A

Senior Data Engineer

Aion Tech Solutions Ltd · Jan 2023 – Present

Not yet confirmed

• Migrated on-premises maritime databases to Snowflake using Fivetran and Azure Data Factory (ADF).
• Redesigned legacy schemas into star schema model.
• Achieved 40 percent reduction in pipeline processing time and 60 percent improvement in query performance.
• Built Matillion ETL workflows for multi-source data ingestion into Snowflake.
• Implemented Snowpipe, Dynamic Tables, Streams, Stored Procedures, and Tasks for real-time CDC.
• Developed Databricks PySpark pipelines using Bronze Silver Gold Delta Lake Medallion Architecture.
• Integrated 20 plus external REST APIs via Snowflake External Access Integration and Snowpark.
• Automated Databricks to SQL Server data loads via JDBC connection.
• Built Power BI dashboards for voyage analytics, fuel consumption, and vessel performance reporting.
• Designed RAG architecture using Snowflake Cortex Search and vector search on vessel logs and operational reports.
• Implemented NL2SQL to enable business users to query Snowflake using plain English.
• Deployed AI anomaly detection on fuel and sensor telemetry using Cortex AI functions including COMPLETE, SUMMARIZE, SENTIMENT, EMBED_TEXT.
• Built end-to-end Databricks PySpark and Delta Lake data pipelines.
• Implemented enterprise RBAC, data lineage, governance, and CI/CD.
• Delivered Streamlit dashboards for real-time vessel monitoring and positioning.
• Designed and built ELT pipelines using Fivetran to integrate LinkedIn Ads, Salesforce, Google AdSense, Google Search Console, Instagram Ads, Facebook Ads, Twitter Ads, Adobe Analytics, and Marketo into Azure Synapse Analytics and Microsoft Fabric.
• Developed transformation logic, KPI calculations, and business rules in Azure Synapse Analytics for downstream BI reporting and stakeholder dashboards.
• Led end-to-end Snowflake data warehouse migration.
• Converted 700 plus stored procedures.
• Migrated data from VectorWise and SQL Server to Snowflake using Pentaho.
• Performed data validation using checksum functions and row-count reconciliation.
• Implemented CDC using T-SQL and SQL Server Change Tracking.
• Designed and deployed AWS pipeline infrastructure including S3, IAM, Lambda, EventBridge, SNS, VPC, and API Gateway to automate ingestion of 20 external API integrations.

A

Senior Consultant

Apps Associates · Jan 2022 – Jan 2023

Not yet confirmed

• Integrated Salesforce, Google Analytics, and Google AdWords into Snowflake using Fivetran.
• Built Matillion ETL workflows for data ingestion and transformation.
• Converted semi-structured JSON files into Snowflake VARIANT data types and relational tables for Tableau reporting and dashboards.

Snowflake Developer

Hexaware Technologies · Sep 2021 – Jan 2022

Not yet confirmed

• Built data pipelines from Azure Blob Storage to Snowflake using Snowpipe and bulk loading.
• Developed T-SQL stored procedures and Informatica IICS ETL workflows for data transformation, data cleansing, and aggregation.
• Delivered Power BI reporting dashboards for healthcare and insurance data.