Vikash Kumar Kesarwani

About Vikash Kumar Kesarwani

Tech Lead-Data Engineer/Senior ETL IICS - CAI/CDI Developer, with over 10+ years of extensive hands-on experience, possessing a strong command and proficiency in utilizing BI-ETL tools, specifically Informatica PowerCenter (9.x/10.x) and IICS (Informatica Cloud) gained through practical application and continuous learning. In Cloud Informatica Data and Application Integration, with a comprehensive knowledge of integrating cloud-based data and applications using IICS. Certified Informatica PowerCenter Data Integration 9.x: Developer Specialist to help design, develop, and deploy data integration solutions leveraging the tool through Informatica PowerCenter. Proficient in SQL development across multiple relational databases, with experience in ETL development using Informatica PowerCenter and Informatica Cloud, and proficiency in Business Objects reporting. Developed mapping tasks, Task Flows, Processes, and sub-processes based on requirements in IICS Cloud data integration (CDI) and Cloud Application Integration (CAI). Experience in analysis, design, development, and implementation of projects using Informatica Power Center, Power Exchange, and IICS (Informatica Cloud), including Informatica Admin Activities, IDMC (Intelligent Data Management Cloud), especially in data integration or cloud development tasks, Talend, Data Stage, SAP BODS, etc. Good knowledge and working experience in Retail/Manufacturing, Healthcare, Insurance, Banking, Telecom, and many other domains. Experience in ETL Design, Entity-Relationship Modeling, and Dimensional Modeling. Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi, TPT to Export and Load data to/from different source systems, including flat files. Designed and deployed ETL pipelines using Informatica IDMC for cloud data integration across Snowflake and Azure SQL. Migrated legacy PowerCenter workflows to IDMC, improving performance by 30%. Collaborated with data architects to implement scalable solutions aligned with business goals. Exposure to Dimensional Data modeling that includes star schema and snowflake schema modeling. Proficient in SQL development across multiple relational databases, with experience in ETL development using Informatica PowerCenter and Informatica Cloud, and proficiency in Business Objects reporting. Created mapping tasks, Task Flows, Processes, and Sub Processes based on requirements in IICS Cloud data integration (CDI) and Cloud Application Integration (CAI).

Experience

1. Specialist- Data Engineering

   LTIMindtree

   Jun 2015 — Present · Maharashtra, IN

Education

• Goverment Engineering College,Bilaspur

  Bachelor of Technology (BTech)

• S S Mandir

  SSC and HSC