SUMMARY:

• Senior Informatica Developer with 4.9 years of experience in design, development and implementation of projects using Informatica Powercenter and Oracle/ Netezza databases.
• Proficient in developing Netezza scripts, Oracle PL/SQL statements and performance tuning Informatica mappings
• Extensive experience on Informatica Powercenter 8.x, 9.x to carry out extraction, transformation and loading processes.
• Extensively worked on Informatica client tools - Mapping designer, Work flow Manager, Workflow monitor and Repository Manager.
• Has extensive experience in versioning, deployment of code and release management.
• Development experience across business areas like Retail, Life Sciences and Telecom
• Experience in Performance tuning of targets, sources, mappings and sessions to identify and remove processing bottlenecks.
• Knowledge of complete Software Development Life cycle including analysis, design, development, implementation, testing and production support.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and views.
• Have a good understanding of ETL and BI concepts data warehousing and data migration methodologies.
• Experienced in implementing delta data / bulk data, update strategies and incremental loading.
• Strong analytical, problem-solving, organizational, communication and team skills
• Actively involved in performance tuning and data analysis
• Experienced in implementing delta data / bulk data, update strategies and incremental loading.

TECHNICAL SKILLS:

Data warehouse & BI Tools: Informatica 8.1, 8.6.1, 9.1.0 Business Objects 6.5, BOXI R2

Operating Systems:: Windows / UNIX (IBM AIX) / Linux

RDBMS: Oracle 8.i/9.i/10G/11G, Netezza 4.6.8

Reports: Business Objects 6.5, BOXI R2

Scheduling tools: Informatica Scheduler

Other Tools: PL/SQL Developer, Toad, MS office, WinSQL, WinSCP3, Putty.

PROFESSIONAL EXPERIENCE:

Confidential, Carlsbad, California

Informatica Analyst/Developer

• Actively involved in design and the technical Documentation for Source to Target Mappings.
• Developed required mappings to migrate the accounts,pricing, finance and freight information.
• Developed the code for migrating the SAP SKU’s (Products) to JDEdwards on an ongoing basis. Also designed and developed Product Integrity report tool to compare the dual branded sku information between SAP and E1.
• Developed the code for doing a mass upload of SAP agreements and quotes to SIEBEL EIM tables.
• Actively involved in the customer migartion process for each country, executed in steps.
• Used the best practices for better performance of the code.

Informatica Analyst/Developer

Confidential

• Involved in requirement analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications.
• Involved in preparation of Data Staging area and start schema for the data mart.
• Worked with the DBA’s to get the necessary database objects in place.
• Designed and developed mappings and other Powercenter objects.
• Unit Testing, Debugging and data validation for each mapping.
• Shell Scripts for scheduling the ETL JOBS on nightly basis, using ControlM tool.

Environment: Informatica 8.1, Informatica 8.6, Informatica 9.1.0, Oracle 10g, Red Hat Enterprise Linux Server Version 5.5, Toad, PL/SQL Developer, Windows XP

Confidential

Informatica Developer and Support Analyst

• Worked in the quickwin track which focuses on handling multiple enhancements with a quick turnaround time, with several live releases every month. Enhancements include addition of a new functionality to the current design or change in the existing design for a better performance of the code.
• Handled remedy requests from the business users. Proactively communicating with the users and resolving tickets well within the SLA.
• Performed data analysis of Retail and Product Insurance domain and implemented a Get-Well tuning to reduce the daily DWH availability time from 12:30 BST to 08:00 BST, which generated a lot of opportunity for the client to improve the business
• Took part in analyzing the data and suggestion of new Indexes to Architects
• Some of the mappings were tuned to achieve 1000% improvements in run times
• Actively involved in Netezza upgrade from 4.0.8 to 4.6.8 and Informatica Powercenter 8.1 to 8.6.
• Enforced constraints in ETL level since Netezza has less ability to enforce constraints
• Performed performance tuning activities to ensure that all the Netezza / Oracle scripts complete execution in an optimized time frame.
• Resolving technical and design issues in the current code in the form of Bug fixes.
• Training and Mentoring Junior team members
• Participating in the review of the detail design and code for all the projects to minimize performance impact on DWH load.
• Coordinated with the DBA’s to get the necessary database objects in place.
• Managing and coordinating project releases scheduled once in a month.
• Ensured 100% ticket resolution and DWH availability on time.
• Highlighted issues and deviations to the client and ensured proactive delivery.

Environment: Informatica Powercenter 8.1, Informatica Powercenter 8.6, TOAD, Oracle 9i, UNIX AIX 5.1, BMC Remedy User application, Windows XP, Netezza 4.0.8, Netezza 4.6.8, WinSQL