Max 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
