*Job Title:ETL Informatica Location:Miami, FL Duration: 6+Months* Gathered requirements from Business users. Work on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Create complex mappings using Unconnected Lookup, Sorter, Source qualifier, Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner. Extract data from different sources such as SQL Server , Oracle, XML, Fixed width and Delimited Flat files to load into Oracle database Maintain warehouse metadata, naming standards and warehouse standards for future application development. Maintain Development, Test and Production mapping migration using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting. Use designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance. Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. Develop and optimize database structures, stored procedures, views, triggers and user-defined functions.
Regards, Monty Nege -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To post to this group, send email to oracle-projects@googlegroups.com. To unsubscribe from this group, send email to oracle-projects+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-projects?hl=en.