Nitish Kumar

Working as a Senior Data Engineer at EY across multiple large-scale client engagements.

📌 Adani (Enterprise Data Lake) | Azure & Databricks
- Led delivery of an Enterprise Data Lake using Medallion Architecture (Bronze/Silver/Gold) with SAP as primary source
- Built 4 reusable enterprise frameworks: Data Ingestion, Data Quality (DQX), Audit Control, Access Control
- Built Databricks notebooks (PySpark) for complex business logic and data transformations at scale

📌 Air India (Employee Data Platform) | Azure
- Integrated APIs from Successfactors, ServiceNow, Azure DevOps, and JIRA
- Built ADF pipelines, Function Apps, Logic Apps and Databricks notebooks

📌 Arvind (Digitization) | Microsoft Fabric
- Contributing to data platform implementation on Microsoft Fabric
- Porting enterprise frameworks from Azure to Fabric architecture

• Led migration of on-premises data applications to Microsoft Azure, improving scalability and reducing
infrastructure overhead.
• Designed and implemented Azure Data Factory pipelines for data ingestion and transformation
across multiple business domains.
• Developed Informatica DEI mappings to extract mainframe data and load into Azure Data Lake
Storage (ADLS).
• Built Databricks notebooks with PySpark to implement complex business logic and data
transformation rules.
• Designed and executed unit test cases for on-premises and cloud data comparison to ensure data
integrity post-migration.
• Developed and optimised complex SQL queries, stored procedures, and functions for data
transformation and performance-critical reporting pipelines.

• Served as SME for ETL solutions, analyzing business requirements and developing Informatica-based
data pipelines.
• Conducted performance optimization of data feeds, significantly reducing processing time for critical
pipelines.
• Led root cause analysis (RCA) for production incidents, delivering timely resolutions and preventing
recurrence.
• Drove code review practices and incorporated lessons learned into team standards and best
practices.
• Delivered end-to-end project requirements at client onsite location, ensuring business continuity and
stakeholder alignment.
• Utilised advanced SQL including complex joins, stored procedures, and query tuning to support ETL
development and performance optimisation.

• Developed and technically designed new data feeds across multiple technologies using Informatica
PowerCenter.
• Built reusable mappings and mapplets leveraging Source Qualifier, Aggregator, Joiner, Lookup,
Router, Expression, and Update Strategy transformations.
• Optimized Informatica mappings, sessions, and source/target databases to improve performance.
• Wrote and optimised SQL queries and stored procedures to support data extraction, transformation,
and loading across source and target systems.

• Developed data integration feeds using Informatica PowerCenter as part of Wipros WASE program
while simultaneously completing M.Tech from BITS Pilani.
• Built standard and reusable mappings and mapplets using Source Qualifier, Aggregator, Joiner,
Lookup, Filter, Router, Rank, Expression, XML and Update Strategy transformations.
• Optimized Informatica mappings, sessions, and source/target databases to improve performance.
• Contributed to ETL development and optimization efforts with strong analytical abilities and keen
interest in learning new tools.