SUMMARY

• 8+ years of Information Technology experience covering phases of the System Development and Testing.
• Involved in Development of Data Warehouse, Business intelligence applications such as Informatica with strong business understanding knowledge of Retail Services Domain and Health Care Domain.
• Experience in Data Warehousing Using Informatica 9.x.x/ 8.6.1/8.1.1/7. x.
• Strong Data Warehousing and Data Integration experience in using Informatica Power Center different versions (Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, and Mapping Designer).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Created xml soap request for web service calls using Java and Http Transformations.
• Solid expertise in using ETL Scheduling tools.
• Working with Informatica Power Exchange to extract data from AS/400 Application.
• Implemented Informatica Change Data Capture on Oracle database.
• Good Experience in Informatica upgrades and installations.
• Experience in debugging mappings, Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good understanding of RDBMS concepts and experience in writing queries, procedures & scripts using Oracle, Teradata, SQL Server, MY SQL and DB2.
• Excellent Client handling ability with good presentation skills.
• Experience in Installation and configuration, Creation of repositories with user groups and security implementation.
• Experience in development Using Pentaho (Kettle 2.4).
• Excellent soft skills such as leadership, communication, organization, time management, crisis management, multi - tasking, and people-management.
• An excellent team player with a track record for meeting strict deadlines.
• Extensive experience in data warehousing testing like SIT, UAT and PAT.
• Keen understanding of Data warehousing concepts and dimensional modeling.
• Excellent Analytical and Problem Solving Skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x.x/ 8.6.1/8.1.1/7. x, Pentaho 2.4

Operating Systems: Windows 98, NT/2000, UNIX

Databases: Oracle10g, Teradata, SQL Server, mysql, Db2

Query Tools: TOAD

Languages: SQL, PL/SQL, UNIX Shell Scripting

Source Control: Sub version (SVN)

Scheduling Tools: Job Scheduler, Control M

PROFESSIONAL EXPERIENCE

Confidential, Little Rock, AR

Sr Informatica Developer

Environment: Informatica 9.1, Oracle 10g, Toad, PL/SQL, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Developed mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Analyzing the issues and providing the solutions to dev and test teams.
• Involved in optimization to identify the bottlenecks for the existing jobs.
• Complex Business Rules are implemented to identify error records.
• Develop debugging and testing mechanism for the data flow mappings.
• Developing complex SCD-2 dimension processes.
• Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.
• Good experience running the workflows by using PMCMD commands.
• Good experience to work with different task such as Session, Command, Event wait, Event Raise, Timer, Assignment etc.
• Performed Unit testing and Performance Tuning testing.

Confidential, CA

Sr Informatica Developer

Environment: Informatica Power center 9.0.1, Oracle 10g, Toad, Sql server 2008 r2, PL/SQL, Windows NT, UNIX Shell Scripting, Control-M.

Responsibilities:

• Responsible for understanding the business requirements and Functional Specifications document and prepared the Source to Target Mapping document.
• Worked closely with Business Analyst and involved in Data Analysis to identify the business rules.
• Extensively worked on Informatica Designer and Workflow Manager to design and develop various mapping and workflows.
• Analyzing the issues and providing the solutions to dev and test teams.
• Complex Business Rules are implemented to identify error records.
• Develop debugging and testing mechanism for the data flow mappings.
• Developed complex Slowly Changing Dimension type 2 processes.
• Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Responsible for tuning the Informatica mappings to increase the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.

Confidential, CA

Informatica developer

Environment: Informatica 8.6, Pentaho 2.4,Oracle 10g, Toad, PL/SQL, Flat Files, XML FilesPutty, Windows NT, UNIX Shell Scripting.

Responsibilities:

• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Designed Informatica mappings by translating the business requirements.
• Studied Session Log files to correct errors in mappings and sessions.
• Wrote pre session and post session scripts in mappings.
• Performed data manipulation using basic functions and Informatica Transformation.
• Understanding the Functional Team requirements & specifications.
• Complex Business Rules are implemented to identify error records.
• Developed ktrs and kjbs using Petaho to extract data from xls and xlsx file sources.
• Develop debugging and testing mechanism for the data flow mappings.
• Need to respond to user’s request and clarifying their doubts Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Handling issues raised by clients in Production Support environment.

Confidential, NY

Informatica Developer

Environment: Informatica 8.1.1, Oracle 10g, Toad, PL/SQL, Putty, Windows NT, UNIX.

Responsibilities:

• Understanding the Functional Team requirements & specifications.
• Complex Business Rules are implemented to identify error records.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Develop debugging and testing mechanism for the data flow mappings.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Developing complex Slowly Changing Dimensions Type-2 Processes.
• Preparing test scripts and reviewing the test results.
• Monitor the Sessions and Batches for data load.
• Tuning of the mappings to enhance the performance.
• Optimizing the mappings by changing the logic to reduce run time.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Confidential, IL

Informatica Developer

Environment: Informatica 7.x, Oracle 10g, Toad 10, SQL/PLSQL, WinSCP, Putty, Windows NT, UNIX.

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with heterogeneous sources including relational sources and flat files.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Extensively involved in monitoring the jobs in order to detect and fix unknown bugs and track performance.