SUMMARY

• 8+ years Extensive experience in using ETL methodologies for supporting Data Extraction, Data Migration, Data Transformation and loading using Informatica Power Center 9.5/9.1/8.6. 1/ 7/6.2 , Power Exchange 9.5/9.1/8.6. , Teradata 13/12,DB2.
• Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries.
• Good understanding of Dimensional Modelling using Star schema methodology and Snow Flake schema methodology.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Strong understanding of OLAP and OLTP Concepts
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 etc.
• Experience in SQL, PL/SQL and UNIX shell scripting.
• Worked wif Full Software Development Life Cycle (SDLC) involving Application Development and ETL/OLAP Processes.
• Used Informatica Metadata Manager and Metadata Exchange exhaustively to maintain and document metadata.
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts wif emphasis on ETL and SDLC (Software Development Lifecycle), Quality analysis.
• Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes wif Query optimizations as part of ETL Development process.
• Adept in UNIX operating system commands & Shell Scripting.
• Experienced in Quality Assurance, Manual and Automated Testing Procedures wif active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.
• Having exposure on Informatica Cloud Services.
• Worked wif Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Strong decision - making and interpersonal skills wif result oriented dedication towards goals.
• Experience wif SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Working Knowledge on Salesforce.com (SFDC).

TECHNICAL SKILLS

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

Business Intelligence: Business Objects 6.5/5.1.7

Databases: Oracle 11g/10g/9i,, SQL Server, Greenplum 4.0/4.1,MS SQL Server 2008/2005/2000

Teradata 14/12:

Languages: UNIX, Shell scripting, SQL, PL/SQL, C, C++

Web Technologies: HTML, DHTML, Joomla 1.6

Design: ERWin Platinum 4.0/3.5,Visio, SQL Developer Data Modeller

Tools: MS Office Suite 2003, TOAD, SQL Plus, SQL Developer, Autosys r11.x, PGAdmin III

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Designing, Implement and delivering data warehouse ETL and reporting applications.
• Worked wif project managers, design lead and solution architect to achieve business and functional requirements.
• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Review existing systems to determine compatibility wif projected and select appropriate systems, including ensuring forward compatibility of existing systems
• Database development and ETL process in Oracle l0g and Greenplum using PSQL, SQL, PERL and UNIX scripting.
• Design/implement queries to extract specific data from legacy system to new data warehouse.
• Worked on the Performance tuning of the programs, ETL Procedures and processes.
• Worked in debugging using Log messages, Server Messages.
• Establish controls to ensure the accuracy and consistency of data.
• Supporting, correcting and following up trouble reports Skills.
• Preparation of the various technical and functional documents consisting of Detailed Design Documentation, function test specification wif use cases.
• Analysis of source systems and work wif business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Cooperating wif stakeholders at handover, system verification, and operations on a need basis.
• Actively coordinated wif testing team in the testing phase and halped the team to understand the dependency chain of the whole project.

Environment: Informatica Power Center 9.5/ Power Exchange 9.5,Oracle 11g, PSQL, PERL, Unix, SQL, SQL Developer, SQL Data Modeler, Sun Solaris, VM Ware, DB2,Teradata, 14, Greenplum 4.0/4.1, SQL Developer Data Modeler, PGAdmin III

Confidential, MN

Sr. ETL / Informatica Developer

Responsibilities:

• Analysis of source systems and work wif business analysts to identify study and understand requirements and translate them into ETL code.
• Perform analysis on quality and source of data to determine accuracy of information being reported.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Designed and developed the Mappings using various transformations to suit the business user requirements and business rules to load data from SQL Server, flat file and XML file sources targeting the views (views on the target tables) in the target database (Oracle).
• Developed custom data transformation (structured/unstructured data) process using Item field content master data transformation tool.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Developed PL/SQL stored procedures for Informatica mappings.
• Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data for management reporting.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Providing technical support and troubleshooting issues for business users.
• Actively Participated in problem solving and troubleshooting for the applications implemented wif Informatica.
• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

Environment: Informatica PowerCenter 8.1, Power Exchange 8.1, Erwin 4.1, EDI, Autosys r11.0 oracle 9i, PL/SQL, Teradata 12, SQL,, XML, SQL Server 2005, DB2.Windows 2003, Unix.

Confidential, Dallas, TX

Sr. ETL / Informatica Developer

Responsibilities:

• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Interaction wif the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (HLD & LLD).
• As an active team member, involved in the initial phases of the design and was taken part in the analysis of the product.
• Created Informatica mappings wif PL/SQL procedures/functions to build business rules to load data.
• Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Involved in the creation of oracle Tables, Table Partitions, Materialized views and Indexes and PL/SQL stored procedures, functions, triggers and packages.
• Working wif various sources such as Flat files, Relational, XML and Web services as part of Informatica Mappings.
• Worked wif Mapping and Workflow variables by using the value of mapping variables on the workflow level.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
• Responsible to tune ETL mappings to optimize load and query Performance
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
• Worked on Shell Scripts in order to convert incoming Excel Flat files from .xls to .csv which halps importing into Informatica.
• On-Call Production support, for every 2 weeks - 24/7 on a scale of every 2 months.
• Using HP Quality Center for the Defects logs and clearing those wifin the timeline.
• Involved in Performance Tuning of the mappings.
• Worked on MAESTRO schedulers in order to schedule the Informatica Workflows.
• Involved in XML and XSLT coding in order to create the Front End screen insert activities.

Environment: Informatica Power Center 9.0/8.6 - (Designer, Repository Manager, Workflow Manager), Oracle 10g, SOAP UI, TOAD, SQL Developer, UNIX Shell Scripts, Microsoft Visio 2007, Adminserver, UNIX, Windows 2000/NT.

Confidential, Plano, Texas

Sr. Informatica Developer

Responsibilities:

• Intensively worked on Informatica mappings and workflows which involved WebServices. Used Webservice Source and Targets, Webservice Consumer Transformations as a part of mapping
• Configured different kind of mappings and workflows using different sources and targets like Database, XML and Flatfiles.
• Used different kinds of transformations like Expression, Joiner, SQL transofrmation, XML generator, XML parser, Router, Filter, Sequence Generator, Sorter, Union and Stored procedure and developed various mappings.
• Designed Major workflows and used Schedulers in order to kick off the workflows at the scheduled time.
• Worked on WebService Call through Informatica by generating and testing the incoming XML using external Freeware called SOAP UI.
• Used various Tasks like Control, Assignment, Timer, Event-Wait, Event-Raise, Email as a part of Workflow Logic as per the requirements.
• Worked on ADMINSERVER, which is the product associated wif major coding part of the project and halp generating some adminserver activities.
• Wrote Quote Site command (Shell Scripting) as a part of FTP'ing the Files to the mainframe region.
• Planned, developed the test steps, executed test methodologies, provided technical support, and designed test result reports.
• Reviewed the Functional spec and developed test case for Signature Capture device
• Gatheird requirements during inception phase, documented and delivered functional specification documents.
• Developed, designed and automate high level reports using Crystal Reports XI and XIR2 and also supported all the development.
• Developed SQL Views and used them in creating reports using Crystal Reports XI R2.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions which are used in generating the Crystal Reports and also in the Informatica Mapping.
• Troubleshooting and Performance Tuning as part of Workflow/Mapping to optimize load and query Performance.
• Analyzed and framed the business logic for the ETL process as per the requirements.
• Worked on FTP as a part of Informatica Workflow.
• Involved in Migration of Informatica workflows/mappings from development region to Test and Production Environments.
• Developed documentations and user manuals for the Informatica mappings.

Environment: Informatica Power Center 8.5.1/8.6.0 (Designer, Repository Manager, Workflow Manager), Oracle 9i, SQL Server 2005, SOAP UI, TOAD, SQL Developer, UNIX Shell Scripts, Quality Center 9.0, QTP, Crystal Reports XI and XIR2, Microsoft Visio 2007, Admin server, UNIX.

Confidential, Plano, Texas

Informatica Developer

Responsibilities:

• Analysed conceptualized/designed the database dat serves the purpose of proving critical business metrics.
• Assisted in the design and Maintenance of the Metadata environment.
• Worked wif project managers, business analysts, SME and technical advisor to achieve business and functional requirements.
• Gatheird business and technical requirements from both formal and informal sessions through NetMeeting, questionnaire, video conferencing and conference calls.
• Developed high level and detailed level technical documents to define the system components, development environment and implementation planning/strategies.
• Developed ETL procedures to ensure conformity, compliance wif standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Experience in Creation of ETL mappings using Informatica PowerCenter to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Created Sessions and Workflows to load data from the SQL Server, Oracle, flat file, and XML file sources dat exist on servers located at various locations all over the country.
• Extensively used Source Qualifier Transformation to filter data at Source level rather TEMPthan at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer dat triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.

Environment: Informatica PowerCenter 8.6, Autosys r11.3, Oracle 10g, SQL Server 2008, PL/SQL, Erwin, TOAD, SQL*Plus, XML, Teradata V2R6, Windows Server 2008.

Confidential, Huston, Texas

ETL/Informatica Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources likeSQL server 2005, flat files and loaded into oracle DWH.
• Created complex mappings in Power Center Designer usingExpression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations.
• Used data miner to process raw data from flat files.
• Used the update strategy to TEMPeffectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored proceduresfor implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Environment: Informatica PowerCenter 8.1.1, oracle, Flat files, SQL server 2005, SQL, PL/SQL, Windows 2003.

Confidential, Orlando, Florida

Informatica Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Involved in designing technical specifications for building Data Warehouse.
• Involved in project cycle plan for the data warehouse, analyzing the source data, deciding the exact data extraction, transformation, loading strategy & Dimensional modeling.
• Creation of shortcuts for source, targets and created transformations according to business logic.
• Validates the data according to the user end.
• Re-org the tables and rebuild the indexes in a data base for high performance.
• Used unconnected lookup for populating date-time entered field in the target tables.
• Developed mapplets, mappings and configured sessions.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Work Flow Manager.
• Extracted data stored in different databases such as Oracle, SQL Server 2005, DB2 UDB to load finally into a single Data Warehouse repository, which is in Oracle.
• Worked closely wif reporting team and generated reports using Business Objects 6.2.
• Analyzed system requirement specifications, coding the routines, developed test plans, test cases to cover overall quality assurance testing.
• Designed and developed unit test cases for system integration testing.
• Involved wif the users in the creation of test scripts for the user acceptance testing.

Environment: Informatica Power Center 7.1.1, DB2 UDB, Oracle 8i, SQL Server 2005, SQL, PL/SQL, Erwin, SQL*Loader, UNIX Shell Script, Business Objects 6.2

Confidential, Orlando, Florida

Informatica Developer

Responsibilities:

• Worked wif Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Created Logical and Physical models for Staging, Transition and Production Warehouses using Erwin 4.0
• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Used sorter transformation and newly changed dynamic lookup
• Created events and tasks in the work flows using workflow manager
• Developed Informatica mappings and also tuned them for better performance wif PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed mappings for policy, claims dimension tables.
• Working wif database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed shell scripts for running batch jobs and scheduling them.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Erwin 4.0, Oracle 10g/9i, SQL, PL/SQL,TOAD, SQL * Loader, Sun Solaris 2.6, UNIX Shell Scripting

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Coordinating wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Designed Informatica mappings by translating the business requirements.
• Worked wif Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse.
• Developed mappings for customers, Investments and Risk analysis.
• Developed reusable Transformations.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Used look up, router, filter, joiner, stored procedure, source qualifier, aggregator and update strategy transformations extensively.
• Assisted in adding Physical conceptual data model using Erwin 4.0.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Assisted the team in the development of design standards and codes for TEMPeffective ETL procedure development and implementation.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Installed, and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica Power Center 7.0/6.2 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, TOAD, Erwin 4.0, PL/SQL, UNIX (Sun Solaris)