1. Responsibilities Experience 5 years In depth knowledge of Informatica 9 x 10 x Power Center Informatica Power Exchange UNIX SQL
2. Strong understanding of ETL data structures and data flow
3. Experience with different data sources such as Oracle Flat files Mainframe VSAM files SQL Server etc
4. Experience in data ingestion using web services Very good Communication skill Requirements
5. Understanding user requirements and translating those requirements into well designed solutions
6. Understand Mainframe data and ability to read write complex mainframe data using Informatica Create data maps in Power exchange for reading writing data to Mainframe Create Complex Informatica mappings in Power Center using UNIX SQL Involve in Unit and Integration testing validating test cases
7. Performance tuning techniques Ability to program complex ETL mappings Involve in SIT UAT support Work on Identifying and resolving various major production fixes and Provide innovative solutions to meet the needs of the business.