I have 6.1 years of experience in cloud computing and data warehousing, with expertise in tools and technologies such as IICS Cloud Data Integration, Informatica PowerCenter 10.6, Informatica BDM 10.6, AWS Glue, Python, Unix, Oracle, SQL, CDB2, and Aurora databases. I possess a strong understanding of warehousing concepts, including Star Schema, Snowflake Schema, dimensions, and fact tables.
I have extensively worked with Informatica/IDMC client tools, including CDI, CAI, Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager, and Informatica Workflow Manager. I have hands-on experience with Oracle, CDB2, Hive, Aurora, and SQL databases, leveraging Unix as the backend.
I have implemented both simple and complex business logic through various transformations, such as Filter, Sorter, Aggregator, Lookup, Expression, Router, Update Strategy, Joiner, and Normalizer. I have expertise in managing slowly changing dimensions (SCD) and have applied Type I, Type II, and Type III strategies to maintain historical and incremental data.
In addition, I have basic knowledge of UNIX and scheduling tools like CONTRPL-M and ESP, with a clear understanding of non-simultaneous dependencies across different functional areas. I’ve handled ad-hoc requests, including order processing in the Test Environment, and contributed to the testing of new IICS features while introducing best practices to improve performance. I have also supported the application team by addressing platform-related issues and creating automated processes to reduce manual work.
Regular interactions with clients have helped me understand their business requirements, enabling me to provide tailored and efficient solutions
Project : TRUIST Financial Corporation