SUMMARY

• Over 8+ years of experience in Information Technology with a strong background in Database development, Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1 , Power Exchange using Designer (Source Analyzer, Warehouse designer, Mapping designer, Metadata Manager, Mapplet Designer, Transformation Developer), Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Informatica Power Center in Extraction/Transformation/Loading of data and developed ETL worklets, workflows and ETL mappings.
• Extensively worked on Repository Server Administration Console, 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.
• Expertise in working with data extract using Power Exchange tool by COBOL copybooks layouts.
• Extensive experience in extracting COBOL copybooks and data files from mainframes using JCL.
• Expertise in OLTP/OLAP System Study, Analysis and E - R modeling, developing Database Schemas like Star flake schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Experience in Dimensional Data Modeling experience using Data modeling, Erwin Modeling (Erwin 4.0/3.5.5) like Physical & logical data modeling.
• Experience with Data Extraction, Transformation and Loading from different data sources like Oracle, MS SQL Server etc. into a common analytical data model using InformaticaPower Center 6x/7x/ 8.1/8.5/8.6.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, and Transformations & Sessions.
• Worked with different data sources non-relational Databasessuch asFlat files, XML files, and other relational sources such as Oracle, Sql Server,AS400 and DB2.
• Expert in Teradata SQL, Teradata (TD) Utilities (BTEQ, FastLoad, FastExport, MultiLoad Update/Insert/Delete/Upsert, TD Administrator 7.1, TD SQL Assistant 7.1, TD PMon, TD Warehouse Miner 5.0).
• Business Intelligence experience using Business Objects 6.5/4.5, Web Intelligence 2.5/2.6, Cognos 8 Suite,Cognos Impromptu 8.x/7.x/6.6/6.x, Power play, Transformer, and Impromptu Web Reports.
• Extensive experience in Creating and maintained Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Table Partitions, Synonyms and Database Link.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions.
• Strong experience in Oracle database Performance Tuning and extensive experience in SQL * Loader Imports/Exports
• Experience with industry standard methodologies like RUP, Waterfall, Agile, and Scrum methodology within the Software Development Life Cycle.
• Creating Data Structures i.e. Tables & Views and applying the referential Integrity.
• Implemented Data Cleansing, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience with Business Intelligence using Business Objects 6.5/4.5.
• Familiar with UNIX Shell Scripting, PL/SQL Coding, Normalized Database creation in relational databases like Oracle 8i/9i, MS-SQL Server 2000 and optimizing the SQL to improve the performance.
• Strong understanding of Performance tuning in Informatica and Databases.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Index, and experienced in loading data into Data Warehouse/Data Marts using Informatica.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1 , Star Schema, Snowflake Schema, OLAP, OLTP, Power Exchange 9.x/8.x/7.x.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.x

Databases: Oracle 9i/8i/10g/11g, Greenplum, SQL Server 2008, DB2,MS Access 2008, Tera Data, Netezza.

Reporting Tools: BUSINESS OBJECTS - Designer and Supervisor, Cognos 9.x suite.

GUI: Visual Basic, Macromedia Dreamweaver MX, FrontPage 98/2K, Visio, MS Project,TOAD, Putty.

Programming: SQL, PL/SQL, Transact SQL, HTML, DHTML, XML, C, C++, ASP.NET and Shell.

Environment: Windows95/98/2000/XP/ 2003/2005/2007 , Unix-AIX 5.2/4.3, WinNT4.0

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr ETL Informatica Analyst/Developer

Responsibilities:

• Involved in the existing OLTP system analysis to determine the data flow.
• Frequent Interactions with the end users and business units in order to define the requirements.
• Participated in system design and data modeling (logical and physical).
• Involved in Data warehousing architecture to provide Better access to information to faster, better and more informed decision-making.
• Developed customized routine (ETL system) to capture and load data from external (Oracle 8.x,Flat files) data sources into Oracle database.
• Developed Data Mart for Sales and Marketing.
• Extensively used Informatica to load data from Central Data Warehouse.
• Configured Repository Manager, created folders and managed objects in repository manager of Informatica. Assigned Permissions and Privileges to Objects.
• Based on the data model, segregated the data, finely-tuned and transformed using Informatica.
• Created Informatica mappings to build business rules to load data. Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence.
• Data Integration From GIF (Global Integration Factory) to ODS (Operational Data Store) and From ODS to DM (Data Mart)
• The ETL tool is an integral part of the data warehousing architecture that will be used to model and create target Warehouse, extract data from multiple data sources, transform the data to make it Accessible to business analysis, and loading target data marts.

Environment: Informatica Power Center 9.5, Power Exchange, SQL Server 2008, Greenplum, DB2, XML, SQL, PL/SQL, UNIX, Oracle 11g, Tera data, Autosys, Quality Center, Designer, Toad, Cognos 9.x, Flat files, CVS, Windows 7.

Confidential, San Leandro, CA

Sr. Informatica Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Design inception.
• Extracted and transformed data from high volume data sets of fixed width, delimited and relational sources to load into target systems.
• Developed and maintained critical and complex mappings and transformations involving Normalizer, Aggregator, Expression, Joiner, Filter, Sorter, Sequencer, Procedure, connected & unconnected Lookup, Update Strategy and SQL transformations using Informatica Power Center 9.1.1.
• Performance tuning has been done to increase the through put for both mapping and session level for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Debugged mappings and sessions by creating break points using debugger wizard.
• Redesigned some of the existing mappings in the system to meet new business logic.
• Created mapplets, worklets and other transformations that enable the reusability of code.
• Used parameters and variables extensively in all the mappings, sessions and workflows for easier code modification and maintenance.
• Created Pipeline session partitions for concurrent loading of data and to optimize the performance in loading target tables.
• Effectively used error handling logic mechanism for data and process errors.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Coordinated and lead the complete code migration/merge process from Dev, UAT to Production environments.
• Involved in Unit, data and Integration Testing of Informatica source and Target Data.
• Tuned DB2 SQL queries for better performance.
• Involved in extensive backend testing of various modules and documented the results using Quality Center.

Environment: Informatica Power Center 9.1.1, SQL Server, DB2(AS400 machine), Oracle 11g, Unix, Autosys, Quality Center, Designer, Toad, Cognos 8.x, Flat files, CVS.

Confidential, Palo Alto, CA

ETL Informatica Developer

Responsibilities:

• Developed and maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems of dimensions and Facts.
• Extensively used Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Implemented scheduling logic for daily extract file generation from dimensions and facts.
• Worked on data modeling for designing dimensions and facts for new Cash Flow domain with various source systems for inbound file to DDM.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Worked extensively on Lookup, Router, Filter, Aggregator, Expression and Update Strategy Transformations.
• Used MD5to handle the Slowly Changing Dimensions (SCD) mappings and data from the source and load into Data Mart by following type II process.
• Scheduled Sessions and created connection links for FTP of flat file on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shells scripts.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating shortcuts, re-usable Mapplets and Transformation objects.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum Performance.
• Experience in Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, Teradata Administrator, SQL Assistant, PMon).
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database.
• Conducted initial trouble shooting of Teradata issues including Teradata tables to provide optimum system functionality.
• Experience with high volume datasets from various sources like Oracle, Text Files, and Netezza Relational Tables and xml targets.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited) for temporary persistent repository (TPR).
• Created new Test plans and test queries using Auto-Recon and SQL on an ongoing basis. Assisted in data migration from ETL system to Oracle data warehouse.
• Unit, data and Integration Testing of Informatica source and Target Data.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications of requirements and work status.
• Worked on UNIX machine on which Informatica Server was installed to check for the session logs and stage directories containing data files.
• Tuned DB2 SQL queries for better performance.
• Optimized the mappings by changing the logic to reduce run time.
• Developed the mappings to extract the data on incremental load basis.
• Developed reusable transformations and user defined functions (UDF) for Julian Date Conversion.

Environment: Informatica Power Center 8.6.1 (Repository Manager, Designer), Power Exchange 8.6.1, Oracle 10g,DB2(AS400), Toad, Tera Data, Netezza, Unix-AIX4.3, Ultra Edit 15.10, Text pad 5.4, Business Objects.

Confidential, Los Angeles, CA

Informatica Developer

Responsibilities:

• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• The project source data (Legacy systems, Flat files, and Relational databases) is extracted from all the operational systems and loaded into the data warehouse, which is the union of all the constituent pieces of the business.
• Analyzed source systems (SQL server and Oracle) from Andesa third party vendor, these files were the source to the Informatica interfaces used to load data to the target downstream systems.
• Defined to implementing the required business transformation rules and logic for ETL design and development using Informatica Power Center as ETL tool.
• Written the technical specifications document and data mapping document.
• Created a design document for data flow process from different source systems to target system.
• Worked on the design and development of the data acquisition process for the data warehouse including the initial load and subsequent refreshes.
• Extensive use of Informatica Power center Transformations like Joiner, Aggregators, Connected & unconnected lookups, Filters, Sequence generators, Routers, Expression, Sorter etc.
• Created reusable transformations and Mapplets to import in the common mappings to avoid complexity in the mappings using Informatica designer.
• Used PL/SQL procedures and functions in mappings to do complex database level operations with Oracle 10g.
• Interfaces are built and automated with Informatica ETL tool, PL/SQL and shell scripting.
• Designing and developing exception handling and data cleansing / standardization procedures
• Involved in migrating the Mappings, Sessions, Workflows from Test environment to Production environment.
• Created Business Objects Queries and Reports by analyzing user requirements and Created complex reports by linking data from multiple sources.
• Created documents for data flow and ETL process using Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 8.1, UNIX, EDW, SQL Server 2005, Oracle10g, TOAD, Cognos 7, Shell Scripting and Windows NT.

Confidential - Charlotte, NC

ETL Informatica Developer

Responsibilities:

• Developing mappings to extract the Data from multiple Flat Files and loading them into staging through CDM database.
• Working on Informatica Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Creation and testing of Power ExchangeData maps.
• Installed ABAP programmes on SAP server using Infa Power connect/Power Exchange 8.1.1.
• Used Informatica Power Exchangeto handle the change data capture (CDC) data from the source and load into Data Mart by following Slowly Changing Dimensions (SCD) type II process.
• Involved in modifying existing Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica source and Target Data.
• Analyzed source systems (SQL server, XML and COBOL files) from third party vendor, these files were the source to the Informatica interfaces used to load data to the target downstream systems.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table, and worked mostly on constraint based loading.
• Creating stored procedures, sequences and triggers to insert key into the database table.
• Working with the maps to reconcile the source data through the ODS.
• Functional knowledge of Mortgage and Home Loan modification Plan.
• Involved in Low level Design for the scripts of the database sequences, constraints, triggers and stored procedures.
• Knowledge of Backups,Partitioning of Database tables..
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings. Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Creating Low level documents for creating maps to load the data from the ODS through the warehouse.
• Used designer debugger to test the data flow and fix the mappings. Tuned Informatica Mappings and Sessions for optimum performance.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Oracle database.
• Optimizing the maps by performance tuning.
• Implemented integration of Datamart with Weblogic Server for creating connection pools and Data Sources of Oracle, SQL drivers.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using test data/cases to verify accuracy and completeness of ETL process.

Environment: Informatica Power center 7.1.1, Informatica Power Exchange 7.1.1, Oracle 10g, Toad 8.6 for Oracle, Unix AIX 5.2, Ultra edit 10.20, Flat Files, Web Logic Server 10g.

Confidential

ETL Developer/Tester

Responsibilities:

• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Used extensively in Functionality and Logic testing for all Mappings used in populating the Data Layer.
• Created global repository, Groups, Users assigned privileges using repository manager.
• As a Member of Data warehousing team, oversaw the design, migration, front-end querying of reporting data.
• Designed, developed and debugged ETL Mappings using Informatica designer tool.
• Created different target definitions using warehouse designer of Informatica Power center.
• Designed mapping as per ETL Specification, developed mappings, optimized them for better performance.
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc.,.
• Perform Debugging and Tuning of mapping and sessions and Scheduling of sessions.
• Identified and tracked the slowly changing dimensions.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Used Debugger to check the errors in mapping.
• Generated UNIX shell scripts for automating daily load processes.
• Documented the entire process. The documents include mapping document, unit testing document and system testing document among others.

Environment: Informatica Power Center 6.2 (Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer), Oracle 8i, Flat Files.