A solution-driven IT professional having over 2.11+ years of experience in IICS and IDMC, Data Warehousing, Decision Support Systems, and extensive experience in implementing Full Lifecycle Data Warehousing Projects with cross-functional teams leveraging ETL solutions for actionable development. I have extensive experience in developing complex ETL code. Experience with ETL using IICS, Possess good Data Validation skills. Good exposure in Reconciliation for unit testing--> Experience in designing, reviewing, implementing and optimizing data transformation processes using unions, router, filter, sequence generator, expressions, joins etc.--> Implemented various MCT types like Verbose Mode, standard mode, advanced session properties and Push Down Optimization(PDO).--> Exposure in developing and Leading end to end implementation of warehouse projects. --> Experience in implementing load type such as Type 1, Type 2, TRUNC and APPEND.--> Implemented Mapplet jobs to use Multiple Mappings with Similar business logic.--> Experience in Unit Testing with respect to SCD Types in DEV, QA, and Production Environments --> Worked on Production Defects debugged complex issues. --> Having Good Exposure in Production defects and Root Cause Analysis(RCA).--> Experience involving performance tuning source to target mapping transformations, adding advanced session properties in MCT.--> Good knowledge of different ETL Architectures and dimensional modelling--> Have experience in analysing Data Stage tools such as Mapping and Sequence and run directory logs.--> Actively involved in the code Deployment process in QA, stage and Production through the Git CI-CD pipeline and Manual deployment process.