Over 2,500 companies and customers worldwide rely on CallidusCloud for better hiring, learning, marketing and selling.

• Installed and configured PowerCenter 9.6 , 9.10 and 9.1.0 on UNIX platform.
• Installed and configured Informatica PowerExchange CDC 9.1.0 and 9.0.1 for Oracle on UNIX platform.
• Performed Informatica upgrade from V8.6.1 to 9.0.1 and 9.1.0.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Installed and configured the following IDQ 9.0 components on AIX UNIX Servers.

• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Worked on Informatica Templates to standardize the CISCO process and maintain consistency across different teams.
• Worked on UNIX shell scripts to handle Job Control Process.
• Testing the Informatica Objects in QA before moving them into Production.
• Designed and documented ETL standards document.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.

• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Ensure that all support requests are properly approved, documented, and communicated using the MQC tool. Documenting common issues and resolution procedures.
• Involved in Unit Testing and resolution of various bottlenecks, performance tuning at source, target, mapping & session level and implementing various performance tuning techniques.
• Handling the process of requirement gathering, Functional process Document Review, change request review with multiple projects.

• Installed and configured PowerCenter 8.6.1 on UNIX platform.
• Upgraded to Informatica PowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Configured OS Profiles and LDAP Authentication.
• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.
• Worked on Push Down Optimization to optimize Oracle loads.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.

Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system

The main objective of this Project, data from relational database sources which will be loaded in to OLAP EDW based as per the requirement. The entire ETL process consists of source systems OLTP.

The primary objective of this project is to extract data from multiple OLTP/ODS systems. Extracted Transformed Loaded data in to data warehouse using Informatica Power centre. These data give details of the various analytical results.