SUMMARY

• Over seven plus Years of IT experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica 8.x, SQL Server and Oracle10g.
• Strong Experience in using Dimensional Data Modeling, Star Join Schema Modeling, Snow - Flake Modeling, FACT and Dimensions Tables.
• Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging
• Extensively worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Experience in designing and implementing ETL solutions for DataMart and Data Warehouse.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect) to capture the changed data.
• Extensive experience creating procedures in T-SQL 2008.
• Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, views, materialized views, Cursors at database level using SQL, PL/SQL for Oracle 9i/10G and SQL SERVER 2005,2008.
• Experience in using the Informatica command line utilities like pmcmd, pmrepserver and pmrepagent to execute or control sessions, tasks, workflows and deployment groups in non-windows environments
• Extensively worked on Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Automated Informatica flow of loading data by using Autosys scheduler.
• Expertise in Query Analyzing, performance tuning and testing.
• Experienced in using database interface tools like Toad and PL/SQL Developer.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/ 8.x/7.x

DATABASES: Oracle 11g/10g/9i/8i, DB2, MS SQL Server 2005/2008, Sybase, Teradata, MS Access, Netezza.

Scheduling Tools: Autosys, Control-M and UC4

Oracle Tools: SQL PLUS, SQL Developer, TOAD

Data Modeling: Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables.

Business Intelligence: COGNOS 8 BI,BO 6.x

Languages: PL/SQL, SQL, TOAD, UNIX Shell Scripting.

Operating Systems: UNIX/LINUX, Windows 95/98/00/NT/XP, WindowsServer2003/2007.

Testing tools: HP QC, QTP, SharePoint, Jira

PROFESSIONAL EXPERIENCE

Confidential, Peepak, NJ

Responsibilities:

• Created mapping to import DVSO source data (StudyList, PlanList, Milestone, Recruitment) using Informatica Web service.
• Used advanced transformations like Java transformation and sql transformation.
• Used Informatica IDQ to check and apply data quality rules.
• Defined the Source databases and Target databases in Informatica..
• Involved in adding Sources and Target databases to Mapping Designer of Informatica.
• Created the Mappings in Informatica.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, lookup, update strategy, Sequence Generator Transformations, Stored Procedure Transformations, Aggregate transformations and Expression Transformations in Informatica.
• Involved in creating, editing, deleting and scheduling of the Sessions in Informatica.
• Involved in preparing the specification documents for individual mapping customization.
• Creating mappings to extract data from source files, transform the data using filters, expressions and stored procedures and then load to Oracle data warehouse.

ENVIRONMENT: Informatica Power Center 9.5/9.1,Informatica IDQ 9.5, Informatica Metadata Manager, Composite, Test Director, AutoSys, UC4, Business Objects 4.0, HP UNIX, Windows NT, Oracle 11g, Erwin 7.2, SQL, PL/SQL, Toad 11.5 and SQL Loader

Confidential, Atlanta, GA

Sr. Informatica Developer

Responsibilities:

• Worked closely with business analyst and Data Warehouse architect to understand the source data and need of the Warehouse.
• Translate customer requirements into formal requirements and design documents.
• Involved in creating the design and technical specifications for the ETL process based on Functional specifications.
• Worked extensively to create integration to build DataMarts.
• Written Informatica mapping for dropping and recreating the indexes of database tables.
• Development of address cleansing Mapplet and mapping using First logic plug-in.
• Worked extensively with Extraction, Transformation and Loading of data from Multiple Sources (oracle,Netezza,Taradata, fixed width and delimited flat files) to ORACLE usingInformatica.
• Worked on Scheduling workflows and sessions usingInformaticascheduler and have implemented decision task and email task for tracking the successful completion
• Handled the creation of tables, views, triggers, stored procedures, functions, sequences in the database using SQL and PL/SQL scripts.
• Experence in using Taradata tools like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) and BTEQ.
• Extensively used T-SQL in creating Procedure.
• Implemented complex mapping such as SLOWLY CHANGING DIMENSIONS (Type II).
• Worked on various types of transformations like Expression, Joiner, update strategy, Aggregator, Filter and Lookup.
• Created UNIX scripts for parsing and modifying data and experience in using AUTOSYS job scheduler for automation of UNIX shell scripts and batch scheduling.
• Facilitate end-user procedures development.

Environment: Informatica Power Center 9.0.1/8.6.1 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g,DB2,TARADATA,NETEZZA,XML,SQLServer2008,UNIX,TOAD,AUTOSYSCONGNOS.

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Participated in the analysis, design, development, and testing of ETL development projects. Also, was involved in assignments that required Data analysis to help out other team members to prepare new project requirements.
• Used Informatica Power Center 8.6.1/8.1.3 for Extraction, Transformation, & Loading of data from multiple sources to multiple targets.
• Extensively involved in developing ETL processes, loading and validating data from source systems into the data warehouse using Informatica and/or Oracle Data integrator (ODI) and Oracle SQL, PL/SQL procedures.
• Worked extensively using Informatica designer components - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Worked extensively using T-SQL.
• Used Teradata tools & utilities like Fast Load, Multi Load, TPump, Fast Export, Teradata Parallel Transporter (TPT) extensively.
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in Transformations.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Worked Closely to build DataMart and Data Warehouse as a part of regular job.
• Used AUTOSYS for scheduling the workflow.
• Converted existing PL/SQL procedures/packages to ETL Mappings using Informatica Power Center.
• Performed Unit Testing and Integration Testing on the mappings.
• Involved in Implementing SLOWLY CHANGING DIMENSIONS - Type I & II in different mappings as per the requirements.

Environment: Informatica Power Center 8.6.1/8.1.3 , Oracle 10g, Teradata,Netezza, MS Access, SQL Server 2008,Sybase,PL/SQL,UNIX,TOAD,COGNOS,AUTOSYS.

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.
• Developed mappings using Source qualifier, Aggregators, Connected & unconnected Lookups, Stored Procedures, Filters, Sorter & Update strategy Transformations using Power Center.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.
• Involved in Creating tasks, Worklets, workflows to load the data
• Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.
• Troubleshoot problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting.
• Used PMCMD commands for stopping and starting workflows and tasks.
• Worked closely in preparation of technical documentation of transformation components.
• Participates in design and development reviews
• Developed UNIX to automate different tasks involved as part of loading process and scheduling.
• Performed Unit Testing and Integration Testing on the mappings.
• Involved in maintaining effective relations with co-workers and business People.

Environment: Informatica Power Center 8.1.3, Oracle 9i, Data Stage, SQL* Loader, Windows 2000, DB2, Taradata, MS Access, UNIX.

Confidential

ETL Developer

Responsibilities:

• Responsible for business analysis and requirements collections.
• Prepared the DDL’s for the staging/work tables and coordinated with DBA for creating the development environment and data models.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 7.1.2.
• Used PL/SQL with Informatica Power Center 7.1.2 for Oracle 8i database.
• Performance tuning and bottleneck resolution.
• Created and Implemented Reusable Sessions like E-mail.
• Designed and documented the validation rules, error handling and test strategy of the mapping.
• Written different varieties of loading scripts for loading the data in to DB and developed scripts to extract data in to files.
• Developed UNIX shell scripts to automate the Data Load processes to the target DW.
• Involved in design and creation of Fact tables and Dimensions.
• Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregator, Lookup, Filter, Update Strategy, Expression, Sequence generator and Sorter.
• Done various optimization techniques in Aggregator, Lookup and Joiner transformation.

Environment: Informatica Power Center 7.1.2., Oracle 8i, TOAD, SQL Server, Flat Files, Windows XP, UNIX, MS Visio.

Confidential

Informatica Developer

Responsibilities:

• Involved in analyzing the systems and gathering of requirements.
• Analyzed the requirements to identify the necessary tables that need to be populated into the staging database.
• Extracted the data from Flat files, SQL Server, Oracle, DB2, and Sybase and load the data into flat files, Oracle and SQL Server using Informatica Power center.
• Created shortcuts for source and target and also created Reusable Transformations, Mapplets in Shared folder.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Performed Data Migration from OLTP to Data warehouse environment.
• Interacted with the business people on user requirements.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Informatica features to implement Type I, II changes in Slowly Changing Dimension tables.
• Used mapping parameters and variables
• Extensively worked on UNIX.
• Effectively involved in user accepting testing and preparing test cases.
• Periodical Interaction with Client to resolve mapping issues.

Environment: Informatica Power Center 7.1.2, Oracle 8i, UNIX Shell Scripts, Flat File, SQL Server 2005,DB2,Sybase,TOAD 8.6