Kavtech Pvt Ltd.
|Senior Data Engineer
Islamabad, Islamabad Capital Territory, Pakistan
Summary
Led the migration and optimization of critical ETL pipelines, significantly boosting data performance and ensuring seamless data access for diverse business applications.
Highlights
Migrated over 15 legacy ETL pipelines to Microsoft Databricks, boosting data processing performance by up to 60% and significantly reducing maintenance overhead.
Engineered over 40 robust ETL workflows to ingest complex ad-marketing and CRM data from multiple sources into Databricks Unity Catalog, ensuring centralized governance and seamless data access.
Developed more than 20 modular ELT models using DBT on Snowflake, reducing query runtimes by 40% and enabling near real-time marketing performance insights.
Automated data quality checks and incremental loads for CRM and ad data pipelines, increasing data reliability by 70% across 5+ downstream Power BI reports.
Achieved 30% cloud cost savings by redesigning data flows and optimizing Spark SQL queries.