SUMMARY

• Over 8 years of software experience in analysis, design, development, testing includes data warehousing experience using Informatica ETL (Extraction, Transformation and Loading Tool) Power center in Finance, Insurance and Transport domains
• Strong experience in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies used in relational, dimensional modeling and multidimensional modeling, Data Profiling and Data cleansing
• Expertise in ETL process using Informatica Power Center Designer, Workflow manager, Workflow monitor, Informatica server and Repository Manager
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions
• Expertise in creating mappings, mapplets, mapping wizards and reusable Transformations using Informatica
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy
• Proficient in using Workflow Manager Tools like Task Developer, Workflow Designer and Worklet Designer
• Highly Skilled with the Integration of various data sources like Oracle, SQL Server,DB2,XML files and Flat Files
• Designed and developed efficient Error Handling methods and implemented throughout the mappings
• Created Business Objects Reports that had multiple data providers, drilldown, slice and dice features using Business Objects
• Strong Experience in creating Stored Procedures using Oracle PL/SQL
• Good experience in UNIX and writing shell scripts for Informatica pre & post session operations and database administration activities
• Closely monitoring the jobs, which are scheduled to run on a daily & weekly basis, fixing the issues in case of any failures and giving the permanent solution to solve the issues
• Effective Team Player with excellent analytical, programming, written and verbal communication skills

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6.1/8.5.1/8.1.1/7.x, Data Quality, Data services and CDC,TPT,MDM

BI Tools: Business Objects 5.1/6.5

Modeling Tools: Erwin 4.1,MS Visio

RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2005/ 2000, DB2,Teradata,Sybase 15.5.0.0

Other Tools: SQL Developer, Quest Central for DB2, Quest Toad for Oracle, MS Office, Rapid SQL, Auto sys, Tivoli workload scheduler, Control - M

Languages: SQL, PL/SQL,C,C++

Operating System: UNIX-AIX, Windows NT/2000/XP, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Informatica Developer and DBA/ILM

Responsibilities:

• Worked as a lead of the project with the combination of DBA with informatica using change data capture and Digital to Analog converter.
• Experienced in ILM(Information Lifecycle Management) with ILM capabilities of data archiving,data masking and application retirement.
• Worked on the utilities of TERADATA such as FastLoad and Mload.
• Worked with the concept of DATASTAGE which allows monitoring and running the tasks.
• Involved in gathering and analyzing the requirements and preparing business rules
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Sybase and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.0
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements
• Involved in Performance Tuning of mappings in Informatica
• Good understanding of source to target data mapping and Business rules associated with the ETL processes

Environment: Informatica 9.0, Oracle 11g, Sybase 15.5.0.0, SQL,Teradata, T-SQL, PL/SQL, Rapid SQL 8.0, Erwin4.x, Unix, perforce, Auto sys R11

Confidential, New York, NY

Sr. ETL/Informatica/ PL/SQL Consultant

Responsibilities:

• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor as a senior Informatica Developer.
• Worked on a Master Data Management to comprise the policies, standards and tools which are used in the project.
• Worked with the concept of DATASTAGE and some BI applications with CONGNOS BI.
• Extracted data stored in Oracle 11g, Oracle 10g and Oracle 9i and Flat files and loaded data into Oracle Data warehouse
• Installation and Upgradatation of Informatica Power center 9.0.1 from 8.6.1 and 8.1.1 versions
• Worked with SAP Business Objects reporting tool
• Worked with Source Analyzer, Data Warehouse Designer, Workflow monitor, Mapping Designer, Mapplets, and Transformation Developer in Informatica designer
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly and monthly loading of Data
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update Strategy transformations to model various standardized business processes
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Participated in reconciling data drawn from multiple systems across the company like Oracle 11g, Oracle 10g, flat files into Oracle data warehouse
• Involved in data Transformations between different Informatica folders and also Repositories along with DBA team.
• Developed entity diagrams and data dictionaries to accomplish tasks. Develop logical and physical data models that capture current state/future state data elements and data flows using ER-WIN.
• Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Experience using different transformations like Aggregator, Lookup (connected and unconnected), Filter, Expression, Router, Update Strategy and Sequence Generator for data transformations.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Developed reusable transformations to load data from various data sources to the DW.
• Created UNIX shell scripts for extract data from various sources like Oracle.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Scheduled Informatica sessions and workflows using Informatica Scheduler in Business process as Requested in SLA.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including partitioning, memory tuning and cache management.
• Created and maintained various project related documents like high level design documents etc.
• Created, executed and documented associated test cases.

Environment: Informatica Power Center 9.1/8.6.1/7.1(Informatica Designer, Workflow Manager, Workflow Monitor), Oracle 10g,Oracle 11g, Flat files, ODBC, Windows NT, UNIX, Shell Scripts, Toad 7.5,Apex explorer/loader, SQL, MDM.

Confidential . Minneapolis, MN

Informatica Developer/MDM

Responsibilities:

• Involved in the analysis, design, coding and testing of the Data analysis
• Experienced skills working on the MDM(Master data Management) with the combination of informatica ETL to approach the Unique MDM requirements.
• Experienced working with ETL Teradata along with Informatica.
• Involved in interpreting the logical and physical data models to determine common data definitions
• Involved in various interactions with concerned application teams to understand the business logic
• Data quality, data validation and data conversion were part of regular responsibilities
• Involved in the data migration from Control-M to TWS scheduler
• Involved in performing data validation for various applications such as Sales force, Annuities and Investments
• Used the features like Workload designer, Viewpoint manager etc
• Extensively worked in data Extraction, Transformation and Loading from sources to target system using Informatica Power Center
• Extensively used Lookup, Joiner, Aggregator, Expression, Update, Filter, Router transformation
• Used Informatica debugging techniques to debug the mappings
• Used heterogeneous files, flat files, spreadsheets, and oracle as sources
• Created, monitored and troubleshooted sessions for daily extracts
• Involved in tuning the SQL statements to optimize the performance
• Disabled the jobs scheduled through Control-M after two weeks of successful runs in TWS

Environment:, Informatica PowerCenter 8.5/9.1, Tivoli Workload Scheduler 8.5.1, Control-M 6.2.1, Oracle 10g, Teradata 12.0, SQL Server 2008, Mainframe DB2,MDM, SQL Developer, MS Visio, UNIX

Confidential, Charlotte, NC

Informatica Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked with TERADATA ETL and INFA tool in it.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked with XSD and XML files generation through ETL process.
• Defined and worked with mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed the performance evaluation of the ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated with testing team to make testing team understand Business and transformation rules being used throughout ETL process.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.

Confidential

Sr. Informatica Developer

Responsibilities:

• Modeled the Data Warehousing Datamart’s using Star Join Schema.
• Worked on Informatica tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write stored procedures to increase the performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources (Flat files, Oracle, Sql Server, XML) using different Transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup, Expression, Sequence Generator, Java, XML Source Qualifier, Union and Update Strategy to load the data into the target.
• Worked on Data cleansing, data conversion & process implementation.
• UNIX Shell scripting for backup and monitoring of databases.
• Responsible for the development, implementation and support of the database of the server.
• Provided daily support to clients including data research and test environment data refreshes
• Monitored the processes to identify potential issues and apply preventative and corrective actions.
• Testing all forms, PL/SQL code for logic correction.
• Responsible for the dealing with the problems, bug fixing and troubleshooting.
• Involved in production support and stabilizations.
• Coordinated between Development, QA and production migration teams.
• Reports were generated using Business Objects for analysis.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, Clear Case, Clear quest, XML, PL/SQL, Toad 9.6.1.1, Unix Korn-shell scripts, Perl scripts, SQL Server Query Analyzer, Erwin, Linux.