Professional Summary

• Around sevenyears of extensive experience in design, development, testing and maintenance of Business Intelligence and database applications using tools and technologies such as Informatica Power Center, Informatica Power Exchange, Informatica Metadata Manager, SQL, PL/SQL
• Experience with implementing ETL solutions using Informatica Power Center 8.x / 9.x, on Windows in various sectors- Insurance, Health Care, Telecom and Banking companies
• Developed tactical and strategic plans to implement technology solutions and effectively manage client expectations.
• Developed effective working relationships with client team to understand support requirements
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the projects
• Good command in developing Mappings and Mapplets, Sessions, Workflows, Worklets and Tasks using Informatica Designer, Workflow manager and Batch processing using PMCMD Command
• Extensively worked onInformatica Power Center transformationssuch asSource Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator
• Hands on experience in Performance Tuning of source, target, mappings, transformations and sessions
• Working knowledge on Installation/Upgrade of Informatica, Creating Users, Integration Service and Repository Service
• Very good knowledge in data warehouse designs using Star Schema and Snow Flake Schema Architectures, Fact and Dimension Tables, OLTP and OLAP applications.
• Very strong in debugging Informatica Mappings
• Technical Skills

Professional Experience

Role: ETL Informatica Developer

Overview: Genworth consolidated all the ETL applications based on BI Methodologies and created a group to develop, enhance existing applications along with the support on day to day activities. The team was responsible for about the 90 of the ETL work in Genworth.

Responsibilities:

• Worked with Informatica Designer of Functional Description, Scope and Detailed functional requirements.
• Designed and Created data cleansing and validation scripts using Informatica ETL tool.
• Responsible for creating, importing all the required sources and targets to the shared folder.
• Worked with Different sources such as Relational Data bases Oracle, SQL Server, and MY SQL , Flat files, Adobe PDFs, Xml files,
• Created mappings using Informatica Designer to build business rules to load data.
• Created Folders and placed all the tested ETL, Oracle and UNIX scripts in the Staging path for production movement.
• Created UNIX scripts for handling the ftp of source files, to make them execute in sequence as per the time stamp and to archive the processed files for future reference.
• Involved table partition in database.
• Scheduled the jobs in Dev and Testing environment using Informatica Scheduler.
• Prepared the data flow of the entire Informatica objects created, to accomplish Integration testing.
• Prepared Unit Test Plans.
• Supported user queries against availability of data from Data Warehouse.
• Performed troubleshooting for non-uniform ness.

Environment: UNIX, Informatica Powercenter 8.5 / 9.01, Windows 2000, Windows XP, DB2 UDB, Flat Files, PL/SQL, Erwin 4.0, Oracle 10g/11g, Oracle 9i, SQL, PL/SQL, SQL Loader, Transact-SQL

Confidential

Role:Informatica Developer

Overview: The Health Care Marketplace Project provides information and analysis about the health care market, including trends in health insurance, health care costs, and health care services.

Responsibilities:

• Involved in requirement, analysis and understanding of business requirements toidentify the flow of information and analyzing the existing accounting systems from daily to weekly to monthly process.
• Designed Distributed Architecture for new data of enrolling Customers every day through CIP and Obama Care Plans etc.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema
• Integration of various data sources like Db2,Oracle, SQL Server, Fixed Width and Delimited Flat Files.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Worked on Normalizer, Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Involved in troubleshooting existing ETL bugs using Power Centre Debug tool.
• Responsible for testing, modifying, documenting and implementation of Informatica mappings.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Troubleshoot data issues, validated result sets, recommended and implemented process improvements.
• Extensively worked with incremental loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Created lookup on DB2 for look particular data into DB2.
• During Implementation phase, tuned Informatica Mappings for optimum performance.
• Informatica Mappings used to load the data from the Source files to staging tables and from staging tables to BW Benefit workstation and DB2 tables.

Environment:Informatica Power Center 7.1.1, Windows 2000, DB2 UDB, Flat Files, PL/SQL, Erwin 4.0, Oracle 9i

Confidential

Role: Informatica Developer

Overview: Confidential is a diversified energy company dedicated to safety, reliability and operational excellence. Headquartered in Akron, Ohio, FirstEnergy includes the nation's largest investor-owned electric system and a diverse generating fleet with a total capacity of approximately 24,000 megawatts.

Responsibilities:

• Involved in Dimensional modelingof the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Worked on performance tuning of SQL and mappings by usage of SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• As per the requirement of the business users to manage change data capture, implemented Slowly Changing Dimensionstype I and type II.
• Involved in reviewing of code and Technical Support to the Team and
• Responsible for conducting the System and Unit Testing using Autosys.
• Experience in Migration of modified informatica mappings based on dates using DAC.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used PowerCenter Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Troubleshoot workflows and sessions for daily and monthly extracts from various data sources across all platforms to the target database.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Created List, Crosstab, Chart type reports for the sales data using Cognos7.3
• Wrote various shell scripts for pre-processing of data and scheduling of jobs.
• Worked on Test Director for Unit and Integration testing.

Environment: Informatica Power Center 5.1, Designer, SQL, PL/SQL, SQL Loader, UNIX Shell Scripts, Business Objects, Stored Procedures

Confidential

Role: ETL Developer

Overview: Confidential is a leading provider of financial solutions for private and business clients. They provide all-round service extending from account keeping and cash securities investment advisory to asset management. The project involved several modules that involves in developing applications for various financial transactions. My module is involved in data warehousing.

Responsibilities:

• Involved in various meetings with business analysts and DBA s for better understanding of business requirements.
• Designed and developed Informatica mappings for data loads using various transformations like Aggregator, Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, Normalizer and Union.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables, Session Partitioning and lookup Cache size.
• Performed change data capture process using Type I and Type II implementations.
• Developed Mapplets and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Development of logical and physical test cases
• Studied Session Log files to find errors in mappings and sessions.
• Implemented Type II Slowly Changing Dimensions Methodology to keep track of historical data
• Worked on Balance and Control mechanism as a part of error handling and data validation processes.
• Developed PL/SQL procedures to implement business logic, Involved in query performance tuning and Informatica ETL tuning.
• Extensively involved in ETL testing, Created Unit test plan to test the mappings, created test data.
• Performed code reviews and handled change request.

Environment: Informatica Power Center 8.1,JCL, MS SQL Server 2005/2008, Transact-SQL, DB2, TIDAL,TOAD, MS Office, Windows 2003

Confidential

Role: Informatica Developer

Overview: Confidential is the largest life insurance company in India. The purpose of the project is to create a customized data mart AIP Agency Information program which consisted of Agency details, Policy details, and Claims/Loss details. The data mart is in star schema with Agency Fact table and several dimension tables, Policy and Claims details were laid out in flat files. The information was then transformed according to the business logic and loaded into the data mart and also involved in to other projects involving Mainframe technologies.

Responsibilities:

• Understood existing business and customer requirements
• Involved in designing the mappings between sources and targets and also tuned them for better performance
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Expression, Lookup, Filter, Router and Update Strategy
• Involved in code migration from development to QA and production environments
• Extracted data from of different types of Flat files, Relational Databases Oracle
• Implemented reusable transformations, mappings, User Defined Functions, Sessions
• Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse
• 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 testing and System testing and prepared test plan documents
• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads
• 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
• Creation of new jobs JCL in the claims system
• Online screen modifications in IMS DC and CICS with the data base as IMS DB

Environment:Informatica Power Center v7.1, JCL, CICS, IMS DB Oracle 7i, Toad 7.6, Windows XP, UNIX

Confidential

Role: Informatica Developer

Overview: Confidential and India's biggest CRO in pharma and healthcare. The current project objective was to design and develop a Single Integrated Data Warehouse for reporting the USFDA Drug data for the organization, which enables the scientific team to access the drug data.

Responsibilities:

• Involved in development phase meetings for Business Analysis and requirements gathering.
• Worked with users and developers on requirement issues and gap analysis.
• Developed and Implemented ETL processes using Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Designed and developed complex aggregate, join, look up transformation rules to generate consolidated fact/summary data.
• Involved in Change data capture process using Slowly Changing Dimensions.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Scheduled Workflows using AutoSys.
• Involved in developing SQL Scripts for extraction and loading of data to data warehouse.
• Developed Test Cases for Unit Testing, also involved in Integration, system, and performance testing levels.
• Create and maintain shell scripts for pre/post session operations.

Environment:Informatica Power Center v6.2, PowerMart 6.2, Oracle 9i, PL/SQL, Toad 7.6, Windows XP, UNIX