prakhar mishra

Lead Data Engineer

Led cloud data movement with Azure Data Factory, architecting pipelines that moved data from Snowflake to ADLS and delivered 100+ DDS files, cutting execution time by 70%. Automated recurring data loads and file hand-offs using ADF events, eliminating 30 minutes of daily manual intervention.

Azure Data FactorySnowflakeADLSSSISTIBCODataSelf ETLC#SQL ServerOAuthREST APIsMicrosoft Entra IDAgileScrum

Senior / Lead Data Engineer & Analytics Specialist

Led architecture of the SSOT data model, consolidating aviation data from three systems into an ID-driven snowflake schema. Developed Databricks pipelines achieving 100% post-migration reconciliation and optimized T-SQL workloads, cutting report generation time by 35%.

DatabricksADLST SQLTableauRLSRobotic Process AutomationKatalon StudioDimensional Modeling (Star And Snowflake Schemas)Data Modeling

Senior Tableau & SQL Developer

Led delivery of 30+ SQL-backed reports and 20+ interactive Tableau dashboards, enabling leadership to identify growth sectors and lift sales opportunities by 15%. Owned Tableau Server publishing, governance, and access controls for 100+ decision-makers.

TableauSQLData VisualizationReporting

Lead Data Integration Engineer / Technical Lead

Tata Consultancy Services

Directed the SDLC of enterprise ETL pipelines spanning SSIS, SQL Server, and Informatica PowerCenter, turning business requirements into scalable frameworks with 100% on-time delivery. Ran a zero-downtime Informatica PowerCenter upgrade and refactored legacy DTS jobs, cutting run times 40%.

SSISSQL ServerInformatica PowerCenterSCDETLData WarehouseAgile

Business Intelligence & Analytics Consultant – MSBI Senior Developer

Tata Consultancy Services

Partnered with business analysts to convert requirements into technical specs and scalable ETL architecture. Modernized legacy SSIS packages and SQL Server 2000 DTS jobs, cutting batch runtime 40% via T-SQL tuning.

SSISSQL ServerT SQLETLData WarehouseMSBI

Technical Consultant – Informatica Solution Expert

Tata Consultancy Services

Built mappings, mapplets, sessions, and workflows in Informatica PowerCenter alongside business analysts and data solution engineers. Applied SCD Type 1, 2, and 3 logic to track historical changes across core warehouse targets.

Informatica PowerCenterSCDETLData WarehouseSQL