Open to opportunities

SHAIK SONY

@shaiksony

Message

Data Engineer crafting scalable Azure ETL/ELT pipelines and Lakehouse models with performance and cost optimization.

India

Message

What I'm looking for

I want a role where I can build scalable Azure Lakehouse ETL/ELT pipelines, strengthen dimensional models and governance, and keep improving performance and cost. I’m also excited to apply Python and GenAI/Agentic automation to streamline data workflows.

I’m a Data Engineer with 4.5+ years of experience designing and implementing scalable ETL/ELT pipelines and data integration strategies across Azure, Databricks, Apache Spark, SQL, and Delta Lake. I bring strong dimensional data modeling (Star/Snowflake), Medallion architecture, and practical BI delivery through interactive Power BI dashboards, with a focus on data governance and reliability.

In my current role, I designed and deployed 50+ Azure Data Factory pipelines processing 1TB+ of data monthly, implementing SCD-Type2, CDC, and incremental load strategies. I migrated 1TB+ Teradata workloads into Azure Databricks Lakehouse using PySpark/SparkSQL and Delta Lake, reducing pipeline runtime by 50%+ and achieving 30% cost reduction through CDC-based loads, Auto-Optimize, and cluster autoscaling—while also automating workflows with REST APIs and Webhooks as I expand my Python and Generative/Agentic AI exposure for pipeline automation.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

EverestDX

Dec 2022 - Present (3 years 7 months)

Designed and deployed 50+ Azure Data Factory pipelines processing 1TB+ of data monthly, implementing SCD-Type2, CDC, and incremental load strategies. Migrated Teradata workloads to Azure Databricks Lakehouse and reduced pipeline runtime by 50%+ while cutting costs by 30% using CDC-based loads and performance tuning.

Data Modeller and SQL Developer

EverestDX

Dec 2021 - Dec 2022 (1 year)

Engineered high-performance stored procedures and functions to support scalable ETL and dimensional modeling, including star/snowflake schema design and batch processing logic. Built and maintained Power BI data models, and performed data modeling and data stewardship to ensure data quality, consistency, and governance.