About Me
· Involved in extracting data from multiple sources like Flat files, Database.
· Extensively worked on Informatica tools such as Source Analyzer, Transformation Designer, Mapplet Designer and Mappi...
· Worked on different screens like PowerCenter Designer, PowerCenter Workflow Manager, PowerCenter Repository Manager and PowerCenter Workflow Monitor.
· Created mappings using the transformations such as the Update Strategy, Lookup, Sequence generator, Aggregator, Source qualifier, Expression, Router, Filter, Joiner and Union.
· Creating reusable transformations and using in mapping.
· To keep track of historical data slowly changing dimensions (SCD) were implemented.
· Performing performance tuning, identifying and resolving performance bottlenecks on various levels like sources, targets and mapping.
· Involved in Migration activities for migrating the code across development to testing environment.
· Involved in Scheduling activities with the scheduling team-providing details of components name, frequency of flow.
Show MoreSkills
Development Tools
Software Engineering
Database
Operating System
Web Development
Others
Portfolio Projects
Company
Suppliers Inventory Repository
Description
The project involved storing the historical data for utilizing the functionalities of the
data generated from our front-end application Siebel CRM. It involved storing and maintaining historical data of the quotation submitted by our client. And storing the data of our suppliers who are providing us materials for manufacturing and maintenance of the cranes. The project involved utilizing the data getting saved in our database and the data we are getting from our suppliers in excel formats and then converting them and saving them in structured format at one location. The project involved staging area to clean the data and then process it and store it at one location.
Show More Show LessSkills
Informatica SQL UNIX Shell ScriptingTools
SQLSMS