Rohit

• Led data migration from legacy on-prem systems to cloud architecture, designing transformation pipelines to modernize healthcare data workflows.

• Built scalable ingestion pipelines using Azure Data Factory, ADLS, Databricks, and Synapse to support real-time and batch processing.

• Oversaw a team of three engineers as lead, ensuring high‑quality delivery of migration and transformation components.

• Designed reusable parameterized ETL frameworks with CI/CD deployment, automated monitoring, and scheduling.

• Implemented complex business rules including cleansing, schema mapping, deduplication, and standardization.

• Collaborated with cross‑functional cloud and product teams to ensure compliance with healthcare data governance.

• Leading the migration to Microsoft Azure cloud using ETL/ELT processes.
• Building data migration and transformation pipelines using Azure Data Factory and Azure.
• ADF using Linked Services to Extract, Transform and load data from different sources like Azure SQL, Blob storage also schedule and automate the processes with the help of Azure Logic Apps.
• Developed the Synapse data warehouse to maximize the performance benefits.
• Designed data model based on client requirements.
• Collecting data and generating periodic reports and carrying out value added analysis of reports to facilitate strategy planning.
• Migrated and cleaned data from ADLS to Synapse and created silver and gold tables from raw data.
• Responsible for maintaining the pipelines.
• Migrating on premises to Azure Synapse dedicated SQL pool and do lift and shift all existing on premises reports, ETL to the cloud.
• Experience in Migrating databases from On Premise SQL Server to ADLS using Self Hosted Integration Runtime.
• Configured Email alerts using Azure Monitor Alerts and Logic Apps.
• Worked on Agile methodology and participated in daily Scrum Meetings and Demo Meetings.
• Accurately maintained, transferred, and processed home data in different databases by developing VBA and SQL script.
• Skilled in identifying problems through data, defining ambiguous and complex problems, and solving problems.
• Analyzing complex data from multiple sources, responsible for detecting problems with the database and suggesting improvements that will have immediate impact.
• Designed and maintained Kafka-based streaming pipelines to ingest and process high-volume, real-time data for analytics and downstream systems.
• Implemented event-driven architectures using Kafka topics, producers, and consumers to enable scalable and fault-tolerant data flows.
• Optimized Kafka performance through partitioning strategies, consumer group tuning, and monitoring to ensure low-latency processing.
• Extensive experience in Extraction, Transformation and Loading of data using SSIS from heterogeneous sources.
• Involved in Creation of Dimensions using Star and Snowflake Schema in SQL Server Analysis Services (SSAS).

• Designed and developing SSIS packages using different transformations like Conditional Split, Multicast, Union-All, Merge, Merge Join and Derived Column.
• Responsible for supporting existing SSIS packages and SSRS reports.
• Identifying the bottlenecks (in sources, targets, and packages) and tuning it.
• Experience in developing SQL queries and stored procedure based on the business requirement.
• Experience in performance tuning of the SQL queries.
• Interaction with the client/ business analyst to understand the requirement.
• Analyzed data if a user reports any issue. Verified the data granularity. Fixed the production issues.
• Handled an ETL migration activity from ADF V1 to ADF V2.
• Created SSIS packages to clean and load data to data warehouse.
• Responsible for maintaining the pipelines.
• Analyzing complex data from multiple sources, responsible for detecting problems with the database and suggesting improvements that will have immediate impact.
• Build operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data using Power BI together with Azure Analysis Services.
• Used Terraform to provision and manage cloud infrastructure as code, ensuring consistent and repeatable deployments across environments.
• Built and maintained reusable Terraform modules for scalable data platforms, improving deployment speed and reducing configuration drift.
• Deployed SSRS reports to share point server and used Excel services in Share point application.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Was in charge of managing a cloud-based data warehouse and overseeing tasks such as data ingestion and development utilizing various Azure technologies such as Azure Databricks, Azure SQL, and Azure Data Factory.