Having 9+Years of experiences in designing, development and implementation of ETL using Informatica Power Center 10.2.2/10.1/9.x .
I Involved in the full development lifecycle from requirements gathering through development and support using Informatica- Power Center, Informatica Power exchange,Unix shell scripting, Oracle, DB2, MS SQL server, Autosys.
working as an offshore lead for informatica team.
Created complex mappings using Unconnected Lookup, Aggregate, Router and Update strategy transformations,XML Transforamtions for populating target table in efficient manner.
Expertise in working with different data sources like Flat Files(csv, fixed width,xml files), RDBMS products like Oracle,SqlServer.
Expertise in Creating Unix Shell scripts.
Experienced at Creating effective Test data and development through Unit test cases to ensure successful execution of the data & used mails for notifying the alerts in case of job failure.
Experienced in Error handling, Troubleshooting using various log files and problem fixing in Informatica.