SUMMARY

• Over 7+ years of experience in software design, development & testing along with Analysis and Implementation of Business Intelligence applications in various domains like Banking, Insurance
• Expertise hands on experience in ETL (Extraction Transformation Loading) using Informatica PowerCenter 7x/8x.
• Expertise in using Relational data base systems like DB2 9.7 LUW, Oracle 11g.
• Good hands on experience in PL/SQL and in writing Stored Procedures, Functions etc.
• Very good hands on experience in UNIX shell scripting.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Excellence in the implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica PowerCenter/PowerMart (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administrator Console and Server Manager).
• Designed and developed Complex mappings from various Transformations and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML, External Procedure.
• Experience in Database Performance Tuning, Performance Monitoring and Query Optimization using Oracle Hints and Table partitioning.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Responsible for Business Analysis and Requirements Collection.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Experience in database design, entity - relationship modeling and dimensional modeling.
• Strong trouble shooting capabilities and problem solving and team leading capabilities
• Expertise in OLTP/OLAP System study, developing Database schemas like star schema, snow flake schema Dimensional Data Modeling used in relational, dimensional modeling and slowly changing dimensions (SCD’s).
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience with high volume datasets from various sources like DB2,Oracle, Flat files.
• Experience in integration of various data sources like Oracle, SQL server and MS access, flat files, and XML files.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Worked in both Waterfall and Agile models and have good knowledge on both methodologies
• Excellent communication and interpersonal skills, flexible and adaptable as per the project needs.
• Very good experience in Interacting with the Team with Onside-offshore models.

TECHNICAL SKILLS

Databases: DB2 9.7 LUW, Oracle 11g, Teradata V2R5

SQL PL/SQL Editors: TOAD, DBArtisian, RapidSQL, Sqldeveloper,SQL Assistant

ETL Tools: Informatica Power Center 9.5/9.0.1/8.6.1

Data Modeling: ERWIN, Visio (Star Schema, Snow-Flake schema, Fact, Dimensions)

Reporting Tools: Qlikview, Cognos

Languages: SQL, PL/SQL, UNIX shell scripting.

Operating Systems: UNIX, MS Windows NT/2000.

Other Tools: Autosys, IBM ClearCase, ClearQuest, Perforce, Putty, HP Quality Center 10,ALM, Sharepoint

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. ETL Developer

Responsibilities:

• Mainly involved in ETL Developing using DB2 and Informatica.
• Participated in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes, Facts and Star Schema to fulfil requirements
• Configured and administered Informatica PowerCenter and extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Developed transformation logic and designed various complex mappings and mapplets by using the Designer and Developed complex mappings in order to implement Slowly Changing Dimensions.
• Worked with the Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure Transformation, Joiner.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the data according to the business logic.
• Extensively used SQL and PL/SQL Scripts and worked in both UNIX and Windows Environment.
• Fined tuned ETL processes by considering mapping and session performance issues.
• Coordinating with offshore team on daily basis and keeping track of deliverables.

Environment: Informatica 9.5.1, DB2 LUW 9.7, UNIX, Qlikview

Confidential, MI

ETL Developer

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.
• Experience in generating XML’s using informatica.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Perform data validation tests using complex SQL statements.
• Having excellent knowledge working on oracle database, writing complex SQL scripts and PL/SQL programs.
• Experience in applying labels in informatica and maintaining versions.
• Experience in converting complex PL/SQL programs into informatica mappings.
• Responsible to understand the unix shell scripts for loading the files.
• Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookup, Dynamic Lookup, Source Qualifier and data flow management into multiple targets using Router transformations.
• Created Sessions & Workflows to run the mappings using Workflow Manager
• Created Stored Procedures & Functions for data transformation purpose.
• Involved in gathering requirements and created design documents and mapping documents.
• As a ETL developer I am responsible for analyzing the informatica code and debugging the issues while loading the data into datawarehouse.
• Experience in working with server migration project.

Environment: Informatica 9.0.1, SQL Developer, Toad, Oracle database 11g, Unix, xml.

Confidential, IL

ETL Developer

Responsibilities:

• Involved in Business Analysis, requirements gathering and logical & physical data modeling.
• Involved in analysis, design and development of ETL process. Created ETL high level design documents and Informatica mapping specifications.
• Worked on data conversion and data analysis. Stored data in the data warehouse about customers and dealers.
• There were two kinds of data loading processes (daily and weekly) depending on the frequency of source data.
• Data architecture using ER and dimensional modeling Erwin for the staging, warehouse and associated data marts.
• Extraction, Transformation and Loading of the data Using Informatica Power Center.
• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Developed Informatica mappings and also tuned them for better performance.
• Extensively used the Expression, Aggregator, Filter, Joiner, Sorter transformations.
• Extensively used Rank transformations to eliminate the duplication of the customers after obtaining their information through LOOKUP transformation.
• Used Update Strategy and Lookup transformations to manipulate the information about the customer.
• Different sessions were run in the Workflow Manager and the log was studied to modify the mappings to obtain correct result from the transformation.
• The mappings were Unit tested to check for the expected results.
• Extensively used ETL to load data from flat files.
• Designed and Deployed UNIX Shell Scripts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Maintained the Workflow processes using Unix Shell Scripts.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.

Environment: Informatica 8.6.1, Oracle11g