SUMMARY:

• Over 8 years of overall IT exposure with system design, development, testing support and production support Data Warehousing which involves ETL, Reporting and Data modeling experience
• Experience in data modeling, data warehouse, ETL design development, Ralph Kimball models with Star/Snowflake Schema Designs with analysis - definition, database design, testing, and implementation and Quality process.
• Extensively worked on Informatica 6.x/7.x/8.x/9. x.Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, 
• Designer, Server Manager, Workflow Manager, and Workflow Monitor.
• Experience in designing/developing complex mapping using transformations like Unconnected and Connected Lookup, Router,
• Filter, Expression, Aggregator and HTTP transformation.Involved in writing various UNIX shell scripts for writing automated scripts for scheduled queue process and PMCMD commands.
• Strong analytical and conceptual knowledge in database design and development using Oracle … SQL, PL/SQL, Developer/2000 and Unix Shell Scripting.
• Experience in writing Unix scripts, Perl scripts for the business needs. 
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and datasets. Extensively worked with SQL, UNIX Shell Scripting, Perl Scripting & Performance tuning to improve performance. 
• Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers.
• Experience in integration of various data sources definitions like Oracle, DB2 UDB, Flat Files, Netezza, SAP, XML and XSDs.
• Installation and configuration of Informatica servers and client environments.
• Experience in writing, testing, and implementation of the cursors, procedures, and functions at database level using PL/SQL and DB2.
• Familiar with Erwin 4.X and Sybase Power Designer 11 as data modeling tools.
• Interacted and well managed various offshore teams.
• Gathered requirements for data extraction & data base queries utilizing Terradata, SQL and MS Access queries.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Had experience as worked in Agile environment.

TECHNICAL SKILLS:

Data Modeling: Erwin 4.0/3.x, Sybase Power Designer 11

Data Warehousing: Informatica Power Center 8.x/7.x/6.x

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2000/2005, Sybase, IBM DB2 UDB, Netezza 4.5.2, Terradata MS Access 

OLAP Tools: Hyperion Essbase 9.3/7.1.5/6. x, EAS 7.1.5, EIS

Languages: SQL, PL/SQL, TSQL, C, UNIX Shell Scripting, Perl scripts

Web Tools: HTML, DHTML, XML, XSD

Tools: SQL * Loader, Toad 9.1, Query Builder, Ws FTP, Filezilla, Microsoft Project 2003, MS Visio, Visual basic 6.0, Mercury Quality Center Tortoise Subversion 4, XML Spy

Operating Systems: Microsoft XP/2000/NT, UNIX, Sun Solaris 5, Linux

PROFESSIONAL EXPERIENCE: Confidential, Tampa, FL

Sr. Informatica ETL Developer

Responsibilities:

• Here the source systems data are exported as Loan files data.
• Worked in an Agile project life cycle environment.
• Perform source-to-target maps and business logic
• Conduct source system and source table analysis to develop the necessary data
• Profiling templates. Assist the Data Architect in creating the logical/physical data models.
• Extensively worked on Netezza table, created NZSQL procedures and used NZLoad utility for Bulk Loading.
• Assisted in staging Historical and Incremental Loads
• Worked extensively on Aggregated/Summarized data.
• Created procedures and mappings for Process Control and Load Control
• Design and develop Perl and Unix Shell Scripts, FTP, sending files to source directory & managing session files 
• ETL mappings and workflows for Slowly Changing Dimensions (SDCs)
• Push Down Object (PDO) and corresponding SQL code (Aggregations, Transformations, Rollups, Inserts, Updates, Deletes)
• Training and mentoring, Release management plans and scripts
• Performance tuning and troubleshooting various Informatica mappings.
• Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata
• System was implemented using Informatica and the Data Warehouse in Terradata. Fast-Load, Multi-Load, BTEQ & Fast-Export were the Terradata utilities used.

Environment: Agile, methodology, Informatica PowerCenter 9.6.2, Oracle 11g, shell scripting, SQL Developer, UNIX shell scripting, Power exchange 9.1, Terradata SQL Assistant, Autosys job scheduler, Perl Scripts, Erwin, TDM, TOAD, SQL*Plus, SQL*Loader, Autosys, Teradata v13, ILM

Confidential, AL

Sr. Informatica ETL Developer

• Worked closely with the Business Analyst while preparing and reviewing the Technical Design Document of the project.
• Involved in designing the technical design of data model and reviewing the physical data model design.
• Involved in creating Unix shell scripts for various database objects related to the data model which involve in creation of schema, tables, sequences, views, External Tables, constraints, indexes.
• Involved in creation of various Unix wrapper scripts which help the ETL cleansing process and help in initial validations of various tasks.
• Involved in data validation during staging tables design.
• Created external tables and involved in writing perl scripts.
• Worked on nzload utility for bulk loading of data into target tables.
• Involved in database tables by in reducing skew factor of tables improving the tables with distribution keys over the columns.
• ETL mapping design and data validation in Informatica and bulk loading of data to warehouse tables using nzsql utility.
• Built Data warehouse for reporting purposes in star schema model.
• Involved in creation mapplets, worklets, parameter files and various mappings using unconnected Lookup, Router, Aggregators, Joiner, Normalizer and Expression transformations.
• Worked and coordinate with Offshore BSA team for specifications discussion.

Environment: Agile methodology, Windows 7, Linux, Informatica PowerCenter 9.5.1, Teradata 13.0, Oracle 11g, UNIX shell scripting, SQL Developer, Teradata SQL Assistant, Erwin, TOAD, SQL*Plus, SQL*Loader, Autosys, Teradata 13.0, Tidal scheduling tool, Flat Files, XML Files, PUTTY

Confidential, McLean, VA

Informatica ETL Developer

• Worked closely with the Business Analyst while preparing and reviewing the business specifications of the project.
• Involved in designing the technical design of data model and reviewing the physical data model design.
• Involved in creating scripts for various database objects related to the data model which involve in creation of schema, tables, sequences, views, Materialized views, constraints, indexes.
• Involved in creation of various unix scripts which help the ETL scheduling jobs and help in initial validations of various tasks.
• Used Informatica as ETL tool for building the data warehouse and datamarts where majorly focused on the transformations namely Expression, Lookup, Unconnected and Connected Lookup, Router, Filter, Expression, Aggregator and HTTP transformation.
• Involved in designing of star schema based data model with dimensions and facts.
• Involved in creation various independent schemas around the database creation.
• Involved in writing PLSQL procedures and functions.
• Worked in creation of Mapplets and Worklets.
• Created various mappings which define denormalization of data.
• Involved in technical design and education offshore-team.
• Worked handling a team of developers in technical discussions and routing of data.
• Experience working with Sybase Power Designer for conceptual and physical data model.
• Invovled in extraction of data using delimited and fixed width flat files and various XML sources.
• Involved in Production Support and various product release activities.

Environment: Windows XP, Linux, Sun Solaris 4, Informatica Power center 8.5/8.6.1, Sybase Power Designer 11, Perl Scripts, PUTTY, Informatica Power Exchange, Tortoise SVN 4, Oracle 9i/10G, XML Spy, Flat Files

Confidential, Chicago, IL

Informatica ETL Developer

• Worked for FTIP project in development of a Financial Transaction database.
• Involved in designing of snowflake schema based data model with dimensions.
• Used Informatica as ETL tool for building the data warehouse.
• Used Flat File data sources in extracting flat file data sources in data extraction.
• Involved in creation of multiple data integration schemas for tuning and purging of data
• Involved in SQL tuning while creation of various sql procedures.
• The data mart was built to look at the invoice amounts from various dimensions like customer, vendor, billing and services.
• Developed Informatica mappings using transformations like Lookup, Stored Procedure, Filter, Expression, Aggregator
• Developed test cases for validating the ETL processes
• Improved the performance of long running jobs by updating the SQL statements and creating indexes.
• Expeirence working with SCRUMM team in Agile environment
• Developed SQL stored procedures, triggers, cursors for implementing business rules and transformations

Environment: Windows XP, Informatica Power center 7.9.3/8.1, Informatica Power Exchange, Business Objects 5.1.1, Business Query for Excel, MQ Series, ERWIN 3.5.2, PL/SQL, COBOL, Sun Solaris, HP-UX, MS Visio, DB2 UDB 9, MS Analysis server

Confidential, Alpharetta, GA

Informatica ETL Developer

• Worked closely with the business analyst and Datawarehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Used Informatica as ETL tool for building the data warehouse.
• Extensively worked on different subject areas like Product, Individuals, Accounts,
• Scores, Billing, Services, Demographics, Call details and summary details.
• Created mappings with heterogeneous sources like flat files, DB2, Oracle databases and created targets in Oracle using Informatica Mapping Designer 7.1.4.
• Written Informatica mapping for dropping and recreating the Indexes of database tables.
• Designed and developed complex aggregate, join, lookup transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica Power center.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Sequence generator, stored procedure, Expression, Filter and Rank transformations.
• Handled various repository upgrades and worked as an Informatica Admin
• Created session variables to build sessions more effectively by using Informatica server manager.
• Having working knowledge of ERWIN 3.5.2 in converting logical data models into physical models.
• Developed mappings to dynamically use parameter files used by other mappings.
• Used touch files, event-wait tasks for scheduled job runs in Workflow execution.
• Duties included coordination, attending meetings with offshore team and the review of requirements, infrastructure setup, task assignments and code reviews.

Environment: Windows XP, Oracle 9i/10G, DB2, Informatica Power center 7.9.3/8.5, Informatica Power Exchange, Business Objects 5.1.1, Business Query for Excel, UNICA 7.1, ERWIN 3.5.2, PL/SQL, COBOL, HP-UX, DB2, MS Office, SQL Server 2000