SUMMARY

• Over 7+ years of IT experience wif a strong background in SDLC, Data Integration tool Informatica PowerCenter, Informatica PowerExchange.
• Expertise in Informatica Power Center 9.x/8.x/7.x/6.x extracting data from Oracle, SQL Server and DB2 databases.
• Involved in different phases of Data Warehouse Life Cycle including business reporting requirements gathering, source system analysis, logical/physical data modeling, ETL design/development, project deployment, production support.
• Strong ability to analyze source systems and business requirements, identify and document business rules, design data architecture for cohesive decision support and prepare dimensional data models.
• Extensive noledge of Dimensional Data Modeling like Star and Snowflake schemas.
• Very skilled in development of Informatica Mappings and Informatica Workflows.
• Experience wif Informatica Advanced Techniques like Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and partitioning.
• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in SQL Server 2000/2005, Oracle 10g/9i/8i and DB2.
• Expertise in Unix Shell Scripting and experience on different UNIX platforms.
• Experience in scheduling of ETL jobs using Crontab, Autosys and Appworx.
• Knowledge in developing reports using Business Intelligence tools like Business Objects and Cognos.
• Experience in working in an onsite - offshore structure and TEMPeffectively coordinated tasks between onsite and offshore teams.
• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.
• A highly motivated self-starter and a good team-player wif excellent verbal and written communication skills.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.x/8.x/7.x/6.x, Informatica Power Exchange

RDBMS: Oracle 10g/9i, SQL Server 2000/2005,DB2

Methodologies: Star schema and Snowflake schema

Languages: SQL, PL/SQL UNIX Shell Scripting, PERL

Operating system: Windows NT, Windows 95/98/2000/XP, UNIX, Linux

Scheduling Tools: Crontab, Autosys, Appworx

Others: MS Word 97, Visio design, MS Access 7.0/97

PROFESSIONAL EXPERIENCE

Confidential, FL

Sr. Informatica Developer, Onsite Coordinator

Responsibilities:

• Co-ordinated Joint Application Development (JAD) sessions wif Business Analysts and source developer for performing data analysis and gathering business requirements.
• Coordinated offshore and onsite team wif a total of 7 ETL developers
• Developed technical specifications of the ETL process flow.
• Designed the Source - Target mappings and involved in designing the Selection Criteria document.
• Extensively used ETL to load data from Flat files, SQL Server and Oracle into Oracle.
• Used Informatica Power Center 8x/9x to create mappings, sessions and workflows for populating the Data into dimension, fact, and lookup tables simultaneously from different source systems (SQL server, Oracle, Flat files)
• Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, Sequence Generator and Normalizer
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, Reducing the development time
• Used version mapping to update the slowly changing dimensions to keep full history to the target database.
• Involved in migration of Informatica from 8.x to 9.x.
• Implemented sending of Post-Session Email once data is loaded.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Used Debugger to test the mappings and fixed the bugs.
• Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
• Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
• Involved in exporting database, table spaces, and tables using Datapump (10g) as well as traditional export/import (until 9i).
• Knowledge of Cold/Hot backups and RMAN backups.
• Scheduled various daily and monthly ETL loads using Crontab
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Involved in unit testing and documentation of the ETL process
• Involved in Production Support in resolving issues and bugs.
• Created Cognos Impromptu reports utilizing existing Oracle views and tables.

Environment: Informatica Power Center 8.x, Oracle 10g, JDeveloper, DB2 8.1.6/8.2.0, UNIX, Windows NT 4.0, UNIX Shell Programming, PL/SQL, T-SQL, TOAD Quest Software

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Involved in gathering business requirements and attended technical review meetings to understand the data warehouse model.
• Involved in data modeling and design of data warehouse in star schema methodology wif confirmed granular dimensions and Fact tables.
• Developed Technical Specifications of the ETL process flow.
• Extensively used ETL to load data from Flat files, DB2 and Oracle into Oracle.
• Used Informatica Designer to Extract & Transform the data from various source systems by incorporating various business rules. Also used different transformations, sessions and command tasks.
• Created mappings using different transformations like Aggregator, Expression, Stored Procedure, Filter, Joiner, Lookup, Router and Update Strategy.
• Worked wif mapping variable, Mapping parameters and variable functions like Setvariable, Countvariable, Setminvariable and Setmaxvariable.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Using Informatica Repository Manager maintained all the repositories of various applications, created users, user groups, and security access control.
• Developed shell scripts for job automation, which will generate the log file for every job.
• Created Stored Procedures for Audit and Error Balancing.
• Used Crontab for scheduling.
• Validated Data to Maintain Referential Integrity.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels.
• Worked on back end programming such as PL/SQL procedures, functions and packages.
• Prepared a production monitoring and support handbook for ETL Process.
• Involved in design and development of Reporting System using Business Objects.

Environment: Informatica Power Center 9.x/8.x, SQL Server 2005, PL/SQL, Oracle 10g, Toad 8.0, Cognos 8.3, Windows NT, UNIX Shell Scripting.

Confidential, BOSTON, MA

ETL Consultant

Responsibilities:

• Interacted wif business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Analyzed existing requirements and consolidated the reports for TEMPeffective and efficient reporting.Extensively worked on tuning mappings and reducing processing times.Involved in Code reviews and determining Informatica standards for Mappings/Sessions/Workflows. Met wif end users to gather requirements. Translated business requirements into Informatica mappings/workflows. Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, mapping).
• Created shell scripts to kick off Informatica workflows and Pl/sql procedures. Created Database Triggers, Stored Procedure, Functions and Packages. Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Created UNIX scripts for automation of ETL process.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Worked wif DBA to identify source and target bottle necks.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center 8.6.1, Sql Server 2005, Oracle 10g, PL/SQL, Business ObjectsXI R2,Toad, Linux, Unix Shell Scripts.

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Used Informatica PowerCenter for (ETL) Extraction, Transformation and Loading data from heterogeneous source systems like flat files, database tables and XML files.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator), Mapplets and Mappings using Designer module of Informatica. Analyzed and created Facts, Dimension tables.
• Loaded data into heterogeneous systems acceptable by Legacy system Migration workbench (LSMW)to load into SAP.
• Wrote complex SQL queries, stored procedures using Oracle 8i/9i and UNIX shell scripts for achieving the ETL requirements.
• Involved in performance tuning of Informatica mappings, sessions and workflows.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Scheduled and executed batch and session jobs on Autosys.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Scheduled workflows and sent automatic email messages that post the statistics of the data load.
• Quickly understood and provided alternate solutions to requirement changes by simplifying mappings, sessions and workflows and improving their performance by using transformations like source filters and sorted input in aggregator while still achieving the desired results wifin the stipulated timeframe.
• Performed extensive testing of changes and fixes in different environments.
• Incorporated the changes and reverted to the business wifin the least possible turnaround time.
• Involved in Recording scripts and loading data into SAP using QTP.
• Coordinated the onsite-offshore teams for developing new requirements.

Environment: Informatica Power Center 8.x, Oracle 8i/9i, 10g, Toad, UNIX Shell Programming, PL/SQL.

Confidential

Jr.ETL Developer

Responsibilities:

• Used Informatica power center for (ETL) Extraction, Transformation and Loading data from heterogeneous source systems
• Assisted in creating the Technical designspecifications based on Client functional specs.
• Involved in development of Mappings, Sessions and Workflows.
• Used transformation such as Source qualifier, Target, Aggregator, Expression, Filter, Joiner, Normaliser, Rank, sorter Store procedure Lookup, and router transformations.
• Designed re-usable sessions and mapplets to ensure better productivity and consistency.
• Involved in writing UNIX shell Scripts for obtaining the data from source systems to the Data Warehouse.
• Scheduled various daily and monthly ETL loads using Appworx.

Environment: Informatica Power Center 7.x, SQL Server, Oracle, SQL Loader, UNIX Shell Scripting, Perl, Toad, AIX, Appworx.