SUMMARY:

• Over 7 years of experience in Data Warehousing/Integration using ETL Tool Informatica PowerCenter 9.x/8.x/7.x across the business areas such as Pharmaceutical, Healthcare and Banking.
• Extensive experience in using Informatica PowerCenter 9.x/8.x/7.x and 6.x to carry out the Extraction, Transformation and Loading process as well as Administering in creating domains, repositories and folder.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, and scheduling the Workflows and sessions.
• Extensive experience in Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Actively involved in Performance Tuning.
• Having good knowledge on SPSS skillset.
• Experience in implementing update strategies and incremental loads.
• Usage of Informatica mapping variables/parameter s and session variables Strong in UNIX Shell scripting. scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Control - M.
• Expert in Oracle 11g/10g, IBM DB2 8.1,Sybase, SQL Server 2008/2005/2008 , SQL, PL/SQL Stored procedures using Toad.
• Extensive experience Informatica Mappings Performance tuning and debugging.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.01/8.6.1/7.1.3/6.2

Database: Oracle (7i/8i/9i/10g/11g),IBM DB2 8.1, SQL Server 7.0/2000,Netezza,WISDM, Teradata

Reporting Tools: SQR, Crystal Reports

Operating Systems: Windows NT/2000/XP, HP-UNIX, Linux

Web Technologies: HTML, Java Script.

Languages: SQL, PL/SQL, C, C++, Java, Unix Shell Scripting

Scheduling Tools: Control-M.

Other Tools: Ultra Edit, Toad, Benthic

PROFESSIONAL EXPERIENCE

Confidential

Informatica ETL Developer

Responsibilities:

• Gathering requirement changes and incorporates them on informatica
• Designed the ETL processes using Informatica tool to load data from Peoplesoft, WISDM, Netezza into the target Netezza database.
• Worked on Informatica Power Center- Source Analyzer,Mapping Designer, mapplet & Transformations.
• Worked on Netezza database
• Created new mapping and customized existing mapping based on end user requirements.
• Designed SQL queries with multiple joins to pull relative data during import state.
• Used Parameter files to define values for parameters and variables used in the mappings and sessions.
• Performance optimization and performance tuning in mapping as well as in session level.
• Developed, executed, documented Unit test plans, Integration test plans, System test plans
• Validating the results with Business Analyst and Customer.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Performed migration of objects from Development to Test and then to Production environment.
• Active interaction with business clients in requirement gathering, analysis, user meetings,
• Discussing the issues to be resolved and translating user inputs into ETL design logic.

Environment: Informatica Power Center 9.1, Netezza 4.1, window xp.Informatica 8.1, TOAD, SQL plus, Oracle 10g, PL/SQL

Confidential, NY

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center - Source Analyzer, Mapping Designer, mapplet & Transformations to import source and target definitions into the repository and to build mappings.
• Worked with XML targets, salesforce.com sources and targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Have experience working with Clear Case tool.
• Created mappings to load Dimension tables and Fact tables.
• Various kinds of the transformations were used to implement simple and complex business logic. Used debugger to test the mapping and fixed the bugs.
• Created and configured workflows, worklets and sessions to transport the data to target systems using Informatica Workflow Manager.
• Created several mapplets and reusable objects to parse out and validate the Source data and exported them to the shared folder.
• Used Parameter files to define values for parameters and variables used in the mappings and sessions.
• Dropping and re-creating Indexes on the database Target table using pre-sql and post-sql techniques while loading huge tables.
• Identifying bottlenecks and resolving performance optimization in mappings and also at session level.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Active interaction with business clients in requirement gathering, analysis, user meetings, discussing the issues to be resolved and translating user inputs into ETL design logic.
• Extensively worked in Performance Tuning and Optimization of Informatica and database objects in the ETL processes.
• Developed work arounds and errands for error handling processes.
• Performed unit testing, system testing and secondary production support.
• Developed test plans, test strategies and test cases for ETL projects ensuring the data meets the business requirements

Environment: Informatica Power Center 9.1, MS SQL Server, Windows 2000/NT and HP Quality Center, Clear Case.

Confidential, MORGANTOWN, WV

Informatica Developer

Responsibilities:

• Data sources /input files are provided by external vendors like NDC, AMA, IMS·
• Worked on the designing of the Central customer database and the decision support system for the ETL and Unix process.
• Worked on informatica workflow manager to organize sessions, scripts and commands.
• Worked on Extraction, Transformation and Loading of the data Using Informatica Power Center.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Worked on connected as well as unconnected Transformations.
• Worked on normalizer transformation to normalize the demoralized sources
• Extensively worked in the informatica performance tuning
• Worked on column level data validation rules on the source data before the data enters the records by record stage of formatting and standardization.
• Worked on Unix Scripts for the informatica and Unix integration level
• Worked intensively on informatica, UNIX and oracle integration part
• Extensively used SQL, PL/SQL for testing the Customer Central database and the Decision support system process.

Environment: Oracle 9i, SQL, PL/SQL, Informatica PowerCenter 7.1.3 and UNIX.

Confidential, Dallas, TX

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Designed the ETL processes using Informatica tool to load data from SQL Server, Oracle 9i, Oracle database.
• Imported various Sources, created Targets and Transformations using Informatica Power Center Designer (Source analyzer, Warehouse developer, Transformation developer, Mapplet designer, and Mapping designer).
• Used transformations like Joiner, Connected, Unconnected lookups, Filter, Aggregator, Rank, Update Strategy, Router, Normalizer, etc.,
• Applied dynamic lookup techniques.
• Extracted data from sources like Oracle 10g and Flatfilestransformed the data according the business requirement.
• Environment: Informatica Power Center 8.1/7.1 Oracle 10g, Repository Manager, Designer, Workflow Monitor,, Business Objects XI, Workflow Manager, Windows XP

Environment: InformaticaPower Center 8.1, 7.1.1, Oracle 9i, 10g, SQL, PL/SQL, TOAD, UNIX.