SUMMARY

• Five Plus years of experience in Information Technology wif a strong background in Informatica Power Center, SQL Scripts and Data Warehousing.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center 8.6./9.1/9.5
• Extensive Experience in Informatica PowerCenter wif strong business understanding and knowledge of ETL of data from heterogeneous source systems such as Oracle, Teradata, SQL Server, Flat files, CSV files, XML files Into Data warehouse and Analytical Data Model.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.
• Strong in Data warehousing concepts, Dimensional, Star Schema and Snowflakes Schema methodologies.
• Extensively used Flat Files to load data from source systems to targets using Direct and Indirect methods.
• Proficient in understanding business processes / requirements and translating them into Technical requirements.
• Extensively worked on Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Designed complex mappings using Source Qualifier, Filter, Expression, Aggregator, Router, Update Strategy, Union, Unconnected and Connected Lookups, Joiner, Sorter and XML Transformations.
• Experience in integration of various data sources like Oracle, Teradata, SQL Server, Flat Files and DB2 into teh data warehouse.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers for Loading target Tables.
• Excellent expertise wif different types of data load strategies and scenarios like Historical dimensions, Surrogate keys and Summary facts etc.
• Troubleshooting and problem solving applications wif Informatica Debugger and performing code migration from Dev to Test.
• Have performed various testing activities like Unit testing, Integration-system Testing and User Acceptance Testing (UAT) and ensured that teh code is ideal.
• Experience in Shell Scripting on UNIX & Linux platform.
• Well-developed interpersonal and communication skills.
• Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/ 8.6

Methodologies: Star Schema, Snow Flake Schema, FACT and Dimension Tables.

RDBMS: Oracle 11g/10g/9i, Teradata 14.0, SQL Server 2008/2005, MS Access.

Operating System: Windows 7, Windows Vista/XP/2000, UNIX/Linux.

Development tools: Toad for Oracle, Teradata SQL Assistance, SQL Developer. Programming/Languages SQL, PL/SQL, UNIX shell scripting, C, C++, Java.

PROFESSIONAL EXPERIENCE

Confidential, Walpole, MA

ETL Developer

Responsibilities:

• Experienced in working closely wif teh Business Analyst, SME while preparing and reviewing teh business specifications of teh project.
• Design ETL processes using Informatica tool to load data from heterogeneous sources systems such as Oracle, Fixed Width and Delimited Flat Files into Oracle Target database.
• Worked wif various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Workflow Monitor.
• Developed ETL mappings in Informatica PowerCenter Designer using various transformations like Source Qualifier, Router, Expression, Filter, Connected and Unconnected Lookup, Update Strategy, Sequence Generator, SQL transformations, Union etc.
• Done performance tuning of teh process at teh mapping level, session level, source level, and teh target level.
• Used Session Task, Command Task, and Event Raise/Event Wait, Email task etc. to develop Workflows.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Trouble shooting and problem solving applications wif Informatica Debugger. Used debugger to test teh data flow and fix teh mappings. Used session log files to identify teh errors by analyzing teh log files if teh session failed and resolved teh errors.
• Implemented Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Performed Unit testing and Data validation testing using Validation scripts for source and target table.
• Implemented documentation standards and practices to make mappings easier to maintain.
• Monitored and improved query performance by creating views, indexes, and sub queries and Extensively Used Oracle Explain plan for query Performance Tuning.
• Used SQL Developer and Toad for Oracle to development of scripts, views, PL/SQL Stored procedures to loading data to teh target tables.
• Scheduled various workflows tasks using Informatica Scheduler. Involved in attending Daily and Weekly Project Status Meetings.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 9.5, Oracle 11g, TOAD, SQL Developer, Relational Tables, Flat Files and Windows 7.

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

• Involved extensively in both development of theETL(Extract, Transform and Load) processes and production support usingInformatica Power Center 9.5/9.1.
• Handled efficiently both enhancements and development of new code projects simultaneously based on teh priority of teh project.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and Relational Table and loaded into Detail and summery table of Teradata 14.0 and Oracle 11g target database.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from teh relational database
• Worked wif various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Workflow Monitor.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation and Aggregator Transformation.
• Improving workflow performance by shifting filters as close as possible to teh source and selecting tables wif TEMPfewer rows as teh master during joins.
• DevelopedTeradata Stored Programs (Procedures, Mecro and Functions)to loading on teh fly table for special type of reports.
• UsedWorkflow Managerfor Creating, Validating, Testing and Running teh sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• Done Error Handling and debugging using Informatica debugger, Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored teh sessions and workflows on teh basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Created Workflows wif Worklets, event wait, event raise, decision, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Involved in User Acceptance Testing and closely worked wif teh Cognos report developer to ensure that correct data is presented in teh reports.
• Interacted wif Teradata DBA team for creation of primary and secondary indexes on Data Warehouse tables
• Update teh source view and target table definition as per teh requirement change.
• Used Teradata SQL Assistance, TOAD for Oracle to run SQL queries and validate and testing teh data.

Environment: Informatica Power Center 9.5/9.1, Teradata 14.0, Oracle 11g, Teradata SQL Assistant, TOAD, Relational Table, Flat Files and Windows 7.

Confidential, MA

ETL Developer/Data Specialist

Responsibilities:

• Responsible for development of theETL(Extract, Transform and Load) processes usingInformatica Power Center.
• Developed an ETL Informatica mapping For Extracting data from different type of source like flat files and Relational Table and loaded into Oracle 10g target database.
• Worked wif Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations -various Informatica Power Center tools.
• Used transformations likeSource Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence GeneratorsandStored Procedure for Creating Informatica mappings.
• UsedSlowly Changing DimensionMappings of type II and I.
• Createdreusable transformationsandMappletsand used them in complex mappings.
• UsedWorkflow Managerfor Creating, Validating, Testing and Running teh sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• Implemented fine development methods for teh Developing mappings.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored teh sessions and workflows on teh basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Closely worked wif teh reporting team to ensure that correct data is presented in teh reports.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Involved in teh creation of Test Cases using SQL and executing Unit Test Scripts and publishing Test Results.

Environment: Informatica Power Center 9.1/8.6.1, Oracle10g, SQL Server 2008, TOAD, SQL developer, Relational Table, Flat Files, Linux, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Designed, developed and improved complex ETL structures to extract transform and load data from multiple data sources into data warehouse and other databases based on business requirements..
• Knowledge of Repository, Folders, Users, and user privileges using Repository Manager.
• Define, create and access data source layouts and target data warehouse and data mart Schemas through Informatica Power Mart Designer.
• Was responsible for Design, development and documentation of Informatica ETL mappings to cleanse, format and move data using Informatica Designer
• Worked extensively wif complex mappings using expressions, aggregators, filters, lookups, Update strategy, router, joiner, rank, sequence generator transformations in Informatica.
• Performed Code review to ensure that ETL development was done according to teh company's ETL standard and that ETL best practices were followed.
• Prepared SQL Queries to validate teh data in both source and target databases.
• Extensively worked in teh performance tuning for teh mappings and ETL procedures, both at designer and session level.
• At session level, tuned teh mapping by setting teh buffer size, cache size, increasing commit intervals etc.
• Done Error Handling and debugging using Informatica debugger.
• Involved in Performance tuning of various queries understanding teh need of indexes after having complete note of teh Explain Plan.

Environment: Informatica 8.6 Power Center, SQL, PL/SQL, Oracle, TOAD, Relational Table, Flat File and WINDOWS XP.

Confidential

Jr. ETL Developer

Responsibilities:

• Understood teh business requirements to transform teh data.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Utilized Informatica to develop detailed mappings for data extract, transformation and loading.
• Developed mappings/Transformations/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power Center.
• Worked wif Informatica Transformations like Sorter, Filter, lookups, Update strategy, router, joiner, rank, sequence generator
• Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO DATE, DATE COMPARE in various transformations.
• Created parameter files, session and workflow and worked wif workflow monitor to monitor running workflows.
• Supported DBA functions such as creating user account, grant permissions, ran some DDL and DML Script, Schema Scripts.
• Wrote PL/SQL stored procedure, triggers and function to implement business rules using SQL Developer and Toad.
• Developed complex SQL extract queries, PL/SQL programs, procedures, functions, database triggers, tables, views, packages Using Toad Developer Tool.
• Created tables, updated tables and deleted unwanted tables from teh database as per teh requirement.
• Worked wif DDL, DML, DCL and TC commands on Tables / Views. Applied teh indexes over teh Table structures. Worked wif Stored Procedures and Functions.

Environment: Informatica 8.1 Power Center, SQL, PL/SQL, Oracle, TOAD, SQL Developer, Relational Table, Flat File and WINDOWS XP.