SUMMARY:

• Eight Plus (8+) Years of Total IT experience in the designing, developing and maintaining large business applications such as data migration, integration, conversion, data warehouse and Testing
• Extensive Experience in Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of Data warehousing and Database business systems.
• ETL: Seven Plus (7+) Years of Data warehousing ETL experience implementing Data Warehousing Applications including Analysis, Architecture, Design, Development, Support using Informatica PowerCenter / PowerMart 9.61/9.5/9.1/8.6/8.1/7.0 , (Source Analyzer, Repository Manager, Server manager, Mapping/Mapplet/Transformations/Warehouse Designers, Workflow Manager, Work flow Monitor, Data Analyzer, Metadata Manager) Informatica Power Analyzer, Power Exchange, Super Glue, Informatica Power Connect, Informatica Power Plug, ETL, Datamart, OLAP, OLTP, CA Autosys, BMC Control M, IBM Maestro.Used IDQ(Informatica Data Quality)for data quality and cleansing. Data Cleansing experience with First Logic (Ace, DataRight, Merge/Purge), Trillium 7.0 (Converter, Poster, Geo - Coder, Matcher), JAVA, UNIX, Tidal, WEBLOGIC. Has full knowledge on the web based Administrator console and worked briefly.
• Expertise in data warehousing, ETL architecture, Data Profiling using Informatica PowerCenter 9.61/9.5/9.1/8.6/8.1/7.0 - Client, Server tools and power exchange
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Mart/ Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, ERP Source Qualifiers, Aggregators, Filters, Joiners
• Developed effectively different types of SCD’s that are based on the specifications.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata, Flat files, DB2 Mainframes, PI Server into the staging area
• Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
• Experience in functions, cursors, triggers, views, materialized views.
• Expert in implementing business rules by creating re-usable transformations, Mapplets mappings.
• Experience in creating workflows, reusable, non-reusable tasks and Worklets.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions.
• Proficient in using pmcmd and pmrep commands.
• Experienced in working with the tools like DBArtisian, RapidSQL, TOAD, SQL Server Management studio and SQL plus for development and customization.
• Extensive Data Warehouse experience using Informatica PowerCenter for designing and developing transformations, mappings, sessions and for scheduling and configuring workflows.
• Data Modeling: Five Plus (5+) years of Data Modeling experience using Erwin, Power Designer, Visio, Oracle Designer. In-depth experience in Star / Snow Flake Schema, Conceptual, Logical and Physical Modeling.
• Business Intelligence: Four Plus (4+) Years of Business Intelligence experience using OBIEE, Business Objects XI/ 6.5/6.0/5.1/5.0 , OBIEE 10g, Cognos Series 7.0/6.0, SSRS and SSAS, QlinkView 9.0/8.0/7.0.
• Database: Six Plus (6+) years of extensive Database experience using Oracle 11g/10g/9i/8i/, MS SQL Server 2008/2000/7.0/6.5 , Teradata V2R6/V2R5, DB 2 8.0/7.0/6.0 , MS Access7.0/2000, SQL, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000. Worked in CIS, MDM, AMI datawerehouses. Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages.
• Worked with PL/SQL packages, IBM SQL Procedural Language and loading data into Data Warehouse/Data Marts using Informatica, DB2 Load, Import Utilities, SQL*Loader. Worked with Teradata Procedures.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center / PowerMart 9.0/8.6/8.1/7.1. x/ 7.0/6.2/5.1/4.7 , (Source Analyzer, Repository Manager, Administration console,Informatica Data Quality, Mapping/Mapplet/Transformations/Warehouse Designers, Workflow Manager, Work flow Monitor, Data Analyzer, Metadata Manager) Informatica Power Analyzer, Power Exchange, ETL, ETI, Data mart, OLAP, OLTP, CA Autosys, BMC Control M, Tidal, IBM Maestro. Data Cleansing experience with First Logic (Ace, DataRight, Merge/Purge), Trillium 7.0 (Converter, Poster, Geo-Coder, Matcher), UNIX, Tidal, Siebel

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 7.2/4.5/4.0/3.5 , Oracle Designer, and Sybase Power Designer.

BI Tools: OBIEE 10g (Administration tool, Answers, Interactive Dashboards, Delivers, Interactive reporting) Business Objects XI/ 6.5/6.0/5.1/5.0 (Designer 5.0, and Developer Suite Business Objects SDK, WebI SDK), Cognos Series 7.0/6.0, SSRS and SSAS reports.

Tools: Developer 2000, Data Reports, SQL*Loader, Toad, MS Access Reports, Visual Basic6.0/5.0, SQL Navigator, DBArtisian, RapidSQL, WEB Services SOAP and REST.

Databases: Oracle 10g/9i/8i, IBM DB2 UDB 8.0/7.0, MS SQL Server 2005/2000/7.0/6.0 , Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access.

Programming: SQL, PL/SQL, SQL Plus, C, C++, Unix Shell Scripting,, HTML, DHTML, XML

Environment: Sun Solaris 2.6/2.7/2.8, IBM AIX 4.2/4.3, MS DOS 6.22, Win 95/98/NT/2000

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Informatica Developer / Consultant

Responsibilities:

• Responsible for the Informatica Upgrade from 9.5 to 9.61 for FINANCE IT.
• Worked Alone on the folder reorg and upgrade to 9.61 and validation of each environment was done.
• In charge of the teams upgrade and solved the compatibility issues .
• The individual workflows were validated and tested and passed to regression testing.
• Cleaned the folder repository for unused workflows and out of date projects.
• Responsible for Documentation and Delivery of the project as per time line.
• Involved in design phases of Opex project, for almost 4 quarters.
• Designed and Developed for complex Restatements of OPEX along with EDW.
• Developing number of Complex Informatica Mappings and workflow for OPEX and OPEX clarity in PnL Cube and Expense BO.
• Designed and Developed the Security of the PnL cube as the data is very sensitive and also set up security on two important hierarchies.
• Performance tuning on Informactica and its SQL’s.
• Created few Opex clarity tables and procedure in Oracle Common layer and also the performance tuning.
• Involved in design, development, testing phase of service line items project.
• This project is a complex project with data from 2 different data source where they do not reconcile with each other.
• We did a POC on a secure environment and try to reconcile the data using various factors and the skew was unavoidable. We did find an approach to minimize the deltas and reconcile at total level.
• Presented a various data reconciliation sheets and was a key part in deciding the final approach.
• Designed and developed the workflows and the SQL in Informatica.
• Worked closely with EDW Team to get the right data sets for the analysis.
• Designed and developed the merge scenarios. Also developed the SQL for the Essbase Cube to use Semaphore concept to less the downtime of the cubes.
• Create the Dollar U jobs to schedule Services ETL jobs
• Worked on the project to optimize the cube downtime and all the Finance IT jobs were re structured.
• Effectively increased the performance and reduced downtime using effective algorithm.
• Designed, developed, performance tuned on CE entities project.
• Designed, developed, performance tuned on indirect adjustments project.
• Optimized the Fast Export workflows for better performance.
• For the all specified project the ETL and dollar U migration to Dev, stage and production were done through internal cisco applications such as KINTANA, Artifact, and PVCS.
• Supported testing in all the above project and bug finding and fixes.
• Written a lot of KSH and SQL in Unix using SSH techia for Informatica and Hyperion Essbase jobs.

Environment: Informatica Power Center 9.61 and 9.5, (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Teradata SQL assistant 13.0, TOAD version 12.6 /10.5, Oracle 11g/11, Teradata14.0,DB2 8.0, IBM DB2, Hyperion Essbase ver3.3 SSH Techia terminal 6.1, Dollar U application, Kintana application, Artifact and PVCS object revision software. Reflection X ver 14.0, Notepad++ and Compare IT.

Confidential, Phoenix, AZ

Sr. Informatica Developer / Consultant

Responsibilities:

• Designed and Developed Logical and Physical Data Model for the HR Data Project.
• Worked Alone on the Design, Development and unit testing of the mapping and sessions.
• Developed some Complex SQL Queries to achieve the requirement.
• A Security table was there to determine the applications access and columns/data and interactively deliver only the necessary data.
• In phase 2 modified the mapping and session to deliver data based on Active and Full History of employees.
• Responsible for the Migration, Documentation and Delivery of the project.
• Loaded the targets using Concurrent Workflow Executions.
• Involved in design phases of Solar Dashboard project, used MDM and CIS data.
• Diagnosed various data quality issues to analyze data cleansing requirements, like null and spaces.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for solar meter ID.
• Created a lot of mapping including Expression mapping using MD5 concept, Lookup, SQL Joiner, Update Strategy and other mapping.
• Created a lot of Parallel Pipelining mapping implementation to achieve different results.
• Learned and integrated PI servers with informatica and get data from it.
• Used PI server information Design and develop Tracker fault information based on tags.
• Involved in designed and testing phase of billing exception project Used MDM and AMI data.
• Responsible for building history and testing historical data for billing exception.
• Re designed certain concept and mapping based on the results of the test data.
• Achieved certain result sand loads under tight schedules and delivered results on time.
• Performed various performance tuning tasks for tables with records having 2 million or more. (this included, updating statistics, preparing indexes, controlling bulk load option)
• Designed, Converted and tested a lot of Sagent SQL mappings to Informatica mapping.
• Part of the EDW (Energy Delivery Warehouse) support and Re-design team, mostly had to work on the unreliable CIS(Customer Information Services) data.
• Built a ETL workflow to invoke data from WEB Services (SOAP and REST ) techniques.
• Used Informatica IDQ to stream line Data Abnormalities and reduce Data Errors.
• SAP integration with informatica on a smaller scale project for solar sites.
• Part of Informatica Support team and worked on critical incidents and issues on weekly rotation basis.
• Currently Working on a small M&T(Marketing and Trading) project.

Environment: Informatica Power Center 9.1, (Designer, Repository Manager, Workflow Manager, Workflow Monitor), DBArtisian, RapidSQL7.7.6,TOAD, Oracle 11.2,11.111g/10g, DB2 8.0, SQL Server 2008/2005, PI OLEDB snap in, QMF, Sagent. Datawerhouse: MDM, CIS, AMI etc.

Confidential, Ann Arbor, MI

Sr. Informatica Developer

Responsibilities:

• Developed Logical and Physical Data Model using Erwin, followed Star Schema to build the Datamart.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator, Union, Lookup and Procedure. Knowledge in use of SQL and Java Transformations
• Developed (SCD 1) and (SCD 2) to capture new changes while maintaining the historic information.
• Used Update Strategy DD INSERT, DD UPDATE, DD DELETE and DD REJECT to insert, update, delete and reject items based on the requirement.
• Used different transformations for Extraction/Transformation, data cleansing and loading data into staging areas and Presentation Tables.
• Worked with workflow Manager and workflow monitor to schedule batches and run the workflow and monitor session logs.
• Effectively tuned the performance of Informatica Transformations, mappings, sessions and workflows.
• Used various partitioning schemes in order to improve the overall session performances.
• Worked on the performance tuning of databases (dropping & re-building indexes, partitioning on tables)
• Involved in developing Unix shell and Perl scripts to invoke the workflows and Informatica batches including the pre and post analysis.
• Integrated the big data from cloud and other source effectively to analyze all the data available.
• Acquired Big interaction data from various networking sites to store various data relating to the trends.
• Big transaction data along with big information data gives a whole new scope of data to work on with, and helps in providing discrete analysis and data to generate results.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Developed slowly changing dimensions mapping to accommodate the passive mode phase.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly Loading of Data.
• Extensively designed Data mapping using filters, Expression, Update Strategy Transformations in Power Center Designer.
• Created target load order group mappings and scheduled them for Daily Loads.
• Preparation of Unit Test Plans and verification of functional specifications and review of deliverables.
• Migrated Mappings, Sessions, Workflows and Common Objects from Development to Test and to Production.
• Wrote Unix Scripts and SQL Commands to test and analyze the data
• Extracted Data from Siebel tables residing on SQL Server.
• Extensively used UNIX commands within Informatica for Pre Session and Post Session Data Loading Process.
• Used Maestro and Informatica scheduler for scheduling the jobs.
• Developed QA/QC processes using shell scripts to help identify data quality issues prior to production load and provide pre-processed data source
• Used IDQ to steam line the data coming from different social media networks.
• Extensive use of Informatica metadata manager for data lineage and where-used analysis, metadata browsing, metadata reporting & metadata document.
• Performed various testing processes unit testing, end to end test, and regression testing
• Generated ad-hoc reports for the end users, as was involved in administering the reports using Obiee 10g.
• Prepared Prod stage, Production install turnover documents describing program development, logic, testing, changes & corrections.
• Used web services to invoke data few other viable services industries for analysis purposes.
• Performed Informatica SAP application integration for the organization.
• Extensively worked with production support and end user team in migrating, promoting and data validation in production servers and Assisted in handling production support issues.
• Worked extensively with HL7 Data, EDI X12 Messages, HIPAA Transactions and ICD Codes.

Environment: Informatica Power Center 9.0/8.6, (Designer, Repository Manager, Workflow Manager, Workflow Monitor, Big data), HL7 3.x/2.4, HIPAA, Epic Systems, Oracle 11g/10g, AS400, DB2 8.0, SQL Server 2008/2005 (Enterprise Manager, Query Analyzer), Maestro, Reflection FTP, OBIEE 10g, QlikView 8.5, T-SQL, UNIX - AIX VERSION 5, Visio 2003, Erwin, UNIX, Maestro, Siebel.

Confidential, Detroit, MI

Sr. Etl Informatica Developer

Responsibilities:

• Coordinated with business analyst in preparing data mapping sheets and conversion documents
• Diagnosed various data quality issues to analyze data cleansing requirements
• Overlooked and approved all error handling architectures (Staging, Pre-staging & EIM)
• Directly responsible for creating and maintaining data architecture for optimal performance of the data warehouse
• Key resource for collaborative planning with senior business leaders and development staff to create common definitions
• ETL migration specialist with a team of five (ETL/EIM) developers
• Created technical artifacts including Current State Architecture documentation, Future State Architecture design, and migration strategies
• Used IDQ to covert data anomalies in the inconsistent transactions systems.
• Worked closely with Database Administrators to migrate complex large scale applications into system test and production environments.
• Created job flow documentations based on parent and child table relationship to ensure referential integrity while loading fact tables.
• De-normalized various attributes based on dimensional segments, Group policy and benefit package plans
• Used Informatica debugger to analyze various data issues reported by the business intelligence team.
• Implemented various stored procedures, triggers and controls for error handling and data exceptions.
• Implemented bitmap indexing for various fact tables based on frequency of data update and inserts.
• Converted complex business requirements into transformation language and functions.
• Scheduled various workflow sessions based on daily/ weekly /monthly refreshes.
• Incorporated audits within the staging area to avoid duplicate rows while maintaining historical data.
• Edited legacy mappings with s to new enhancement and prepared unit test/ system test scripts
• Developed scripts to send flat files via ftp for file archiving
• Tested, migrated and deployed Informatica Mappings from Development/QA to Production
• Performed post production debugging and workflow monitoring
• Tuned legacy SQL queries and Informatica mappings for better performances with adherence to new requirements.
• Incorporated all common transformations including Sorter, Filter, Router, Source Qualifier, Look-ups, Update strategy, sequence generator, expressions & Stored procedures.
• Designed and developed various data change capture mappings and workflows for non sun-setting systems (Delta).
• Worked with multiple flat files of the same structure and enabled indirect file loading (Workflow Manager)
• Incorporated parameter files and variables to keep track of load runs and date profiling
• Implemented complex mappings that helped in automation of data manufacturing (Creating multiple rows from one source row)
• Designed various mappings and sessions to coordinate relational, technical and business errors.
• Implemented complex queries that included cross joins, inner joins, outer joins & Unions
• Made changes to existing override queries, lookup overrides & session parameters
• Worked with sharable folders for re-usable source definitions, targets, lookups, sequence generator & date expressions
• Generated ad-hoc reports for the end users and other standard reports using SSRS and SSAS reports.
• Performed various performance tuning tasks for tables with records having 2 million or more. (this included adding hints to queries, gathering statistics, preparing indexes, controlling bulk load option)
• Help implement all relational design, mappings and load process for custom entities like sub-ledger and purchase order.
• Prepared multiple batch job and Unix scripts for file retrieval, file merging, file formatting, file delimitation and task scheduling

Environment: Informatica 9.0/8.6/8.1/7.2 , Windows Server 2003 R2, Unix HP-UX 11i v3, Oracle 10g, Microsoft SQL Server 2008 R2, SSRS and SSAS, Oracle developer, OBIEE 10g, Toad, CA Workload Automation AE r11.3.

Confidential, PA

Informatica Developer

Responsibilities:

• Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Created different transformations for loading the data into target database using e. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created sessions to move data at specific intervals & on demand using Workflow Manager.
• Created session tasks, worklets and workflows to execute the mappings.
• Worked on issues with migration from development to testing.
• Created FTP scripts to extract the source files from different machines.
• Scheduled the workflows and FTP scripts to load the data warehouse as per the required frequency
• Worked on Unit testing, integration testing of ETL mappings.
• Developed scripts to perform both unit as well as system integration testing.
• Involved in Production support.
• Populating fact and dimension tables with power center slowly changing dimension wizard model, maintain history of the dimension tables.
• Using versioning capabilities of Informatica performed check in check out of objects.
• Used Informatica debugger to validate mappings and to gain troubleshooting information about data and error conditions.
• Was involved in the testing phase of the project.

Environment: Informatica PowerCenter 8.1/7.1.3(Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager, Workflow Monitor, Worklet Designer),Informatica Data Analyzer, PL/SQL, Oracle 10g, Shell Programming, Toad, Excel, Unix scripting, Sun Solaris, Flat files, IMS RX Data,MicroStrategy, Cognos, CA Erwin, QA Testing.

Confidential, Newark, NJ

ETL Informatica Developer

Responsibilities:

• Requirements gathering and business analysis by attending business meetings
• Assisted in Logical and physical modeling, followed Star schema to build Claims Datamart
• Maintained warehouse metadata, naming standards, and warehouse standards for future application development
• Created ER (Entity Relationship) diagrams and maintained corresponding documentation for corporate data dictionary with all attributes, table names, and constraints
• Extensively used Erwin for Dimensional data modeling
• Designed Source to Target mappings from primarily Flat files to Oracle database using Informatica
• Created Project and corresponding Source and Target modules in Informatica
• Developed complex mappings in Informatica using different transformations such as Expressions, Aggregators, Filters, Lookup, and Stored Procedure to ensure movement of data between various applications
• Documented development and execution of Data Mappings/Mapplets, and Informatica sessions as per the business requirement
• Tuned Informatica Mappings and Sessions for optimum performance
• Migration of all Informatica Powercenter mappings to Oracle Warehouse Builder 9i and deployed successfully
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Developed Complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations. Used debugger to test the mapping and fixed the bugs.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Identifying and tracking the slowly changing dimensions, heterogeneous Sources and determining the hierarchies in dimensions.
• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developing number of Complex Informatica Mappings, Mapplets and Reusable Transformations for weekly Loading of Data. Used Autosys for scheduling.
• Used SSRS and Cognos for reporting
• Extensively used Toad for creating Source and Target table structures

Environment: Informatica PowerCenter 8.1/7.1, MS SQL Server, Oracle 9i/8i, Erwin 4.2/4.0, PL/SQL, SQL Loader, Toad 8.5, Oracle Discoverer, Oracle Developer, Cognos 7.0, SSRS, Autosys, Windows NT 4.0, Sun Solaris

Confidential, Emeryville, CA

Etl Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Analyzed both the source systems - Legacy and new commerce platform to map the data into data warehouse accordingly.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Used shell scripts for automating the execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica Power Center 8.x, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, BO XI, PL/SQL, Oracle 10g/9i, Sybase, Sybase IQ, SQL Server 2005/2000, SQL server BI services, HP-UX 10.20, Windows Server 2003, Toad.

Confidential

ETL and Db. Programmer

Responsibilities:

• The Project is a Hotel Intranet system which provides functionalities like, providing info, booking seats in Restaurants, Party/Function halls, interacting with different departments in the hotel like travel desk to book tickets, Laundry, Kitchen and providing internet facilities like E-Mail, chatting, browsing etc.
• Part of the team to develop and test the server side application.
• Interact with the GUI team and design/develop the pages accordingly.
• Design/develop the database related tables.
• Implement the server side functionality for all the transactions.
• To test the overall application and resolve the bugs.
• Performed data analysis of the source data coming from point of sales systems (POS) and legacy systems.
• Developed approach paper for the project after gathering the requirements from business users.
• Developed mappings using Informatica 7.1 designer to extract data from the source databases and flat files into oracle staging area.
• Developed transformation logic to cleanse the source data of inconsistencies during the source to stage loading.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules
• Developed scripts to perform both unit as well as system integration testing.
• Involved in the migration of the project from development to production.
• Involved in monitoring the workflows and in optimizing the load times.

Environment: Informatica PowerCenter 7.1, Oracle 9i PHP, HTML, JavaScript, Red Hat Linux, MySQL, BO 5.0.