DATAECONOMYSenior Data Engineer
Sep. 2022India, PuneLed end-to-end modernization of legacy DB2/Mainframe systems, implementing Delta Lake with Medallion Architecture to build high-performance Apache Spark pipelines on Databricks.
Designed and developed scalable ETL solutions using Azure Synapse Analytics, ADF, Azure Logic Apps, Databricks, PySpark, and Python to ingest, transform, and load large data volumes into Delta Lake and Hive metastore.
Migrated and optimized banking pipelines from DataStage to Databricks, Snowflake, and AWS Redshift, improving reliability, scalability, and cost efficiency.
Built and tuned Snowflake data models with clustering, partitioning, and materialized views to accelerate query performance and analytics for business stakeholders.
Developed Python-based data validation frameworks and utility scripts to automate data quality checks, reconciliation, and ETL orchestration, reducing manual intervention by 40%.
Owned the migration of legacy WebFocus reports and ETL workloads to Power BI and Dataiku workflows, enabling advanced reporting, cloud-native transformations, and self-serve analytics.
Architected Power BI data models using star and snowflake schemas to deliver interactive dashboards with embedded capabilities and secure Row-Level Security.
Spearheaded migration of SSIS pipelines to Azure Databricks, ADF, and Synapse, optimizing large-scale data loads and reducing ETL runtime significantly.
Collaborated with stakeholders to define requirements, implement automated data-quality checks, and set up monitoring alerts for pipeline failures using Python and Databricks jobs.
Authored comprehensive documentation and runbooks for onboarding and troubleshooting, recognised by senior leadership for clarity and completeness.
Created automation runbooks and orchestrated jobs using Control-M and Autosys, streamlining ETL operations across hybrid environments.
Developed PoCs to validate business cases such as Power BI embedding, real-time reporting, and Python-based ETL utilities.
Followed CI/CD best practices by leveraging Git, Bitbucket, and Azure DevOps for version control, testing, and automated deployment pipelines.