Informatica IICS Developer (7-10 yrs)

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.