PROFESSIONAL SUMMARY:

• Around 4 years of IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience using Informatica Power Center 9.x, Oracle and Shell Scripting.
• Expertise in Developing Mappings, Define Workflows & Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, Oracle, and SQL Server.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, Transaction Control, Java and update strategy.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Expertise in doing the RCA (Root Cause Analysis).
• Strong skills in analyzing the database design, Coding using SQL and PL/SQL, Oracle 10g, SQL Server, and Sybase database applications. Coded Stored Procedures, Packages and Triggers using PL/SQL. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Closely worked with business users at various stages of the project lifecycle, including requirements gathering, design, development, testing and post - production support.
• Ability to adjust to the people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.
• Management skills include Team Management, Project Planning, and Monitoring, documentation, presentation skills and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILL:

Data Warehousing Tools: Informatica Power Center 9.1.0

Reporting Tools: Crystal Reports & Excel

Languages: PL/SQL, UNIX Scripting

Databases: Oracle-10g, SQL Server 2008

Tools: /Utilities: Toad, ORACLE SQL Developer,

Confidential, USA

Tools: Informatica Powecenter 9.1.0, Oracle 11g, Shell scripting, CTRL M

Sr. Informatica Developer

Roles and Responsibilities:

• Working closely with the business Analyst to understand the requirements and converting them into project level technical capabilities & reviewed it with an architect.
• Created new PL/SQL Packages/procedures to update the data into the database and to retrieve the same data to display it in the UI (Web service).
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator and Stored Procedure.
• Parameterized the mappings and increased the re-usability.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Schedule & Monitor jobs on a daily/weekly/Monthly/Yearly basis
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Creating primary objects (tables, views, indexes) required for the application.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Creating the deployment documents and migrating the code to the production environment.

Confidential, USA

Tools: Informatica Powecenter 9.1.0, SQL Server 2008

Sr. Informatica Developer

Roles and Responsibilities:

• Extracted data from MS SQL Server database and applied business logic.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the database.
• Extensively used Transformations like Router, SQL, Joiner, Expression & Update strategy.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Confidential, USA

Tools: Informatica Powecenter 9.1.0, Oracle 10g, Shell scripting

Informatica Developer

Roles and Responsibilities:

• Understand the requirements and converting them into project level technical capabilities (TSD).
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Used Java transformation to split the concatenated strings & Aggregator to concatenate it again.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator and Stored Procedure.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Schedule & Monitor jobs on a daily/weekly/Monthly/Yearly basis in Crontab.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.