PROFESSIONAL SUMMARY:

• 9+ years of Professional Experience in developing, handling and testing Informatica mappings and workflows and Data Warehousing Development using Informatica 8.6.0, Informatica 9.1.1 and Informatica MDM 9.1.1, Data modeling using Erwin.
• Extensively used ETL methodology for developing and supporting data extraction, transformations and loading process, in a corporate - wide-ETL Solution using Informatica.
• Proficient experience in different Databases like Oracle 11g/10g, DB2/AS400 and SQL Server.
• Extensive experience in reviewing Business Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Performance testing, Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Knowledge of Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in writing SQL statements.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments
• Automated and scheduled the Informatica jobs.
• Knowledge of UNIX/LINUX scripting language - shell scripting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica 9.1.1/8.6/8.1, Informatica MDM 9.1.1

Reporting Tool: Knowledge of OBIEE

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables

RDBMS: Oracle 11g, MS SQL Server 2008, DB2/AS400

Programming SQL, SQL*Plus, TOAD:

Environment: Win NT/XP/2003, UNIX, AIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, Bala Cynwyd, PA

ETL Informatica Developer

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer and Transformation Developer.
• Created mappings for applying appropriate business rules
• Development, Maintenance and Enhancement of ETL Interfaces.
• Bug fix - Quick fix and long-term solution in confirmation with onsite
• Created sessions and workflows to run the mappings and also scheduling workflows by using parameters.
• Developed ETL BI test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Involved in developing test cases to test.
• Developed unit test cases, configured environments and prepared test data for testing.
• Written test cases and completed unit test documentation.
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible for testing all new and existing ETL data warehouse components.

Confidential, Bala Cynwyd, PA

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer and Transformation Developer.
• Created mappings for applying appropriate business rules
• Development, Maintenance and Enhancement of ETL Interfaces.
• Bug fix - Quick fix and long-term solution in confirmation with onsite
• Created sessions and workflows to run the mappings and also scheduling workflows by using parameters.
• Developed ETL BI test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Involved in developing test cases to test.
• Developed unit test cases, configured environments and prepared test data for testing.
• Written test cases and completed unit test documentation.
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible for testing all new and existing ETL data warehouse components.

Confidential, Ontario, CA

ETL Informatica Developer

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements,data modeling.
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer and Transformation Developer.
• Created mappings for applying appropriate business rules
• Development, Maintenance and Enhancement of ETL Interfaces.
• Bug fix - Quick fix and long-term solution in confirmation with onsite
• Created sessions and workflows to run the mappings and also scheduling workflows by using parameters.
• Developed ETL BI test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Involved in developing test cases to test.
• Developed unit test cases, configured environments and prepared test data for testing.
• Written test cases and completed unit test documentation.
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible for testing all new and existing ETL data warehouse components.
• Performed Functionality, Stress, Security, and Regression testing

Confidential, San Diego, CA

Informatica Developer

Roles & Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer and Transformation Developer.
• Created mappings for applying appropriate business rules
• Development, Maintenance and Enhancement of ETL Interfaces.
• Bug fix - Quick fix and long-term solution in confirmation with onsite
• Monitoring and closing Zera Tickets.
• Created sessions and workflows to run the mappings and also scheduling workflows by using parameters.
• Developed ETL BI test plans based on test strategy, Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Involved in developing test cases to test.
• Developed unit test cases, configured environments and prepared test data for testing.
• Written test cases and completed unit test documentation.
• Created test cases to make sure the data originating from source is making into target properly in the right format.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible for testing all new and existing ETL data warehouse components.
• Performed Functionality, Stress, Security, and Regression testing
• Creating Landing tables, Staging tables & Base Objects.
• Developing the cleansing functions using MDM.
• Configure Trust and Validation rules setting
• Extensively working on Load, Consolidation, Match processes and Publish Processes
• Creating Packages and involved in ETL and MDM testing