Informatica developer

Vikramaditya Rayudu

Summary

Having around * years of experience in Informatica.

Involved in designing bridge tables to ensure design criteria.

Created junk dimension.

Expertise in developing of data warehousing solutions using Informatica Power Center 8.6

Extraction, transformation and loading data from heterogeneous sources systems like Flat files, Oracle, SQL Server.

Hands on experience on Informatica designer components –Source analyzer,Transformation developer and Mapping designer.

Hands on experience on various transformations like Unconnected & Connected lookups, Router, Filter, Sequence, Aggregator, Joiner and Reusable transformations.

Hands on experience on workflow manager tools-Task developers, Workflow & Work let designer.

Develop/Maintain existing Informatica mappings and workflows

Responsible for interacting with business partners to identify information needs and business requirements

Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Involved in Installation and Configuring Informatica Power Center 8.6 with oracle on Windows XP Server

Experience in using the informatica command line utilities like Pmcmd,Pmrepserver and Pmrepagent to control workflows, Sessions, and tasks in non-windows environment

Performed unit testing and aided in client acceptance.

Migrated development mappings to production environment.

Accomplished technician, knowledgeable in applying the latest proven technologies for a timely, optimal solution.

Having good knowledge on SQL/PLSQL.

Education

B.Tech in Computer Science & Engineering from Jawharlal nehru technological University in 2008

Professional Experience

Working as Software Engineer in iGate Computer Systems Ltd, Hyderabad from July 2011 till date

Worked as a Software Engineer in Infinite Computer Solutions Pvt. Ltd Hyderabad from March 2010 to July 2011.

Worked as a Software Engineer for Sonata Software Ltd Hyderabad. Aug 2009 to Feb 2010.

Worked as a Software Engineer in Tata Consultancy Services Ltd from Jan 2009 to August 2009.

Technical Skills

Data warehousing (ETL TOOL) Informatica Designer 8.6,Informatica Workflow Manager 8.6,informatica workflow Monitor 8.6,informatica Administrator 8.6,informatica Repository Manager 8.6

OS Unix, windows

Languages SQL/PLSQL, java j2se,j2ee

Database Oracle 10g, MS SQL Server 2005

Professional Experience

Project Name : Sun Life Insurance Warehouse

Client : Sun Life Financial

Team Size : 5

Position : ETL Developer

Environment : Informatica versions 8.1,

UNIX,

Oracle versions 10g,

Description:

The SUN LIFE Group is Insurance Company. The Company is having various branches related to Insurance and Financial. The SUN LIFE Group handling health insurance, Card Insurance, Home Insurance and Motor Insurance.

By integrating disparate data sources into a single enterprise-wide warehouse while maintaining consistently high data quality, which tightly integrates capabilities for data profiling data quality and data transformation into a complete, end-to-end solution. Built upon a shared platform services including enterprise Meta data management. This solution provides the performance and scalability to address the massive data volumes and real-time/right-time delivery of data required by today’s information intensive enterprises

Roles & Responsibilities:

Interacted with Business Analyst to understand the business requirements

Extensively worked with Source Analyzer, Power centre Designer, Transformation Designer, Mapping Designer and Mapplet Designer.

Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation

Create Mapplets, Parameters and Variables to implement and facilitate the reusability of code.

Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Create Pre-session and post-session SQL commands to drop indexes on the target before session runs, and then create them when the session completes

Creating workflows, Worklets and Tasks like sessions, E-mails.

Schedule workflows using informatica schedulers.

Optimize and troubleshoot informatica mappings and workflows.

Creating session parameters.

Worked on file repository

Unit tests for applications.

Project Name : HART FORD Insurance Warehouse

Client : HART FORD

Team Size : 5

Position : ETL Developer

Environment : Informatica versions 8.6,

UNIX,

Oracle versions 10g,

Description:

The HART FORD Group is Insurance Company. The Company is having various branches related to Insurance and Financial. The HART FORD Group handling health insurance, Card Insurance, Home Insurance and Motor Insurance,By integrating disparate data sources into a single enterprise-wide warehouse while maintaining consistently high data quality, which tightly integrates capabilities for data profiling data quality and data transformation into a complete, end-to-end solution. Built upon a shared platform services including enterprise Meta data management. This solution provides the performance and scalability to address the massive data volumes and real-time/right-time delivery of data required by today’s information intensive enterprises

Roles & Responsibilities:

Interacted with Business Analyst to understand the business requirements

Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.

Involved in Installation of Informatica PowerCenter 8.6.1 on Windows 2003 Server

Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter, Sequence Generator, Joiner, Aggregator, and Expression Transformation

Create Mapplets, Parameters and Variables to implement and facilitate the reusability of code.

Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Create Pre-session and post-session SQL commands to drop indexes on the target before session runs, and then create them when the session completes

Creating workflows, Worklets and Tasks like sessions, E-mails.

Schedule workflows using informatica schedulers.

Optimize and troubleshoot informatica mappings and workflows.

Creating session parameters.

Worked on file repository

Unit tests for applications.

Project Name : AH - PALLAS

Client : AHOLD

Team Size : 9

Position : ETL Developer

Environment : Informatica versions 8.6,

UNIX,

Oracle versions 10g,

Description:

AHOLD is in the retail grocery business in the Netherlands. The chain of stores is known under the brand name of Albert Heijn. Albert Heijn is a very old and established chain of grocery stores all across the Netherlands

The Pallas architecture is constructed around a central data warehouse, the Transaction Repository (TR). The TR is filled from the different source systems within Albert Heijn. The data marts from which the end users can request data are generated from the TR; they are customized to suit the support needed by specific business demands and processes. Pallas has a delay of a day when compared to the source systems. The source information is supplied every night and is loaded and processed in the TR and the data marts so that they are available the next day for reporting and analysis. Every week approximately 600 million records are loaded into the data warehouse. The feeding systems will gradually switch over to supplying data in real time, which will make the data warehouse’s response duration increasingly shorter. In the meantime, reports are available that can display the turnover as of ten minutes ago.

Roles & Responsibilities:

Responsible for the Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center

Worked extensively with Aggregator, Lookup, Sequence Generator, Stored Procedure, Router and Expression Transformations.

Using Informatica Designer to create or modify mappings, Mapplet, Reusable Transformations.

Using Informatica Workflow Manager to create or modify different types of tasks like session, email, timer, event wait, event raise etc. Scheduling and running the Workflows

Project Name : FourU Data Mart

Client : Symantec, Spring Field, USA

Team Size : 4

Position : ETL Developer

Environment : Informatica versions 8.6,

UNIX,

Oracle 9i.

Description

The 4U Data Mart will provide the key data elements for the following 4 areas: File Connect, UPIN, Renewals and Licensing. This data will be organized and optimized in a Data Mart that is access by both Power Users for ad-hoc reporting, and Sales Opts team for develop of Sales Reporting Website reports

Roles & Responsibilities:

Mainly involved in ETL development process

Designed and implemented the ETL process using Informatica Power Center 8.6

Used ETL Process to Extract, Transform and Load the data into Target area and Data Warehouse.

Designed and developed Mappings and Mapplets to load data from source to target database using Informatica Power Center, and tuned mappings to improve performance

Involved in the Code Reviews

Created Sessions and Workflows using Informatica Workflow Manager

Project Name : Ordering Shipping Billing

Client : GE Aircraft Engines

Team Size : 4

Position : Team Member

Environment : Informatica versions 8.6,

UNIX,

Oracle 9i.

Description:

OSB (Ordering Shipping Billing) Data warehouse is project that is being developed for GE Aircrafts division of spare parts repairing shops. It deals with the tracing of parts information and customer info starting from ordering to the shipment, in order to know their

Customers payment history

Status of a particular part in repairing shop

To give the above essential details to the customer when he/she requests for the same.

Roles & Responsibilities:

Analysis of ETL Logics and Mappings which are built in Informatica PowerCenter.

Building and Enhancements of Informatica Mappings

Testing of Mappings and Data Loading through Informatica Work Flow Designer

Contact this candidate