Shashank Kanchibail

Experience

• 

  Tata Consultancy Services

  Aug 2021 - now

  Currently working on ETL, OBIEE, Oracle Database, Oracle SQL and having knowledge on how to work with Informatica Powercenter and Toad and learning how to work with OBIEE for data analytics.• Developed mappings, workflows and tasks using Informatica Powercenter 10.5.• Developed mappings that perform Extraction, Transformation and Load of source data into Derived Masters schema using various powercenter transformations like Source Qualifier, Filter, Router, Lookup, Joiner, Sql, Normalizer to meet Business logic in the mappings.• Strong skills in Data Analysis and Data mapping for ETL processes.• Set and follow Informatica best practices, such as creating shared objects in shared folder for reusability and standard naming convention of ETL objects.• Used Informatica Debugger to figure out the problems in mapping and also helped in troubleshooting existing ETL bugs.• Investigating and fixing the bugs occurred in Production environment and providing the on-call support.• Optimized performance of ETL processes by fine-tuning mappings, sessions, and workflows, resulting in significant reduction in processing time.• Conducted thorough unit testing and participated in system integration testing and user acceptance testing phases.• Created documentation after the workflow was completed and was ready for Production deployment. • Created Change Request(CR) for every ETL workflows in the Servicenow tool for Migration.• Actively involved in creating the tables required for ETL Mappings, using SQL Queries in Toad for Oracle. Show less

  • Data Warehouse Engineer

    Sept 2023 - now

  • ETL Developer

    Nov 2021 - now

  • Assistant System Engineer-Trainee

    Aug 2021 - Oct 2022