Summary




More than 7 years of IT experience in Informatica Power Center 8.x,7.x,6.x, and more than 5 years Experience as Senior ETL Developer onsite for Data warehouse project, Used Informatica Data Explorer IDE, Informatica Data Quality IDQ, PowerExchange PWX 7.x, 8.1, Trillium and Zycus tools.
Extensively worked on developing informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
Experience in conceptual, logical and physical data models using ERWIN.
Strong knowledge on databases like Oracle, Sql Sever, DB2.
Extensive experience in writing SQL and PL/SQL programs Stored procedures, Triggers, Functions for back end development.
Involved in Performance tuning.
Developed Unix Shell scripting for Data manipulation and scheduling jobs to automate daily load processes
Used PMCMD, UNIX shell scripts for workflow automation and repository administration.
Generated Business reports using Business Objects as a reporting tool as and when required.
Excellent communication skills, Good organizational skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, sincere, eager to learn, ability to grasp quickly.


Achievements

Informatica Designer Certification 8.x.


Employment

June, 2009 -  Present
ETL Senior Developer

VPF Verizon Product Facility is a global application which feeds data to different downstream application. The objective of this project is to eliminate manual loading of PCR S Product Change Requests to downstream systems whenever there are changes in VPF application and get an automated feedback from downstream systems, once PCR is loaded.
Responsibilities
Talking to business and gather the requirements.
Co-ordinate and guide the team on the technical front.
Review the deliverables and ensure standards and guidelines are followed.
Wrote PL/SQL stored procedures and triggers for implementing business rules and transformations.
Creating mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.
Creating necessary test plans and design documents for the mappings.
Designing, developing of different mappings according to the requirements and tested the mappings using various test cases in the test plans.

Environment : Informatica Power Center 8.1.1 Power Center, Designer, Workflow Manager, Repository Manager, Oracle 10g, SQL Server2005, DB2 and UNIX.

DUPONT,
Wilmington, DE.

September, 2006 -  May, 2009
ETL Consultant

DuPont DSAP organization executes and maintains different Projects which extracts data from different business and load them into SAPBW. Being the ETL Administrator and a part of the Run and Maintain Team, we support different Project Teams, set up the architecture for any new upcoming Projects and maintain/monitor the existing environment.
Responsibilities
Monitor, Manage and Coordinate administration of the Informatica server for Development, Quality and Production Environment.
User Security requests, routing UNIX tickets to Midrange and Informatica User Setup.
Migrate developed Informatica Objects, IDQ plans and UNIX files to Quality and Production.
Configure new relational connections DB2 and Power Exchange connections SAPR3 and SAPBW.
Create and configure new Informatica folders for new and existing projects.
Monitoring Informatica environments.
Create ands Configure infrastructure file system UNIX setup for new and existing projects.
Perform and co-ordinate all the environment upgrades.
Informatica Power Center Upgrade 7.1.2 to 8.5.1
Trillium Upgrade 7.5 to 7.8
Informatica Data Explorer IDE 5.0 to IDE 8.6
Informatica Data Quality IDQ 3.0 to IDQ 8.6
Integration of Power Center with Data Quality.
Zycus Model Updates.
Integrated Power Center with data quality.
Document all Installation, up gradation and post up gradation steps.

Document all the issues faced. Work with the Informatica Technology Support and different Project teams to resolve them.
Backup/Recover Informatica Repository.
Perform Log Management.
Performed Repository Consolidation.
Worked on DuPont s ETL Security redesign project.
Used PowerExchange to extract batch and CDC sources VSAM on mainframes.

Environment : Informatica Power Center 8.1.1 8.5.07.1.2 Power Center, Designer, Workflow Manager, Repository Manager, PowerExchange 8.1.1 IDE, IDQ, Trillium7.8, Zycus Auto class 2.5, DB2 and UNIX

February, 2006 -  September, 2006
Production Support

EDS Corporate office has requested an analytical application that will provide insight to support strategic decisions regarding Enterprise Operating Metrics with the mission to better assist leaders and executives with relevant workforce, finance, sales information in the form of an executive dashboard and ad-hoc analytics. This solution will provide an integrated view of EDS Delivery and Non Delivery Metrics.
It will improve the accuracy and currency of data by automating the collection data from multiple source systems.
Responsibilities
Extensively used Informatica Power Center for Extracting, Transforming and Loading into different databases.
Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.
Extensively used ETL to load data from Oracle database, Sql server database and Flat files to Oracle.
Created necessary test plans and design documents for the mappings.
Designing, developing and testing the different mappings according to the requirements.

Used Source Analyzer and Warehouse Designer to import the source and target database schemas.
Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Lookup, Update Strategy, Sequence Generator and Joiner.
Integrated various sources into the staging area in Data Warehouse.

Environment : Informatica Power Center 7.1.2 PowerCenter, PowerMart, Designer, WorkflowManager, Repository Manager, Oracle 10g, SQL Server 2000, PL/SQL, Windows Server 2000 and UNIX

October, 2004 -  February, 2006
Senior Informatica Developer

Agilent Technologies aims at combining variety of data sources Everest/PI/SAP into a new Global Data Warehouse GDW that is used by functional areas in the company that require an enterprise view of data. This goal is to meet the request for improved business information, historical and trend analysis. The program would provide a 360 degree view of customers world wide, create a trusted source for all enterprise analytical and management reporting and provide timely reporting of standardized metrics with the ability to drill down and perform analysis.
Responsibilities
Extensively used Informatica Power Center for Extracting, Transforming and Loading into different databases.

Extensively used Informatica Power Connect to work on SAP Sources.
Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.
Created necessary test plans and design documents for the mappings.
Designing, developing of different mappings according to the requirements and tested the mappings using various test cases in the test plans.
Created post-session and pre-session shell scripts and mail-notifications.
Used Informatica features to implement Type II changes in slowly changing dimension tables.
Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.
Integrated various sources into the staging area in Data Warehouse.
Development of Informatica mappings and Mapplets and tuned them for Optimum performance, Dependencies.
Extensively used ETL to load data from Flat Files to Staging area Oracle 9i using Informatica Power Center 7.1.2
Moving of mappings and sessions from development repository to production repository
Involved and Extensive knowledge in full develop of Development Life Cycle.
Implemented and tested Versioning feature.

Environment : Informatica power center 7.1.1 Oracle 9i, TOAD 8.5, Erwin 4.0, SQL, PL/SQL and Windows Server 2000, UNIX

February, 2004 -  October, 2004
Informatica Developer

North Delhi Power Limited is 1 of the leading Power companies in the nation 10 million Customers. The Business Process Data warehousing project was developed in an effort to streamline the business process of NDPL and to keep track of various Connections, Customers and Business Processes. Connection, Billing, Enforcement were some of the modules we were dealing.
Responsibilities

Interacted with the end users, Project Manager and other resources in understanding the requirements.
Extensively used ETL to load data from Oracle database and Flat files to Oracle.
Created necessary test plans and design documents for the mappings.
Created mappings using Informatica designer, sessions using workflow manager and tested the sessions using test data.
Designing, developing and testing the different mappings according to the requirements.

Used Source Analyzer and Warehouse Designer to import the source and target database schemas.
Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.
Integrated various sources into the staging area in Data Warehouse.
Development of Informatica mappings and Mapplets and tuned them for Optimum performance, Dependencies.

Environment : Informatica Power Center 6.2, Oracle 8i, TOAD 8.5, SQL Server 2000, PL/SQL, Windows Server 2000, UNIX

January, 2002 -  February, 2004
Informatica Developer

Indian Railways Head quarters requested for an application which will give a 360 degree view of data from various legacy systems like MMIS, CEMIS, SMIS and IPMS. This application would help the Senior Executives to make strategic decisions.
Responsibilities

Education

Skills

Hardware : IBM Compatibles, Sun SPARC Stations, HP, IBM Operating Systems : UNIX, Suse Linux, Windows 95/98, Windows NT/2000 ETL Tools : Informatica 8. x/7.1.2/6.2/6.1/5.1 PowerCenter, PowerMart, PowerConnect, Designer, Workflow Manager, Repository Manager, Administration, PowerExchange, Zycus Auto class 2.5 Database Tools : TOAD, Pl/SQL Developer Languages : SQL, PL/SQL Databases : Oracle 8i/9i, SQL Server 7.0, MS Access Front End Tools : Developer 2000 Forms 6i and Reports 6i Data Quality Tools : Trillium 7.8, InformaticaData Quality IDQ, Informatica Data Explorer IDE.
Involved in analysis of business requirements and keeping track of data available from various data sources, transform and load the data into Target Tables using Informatica Power Center. Prepared documentation for ETL strategies, source versus destination system mappings. Involved in building and supporting the extraction flows. Identification and Documentation of various data sources, the detailed Table/File/Field level mappings between the source and target systems. Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy. Created necessary test plans and design documents for the mappings. Tested mappings and sessions using various test cases in the test plans. Implemented SCD methodology, Type 1, Type 2 to keep track of historical data. Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters. Created post-session and pre-session shell scripts and mail-notifications. Environment : Informatica Power Center 6.2, Oracle 8i, SAP, Business Objects 5.1, TOAD 7.4, WindowsNT, UNIX