Informatica Developer & SAP B.O - Universe Designer Resume - Hire IT People

PROFESSIONAL SUMMARY:

3.5 years of experience in Data Warehousing as an Informatica Developer and in total 3.5 Years of experience, have 1 year experience as SAP Business Objects - Universe Designer.
Strong Data Warehousing experience using Extensive knowledge in SQL and experienced in scheduling the Informatica sessions.
Experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanisms using Informatica Power Center 8.x in Healthcare & Finance sectors.
Expertise, Knowledge and hand on experience with Informatica.
Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Mart using Informatica Power mart, Power centre.
Analyzing data issue problems with data marts and recommending solutions
Testing the mappings and tables which are developed using Informatica.
Analyzing ETL mappings and making changes for optimization of load and inclusion of some required new logic using Informatica.
Interacting with other project teams for seamless integration.
Maintaining Data Quality across domains.
Created UDT & IDT Universes in SAP Business objects.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
Exceptional ability to learn new concepts and hard working.

TECHNICAL SKILLS:

Operating System: Windows 2000/NT/XP.

ETL Tools: Informatica Power center (8x),SSIS.

Reporting Tools: SAP Business objects 4x.

Languages: SQL, PLSQL.

RDBMS: DB2,Oracle,Sql Server 2000,Sql server 2008

DB Utilities: Toad for DB2,PL/SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer & SAP B.O - Universe Designer

Platform : Client/Server, Oracle

Technology Software: Informatica 8.6/windows

Responsibilities:

Analyzing the requirements - designing and developing the maps for extraction, transformation and loading of data in to data warehouse and data mart tables.
Designing of Sources, Targets, Transformations and Mappings using Designer, while using data from various sources viz. Oracle, flat files.
Add Sessions and Schedule to Load the data in to Data Warehouse using work flow manager.
Running sessions and batches to load the data.
Fixing informatica mapping problems.
Scheduled sequential and concurrent sessions and batches for loading from source to target server manager.
Maintenance and enhancement of the existing mapping and workflows in informatica.
Unit Testing.
Created universes using IDT & UDT.
Testing of the Universes in IDT & UDT as per business rules and deployment in UAT,PROD respectively.

Informatica Developer

Platform : Client/Server, UNIX

Technology Software: Informatica 8.6, DB2.

Confidential

Responsibilities:

Analyzing the requirements - designing and developing the maps for extraction, transformation and loading of data in to data warehouse and data mart tables.
Designing of Sources, Targets, Transformations and Mappings using Designer, while using data from various sources viz. Oracle, flat files.
Add Sessions and Schedule to Load the data in to Data Warehouse using work flow manager.
Running sessions and batches to load the data.
Fixing informatica mapping problems.
Scheduled sequential and concurrent sessions and batches for loading from source to target server manager.
Maintenance and enhancement of the existing mapping and workflows in informatica.
Unit Testing.

Confidential

Informatica Developer

Platform : Client/Server, Windows

Technology Software: Informatica 8.6, SQL.

Responsibilities:

Analyzing the requirements - designing and developing the maps for extraction, transformation and loading of data in to data warehouse and data mart tables.
Designing of Sources, Targets, Transformations and Mappings using Designer, while using data from various sources viz. Oracle, flat files.
Add Sessions and Schedule to Load the data in to Data Warehouse using work flow manager.
Running sessions and batches to load the data.
Fixing informatica mapping problems.
Scheduled sequential and concurrent sessions and batches for loading from source to target server manager.
Maintenance and enhancement of the existing mapping and workflows in informatica.
Monitoring Informatica Daily scheduled batches and Resolving if any issues.
Developed reusable mapplets using mapplet designer.
Created and executed sessions.
Unit Testing.