SUMMARY

• 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Pharmaceutical, Manufacturing, Service, Retail, Financial, Insurance, Telecom and Banking.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Implemented various ETL solutions as per the business requirement using Informatica 9.5.1/9.0/8.6.1
• Involved in the full development lifecycle from requirements gathering through development and support using Informatica Power Center, Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Good experience in TIBCO AMX
• Worked on PowerExchange for Greenplum allows Informatica solutions to seamlessly integrate with Greenplum to extract, transform and load (ETL) data from a wide variety of source systems into the Greenplum Platform
• Experienced in designing/developing complex mapping using Informatica transformations.
• Experienced in defining data modeling, data warehouse, Star/Snowflake Schema Designs with requirements analysis - definition, database design, testing and implementation, and Quality process.
• Successfully managed operations on Informatica Enterprise Data Warehouse (EDW) including creation, designing, development, implementation, and testing.
• Experience in integration of various data source definitions like SQL Server, Oracle, Flat Files, SAP, and XML
• Hands of experience in DAC and also done the DAC set up and Installation for multiple BIAPPS projects.
• Experienced in debugging and performance tuning of sources, targets, mappings, and sessions in Informatica.
• Managed Onsite-offshore module
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.
• Strong Team working spirit and relationship management skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5.1/9.1/8.6.1 , OLAP, OLTP

Data Base: Oracle 11g/10g, DB2, Teradata 12/13, People Soft, SQL Server, SQL Developer

Languages: SQL, PL/SQL

Web Tools: HTML, DHTML, XML, TIBCO AMX

Tools: Toad 9.1, Query Builder, Microsoft Project 2003, Quality Center, PVCS, Control-M, Autosys, SQL Developer

Operating Systems: Windows 7/Microsoft XP/2000/NT, UNIX

DAC: DAC 7.9.6.3

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton, CA

Sr. Informatica ETL Developer

Responsibilities:

• Discussing business requirement with Business Analysts to develop technical specifications and design and develop ETLs.
• Extracted data from Oracle, Flat files and XML files and transformed data using Source qualifier, Expression, Sequence Generator, Sorter and Router transformations.
• Created Mapping parameters, session parameters and generated the parameter file using ETL.
• Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
• Used Control-M Scheduler to schedule the process on a daily basis.
• Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet all the complex business rules implemented in ETL mappings.
• Adhered to the quality code standards described by the client.
• Extracted Data from People soft and transform data according business rules and load data in to data warehouse
• Developed PL/SQL scripts to perform activities at database level, Automate manual tasks to reduce time and effort
• Worked on informatica Power Exchange to seamlessly integrate with Greenplum to extract, transform and load (ETL) data from a wide variety of source systems into the Greenplum Platform
• Creation of sessions and workflows according to the data load in to different systems.
• Configure DAC and done the Initial load after setting the DAC parameters and csv file configuration which is required before the full load.
• Involved in Design and develop various modules using TIBCO AMX product suite
• Handling client calls and updated Status regarding ETL Informatica.
• Maintained Coding standards and participated in Code Review.
• Involved in Performance tuning of mapping level and session level.
• Maintained all the documents in the clear case and CVS for Version control.
• Executed Unit, Functional, Integration, Regression and System testing and preparation review documents for the same.
• Deployment to various servers & Migration activities.

Environment: Informatica PowerCenter 9.5.1/ Oracle 11g, Control-M,Autosys,Teradata,Greenplum, Oracle SQL, TIBCO AMX, XML, SQL Developer 8.9.1, People Soft, MS Excel, MS Visio, UNIX Shell.

Confidential, Oakland, CA

Sr. Informatica ETL Developer

Responsibilities:

• Discussing business requirement with Business Analysts to develop technical specifications and design and develop ETLs.
• Extracted data from Oracle, DB2, flat files and XML files and transformed data using Source qualifier, Expression, Sequence Generator, Sorter and Router transformations.
• Created Mapping parameters, session parameters and generated the parameter file using ETL.
• Implemented Reusable transformations, mappings, User Defined Functions, Sessions.
• Used Built in Informatica Scheduler to schedule the process on a daily basis.
• Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet all the complex business rules implemented in ETL mappings.
• Adhered to the quality code standards described by the client.
• Prepared process level reports such as Regression Testing Reports, Execution Reports, Effort Estimation Reports, Tractability Reports, and Change Request (CR) Estimation Reports etc.
• Creation of sessions and workflows according to the data load in to different systems.
• Maintained Coding standards and participated in Code Review.
• Involved in Performance tuning of mapping level and session level.
• Maintained all the documents in the clear case and CVS for Version control.
• Executed Unit, Functional, Integration, Regression and System testing and preparation review documents for the same.
• Deployment to various servers & Migration activities.

Environment: Informatica PowerCenter 9.0/ Oracle 11g, Oracle SQL, DB2, XML, Autosys,MS SQL Server 2005, MS Excel, MS Visio, UNIX Shell.

Confidential, Ferguson, MI

Sr. Informatica ETL Developer

Responsibilities:

• Interacting with Business analyst and on-site coordinates for requirement analysis.
• This is a kind of Up-gradation Project from BIAPPS 7.9.5 to 7.9.6.2 and in this we have two source systems one is EBS and another one is Main Frames. I was a part of Financial Analytics.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source EBS database into the target Oracle database.
• Designing and developing mappings to extract data from diverse sources including flat files.
• Designed and Developed the Sales Order Aggregate to resolve the performance Issues.
• Successfully solved Tracks assigned Before Dead Lines.
• Involved in the testing process throughout the project.
• Involved in debugging the data mismatches and fixed those and also prepare proper analysis document for the mismatches.
• Worked on a Production Clone instance for the same project based on the client request and hand over to client in a couple of weeks’ time including the data validation.
• Worked on Migration from DEV environment to QA and Production Environment.
• Performed unit testing.

Environment: Informatica 9.0, Tivoli, Oracle 11g, PL/SQL, DB2, XML, MS SQL Server 2005, MS Excel, DAC, UNIX Shell..

Confidential, San Jose, CA

Sr.ETL/Informatica Developer

Responsibilities:

• Interacting with Business analyst and on-site coordinates for requirement analysis.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source People soft database into the target SQL server database.
• Designing and developing mappings to extract data from diverse sources including flat files, People Soft, MS-Excel, MS Access Data Bases etc.
• Successfully solved Tracks assigned Before Dead Lines.
• Involved in the testing process throughout the project.
• Conducting Quick Internal Meetings to Distribute Work On a daily basis After Client Call.
• Worked on Migration from Dev environment to Production Environment.
• Code migration from development to QA and production environments.
• Analysis of requirements and finding the gap between use cases, User interface documents and ETL specifications.
• Creation of ETL Design documents with the help of use cases and User Interface documents, Business rule documentation and PDM.
• Creation of mappings according to the use cases by following the ETL specifications.
• Creation of Informatica mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Joiner, Union, Aggregator, Sorter, Sequence generator, Router, Update Strategy, and Stored Procedure etc.
• Extracted data from of different types of Flat files, Oracle.
• Implemented the Error handling mechanism.
• Involved in identifying the Power Exchange Oracle CDC limitations and supplementary solutions.
• Involved in migrating the power center maps.
• Worked on to Extract the data from Source and cleanse and apply transformations according to the client requirements and load data in target Teradata Database using Teradata utilities like TPUMP, MLOAD and FLOAD
• Developed the strategy for the incremental loads, delta load and MDM.
• Creation of Unit, Functional, Integration and System test cases based on Requirement Specification Documents, Use Case Docs, PDM, and User Interface Specifications. .
• Involved in Unit, Functional, Integration and System testing and preparation review documents for the same.
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.
• Involved in Load schedule plan.
• Performed unit testing.

Environment: Informatica Power Center 8.6.1/9.0.1 , Oracle 10g/11g, Autosys,Flat Files, XML Files, PL/SQL, TOAD for Oracle, People soft,MS Visio and Windows 2000.

Confidential, Framingham, MA

ETL Developer

Responsibilities:

• Interacting with Business analyst and on-site coordinates for requirement analysis.
• Successfully solved Tracks assigned.
• Data Handling in Informatica and Oracle 9i.
• Created mappings and work flows to implement business requirements.
• Designing and developing mappings to extract data from diverse sources including flat files, and RDBMS tables.
• Development & support of client’s manufacturing and purchasing applications and end user reporting.
• Analyzed the Change requests (RFC) and Business Requirement Documents (BRD) as per requests
• Create, backup, restore for Informatica Repositories
• Involved in migration of objects in all phases (DEV, INT and PRD) of project
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS
• Created SSIS Packages to migrate slowly changing dimensions.
• Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Interacted with Business Analyst and user for requirement gathering and created High Level and Low Level design documents.
• Suggested redesign of ETL processes and also re-architecture of existing ETL processes.
• Worked as an Informatica/Data Warehouse Developer helping the team with production issues, enhancements and maintenance of existing code, as well as did an Informatica Administrator role.
• Worked on Informatica MDM Data Director to check the central view for recognize Mata data changes across the all the Master Data.
• Support defect resolution and perform change management by updating Technical system specification documentation, this will require analysis of existing software systems, and designing and implement testing for existing and new software systems.
• Gather Requirements, Perform Impact Analysis and Create the functional and Technical documentation for ETL process for Real time data process.
• Work closely with business users and involve in designing, developing high complexity mappings.
• Performed unit testing.

Environment: Informatica Power Center 8.6/8.1, Oracle 9i, Flat files, PL/SQL, SQL Developer, UNIX Shell Scripting, Windows Server 2003, Windows XP.

Confidential, San Jose, CA

ETL Developer/Data Analyst

Responsibilities:

• Designing and reviewing the ETL solutions in Informatica Power Center 7.1.2.
• Based on the requirements, created Functional design documents and Technical Design specification documents for ETL Process.
• Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source oracle database into the target oracle database and flat files.
• Designing and optimizing the Mapping to load the data in Slowly Changing Dimensions.
• Involved in Performance Tuning at various levels including Target, Source and Mapping.
• Used Debugger to gain troubleshooting information from the mappings.
• Worked on Migration from Dev environment to Test Environment.
• Assisted gathering business requirements and worked closely in various Applications with Business Analyst teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed schema model for target database using Erwin Data modeling.
• Designed and developed Context for faster development, standardization and reusability purposes.
• Involved in pre and post session migration planning for optimizing data load performance.
• Understanding client process to work efficiently and deliver solutions in accordance with Wells Fargo quality control standards and business practices and procedures.
• Have developed a level of competency, which helps to anticipate issues solve them in advance.
• Involved in analyzing, resolving and providing temporary fix for the Data issues Also he had to interact with the business users to intimate and do the recovery steps if there is any problem in the process
• Deployment to various servers & Migration activities.
• Done unit testing of the mappings.

Environment: Informatica Power Center 7.1.2, Oracle 9i, SQL, PL/SQL, UNIX HP/ Linux and Win XP.

Confidential, CA

Informatica Developer

Responsibilities:

• Involved in understanding requirements, analyze new and current systems to quickly identify required sources and targets
• Prepared technical documentation, design transformations that are consistent with the goals of the existing data warehouse, and worked with the development team to implement the solution
• Worked in legacy code to analyze problems, confirm requirements, and create designs, code and testing.
• Experience in designing, developing, and testing Informatica extract/transform/load processes in a Data Warehouse.
• Extensively worked on Mapping Parameters, Workflow Variables, Mapping Variables, and Session Parameters.
• Used the Workflow Manager to create Workflows, Worklets and Tasks.
• Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
• Used design and development techniques that resulted in efficient, maintainable, and high quality ETL processes.
• Used problem solving skills and quickly understood relationships between data with little documentation or guidance.

Environment: Informatica PowerCenter 7.1.2, Oracle 9i, Flat Files, PL/SQL, DB2, Windows 2000, UNIX