Hanni Kumar Email & Phone Number

Lucknow, Up, In

Bengaluru, Karnataka, India

Working as a Software Engineer with excellent experience in ETL tool Informatica PowerCenter, IICS, Oracle, PL/SQL, Data Modeling, UNIX, Snowflake and JIRA.Having around 4 years of experience in ETL data integration using Informatica Power center 10.2, Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Developer, Workflow Designer, Shortcuts and Informatica Power Exchange.Good knowledge in Star Schema/Snowflake, Fact and Dimension tables and Data Mart, Data Warehouse.Basic Knowledge in AWS (Glue, Athena, S3, Redshift) And ADF (Azure Data Factory).Experience in Data Analysis, Data Extraction, Transformation and loading processes.Have fare Knowledge in Informatica Intelligent Cloud Services (IICS), Oracle SQL, and PL/SQL. Implemented Slowly Changing Dimensions Type 1, Type 2 methodology for accessing the full history of accounts and transaction information.Vast experience in Designing and developing mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategies.Using Target Load Plan to optimize the performance of the server.Have the ability to work under pressure, prioritize and manage multiple tasks. Good exposure to Agile development methodologies