Anand Kumar Mahankali

Working for TCS - Client Credit Sussie Responsible for Product Control Data warehousing Team Prepare Tech Specs and ETL Spec Docs Involved in gathering the BRS and Convert in to Tech Specs Monitoring Team activities day to day basics and collect the status reports by EOD. Setup calls and Stand up calls with Onsite Team.

Involved in Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements. Designed the Source - Target mappings and involved in designing the Selection Criteria document.

Developed and documented Mappings/Transformations and Informatica sessions. Designed several mappings to extract the data from Flat files. Created mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations

Participated in complete SDLC – requirements gathering, feasibility analysis, physical and logical data modeling, mapping design, unit and integration testing, production support and related documentation. Classified requests as either New Data or Changed Data requests. Developed and documented date Mappings/Transformations and Informatica sessions. 

Using Informatica Designer, developed mappings, which populated the data into the target. Used Source Analyzer and Warehouse Designer to import the source and target database schema and the mapping designer to map the sources to the targets. Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.

Computer Science