Professional Summary:

• 7 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
• 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, DB2/AS400 and SQL Server,PL/SQL.
• Extensive experience in reviewing Business Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in White Box and 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 - shell scripting, OBIEE, UPERFORM, ERWIN.
• Excellent analytical, programming, written and verbal communication skills.

Technical Skills:

Data Warehousing Informatica9.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, PL/SQL

Environment Win NT/XP/2003

Professional Experience:

SAP Analyst

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

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

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

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.
• Creating Landing tables, Staging tables Base Objects.
• Performed Functionality, Stress, Security, and Regression testing
• 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 ETLand MDM testing

Confidential

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 Service Center 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