Anan Gupta

Background

About Anan Gupta

Experience in 2 ETL tools (Informatica PowerCenter and DMExpress Syncsort). • Designed and developed Informatica's Mappings and Sessions based on business user requirements and business rules to load data from source flat files and DB2, Netezza tables to target tables. • ETL Design and development using Informatica transformations like Sorter, Aggregator, Router, Normalizer, Sequence generator, Union, Ranker, Update Strategy, Lookup, Source, Target, Transaction Control etc. • Performed Impact Analysis of the changes done to the existing mappings and provided the feedback. • Made updates to current ETL processes based on new requirements or bug fixes. • Participated in providing the project estimates for development team efforts. • Written UNIX scripts to invoke informatica workflows and sessions • Prioritized and handled multiple tasks in high-pressure environment. • Provided training and mentoring for junior developers to resume with steady state operations.