Job Description :
Hi Greetings,

Please find the below mentioned requirement and let me know if you are interested and available

Role : Informatica ETL Lead/Developer
Location : Windsor CT
Duration : Long Term

Job Description:
Able to Create ETL design documents as per the requirements and high level design document.
Able to create new customized mappings to move data from Source Applications to Warehouse and modified the current existing customized mappings as per the requirements.
Should b extensively used various transformations like Lookup, Source Qualifier, Expression, Update Strategy, Joiner transformations to build mappings.
Able to Use Post and Pre session commands to call scripts which Drop, recreate indexes, run reorg and run stats on the warehouse table which was loaded.
Able to write Unix/Linux scripts and Pl/Sql procedures.
Able to work on performance tuning of mappings and session to identify and remove the bottle necks.
Able to fine tuning the ETL mapping by studying the session logs and identify the bottlenecks such as time involved in building the cache.
Able to write complex SQL queries to test the data in production for analysis by business analysts and to cleanse the corrupted data.

Looking forward to work with you !!
             

Similar Jobs you may be interested in ..