
LEAD ENGINEER-I
CitiusTech Healthcare Private Limited · Apr 2025 – Present
- Designed and developed metadata-driven ETL/ELT pipelines using Azure Data Factory (ADF), Azure Databricks, PySpark, and Azure Synapse Analytics for scalable healthcare data integration.
- Engineered complex transformation logic using SQL Stored Procedures, aligning business rules to deliver high-quality data to target tables and file-based outputs.
- Developed SQL Stored Procedures, Functions, and transformation logic to process data across Stage, Ingress, and Egress layers.
- Built and optimized PySpark and Spark SQL notebooks for data ingestion, transformation, validation, and automated generation of client-specific Egress files.
- Automated vendor-specific file generation processes using SQL Stored Procedures, supporting multiple client facilities and improving operational efficiency and consistency.
- Engineered Ingress frameworks to ingest data from SFTP/ADLS, perform historical backfill loads, automate file validation, and ensure reliable end-to-end data processing.
- Orchestrated end-to-end data workflows using ADF, integrating Databricks notebooks, SQL procedures, and multi-source data pipelines into Azure Synapse Analytics.
- Used Azure DevOps to manage Agile/Kanban boards, track PBIs, maintain project documentation, and coordinate production support activities.
- Managed production ETL operations by monitoring pipeline health, resolving job failures, performing root cause analysis, implementing corrective actions, and ensuring reliable end-to-end data processing.
- Supported Microsoft Fabric migration by assessing ETL workflows, validating migration readiness, documenting data assets, and assisting in migration planning and testing.
- Partnered with business and cross-functional teams to deliver client enhancements, implement change requests, prepare technical documentation, and support seamless production deployments.


