SUMMARY:

• Over 7 years of IT experience as a highly motivated, quality minded ETL and Data Migration specialist.
• Experience in development, design support of ETL Methodology for data transformations using Informatica Power Center 9.x/8.x/7.x/6.x, IBM Datastage 8.x, Datastage designer, Datastage director, Datastage Monitor etc
• Have extensive experience on Informatica enterprise data integration and management solutions.
• Experience in handling various Data sources like DB2 9.x/8x , Netezza, ORACLE 11/10/9g , SQLServer 2008/2003/2000, Teradata 14/13/12, MS Access, Ms Excel
• Extensive experience in using Informatica Power Center components: Designer, Workflow Manager and Workflow Monitor.
• Experience on Informatica Power Exchange
• Extensive experience on Data Modeling ER Modeling and Dimensional modeling
• Extensive experience in Analyzing the Dimensional Data modeling, Star Schema/Snowflake modeling, FACT Dimensions tables, Physical logical data.
• Skilled in Extracting/Loading data by using various Teradata utilities like MultiLoad, FastLoad, BTEQ, TPump, FastExport and Teradata Parallel Transporter TPT .
• Demonstrated ability to utilize industry best practices for developing data migration and data warehouse solutions.
• Background includes successful implementation of Data Migration, Data Integration and Data Warehouse Projects in wide variety of business including communications, energy, utilities, Banking, Health care etc.
• Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Knowledge of UNIX shell scripting korn/bash/AWK/SED , job scheduling on multiple platforms. Excellent individual and team performer maintains high levels of communication with Business Analysts and end users to enable better team performance.
• Extensive experience in using Powercenter 9 advanced features Change Data Capture, Pushdown Optimization, Grid Configuration, Metadata manager.
• Expertise in data profiling and data quality management using Informatica Data Explorer and Data Quality software.
• Experience in relational database concepts with a solid knowledge of Oracle, SQL and PL/SQL.
• Working knowledge on different data sources ranging from flat files, Excel, Teradata, Oracle, SQL Server, DB2 databases and XML files.
• Expertise in creating database objects like views, packages, procedures, triggers, functions and PL/SQL data types etc.
• Experience in using advance PL/SQL features like bulk loading, Collection usage etc.
• Experience in using database administration tasks such as exporting and importing data using data pump and SQL Loader.
• Hands on exposure on UNIX Environment and experience in using third party scheduling tools like Auto Sys, control-m, etc.
• Good knowledge on reporting tools like Micro strategy.
• Experience in troubleshooting performance related issues with data loads and reports.
• Experience in Migrating repositories and connections to different environments
• Experience in using version controlling tools like PVCS Tracker and Rational Clear case.
• Experience in using software configuration management tools like Serena.
• Have the ability to work in a complex and changing environment.
• Excellent communication and interpersonal skills.
• Possess good analytical and problem solving abilities

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Informatica Developer

Project Description: Confidential is the premier global professional services firm providing advice and solutions in risk, strategy and human capital. Through our market leading brands, colleagues in more than 100 countries help clients identify, plan for and respond to critical business issues and risks. ERLON Datamart involves enhancement of the existing J2EE application ERLON. This involved building a reporting Data Mart which gives business users reporting environment to generate bond related canned and ad-hoc reports.

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica ETL mappings to load data into various target tables and defining ETL standards.
• Created logical and physical data models using Erwin.
• Created Entity Relationship ER diagrams based on requirements.
• Preparing ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from Development to Testing environment and then to production environment.
• Worked with various Informatica client tools like Source Analyzer, Target designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager, Informatica data explorer, Workflow Manager and Workflow Monitor extensively to create, execute and monitor a mapping's run process.
• Created mappings using different transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
• Developed Mapplets and Worklets for reusability.
• Involved in upgrading Informatica 8.6 to Informatica 9 and worked on Informatica 9.
• Developed Fast Export scripts to send data files to other teams.
• Developed mappings which load data mart data into Teradata.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL scripting for creating Connected and Unconnected Stored Procedure Transformations.
• Created AutoSys schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and using Test data/cases to verify accuracy and completeness of ETL process.
• Actively involved in the Production support and also transferred knowledge to the other team members.

Environment: Informatica Power center 9.x, Informatica Designer, Repository Manager, Workflow Manager, Power Exchange 8.1, Java, Teradata 13, SQL Server 2005, Oracle 11g, TOAD, PL/SQL, and Business Objects.

Confidential

Sr. Informatica Developer

Project Description: Confidential is an multinational information technology corporation specialized in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. Major product lines include personal computing devices, enterprise industry standard servers, related storage devices, networking products, software and a diverse range of printers, all-in-one's and other imaging products. Hewlett Packard Information System Sales and Procurement HPIS SP involves building a data warehouse by consolidating data from the transactional SAP R/3 ERP system MM and SD module into a central data warehouse and storing historical information. This initiative helped the purchasing department and the management team to generate variety of reports from this transactional system in order to quickly identify trends and respond to changing market and economic conditions. HPIS SP deals with different kind of data such as purchase requisitions and purchase orders, materials, vendors, goods stock and location, quantity and price.

Responsibilities:

• Modified the logical and physical data models that capture new requirements to reflect the data model using Erwin.
• Involved in designing the process flow for extracting the data across various source systems.
• Extracted source data using power exchange from legacy systems.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Coded BTEQ scripts to load data from Teradata staging to Enterprise Data warehouse.
• Worked with Teradata External Loader connections such as MLoad, Upsert, MLoad, Update, and Fast Load in the Informatica Workflow Manager while loading data into the target tables in Teradata Database.
• Optimized the existing applications at the mapping level, session level and database level for a better performance.
• Developed complex mappings to implement type 2 slowly changing dimensions using transformations such as the Source qualifier, Aggregator, Expression, Static Lookup, Dynamic Lookup, Filter, Router, Rank, Union, Normalizer, Sequence Generator, Update Strategy, and Joiner.
• Developed Informatica workflows and sessions associated with the mappings using Workflow Manager.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length with the help of DBA's, target based commit interval and SQL overrides.
• Performed data validation, reconciliation and error handling in the load process.
• Migrated the mappings and workflows from the development server to the Test Server to perform the integration and system testing.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created PL/SQL procedures and UNIX shell scripts to run along with daily/weekly/monthly batches to reduce or eliminate manual testing effort.
• Responsible for writing unit test cases and performing the unit testing for data validity based on business rules.
• Member of On call team for providing support for daily and weekly batch loads.

Environment: Informatica PowerCenter 6.2, Informatica PowerCenter 7.1, Windows NT, Oracle 10g,Erwin, SQL Server 2005, Javascript, Facets, UNIX, OBIEE 10.1.

Confidential

Sr. ETL Developer

Confidential personalizes communications for business-class customers across the Confidential through a comprehensive suite of data, voice, and IP services, as well as enterprise communications management software, network security solutions, CPE, and managed services. The goal was to implement a centralized Enterprise Data warehouse. The CARP Call Record Processing data warehouse collects, organizes and stores data from different operational systems and Network switch elements such as Gateways, Routers and SBCs to provide a single source of integrated and historical data for sales and billing reports. This further provides as a source for end user reporting, analysis, decision support and to improve the client services.

Responsibilities:

• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.
• Involved in Data Modeling Using Erwin.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager, PMCMD and also using scheduling tools. Generated completion messages and status reports using Workflow manager.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.
• Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed Unit testing and verified the data.
• Supported Business Objects end-user in areas including software Designer, Reporting, Web Intelligence, and Publisher and creating reports.

Environment: Informatica Power Center 8.1.1, Teradata V2R5, Unix, DB2 Power exchange 8.1, Erwin, TOAD, PL/SQL, Flat files, Oracle 10g/9i,XML, SQL Server.

Confidential

Informatica Developer

Confidential involved consolidating the data from various data sources Involving Household, Accounts, Security, Positions, Balances and HR related information. This data come from different sources which included databases such as Oracle, MS SQL Server and flat files . The Project mainly involved working with data quality, data analysis and production support of the ODS system.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model E-R diagrams , database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Participated in evaluation and selection of the ETL tool to facilitate the migration of data among operational systems.
• Involved in writing the use cases for the current system and analyzed the stored procedures to list out the performance bottlenecks of the current system.
• Responsible for developing program specifications and testing requirements.
• Accomplished automated data extraction from various RDBMS via scripts, ETL processing using Informatica and loading into Retail Data warehouse.
• Reviewed the code developed by offshore team and recommended changes.
• Involved in ETL processes to load data from SQL Server, Sybase, flat files and Excel spreadsheet into the target SQL Server databases by applying business logic on transformation mappings for inserting and updating records when loaded.
• Involved in replacing the inbound DTS packages and stored procedures with ETL interfaces.
• Involved in unit, integration and user acceptance testing of mappings, mapplets and sessions.
• Tuning the Informatica Server and Mappings for optimum performance. Extensively used debugger to check the correctness of data.

Environment: Informatica Power Center 6.2, Oracle9i, SQL Server 2005, Windows NT and UNIX.

Confidential

Oracle / ETL Developer

Project Description: Oracle Financial Services Software Limited formerly called i-flex Solutions Limited is an IT solution provider to the banking industry. Oracle Financial Services is majority owned by Oracle Corporation. It claims to have more than 900 customers in over 135 countries. The project was designed and developed for maintenance of all IFLEX products. The database facilitated maintains data related to the entire FLEXCUBE warehouse. The project involved Oracle Development and ETL Work.

Responsibilities:

• Involved in requirement gathering and identifying the report set to be produced Data Warehouse design, ETL specifications.
• Interacted with Business Analysts for mapping specs and business rules.
• Created various Mappings using Informatica PowerCenter and refined the specs to load data in Warehouse.
• Created Interfaces for PowerExchange with Informatica PowerCenter using PWXPC and PWX ODBC to capture change data.
• Involved in ETL Process with Normalization.
• Involved in designing the mappings and end-to-end data flow in a mapping.
• Handled Errors at different levels for lookups, matching CDC data capture flag and Dynamic Lookup and error out if any mismatch.
• Involved in the Development, Unit Testing/System Testing of various Informatica mappings.
• Involved in reading and Translating logic from SQL Server Stored Procedure and Functions into Informatica Design.
• Identified tables/Scripts required for full load, daily delta-load and monthly load and documented ETL process for Warehouse design
• Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Did Data Analysis from Source to target.
• Designed the process for data profiling and cleansing.
• Implemented SCD Type I and Type II for maintaining history for Member and Provider.
• Used parameter files for all parameters, connection and hard coded values.
• Wrote UNIX shell scripts and used them as Pre/Post Session commands in Sessions.
• Scheduled the Workflows and monitored them. Provided Pro-Active Production Support after go-live.
• Documented the number of Source/Target rows and analyzed the rejected rows and worked on re-loading the rejected rows.
• Used workflow monitor to monitor the jobs, reviewed error logs generated for each session.
• Analyzed test cases for automation and created scripts for regression testing using QTP.
• Lead the effort to convert manual test scripts into automated test scripts for functional, regression and sanity testing using QTP.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Informatica 6.2, Oracle 8i, Developer 2000, SQL Loader, PL/SQL procedures, Windows 2000, Unix Shell Scripting.