Description
Informatica Data Archival Architect
Required Sills:
- Informatica Data Archival ILM,Informatica PWX,SQL server, Oracle, Informatica Power center, IMS, DB2
- Extensive experience in data archiving, database design(relational & hierarchical), data integration and analytics specifically in the area Insurance industries
- Experience architecting/designing and implementing large complex data archiving and Business Intelligence reporting.
- Establishing or leading data conversion from hierarchical to relational DB using INFA PWX and establish data integration capability.
- Strong understanding of hierarchical, relational and multi-dimensional database designs
- Experience with BI, Analytics
- Expert knowledge in SQL, procedure languages and database access tools
- Expert knowledge of relational and hierarchical database design concepts
- Extensive experience working with Mainframe system
- Experience with ETL technologies
- Experience in analysing source system, data flows
- Good understanding of both database and data archival performance tuning
- Good understanding of database related utilities and tools
- Good understanding of testing of source & target data.
- Good understanding of Mainframe and datavault database
- Good Understanding in Unix programming and the underlying operating systems
- Experience in Insurance, Banking or Financial service industries.