We provide IT Staff Augmentation Services!

Informatica Developer & Sap B.o - Universe Designer Resume

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.

Hire Now