Universe Designer Resume Profile

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:

Project Profiles:

Confidential

Informatica Developer SAP B.O - Universe Designer

Roles and 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.

Confidential

Informatica Developer

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

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.