SUMMARY

• Over 9 years of Professional ETL experience in developing, handling and testing Informatica mappings and workflows and Data Warehousing Development using INFORMATICA 8.6/9.1.1/9.5/9.6,
• IDQ and INFORMATICA MDM. He TEMPhas proficient experience of writing SQL statements in different Databases like NETEZZA, ORACLE, TERADATA, DB2/AS400 and SQL SERVER, PL/SQL, Stored procedures.
• Confidential TEMPhas extensively used ETL methodology for developing and supporting data extraction, transformations and loading process, in a corporate - wide-ETL Solution using INFORMATICA.

TECHNICAL EXPERTISE

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

Reporting Tools: Tableau, Microstrategy

Data Modeling: Erwin, Star-Schema, Snowflake-Schema, Fact and Dimension Modeling

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

Programming: SQL, SQL*Plus, TOAD, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City, UT

Technical Lead/ Analyst

Responsibilities:

• Involved in Data Modeling along with Data Architect and business team
• Create source target matrix based on the Technical Design requirements
• Analyze and assign roles and responsibilities to the team members
• Work on Informatica - Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• Create mappings for applying appropriate business rules
• Development, Maintenance and Enhancement of ETL Interfaces
• Create sessions and workflows to run the mappings and also scheduling workflows by using parameters
• Develop ETL BI test plans based on test strategy, create and execute test cases and test scripts based on test strategy and test plans based on ETL Mapping document
• Involved in developing test cases to test
• Develop unit test cases, configured environments and prepared test data for testing
• Write test cases and complete unit test documentation
• Create test cases to make sure the data originating from source is going into target properly in the right format
• Test several data migration application for security, data protection and data corruption during transfer
• Responsible for testing all new and existing ETL data warehouse components
• Implement efficient and effective performance tuning

Environment:SQL, UNIX, Netezza, Informatica 9.6, Netezza, Microstrategy

Confidential, Philadelphia, PA

Team Lead/ Analyst

Responsibilities:

• Involved in creating source target mappings based on 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
• 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

Software Developer

Responsibilities:

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

Software Developer

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• 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
• Monitored and closed 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
• Wrote 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
• Created Landing tables, Staging tables and Base Objects
• Developed the cleansed functions using MDM
• Configured Trust and Validation rules setting
• Extensively worked on Load, Consolidation, Match processes and Publish Processes
• Created packages and involved in ETL and MDM testing

Confidential

Developer

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements
• Worked on Informatica - Source Analyzer, Target Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• 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
• 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 by performing Functionality, Stress, Security, and Regression testing