Home

Venkatesh R - ETL Informatica

[email protected]

Location: Virginia Beach, Virginia, USA

Relocation: Remote

Visa: H1B

Experience in analyzing, designing and modeling data warehouses and star schema data marts for various business verticals like Imports, Unemployment Insurance, Health Care (Pharmacy) and Sales. ETL-Data Warehousing experience using Informatica PowerCenter 9.6.0/9.6.1/10.4.1, Informatica Intelligent Cloud services (IICS), Informatica Developer (BDM), Informatica Data Quality(IDQ), Data Integration Hub (DIH) , SAP Business Objects Data Services 3.2/4.2 (SAP BODS), Workflow Manager, Workflow Monitor, Repository Manager. Conducted job duties and responsibilities according to the organization s business systems development methodology and/or its Systems Development Life Cycle (SDLC) methodology and Agile. Experience in using Business Objects Suite products such as CMC, LCM, Designer/Information Design Tool, Web Intelligence, Deski, Dashboard Manager, Crystal Reports, Live Office, Business Explorer (BEx Query), QAAWS, Xcelsius, Explorer, Information Steward and Lumira. Experience in leading and implementing Client server, Cloud based ETL integration projects using Informatica IICS, Oracle, Microsoft Azure, Informatica BDM, AWS and Hadoop environment Proficient in planning, designing and building Universes using databases like IBM-DB2 UDB, Oracle, TeraData, SQL Server, Personal Data Files and Stored Procedures. Experience in Migrating and Upgrading Universes & Reports from Business Objects XI R2 to XI 3.1 and XI 3.1 to XI 4.0. Managing the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CCM. Participated in ETL requirements gathering meetings with tier-1 data analyst s and suggested the designs in development point of view for building the ETL Specification document. Extracted data from Homogeneous and Heterogeneous sources and developing the mapping needs and to push the data as per ETL Specification document into Target Tables. Has good hands-on knowledge in configuring various transformations like Source Qualifier, Expression, Filter, Joiner, Aggregator, Router, Unconnected and Connected Lookups, Update Strategy, Sequence Generator, Stored Procedure. Created, Generated and Installed SAP R/3 code by connecting SAP Applications through Informatica Powercenter 10.4.1. Handled PRE-SQL and POST-SQL for targets. Implemented SQL Overrides at Source Qualifier and Lookups whenever needed. Created Reusable objects like Transformations (Expression, Stored Procedure, Filter, and Lookup-Unconnected), Mapplets, and Functions. Experience in Informatica s Intelligent Data Management Cloud. Lead the team for Integrating Informatica Intelligent Cloud services to Microsoft Azure application. Keywords: rlang Keywords: rlang