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
• More than 2 years of experience in Data Warehousing Methodologies using Kimball and immon to solve the business problems.
• Installing Informatica Power center 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.
• Experienced in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables and Table portioning in DB level.
• 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 ).
• Worked extensively with Data Quality Teams to ensure the Data Quality.
• 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.
• Worked on Various Ticketing systems to resolve issues revolving the Identity Resolution.
• Profound knowledge about the architecture of the Teradata database.
• Extensive experience in handling ETL using Informatica Power Center/Power Mart 8.X/7.x/6.x/5.x.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Strong Experience in using Workflow Manager Tools - Task Developer, Workflow & Work let Designer.
• 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.
• 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.
• Strong Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• 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 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).Data 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.

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, 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

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.
• Involved in Design and Data Modeling using the Star schema.
• Logical database modeling using Erwin includes definition of business entities and their relationships.
• Logical & Physical Database Layout Design.
• Involved in Developing ETL Strategy using Informatica 8.6.
• Developed mappings, workflows using Informatica 8.6
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files, XML
• Responsible for Performance tuning, and Error Handling
• Developed Re usable 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.
• 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 8.6.1, Oracle 10g, SQL Server 2005, OBIEE, Windows 2003, Unix/Linux.

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.
• Data Quality Analysis to determine cleansing requirements.
• Designed and developed Informatica mappings for data loads.
• 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.
• 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, Business Objects XI/6.5, Erwin 3.5, PL/SQL, Oracle 8i/7i, DB2, Windows 2000, HP-UX, AIX 4.3.3, Shell Scripting.

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.
• Created Scripts using Teradata utilities (Fast load, Multi load, Fast export, Tpump, BTEQ).
• Extensively used loader utilities to load flat files into Teradata RDBMS.
• Performed high volume maintenance on large Teradata tables using Multi Load loader utility
• Used various Teradata Index techniques to improve the query performance.
• 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.
• 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, Perl Scripting, Erwin 4.2.

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.
• Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading 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, Windows XP Professional, UNIX, Perl Scripting, AIX, Erwin 4.2., Remedy, MS Virtual Source Safe, Share Point.

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.
• 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 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.