Fannie Mae exists to expand affordable housing and bring global capital to local communities in order to serve the U.S. housing market. In today’s wor
Loading new data into the Web-Force system.
Developed Informatica mappings and also tuned them for better performance.
Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy, Normalizer,Sequence generator transformations
Used the latest features in Informatica power centre 9.1 like workflow manager, monitor, repository server – more... etc
Used the Workflow manager to create workflows and tasks, and also created worklets.
Used the Workflow monitor to monitor the job submission and progress.
Developed reusable Mapplets and Transformations to use them in different mappings.
Assign Machine Nodes for all the field users so that they can communicate to the host with their devices and pick up their new databases.
Develop shell scripts, which include AWK to execute the SQL file to generate various reports based on the client requirements.
Responsible for querying data from different database tables as per the requirement.
Used to create folders and giving privileges to the new users.
Generate complex reports using SQL Reports.
Involved in extensive data validation using PL/SQL queries and back end testing.
Load Sales and Ratings related data periodically and send the new data to the field force.
Track and Fix any kind of errors that occur when the users communicate to the database, and also the various issues that originate on the representatives devises and provide a error free data maintenance to the client both on the backend and front-end.
Merged Prescribers using Scrub Process.
Also participated in the Roll Out (visit client site for support when our databases are initially installed on the representatives devises) and received appreciation for successfully completing it.
Environment: Informatica PowerCenter 9.1 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor), Unix Shell Scripting, MS Access 2000, Oracle 11g/12i, PL/SQL, Windows NT , SQL Loader, SQL Reports. – less