A.Rahul Chandra

Ph : +91-994*******

Email : acefcg@r.postjobfree.com

SUMMARY:

. Having 1.5+ years Of Data warehousing experience using Informatica

Power Center 7.x, 8.x .

. Extensively worked on Informatica Designer Components -Source

Analyzer, Warehouse Designer, Mapping Designer & Mapplet

Designer,Transformation Developer, and Workflow Manager.

. Extensive experience in extraction, transformation and loading of data

directly from different heterogeneous source systems like flat

files,Oracle.

. Good Knowledge On Dataware Housing Concepts.

. Developed complex mappings in Informatica to load the data from

various sources into the Data Warehouse, using different

transformations like Update Strategy, Router, Lookup, Sequence

Generator, Filter, Sorter, Joiner, Aggregator, etc.

. Developed Slowly Changing Dimension Mappings of type I, and II.

. Used Mapping Parameters and session parameters in various projects in

the development.

. Familiar with Oracle and basic UNIX commands needed for Data

warehousing projects.

. Involved in UNIT TESTING of mapping.

. Excellent problem solving skills with a strong technical

background and good interpersonal skills.

. Quick learner and excellent team player, problem solving abilities.

TECHNICAL SKILLS:

Languages C,SQL

ETL Informatica PowerCenter 9.1/8.6/7.x,Websphere

transformation extender IBM

Database Oracle 11g/10g/9i/8i, SQL Server 2000/2005, Teradata

v8/v12

Operating Systems UNIX, Windows 7/2K/NT/XP/98/95, Linux.

Tools SQL *Plus, PL/SQL Developer, SQL Developer.

EDUCATION:

> Bachelors in Mechanical Engineering (ANITS 2007-2011) with 62.2% Marks

Obtained

> Intermediate (Sri Chaitanya college 2005-2007) with 71% Marks Obtained

PROFESSIONAL EXPERIENCE:

Company:- Nanomindz Technologies

Client:- Valassis

July'12 - May'13

DB & ORM Developer

Description: This position requires implementing data warehouse for

Forecasting, Marketing, Sales performance reports. The data is obtained

from Relational tables and Flat files. Involved in cleansing and

transforming the data in the staging area and then loading into Oracle data

marts. This data marts/Data warehouse is an integrated Data Mine that

provides feed for extensive reporting.

Responsibilities:

. Understanding the architecture of the source system.

. Worked with DBA to set up the DEV environment and various users and

roles

. Performed data manipulation using basic functions and Informatica

transformations.

. Used flat file and Oracle as the source and the target is

Oracle database

. Created mappings using transformations such as Source Qualifier,

Aggregator, Expression, Lookup, Filter, Router, Rank, and Sequence

Generator.

. Used Workflow manager to create and configure workflow and session

task to load data. Used Informatica workflow monitor to create,

monitor workflow in case of process failures

. Used workflow monitor to monitor the jobs, reviewed session/workflow

logs that were generated for each session to resolve issues, used

Informatica debugger to identify issues in mapping execution.

. Creating Unit test cases.

Environment: Informatica PowerCenter 8.6, Repository Manager, Designer,

Work Flow Manager, Oracle 10g, SQL Server 2005,Flat Files, CSV files,UNIX.

Company:- Nanomindz Technologies

Client: Sai solutions inc USA

May '13 - till to date

Informatica Developer

Description : Performed scheduled loading and clean ups and Monitored

troubleshoots

batches and sessions for weekly and Monthly extracts from various data

sources across all platforms to the target database.

Responsibilities:

. Worked with Business Analysis team in gathering the requirements and

created written documentation to describe program development, logic,

coding, testing, changes and corrections

. Analyzed the Business Requirement Documents (BRD) and laid out the

steps for the data extraction, business logic implementation & loading

into targets

. Created mappings using Informatica Designer translates business rules

and functionality requirements into ETL procedures.

. Developing and modifying changes in mappings according to business

logic.

. Responsible for creating and updating technical design documents.

. Designed and developed data model star schema (dimensions and facts).

. Mapped data from source systems and other sources to many different

DBMS using Informatica

. Worked on Informatica tool -Source Analyzer, Data warehouse

designer, Mapping Designer and Transformation Developer.

. Used most of the transformation such as the Source Qualifier,

Expression, Aggregator, Connected & unconnected lookups, Filter,

Router, Sequence Generator, Sorter, Joiner and Update Strategy.

. Used Workflow manager to create Workflows and Sessions, database

connection management.

Environment: Informatica Power Center 8.6, Oracle 11g/9i,

PL/SQL,Excel,Visio,SQL-Server 2008.

Personal skills:

. Good verbal and written communication skills, ability to deal with

people diplomatically, willingness to learn and team facilitator.

. Performance Modifications for Automobiles.

. 7.5/9 in IELTS.

. Prepared Power Point Presentations on present operating systems and

Upcoming Operating Systems Based on different platforms.

. Participated in many Seminars, Workshops and events organized by

Gitam, Andhra University and other colleges in and around

Visakhapatnam

Languages known:

. English, Telugu, Hindi.

Contact this candidate