SUMMARY

• Over 7 years of experience in development of ETL process for extracting, transforming and loading data using ETL tool Informatica Power Center 8.x/7.x/6.x in various domains like Mortgage Insurance, Pharmaceuticals, Banking and manufacturing industries.
• Proficiency working with Informatica Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Experienced in integrating various data sources with Multiple Relational Databases like Oracle, SQL Server and DB2, MS Excel, XML, COBOL and flat files like fixed length and delimited.
• Extensively worked with ODS and staging area to perform data cleansing, data profiling, data consolidating, and data standardization process.
• Extensive experience in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, scheduling the Workflows and sessions.
• Designed and developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer.
• Expert in implementing Type 1, Type 2 and Type 3 Slowly Changing Dimensions as per the business requirements to maintain full historical information.
• Implemented performance tuning of sessions by identifying bottlenecks in Sources, Targets & Mappings, Performed unit testing & used Debugger to debug the complex mappings and fix them.
• Developed UNIX shell scripts for automation of sessions as well used in command task to handle requirements like dropping and building indexes, flat file archiving/dropping process.
• Expert in RDBMS concepts, PL/SQL Stored Procedures, Functions and creating database objects like Tables, Indexes, Views, synonyms and sequences.
• Proficient in understanding Data warehouse concepts for Ralph Kimball & Bill Inmon Methodologies, Star Schema, Snowflake schema and Surrogate keys.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 8.x/7.x/6.x, Oracle 10g/9i/8i, DB2, SQL Server 2000/2005/2008 , Teradata, MS SQL, SQL, PL/SQL, Toad, SQL developer,, SQL *Pus, XML, COBOL, SQL loader, Unix Shell Scripting, Erwin 3.5/4.0, MS Office, MS Visio

Operating Systems: Windows, UNIX, and Linux

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analyst to gather and understand the business requirements based on Functional specification to design the ETL.
• Implemented code using various Informatica Transformations like Source qualifier, Joiner, Union, Expression, Lookup, Aggregate, Filter, Router, Normalizer and Update Strategy.
• Performed Unit testing for mappings to ensure successful execution of the data loading processes & fix the errors to meet the requirement.
• Involved in preparing data flow diagram for new and existing ETL on MS Visio for documentation purpose and better understanding of data flow for non ETL team.
• Used connected /Unconnected Lookup Transformation to lookup the values in Flat Files and relational sources and targets.
• Developed huge workflows with Worklets, Session, Command, Decision, E - mail, Control, Timer, Event-Wait and Event - Raise tasks.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups as well used filter conditions in source qualifier thereby improving the performance of the mapping.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Wrote the Pre SQL and Post SQL for creating & dropping the indexes before the session run to improve the session performance and rebuild them after completion of session.
• Extensively worked on Mapping parameters and Variables and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Automation and Scheduling of ETL jobs through PMCMD Command and Crontab utility through UNIX.
• Tested all the mappings and sessions in Development environment and migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, SQL Loader, Toad 8.5, Delimited Flat Files, SQL, PL/SQL, MS Visio 7, UNIX Shell Scripts, Windows XP

Confidential, Morris Plains, NJ

Sr. Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Extensively worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Implemented code using various Informatica Transformations like Source qualifier, Joiner, Union, Expression, Lookup, Aggregate, Filter, Router, Normalizer, XML and Update Strategy.
• Developed SQL overrides in Source Qualifier and Lookup transformations according to business requirements.
• Implemented Type 2 Slowly Changing Dimensions to maintain the historical data in sales data mart as per the business requirements.
• Implemented different Tasks in workflows which include Session, Command, E-mail, Event-Wait, Event - Raise, Timer etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets, Transformation and sessions by identifying and rectifying performance bottlenecks.
• Used stored procedures for creating & dropping the indexes before the session run to improve the session performance and rebuild them after completion of session.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Automation of job processing using Autosys scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager
• Migrating ETL code, including mappings, sessions and workflows from development to QA and production environment.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, Teradata, SQL Loader, Toad 8.5, Delimited Flat Files, SQL*Plus, PL/SQL, UNIX Shell Scripts, Autosys, Solaris 5.8, Windows XP

Confidential, Pennington, NJ

Informatica Developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Experience in integration of heterogeneous data sources like Oracle, Sybase, Teradata, DB2, SQL Server and Flat Files (Fixed & delimited) into Staging Area.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.

Environment: Informatica Power Center 8.5, Oracle 10g, SQL Server 2005, DB2, Teradata, SQL*Plus, SQL Loader, SQL Developer, Autosys, COBOL files, Flat files, UNIX, Windows 2000

Confidential, Norwalk, CT

Informatica Developer

Responsibilities:

• Interacted with Business Analyst and DBA to gather the Requirements and Business logics.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files, DB2 and load the data in to Oracle database
• Designed and developed complex mappings using different transformations like Source Qualifier, Expression, Aggregator, Joiner, Union, Sorter, Router, filter, Update strategy, and look up, stored procedure.
• Imported XML Source files to Designer, modified groups used in the Mappings and loaded into relational tables and some XML target files
• Implemented Type 2 & Type 3 Slowly Changing Dimensions in mappings to maintain historical data as per the business requirements.
• Created workflows, worklets and scheduled the sessions according to Target Load order also scheduled the workflows for daily, weekly and monthly loads.
• Analyzing the Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Automation of job processing, establishing automatic email notifications to the concerned persons.

Environment: Informatica Power Center 7.1, Oracle 9i, DB2, MS SQL, SQL Server 2005, Flat files, Windows NT, UNIX, Toad, SQL*PLUS, Erwin 3.5,Putty

Confidential, Tampa, FL

Informatica Consultant

Responsibilities:

• Co-ordinate with the Business Analysts and users to understand business and functional needs and implement the same into an ETL design document.
• Extensively worked on Informatica Power Center Designer (Source Analyzer, Warehouse designer, Transformation Developer, Mapping Designer and Mapplet Designer).
• Prepared high-level design specification document, Informatica Mapping specification documents for all the Transformations used in the project.
• Developed Informatica mappings using heterogeneous sources like flat files and different relational databases, Mapplets, Mappings using Power center Designer.
• Implemented Type 2 and Type 3 Slowly Changing Dimensions in mappings as per the business requirements.
• Developed and Implemented UNIX shell scripts through command task to handle requirements like dropping and building indexes, flat file archiving/dropping process etc.
• Scheduled Workflows based on demand, run on time, run only once using Informatica Workflow Manager and shell scripts.
• Used PMCMD command to automate the Power Center sessions and workflows through UNIX.
• Extensively worked in the performance tuning for the mappings and ETL Procedures both at designer and session level.
• At session level tuned the mapping by setting the buffer size, cache size, increasing commit intervals.

Environment: Informatica Power Center 6.2, Oracle 9i, Flat files, SQL Server 2000, DB2, SQL *Plus, Windows 98, Sun Solaris, TOAD

Confidential

ETL / Informatica Developer

Responsibilities:

• ETL was developed using Informatica to transform and load the data.
• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client toolsSource Analyzer, Warehouse designer, Mapping designer and Mapplet Designer.
• Extracted data form Flat files, Oracle database, DB2 and SQL SERVER and applied business logic to load them in the target database.
• Designed and developed complexmappings using source qualifier, Aggregate, expression, filter, join, Router, Lookup, sequence generator and Update strategy transformation rules.
• Worked on sequential and parallel jobs to run multiple sessions concurrently and parallel to improve performance.
• Identified various bottlenecks and critical paths of data transformation in sessions.
• Migrated folders from development repository to QA repository.
• Created email tasks for reporting the status to entire group.

Environment: Informatica Power Center 6.1, Oracle 8i, SQL SERVER 2000, Flat files, DB2, SQL*Plus, Windows95,UNIX