Job Description :

Role : Informatica ETL Developer

Location: Basking Ridge, NJ(Initially remote)

Duration : Long term

Interview mode: Phone then skype


Informatica ETL Developers, responsible for developing, enhancing, debugging, maintaining, and testing software applications that support business units of an organization. They will maintain warehouse metadata and standards for future application development. Create Informatica mappings with PL/SQL store procedures/functions 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. Develop PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic. Work with relational databases like DB2. 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 logical, 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.

Similar Jobs you may be interested in ..