NIKHIL KUMAR

Azure Data Engineer

Tata Consultancy Services•  April 2021 - Present

• Orchestrated daily Data-load jobs in ADF using relevant  ADF components to Extract, Transform and load data  from different sources like Azure SQL, Blob storage, Web API. • Built ADF pipelines with event-based triggers to leverage  the functionality to load data as and when it arrives in  source systems to minimize data delays • Worked with API calls like GET and PATCH as per  business logic using ADF and generated daily reports. • Designed tables with Optimal distributions as per business requirements for best query  performance. • Building integration between Dynamics 365 and Data lake using Azure Synapse link. • Data Extraction from On-Premise Sources and Delta Extraction methods from Source Systems to ADLS. Scheduled Jobs using Event and time-based scheduler. • Leading the offshore development team and L3 Maintenance team for ADF and related technologies.

Software Engineer

Cognizant Technology Solutions•  March 2016 - April 2021

• Involved in design, development, testing and provided maintenance and development for Azure data factory, API, Azure SQL, and SSIS. Achieved 100% client satisfaction and on-time completion. • Worked on different projects following up the Agile methodology. • Developed multiple database objects like complex stored procedures, triggers, etc. • Interaction with stakeholders to streamline the business processes and come up with the new enhancements for existing applications. • Oversaw the entire software development life cycle for ongoing projects and configured existing systems.