Informatica IICS Developer - ETL / Data Warehousing

Job Description

• Hands on experience in Informatica Intelligent Cloud services (IICS)
• Should be expertise in performance and tuning of Informatica mappings and sessions for better performance and moving the objects from development to production environment.
• Hands on experience in all aspects of project development life cycle in Data Warehousing.
• Expertise in Informatica PowerCenter (10.x / 9.x / 8.x), Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, FACT Tables, Dimension Tables, Star Schema Modelling, OLTP, OLAP.
• Extensive experience with Data Extraction, Transformation , and Loading from disparate Data sources into a common reporting and analytical Data Model using Informatica .
• Should have experience to load data from heterogeneous sources like SAP, Oracle, XML and Flat files etc.
• Hands on Experience in code migration by Export and Import Object and Deployment Groups
• Experience with PL / SQL Coding, Normalized Database creation in relational databases like Oracle 12c / / 11g / 10g
• Experience with UNIX Shell Scripting, PL / SQL, Oracle tuning and Indexes, function-based indexes and optimizing the SQL to improve the performances.

ref : hirist.tech)