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