SUMMARY

• Informatica Designer with 7 years of IT experience with 6 years of experience in Design, Development, Administration and Maintenance of Data warehouse applications an ETL Developer
• Installing Informatica Power center 9.x/8.x/7.x/6.x on HP - UNIX and IBM AIX Upgrading Informatica Power center Version 7.x to Informatica Power center Version 8.x.
• Experience in Applying Informatica Latest Hot fixes/Patches.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, Cobol, VSAM, IMS, SAP R3, DB2 UDB, Oracle, SQL Server, Teradata.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Developed and Tested complex Mappings, used transformations such as lookups, Dynamic-Lookups, Unstructured Data Object(B2B), Router, Filter, Expression, Aggregator, Joiner, Transaction Control to create dynamic file names, Sequence Generator and Update Strategy.
• Performance tuning, Indexing and partitioning techniques on Sources, Targets, Mappings and Workflows in Informatica.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Proficient in all phases of software development life cycle (SDLC) including requirements definition, data conversion, system implementation, maintenance and acceptance testing.
• Extensive experience in designing and developing ETL involving Source databases Oracle, SQL Server and Flat Files ( fixed width, delimited ),Main Frame (COBOL Files) and Target databases Oracle, SQL Server 2005 and Flat Files ( fixed width, delimited ).
• Extensive knowledge with Teradata SQL Assistant, Fast Export, Fast Load, Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Strong experience in developing complex mappings using varied transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Strong experience in developing Workflows, Work lets, sessions and tasks to effectively manage the Load.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts.
• Excellent knowledge in identifying performance bottlenecks and tuning the Informatica Load for better performance and efficiency.
• Extensive experience in error handling and problem fixing in Informatica.
• Fair amount of knowledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.
• Excellent knowledge in Creating database objects like Stored Procedure, Views, packages, functions and Triggers using PL/SQL.
• Good knowledge of Oracle 10g/9i/8i.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/8.6.0/8.5.1/8.1/7.1/6.2.2/5.1.2/ Power Connect and Power Exchange, Power Mart 6.x/5.1, Power Center Data Analyzer Mart 6.x/5.1, SQL Server 2005 Integration Services (SSIS).SSRSData modeling Tools Erwin 4.2, Dimensional Data Modeling, Star Schema Modeling, snow-Flake Modeling, Fact and Dimensions Tables.

RDBMS: Oracle 10g/9i/8i, SQL Server 2005, Teradata,DB2, SYBASE, Flat files, XML and MQ COBOL Files

Web Technologies: HTML, Java, JavaScript, Oracle MapViewer,JDBC, XML, XHTML,Web services, Dataflux

Programming Languages: C, C++, SQL, PL/SQL and Shell Scripting.

Data Warehousing Methodologies: Dimensional modeling - Star schema, snow flake schema

Reporting Tools: Crystal Reports2008/XI R2, OBIEE 10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle BI Services, Oracle CRM on Demand, BI Publisher, I- Bots.

Other Tools & Utilities: SQL * plus, Toad, SQL Server2005 SSIS, MS SQL Server Reporting Services (SSRS),, AutoSys, Microsoft Visio, Clear case, Text Pad

Languages: SQL, PL/SQL, TSQL

Scripting Languages: Shell Scripting, Perl Scripting

Operating Systems: Windows XP/NT, UNIX (Sun Solaris, Linux, HP-UX), AIX

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Sr. ETL Developer

Responsibilities:

• Involved in Design, Development, Testing phases of the Data warehouse and in Software Development Life Cycle (SDLC).
• Analysis, Requirements gathering, function/technical specification, development, deploying and testing.
• Formalization of user requirements and creation the formal subject area description based on BRD, functional specs and technical specs, metadata for the data warehouse, database naming conventions using Microsoft Word, Excel.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center
• Involved in Design and Data Modeling using the Star schema.
• Logical database modeling using Erwin includes definition of business entities and their relationships.
• DevelopLogical and Physical DataModel using Erwin, followed Star Schema to build Reporting datamart.
• Logical & Physical Database Layout Design.
• Involved in Developing ETL Strategy using Informatica 9.1.0.
• Developed mappings, workflows using Informatica 9.1.0
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files, XML
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Designed mapping documents and developed ETL packages using SSIS, SSRS. Designed and developed packages to build business rules to load data.
• Responsible for Performance tuning, and Error Handling
• Developed reusable Transformations, and Mapplets.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Involved in designing Business Objects Universes, Queries, and Reports.
• CreatedOracle Views and Stored Proceduresto implement complex business logic.
• Using Informatica Designerdesigned Mappings, which populated the Data into theTarget Star Schema,which is on Oracle Instance.
• Created advanced external procedures to test PERL functionality
• Responsible for determining the Performance bottlenecks and fixing the bottlenecks.
• Interact with OBIEE Analyst to assist him in Understanding the Source and Target System.
• Responsible for Unit Testing and Integration testing of mappings and workflows
• Involved in Production Deployment and solved various Production issues.

Environment: Informatica Power Center 9.1, Oracle 10g,OLAP, Windows 2003, Unix/Linux, Star schema, XML, Flat files, Microsoft Excel 2003, UNIX Shell Programming, PL/SQL, SQL*Plus, TOAD 9.1, SSIS, SSRS, Business Objects XI/6.5

Confidential, WASHINGTON DC

ETL Developer

Responsibilities:

• End-to-end ETL development of the Premium Module Data Mart.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Understand the business needs and implement the same into a functional database design.
• ETL Migration process from legacy scripts to Informatica Power Center 8.6.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling the jobs.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005).
• Data Quality Analysis to determine cleansing requirements.
• Involved in dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions.
• Written Unix Shell Scripts to execute the DLY and HST Workflows.
• Designed and developed Informatica mappings for data loads.
• Created/modified a variety of parameterized, drill down, click through, chart, matrix, sub reports using SSRS 2008 using data from a variety of sources.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Arrived Confidential the dimension model of the OLAP data marts in ERwin.
• Extracted data from Sales department to flat files and load the data to the target database.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Created and maintained several custom reports for the client using Business Objects.
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Created standard and Ad hoc reports using Business Objects.

Environment: Informatica PowerCenter 8.6 (Source Analyzer, Data warehouse designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor), Teradata V2R5,TD 13, Business Objects XI/6.5, SSIS, SSRS, Erwin 3.5, PL/SQL, Oracle 8i/7i, DB2, Windows 2000, HP-UX, AIX 4.3.3, Shell Scripting, OLAP

Confidential, Atlanta, GA

Informatica Designer/Developer

Responsibilities:

• Responsible for the Business Analysis and Requirements gathering, create a road map for the Data warehouse designing.
• Translated user requirements into system solutions.
• Involved in Data Modeling sessions using Erwin.
• Involved in Data Analysis of the OLTP system to identify the sources for extraction of the data.
• Prepared the Technical and Functional Specification Documents.
• Prepared the Tech Design Document to some extent gathering the requirements from the clients.
• Extracted the datafrom Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2005) AND MS SQL Server Reporting Services (SSRS).
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Responsible for loading data into warehouse from different sources using Multiload and Fastload to load millions of records.
• Creating and modifying Oracle Database tables as per the design requirements and applying Constraints to maintain complete Referential Integrity and creating indexes for performance and loading the data into Oracle database tables.
• Designing and developing Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter, Ranker, Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Creating Sessions, Workflows and Work lets for data loads using Workflow Manager
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Developed and implemented Error Handling Strategies.
• Deployment of the web service converted java interfaces on a daily basis to a Websphere testing environment for subsequent development of the front end.
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, 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.
• Maintaining issue log of the issues during the UAT phase for future reference.
• Migrating Folders, Mappings across repositories and folders.
• Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 8.1, BODI, Teradata, Oracle 9i, DB2, XML, MQ, Flat files, Microsoft Excel 2003, Text Pad, PL/SQL, SQL*Plus, TOAD 9.1, Windows XP Professional, UNIX, Shell Scripts, Erwin 4.2, OLAP, SSIS, SSRS, Web services

Confidential, Houston, TX

Informatica Administrator

Responsibilities:

• Worked as a Informatica Administrator.
• Resolved the issues Remedy Tickets on Priority basis.
• Analyzed the Fulfillment requests (FR) and Change request (CR) as per requests from HPPM.
• Installing Informatica Power center 8.5.1 on HP-UNIX.
• Creating SR to Informatica Inc- related to any Power center product issues.
• As per Fulfillment requests (FR) migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Performed Upgrading Informatica Power center Version 7.x to Informatica Power center 8.X.
• Creating Folders and manages user and user group access to objects based on LDAP settings.
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Maintain all necessary updates and patches for the ETL environments.
• Creates and maintains all databases required for development, testing, education and production usage.
• Performs the capacity planning required to create and maintain the databases.
• Performs ongoing tuning of the database instances.
• Install new versions of the Oracle and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Work UNIX / Windows Admin team related to OS.
• Monitoring the Jobs and sever space availability and CPU Process.
• Preparing Procedures for related Informatica issues.
• Preparing weekly and monthly progress report.

Environment: Informatica Power Center 7.1.4, Oracle 9i, Siebel, Sybase, XML, Microsoft Excel 2000, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, SQL Server 2005 SSIS, SSRS, Windows XP Professional, UNIX, Perl Scripting, AIX, Erwin 4.2., Remedy, MS Virtual Source Safe, Share Point, DATAFLUX.

Confidential, New Jersey

Informatica Designer/ Developer

Responsibilities:

• Responsible for the Business Analysis and Requirements gathering, create a road map for the Data warehouse designing.
• Translated user requirements into system solutions.
• Involved in Data Modeling sessions using Erwin.
• Involved in Data Analysis of the OLTP system to identify the sources for extraction of the data.
• Creating and modifying Oracle Database tables as per the design requirements and applying Constraints to maintain complete Referential Integrity and creating indexes for performance.
• Implementing Screen Door Process for Flat file sources for data validation and data cleansing
• Designing and developing Mappings using Mapping Designer to load the data from various sources using different transformations like Unconnected and Connected lookups, Router, Aggregator, Sorter,Ranker Joiner, Stored Procedure, Update Strategy and Re-usable transformations.
• Creating Sessions, Workflows and Worklets for data loads using Workflow Manager
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Developed and implemented Error Handling Strategies.
• Preparing ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.
• Maintaining issue log of the issues during the UAT phase for future reference.
• Migrating Folders, Mappings across repositories and folders.
• Actively involved in the production support and also transferred knowledge to the other team members.

Environment: Informatica Power Center 7.1.1/ 6.2.2 , Oracle 9i, DB2, Teradata, Microsoft Excel 2000, SQL Server2005, XML, PL/SQL, SQL*Plus, TOAD 6.3.11.1g, Windows XP Professional, UNIX, Perl Scripting, Erwin 4.2.

Confidential

Informatica Developer

Responsibilities:

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files to target Oracle Data Warehouse database.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Involved in creating logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Written SQL overrides in source Qualifier according to business requirements.
• Written pre session and post session scripts in mappings.
• Created sessions and workflow for designed mappings.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Worked with Operational Data Store (ODS).
• Developed PL/SQL procedures for processing business logic in the database.
• Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department.

Environment: Informatica7.1, ORACLE9i, DB2, Teradata, Clearcase, AIX, Windows NT, UNIX Shell Programming, Erwin.