Manager Data

Sravanthi

571-***-****

Summary

. * years of ETL and data integration experience in developing ETL

Mappings, Mapplets, Workflows, Worklets and scripts using Informatica

PowerCenter 9.x/8.x/7.x and PowerMart 8.x/7.x.

. Experience in all the phases of Data warehouse life cycle involving

Requirement Analysis, Design, Coding, Testing, and Deployment.

. Experience in working with business analysts to understand requirements

and translating them into ETL code in Requirement Analysis phase.

. Experience in creating High Level Design and Detailed Design documents in

the Design phase.

. Strong knowledge of Entity-Relationship concept, Facts and dimensions

tables, OLTP Data Modeling and Data warehousing concepts (Star Schema and

Snow Flake Schema).

. Experience in integration of various data sources like Oracle, DB2,

Sybase, SQL server and MS access and non-relational sources like flat

files into staging area.

. Experience in creating Reusable Transformations (Joiner, Sorter,

Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence

Generator, Normalizer and Rank) and Mappings using Informatica Designer

and processing tasks using Workflow Manager to move data from multiple

sources into targets.

. Hands on experience on several key areas of Enterprise Data Warehousing

such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I

and Type II).

. Strong experience in performance tuning, debugging and Error handling of

mappings, sources and targets for better performance, also identified and

fixed the bottlenecks.

. Extensive experience in creating and Reusable Mapplets, Worklets used

event wait, Event raise, decision box, email and command tasks in

Workflows.

. Strong knowledge in writing efficient & complex SQL Queries in Oracle

11g/10g/9i and in PL/SQL for Stored Procedures, triggers, indexes,

cursor, and functions.

. Experienced in UNIX work environment, file transfers, job scheduling and

error handling.

. Hands on experience on UNIX shell scripts for Informatica pre & post

session operations.

. Involved in Unit testing, System testing to check whether the data loads

into target are accurate.

. Experience in support and knowledge transfer to the production team.

. Proficient in interaction with the business users by conducting meetings

with the clients in Requirements Analysis phase.

. Extensive functional and technical exposure. Experience working on high-

visibility projects.

. Assign work and provide technical oversight to onshore and offshore

developers.

Software Skills:

ETL Tools Informatica Power Center 9.x/ 8.x/7.x

Data Warehousing Informatica PowerCenter 8x/7x/6x, Informatica

PowerMart 7x/6x Informatica PowerExchange

7.x/8.x, Repository Admin console, Repository

Manager, Designer, Workflow Manager, workflow

Monitor.

Databases Oracle 11g/10g/9i/8i, SQL Server 2008, IBM DB2,

Teradata, Sybase, MS Access, MS-Excel.

RDBMS Load Tools Toad, SQL Developer, SQL Loader, SQL plus.

Reporting Tools Business Objects XI3.1

Programming Skills SQL, PL/SQL, UNIX shell scripting.

Data Modeling Tools MS - Visio, Erwin

Operating Systems UNIX, Windows 98/2000/2007/XP/NT, UNIX (Solaris,

AIX).

Contact this candidate