Summary
Overview
Work History
Education
Skills
Extracurricular Achievements
Timeline
Generic

Keshav Nirwan

ETL Developer
Ghaziabad

Summary

More than 9 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server Integration Services and Azure Data Factory in Development, Test and Production Environments in banking domain.

Overview

9
9
years of professional experience
2
2
Languages

Work History

Senior ETL Developer

Genpact
10.2023 - Current
  • Translated technical concepts and information into terms parties could easily comprehend.
  • Working on ADF (Azure Data Factory) and SSIS (SQL Server Integration Services) for data integration, transformation, and workflow orchestration
  • Integrate ADF pipelines with other Azure services such as Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, etc.
  • Configure ADF pipelines to replicate the data movement and transformation logic from existing SSIS packages.
  • Validate the data integrity and accuracy after migration by comparing the output of ADF pipelines with the original SSIS packages.
  • Migrated legacy applications to the Azure cloud platform, resulting in increased flexibility and reduced operational costs.

SQL and SSIS Developer (Technical Lead)

Accenture
1 2020 - 09.2023
  • Operational Data Store is a type of database designed to integrate data from multiple data sources used for regulatory reporting.
  • Enhanced data accuracy by optimizing SSIS packages and implementing data validation techniques.
  • Streamlined ETL processes for faster data extraction, transformation, and loading.
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
  • Analyzed existing SQL queries to identify opportunities for improvements.

SSIS Developer

Tata Consultancy Services
2 2016 - 12.2019
  • TCS has started a new joint venture with Royal Bank Of Scotland to support and extend help on the Technical/Technological front
  • Analyzing the existing structure and providing the solution and enhancement to the system and created the estimation plans.
  • Interaction with the clients to gain the functional knowledge.
  • Coding in SSIS and MS SQL (complex programming queries. SPs).
  • Designing, creating and scheduling MS SQL jobs.
  • Created functions, procedure and tables in MS-SQL

SharePoint and .net Developer

Tata Consultancy Services
12.2014 - 12.2015
  • Developed timer job for the movement of data from World Bank Inranet Site (PPF) to World Bank Internet Site.
  • Developed timer job for pushing PDF file generated from World Bank Inranet Site (PPF) to WB Docs (World Bank Database).
  • Converted PDF files from World Bank Database into html files then extracting the data from html and feed to the new developed Intranet Site called Policy Procedure Framework(PPF)
  • Developed PDF Convertor module to export user filled form data to PDF using iTextSharp.

Education

Bachelor of Engineering (Information Technology) -

Krishna Engineering College
Ghaziabad, Uttar Pradesh

12th - undefined

Schiller Institute
Ghaziabad, Uttar Pradesh

10th - undefined

Schiller Institute
Ghaziabad, Uttar Pradesh

Skills

SSDTundefined

Extracurricular Achievements

  • Worked as an Information Security coordinator in the Project.
  • Participated and volunteered in 4 days Global Spirituality Mahotsav organized by Ministry Of Culture , hosted at Kanha Shanti Vanam, World Headquarters of Heartfulness, Telagana


Timeline

Senior ETL Developer

Genpact
10.2023 - Current

SharePoint and .net Developer

Tata Consultancy Services
12.2014 - 12.2015

SQL and SSIS Developer (Technical Lead)

Accenture
1 2020 - 09.2023

SSIS Developer

Tata Consultancy Services
2 2016 - 12.2019

Bachelor of Engineering (Information Technology) -

Krishna Engineering College

12th - undefined

Schiller Institute

10th - undefined

Schiller Institute

Similar Profiles

CREATE PROFILE
Keshav NirwanETL Developer