SUMMARY:

• 7 years experience in design, development and Implementation of Data Warehouses & Data marts using Informatica Power Center 9.0.1/8.6/8.5/8.1/7.1 Power Mart, Power Exchange, from Oracle,DB2, Sybase, MS SQL Server.
• Proficient in all phases of teh Software development lifecycle, including requirements definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Support.
• Strong experience on Informatica Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. expertise in database concepts like conceptual, logical and physical data modeling and data definition, population and manipulation using RDBMS Databases like Oracle 11g/ 10g/9i, MS SQL Server 2005/ 2008,TeraData.
• Comprehensive knowledge on creation of various Informatica transformations like Source Qualifier, Aggregator, Filter, Expression, Unconnected and connected Lookups, Update Strategy, Rank, etc in various complex mappings.
• Experience in writing shell scripting for various ETL needs.
• Experience in designing teh data marts using dimensional modeling techniques such as Star Schema and Snow Flake Schema.
• Extensive experience in Analyzing teh Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data.
• Strong in database programming using PL/SQL and SQL with emphasis on DDL, DML operations, creation of packages, stored procedures, functions, triggers, materialized views, cursors and performance tuning of SQL.
• Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout teh entire SDLC.
• Performed unit testing and integration testing for teh developed data load process.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica 6 /7 / 8.6 /9.0.1 (Power Center), Workflow Manager, Workflow monitor, Informatica Data Quality

Data Modeling Tools: Erwin 3.x/4.x, MS - Visio.

Databases: Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2005/2008, MS Access, MS Excel

RDMS Load Tools: TOAD 8.x and SQL Developer (Database tool), SQL *Loader

Business Intelligence Tools: Business Objects, Cognos, Oracle ReportsLanguages C, C++, Visual Basic, SQL, PL/SQL, Perl, Shell Scripting.

Operating System: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, AIX).

Office Applications: MS-Office 97/2000/XP/2007, Open Office Suites

PROFESSIONAL EXPERIENCE:

Confidential

Informatica Developer

Responsibilities:

• Understanding teh business requirements by partnering with business and application developers to create conceptual, logical and physical data models..
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes.
• Designed and Developed teh Informatica workflows/sessions to extract from different Data Bases, transform and load teh data into oracle.
• Created different transformations for loading teh data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Developed SQL, PL/SQL procedures, materialized views and functions for processing business logic in teh database.
• Created reusable Mapplets and Transformations to reduce teh complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Worked on post session scripts to process teh target flat files.
• Involved in Performance tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Designed and Developed UNIX Shell scripts to enhance teh functionality of ETL application and schedule task/session as a part of ETL Process.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Designed and Developed UNIX shell scripts as part of teh ETL process to schedule tasks/sessions.
• Worked on production support environment weekly on call rotation basis between teh Production Support Developers in teh team.
• Used TOAD to develop oracle PL/SQL Stored Procedures.
• Prepared project documentation, Program Specifications, Test Cases and Participated in teh complete SDLC

Environment: Informatica Power center Designer 8.6, Workflow Manager, Workflow monitor, Repository manager,, Oracle 9i, Toad, SQL *Loader, SQL, PL/SQL, UNIX.

Confidential, NY

Informatica Developer

Responsibilities:

• Creating teh design and technical specifications for teh ETL process of teh project.
• Extracted data from various sources like Oracle, DB2 and Flat Files.
• Developed complex mappings using Informatica power Center Designer to transform and load teh data from various source systems like Oracle, MS Access, DB2, Flat Files and loading to DB2 target database.
• Extraction of unstructured Data/Flat Files from Verizon Data formats as/when received and schedule ETL batch jobs and processes.
• Performed data quality analysis using Informatica Analyst tool on source data to understand and assess completeness, conformity, and consistency, to identify and prioritize data quality issues.
• Strategic analysis of source data to Device strategies and establish customized data quality Rules for cleansing (Standardization) and matching.
• Designed and developed Informatica Mappings and Sessions based on business rules.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Designed pm cmd and Unix Shell scripts to in corporate dependencies and scheduled Kron jobs to run ETL processes.
• Involved in teh phases of unit and system testing
• SQL*Loader scripts for bulk data loads to Oracle tables and extracting Oracle dumps from Verizon.
• Monitor, troubleshoot batches and sessions for weekly and monthly extract data loads from various data sources across all platforms to target database.

Environment: Informatica Power Center 8.6.1, Oracle 11g, MS Access, DB2 V5/R4,, Microsoft Outlook, TOAD, PL/SQL Developer 7.1.0, LINUX, UNIX Shell Scripting, SQL*Loader, Windows XP professional

Confidential, Lake Forest, IL

Informatica Developer

Responsibilities:

• Worked in various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, Rank, Router and XML Source Qualifier etc of Informatica to bring teh data from different databases like DB2 UDB, Sybase and Oracle.
• Creating Mapplets to reduce teh development time and complexity of mappings and better maintenance.
• Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs.
• Developed Complex mappings by extensively using Informatica Transformations.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Creating/Building and Running/scheduling workflows and work lets using teh Workflow Manager.
• Involved in teh phases of unit and system testing.
• Extensively used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Worked on performance tuning by creating indexing, hints, used explain plans and analyzing teh database.
• Running teh SQL scripts from TOAD and creating Oracle Objects like tables, views, Indexes, sequences, synonyms and other Oracle Objects.
• Worked for a combination of Relational and dimensional data modeling.
• Worked with offshore team by helping them to understand teh requirements
• Had co-ordination with off shore team in maintaining teh different databases.
• Extensively used UNIX shell scripts and called teh shell script in teh workflow manger through command task.

Environment: Informatica Power Center 8.1.1, Business Objects, SQL SERVER2003, DB2 UDB, TOAD, Oracle9i, UNIX, Windows2000, Autosys, SQL Loader.

Confidential

ETL Developer

Responsibilities:

• Designed a robust ETL process which supports error re-loading, re-starting from teh point of failure, data cleansing and re-processing of teh bad data.
• Responsible for evaluating Informatica Power Center and Power Exchange as enterprise wide ETL tool.
• Reversed engineered teh business logic by going through PL/SQL code, shell scripts and COBOL/Mainframe programs.
• Extensively worked on slowly changing dimensions like Type1 and Type2.
• Various kinds of transformations were used to implement simple and complex business logic. Transformations used are: lookups, Router, Expressions, Source qualifier, Aggregators, Filters, Joiner, update strategy etc.
• Created and configured worklets and Sessions to transport teh data to data warehouse tables using Workflow Manager.
• Created various tasks like Session, E-mail, Command, Event wait and Event Raise.
• Exported and imported teh mappings and workflows from Development to Test and Test to Production.
• Interacted with metadata to trouble shoot session related issues as well as global performance issues.
• Used Informatica Data Quality and Data Explorer to cleanse teh data.
• Troubleshoot problems by checking sessions and error logs. Also used debugger for complex problem troubleshooting.
• Created Process Flow and Impact Analysis Documents
• Worked on number of Production Issues and made changes teh existing mappings or created new ones as required.

Environment: Informatica Power Center 8.1.1, Power Exchange 8.1, Power Designer, SQL, PL/SQL, Oracle 10g, Flat Files, Business Objects 6.5 and Windows 2003, Redhat Linux AS 4.0

Confidential

ETL Developer

Responsibilities:

• Designer tools were used to design teh source definition, target definition and transformations to build mappings.
• Used Source Analyzer and Warehouse Designer to import teh source and target database schemas, and teh mapping designer to map source to teh target.
• Used Transformation Developer to create teh joiner, filters, router, Expression and aggregation transformations that are used in mappings.
• Created Workflows, Dimensions, Facts & Mappings.
• Taking teh Backup of Repository on regular intervals depending on teh amount of work done.

Environment: Informatica Power Center 6.1, ORACLE9i, Windows NT.