SUMMARY

• 7+ years of IT experience in Analysis, Development, Implementation, Testing, and support for Data warehousing applications.
• 6+ years of extensive experience in using Informatica PowerCenter tool 9.5.1/9.0.1/8. x/7.x for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Have clear understanding of Data Warehousing concepts wif emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Extensive experience in ETL of data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow manager, Workflow Monitor).
• Experience in integration of various relational and non relational sources such as Oracle, DB2, SQL Server, Flat Files, XML files and Cobol files.
• Hands on experience in data warehousing techniques such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2 and Change Data Capture (CDC)
• Extensive worked in ETL process consisting of Informatica Data Transformation (Filter, lookup, Sorter, Normalizer, Update strategy Transformation, Router) Data Sourcing, Mapping Conversion and Loading
• Extensively used heterogeneous data sources, flat files to load data from source systems to targets using Direct and Indirect method
• Vast experience in error handling and troubleshooting in Informatica
• Experience in Performance Tuning of Source, Targets, mappings, sessions and Transformations.
• Experience in Scheduling and monitoring jobs using informatica scheduler as well as control - M
• Dimensional and OLTP Data Modeling experience using Star Schema/Snowflake modeling, Physical & logical data modeling.
• Over 7 years of experience working on Databases such as Oracle 11g/10g/9i/8i, SQL Server 2000, Microsoft SQL server-2008, Sybase, DB2 and MS Access.
• Strong experience working wif SQL, PL/SQL Stored Procedures, Triggers and Packages.
• Experience in UNIX shell scripting to support teh ETL process.
• Expérience in on-shore and off-shore support model activities.
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented.
• Excellent analytical and problem solving skills; proven ability to TEMPeffectively manage time and resources and prioritize tasks in order to consistently complete projects on time

TECHNICAL SKILLS

ETL: Informatica Power Center 9.5.1/9.0.1/8. x/7.x

Data Modeling: Star and Snowflake Modeling, FACT and Dimension tables

Database: Oracle 11g, DB2, SQL Server

Languages: SQL, PL/SQL, Unix/Linux Shell Scripting for Scheduling Informatica Jobs

Operating Systems: UNIX, Windows 2008/03/NT/XP.

Tools: Toad 9.0/8.x, WINSCP, SSH Secure Client, SQL developer

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, Ohio

Sr. ETL Developer

Responsibilities:

• Participated in requirement gathering and converted them into functional specifications.
• Interacted wif business and technical teams while finalizing teh source systems data flow process into data mart.
• Developed and Unit tested teh mappings, sessions and workflows including but not limited to Normalizer, XML parser, Aggregator, Filter, Router, Expression transformations.
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Joiner, Update Strategy, Connected and Un-connected Look ups in developing teh mappings.
• Responsible for creating business solutions for Incremental and Full loads.
• Developed complex mappings to load data into ODS followed by Dimensions and Fact Tables.
• Extensively worked wif Slowly Changing Dimensions Type1 and Type2 for Data Loads
• Tuned informatica mappings by identifying bottlenecks.
• Created required shell scripts and scheduled workflows using Control M scheduler.
• Actively involved in teh design and implementation of Physical and logical Data warehouses and Data marts.
• Used Workflow Manager for creating, validating, testing and running teh sequential and concurrent sessions.
• Used Parameter files for assigning teh Source file locations for flat files coming from different BU’s across globe.
• Deployed teh application in teh test environment and initiate teh process of User Acceptance Testing (UAT). dis includes fixing of data variances issues and fixing technical errors dat may come up during dis phase.
• Worked wif Deployment Groups to migrate teh code from development environment to other higher environments (INT, TEST and PROD)
• Created, updated and maintained ETL technical documentation.

Environment: Informatica Power Center 9.5.1 (Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 11G, AIX, Control M, PLSQL Developer, SQL, Toad.

Confidential, Parsippany, NJ

ETL Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts.
• Developed ETL mappings, transformations using Informatica PowerCenter 9.1/8.6.1.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL server.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in teh Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all teh Informatica mappings and update processes.
• Extensively worked wif teh Debugger for handling teh data errors in teh mapping designer.
• Hands on experience wif mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations.
• Created events and tasks in teh work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Extracted and Loaded data into Teradata using FastLoad and mLoad.
• Designed data mappings for loading date for teh Star Schema modeling, and FACT and Dimensions tables.
• Tested teh mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Created Pre/Post Session/SQL commands in sessions and mappings on teh target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created debugging sessions before teh session to validate teh transformations and also used existing mappings in debug mode extensively for error identification by creating break points.
• Worked closely wif business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify teh data loading process.

Environment: Informatica - PowerCenter 9.1.0/8.6.1, Power Exchange, Oracle 11g/10g, SQL Server 2008, UNIX Shell Script, Windows XP.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line
• Designed and developed teh ETL Mappings for teh source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into teh data warehouse. Source files include delimited flat files, and SQL server tables
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email and command
• Used Informatica for loading teh historical data from various tables for different departments
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Created Mapplets for implementing teh incremental logic, in identifying teh fiscal quarter of teh transaction and in calculating various requirements of business processes
• Involved in teh Unit & Integration testing of teh mappings and workflows developed for teh enhancements in teh application.
• Code migration teh Informatica jobs from Dev. to Test to Prod. Ensuring teh Unit testing, Integration Testing, Job & Environment parameters testing along teh way
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned teh MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Created Informatica mappings wif PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes

Environment: Informatica 9.0.1, Oracle, DB2, Erwin, Oracle, SQL server, Shell scripting, TOAD.

Confidential, NJ

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to teh field user and support for production environment.
• Involved in Analysis of teh current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from teh current system to teh new system.
• Used Informatica to extract data from different Source systems DB2 and Flat files tan into Oracle Target system
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into teh data warehouse.
• Involved in Development and Data Integration of teh main components using Informatica Power Center.
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.
• Actively involved in teh design and implementation of Physical and logical Data warehouses and Data marts, OLAP solutions, Multidimensional analysis.
• Developed logical models building hierarchies, attributes and facts extracting tables from warehouse
• Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Used teh command line program pmcmd to communicate wif teh Informatica Server and for monitoring teh workflow and tasks.
• Involved in performance tuning, monitoring and optimization of ETL loads.
• Involved in different team review meetings.
• Created teh mapping and Functional Specs
• Managed software releases after each stage of teh testing and defect removal. As well as resolving issues from UAT, System testing.

Environment: Informatica Power Center 8.6, Oracle 9i, Toad, Quest Central for DB2, UNIX, Windows NT, XML, Teradata, IBM DB2, MS Excel 97, Flat files, SQL, PL/SQL and UC4 Scheduling tool.

Confidential, SFO, CA

ETL Developer

Responsibilities:

• Analyzed teh data models of teh source systems to develop comprehensive mapping specifications
• Developed various mappings for extracting teh data from different source systems using Informatica Power-Center 7.1.1 - Server, Workflow Manager, Repository Manager and Designer.
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Involved in writing Unit Test cases (UTC) and Integration Test cases for Informatica development
• Written SQLs /Scripts to generate primary keys and foreign keys (Surrogate key) for different tables in staging schema
• Implemented Daily/weekly incremental load of data (Delta Capture)
• Extensively worked in teh performance tuning of teh ETL mappings and workflows
• Facet had been used for registration and enrollments of customers
• Involved in handling/Implementing Change data Capture (CDC) by using Informatica Power Exchange
• Transferred logic from mainframe, Cobol to Informatica design
• Worked wif full life-cycle, such as from requirement gathering, design, coding, testing and production
• Extensively involved in writing SQL queries (sub queries and join conditions)

Environment: Informatica Power Center 7.1.1, Oracle 10g, PL/SQL, SQL Scripting, TOAD, SQLPlus, Solaris 5, Windows 2000-Client

Confidential

System Analyst

Responsibilities:

• Responsible for SQL coding using SQL/PLUS.
• Responsible for PL/SQL programming.
• Developed Stored Procedures, functions, triggers, and packages.
• Created primary Database storage structures (Table Spaces) and objects (Tables, Views, and Indexes).
• Managed teh Table Spaces, rollback segments and indexes for applications.
• Coded teh scripts for loading teh data into Oracle Database from flat files using SQL Loader.
• Extensively used all teh features of Informatica Versions 6.x and 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.

Environment: SQL*Plus, Oracle 9i