Praveen Peruca

WORK HISTORY

EDUCATION

SKILLS

ABOUT PRAVEEN PERUCA

Having 13+ Years of IT experience in Data Warehousing with extensive use of ETL tools such as Informatica intelligent Cloud Services (IICS), Informatica Power Center 8X/9X and IDQ 9X.•Expertise in integrating various applications like Salesforce, Snowflake, ServiceNow, Oracle Cloud, Oracle Database using IICS. •Extensively worked with App connections, service connectors, process and process objects in informatica cloud application integration.•Extensively worked with Oracle Financial Cloud V1, Oracle Business Intelligence PublisherV1, Oracle HCM Cloud V1, Anaplan V2, Salesforce, ServiceNow Connectors, RestV2, File Processor, Oracle, Flat File•Expertise in using REST and SOAP web services.•Expertise in various informatica products like PowerCenter, Informatica intelligent Cloud Services (IICS), Cloud B2B and Cloud Data Quality.•Expertise in various services of IICS like data integration, application integration, B2B gateway, monitor, application integration services, Administrator, Data quality, profile and so on.•Worked with Assignment step, create step, jump step and data decision step, Service call step, wait step, sub process… in application integration services •Expertise in creating Data Synchronizing Task, Mapping Task, Mapping Configuration Tasks•Extensively worked with File Listeners, Schedulers, Connections, Swagger Files, Task Flows, Mapplets, Parameterized Mappings and configuring re-usable code. •Extensively worked with Task flows•Expertise in using the various advanced transformations like Hierarchy Builder, Hierarchy Parser, Structure Parser, Webservice Transformation, Aggregator, Joiner, Lookup, Normalizer etc.•Extensively worked with various components like Business Services, Intelligent Structure Model, File Listeners, Fixed width file Formats. •Implemented B2B Partners for both inbound and out bound flows for both custom and structured files in Cloud B2B gateway.•Expertise in creating Users, Assigning User Roles, creating Connections, Generating Swagger files using Informatica cloud Administrator services.•Extensive experience in building PowerCenter mappings using expression, lookup, joiner, Update strategy, Java, SQL and router transformation.•Experience in creating different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.