SUMMARY

• Over 8 +years of IT experience as ETL Developer (Informatica PowerCenter 9.1/8.6/7.1.2 ), Scheduling of ETL workflows.
• Expertise in Installation, Configuration, and Administration of Informatica Power Center and Server.
• Thorough knowledge of the Data Mart Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.
• Experience in complete Software Development Life Cycle SDLC (Requirement Analysis, Design, Development and Testing).
• Applying patches, taking backup and restore repositories.
• Strong decision making skills, organizational skills, and customer service oriented. Excellent analytical and problem solving skills.
• Provided 24 x 7 supports to Key Production Environments.

TECHNICAL SKILLS

Programming Languages: C, C++, HTML, PL/SQL

Data bases: Oracle 10g/9i/8i/8.0, SQL*Plus, MS SQL

Packages &ETL Tools: Informatica 9.1/8.6/7.1, TOAD ETL Testing,QTP

Operating Systems: Unix, Win NT, MS - DOS, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Arlington VA

Sr.Infomatica Consultant

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects of business.
• Identification of various Data Sources and Development Environment.
• Prepared user requirement documentation for mapping and additional functionality. Extensively used ETL to load data using PowerCenter/PowerConnect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Created PL/SQL packages and Stored Procedures for data transformation on the data warehouse.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL for UAT.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Improved performance by identifying the bottlenecks and tuning in Source, Target, Mapping and Session levels.
• Design and Development of ETL routines, using Informatica PowerCenter Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Stored procedures, functions, MS SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data warehouse and defining ETL standards.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design
• Configure the workflow, Tables and indexes using Oracle Data warehouse Administration Console (DAC) and monitor the job runs for full and incremental loads.
• Provide production support and resolve the tickets.
• Applied patches, taking backup and restore repositories.
• Upgraded Informatica PowerCenter 8.6 to Informatica 9.1.
• Designed migration templates, Informatica Admin standards document and monitored production jobs.
• Created folders, permissions, migration of code, setting up environments, versioning control

Environment: Informatica PowerCenter 9.1/8.6, PL/SQL, Oracle10g, Quality Center, Microsoft Visual Source Safe

Confidential, Washington DC

Lead Infomatica Consultant

Responsibilities:

• Worked along with the Business Analysts for requirements gathering, business analysis, and testing and project coordination.
• Involved in all the phase of the project development, acceptance and production.
• Modified the PL/SQL stored procedures to meet the changing standards.
• Optimization and Performance tuning of mappings to achieve high response times.
• Created reusable transformations and Mapplets and used them in various mappings.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to the business rules and technical specifications.
• Prepared Document for Root Cause Analysis (RCA).
• Debugging and Trouble Shooting Of Informatica Mappings
• Assisted in knowledge transfer to client personal for maintaining the environment after implementation.
• Written Test scripts and Test cases for testing and enhancements which were used by QA for unit testing and user acceptance testing.
• Configure the workflow, Tables and indexes using Oracle Data warehouse Administration Console (DAC) and monitor the job runs for full and incremental loads.
• Coordinated User Acceptance Testing (UAT) with the business users.
• Created and used Tidal schedules for scheduling jobs of the sessions.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.

Environment: Informatica PowerCenter 8.6.1, UNIX, Dimensions CM 10.1.2, HP Quality Center, Oracle 10g, PLSQL Developer

Confidential, San Francisco, CA

Lead Infomatica Consultant

Responsibilities:

• Thorough study of the system with user meet and in business perspective
• Extracted data from various tables in data mart thru SQL*Loader, PL/SQL, unix shell scripting and loaded into DRP system for sales analysis and demand planners to use these data for next month’s production plan.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Developed various packages, stored procedures, functions for business and functional needs
• Error review, log and restudy/recode of the system.
• Created test scripts for unit testing and user acceptance testing (UAT).
• Migrated mappings from Development to Testing and to Production.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.
• Provided knowledge transfer to client personal for maintaining the environment after implementation.
• Provide production support and resolve the tickets.
• Applied patches, taking backup and restore repositories.

Environment: Informatica PowerCenter 7.1, UNIX, Oracle 9.1, TOAD, BMC Remedy User 7.1

Confidential, Horsham, PA

Senior Informatica consultant

Responsibilities:

• Identification of various Data Sources and Development Environment.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using PowerCenter/PowerConnect from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.
• Design and Development of data validation, load processes, test cases, error control routines, audit and log controls using PL/SQL, MS SQL.
• Used Update strategy and Target load plans to load data into Type-2/Type1 Dimensions.
• Created and used reusable Mapplets and transformations using Informatica PowerCenter.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Design and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Documented the complete Mappings.

Environment: TOAD, Informatica PowerCenter 7.1, Oracle 9.1.

Confidential, Houston/TX

Informatica Consultant

Responsibilities:

• Thorough study of the system with user meet and in business perspective
• Extracted data from various tables in data mart thru SQL*Loader, PL/SQL, unix shell scripting and loaded into DRP system for sales analysis and demand planners to use these data for next month’s production plan.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Developed various packages, stored procedures, functions for business and functional needs
• Error review, log and restudy/recode of the system.
• Created test scripts for unit testing and user acceptance testing (UAT).
• Migrated mappings from Development to Testing and to Production.
• Performed unit testing and Involved in tuning the Session and Workflows for better performance.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.
• Provided knowledge transfer to client personal for maintaining the environment after implementation.
• Provide production support and resolve the tickets.
• Applied patches, taking backup and restore repositories.

Environment: Informatica PowerCenter 7.1, UNIX, Oracle 9.1, TOAD, BMC Remedy User 7.1

Confidential

ETL Informatica Developer

Responsibilities:

• Worked along with the Business Analysts for requirements gathering, business analysis, and testing and project coordination.
• Involved in all the phase of the project development, acceptance and production.
• Modified the PL/SQL stored procedures to meet the changing standards.
• Optimization and Performance tuning of mappings to achieve high response times.
• Created reusable transformations and Mapplets and used them in various mappings.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted according to the business rules and technical specifications.
• Prepared Document for Root Cause Analysis (RCA).
• Debugging and Trouble Shooting Of Informatica Mappings.
• Assisted in knowledge transfer to client personal for maintaining the environment after implementation.
• Written Test scripts and Test cases for testing and enhancements which were used by QA for unit testing and user acceptance testing.
• Configure the workflow, Tables and indexes using Oracle Data warehouse Administration Console (DAC) and monitor the job runs for full and incremental loads.
• Coordinated User Acceptance Testing (UAT) with the business users.
• Created and used Tidal schedules for scheduling jobs of the sessions.
• Documented the complete Mappings, System delivery specification, test scripts and technical systems design.

Environment: Informatica PowerCenter 7.1, UNIX, HP Quality Center, Oracle 9.1, PLSQL Developer