Informatica Developer

·       Create Informatica mappings to incorporate critical business functionality to load data.

·       Used connected, unconnect lookup, static and dynamic cache to implement business logic and improve the performance.

·       Develop procedures and functions using PL/SQL and develop critical reports.

·       Work with relational databases like Oracle/Teradata/Sql Server.

·       Detail table design and index selection in for TeraData databases using SQL.

·       Develop mappings with XML as target and formatting the target data according to the requirement.

·       Work with logica l, physical, conceptual, star, snow flake schema data models.

·       Extract data from flat files, DB2 and to load the data into the SalesForce database.

·       Create and used debugger sessions to debug sessions and create breakpoints for better analysis of mappings.