SUMMARY

• Over 8 + years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica with Oracle, SQL Server, DB2 databases.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Finance, Insurance, Banking and Pharmaceutical.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in developing Enterprise level Data warehouse (EDW), Data marts and Operational databases (ODS).
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)
• Proficient with Informatica Data Quality(IDQ)for clean - up and massaging at staging area
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 9.x/8.x.
• Experience in Informatica (MDM) Hub components such as Informatica MDM hub console.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.
• Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, flat files, XML files, DB2.
• Used Metadata Manager to extracts metadata from application, business intelligence, data integration, data modeling, and relational metadata sources.
• Expert in troubleshooting/debugging and improving performance at different stages like database,workflows,mapping
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data Warehousing ETL: Informatica Power Center 9.x (Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Worklets), Informatica Data Quality, Informatica Data Explorer, Repository Server Administrator Console

Data Modeling: Ralph Kimball Methodology, Bill Inmon Methodology, ERwin4.0

Databases: Oracle 10g/9i/8i, MS Access, MS SQL Server2005, mainframe Z/OS, DB2 LUW

Programming: UNIX Shell Scripting (Korn Shell, Bourne Shell), SQL, PL/SQL

Scheduling Tools: Informatica Scheduler, Autosys, Tidal, Control-M

OS Environment: UNIX (AIX, Solaris), Linux, Windows 2003/2000/XP/NT, Mainframe Z/OS

BI Tools: Business Objects XI, Cognos 8 BI, Crystal Reports 8.5

Tools: TOAD 7.x, Quick Test Pro, MS - Visio, HP Quality Centre, SQL*Loader

PROFESSIONAL EXPERIENCE

Confidential, Salem, NC

Sr. Informatica Developer

Responsibilities:

• Worked on all phases of this implementation, from gathering requirements to testing, implementation, and support.
• Involved in Preparing the High Level Design (HLD) and Low Level Design (LLD) documents for ETL Informatica process.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica.
• Developed several generic Informatica jobs which can be reused for several processes.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Created sessions, worklets, workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Prepare ETL specification, creating mappings, Teradata scripts for extraction, transformation and loading of data to data warehouse.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected) Joiner, Filter, Sorter, Router, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Created Sessions and partitioned using different partition types like key range partitioning.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle using Oracle Warehouse Builder.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Designed, developed and tested data conversion/data integration modules to support large scale system migrations and implementations.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used Change data capture (CDC) for data integration that is based on the identification, capture and delivery of the changes made to enterprise data sources
• Configured ODBC connectivity to various source/target databases.
• Tuned performance of Informatica session for large data files by using partitioning, increasing block size, data cache size, sequence buffer length and target based commit interval.

Environment: Informatica Power Center 8.6.1/8.1.1, WorkFlow Designer, Powercenter Designer, Repository Manager, Oracle 10g/9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Windows NT/2000/XP, Erwin7.1

Confidential, Birmingham, Al

Informatica Developer

Responsibilities:

• Interacting with end users to get business Requirements and reporting needs. Created Business Requirement Document based on the client requirement and existing application.
• Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial load and incremental load.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse.
• Designed, Developed and implemented of project from the Initial Life Phase until deployment into production.
• Informatica Power Center was used to develop ETL mappings and transformations, and to load data.
• Modified existing mappings in accordance with the Data Model.
• Developed 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.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created variables and parameters in the Mapping Designer.
• 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.
• Used Informatica Server manager to create Sessions and Workflows to run with the logic embedded in the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Involved in Documentation regarding the ETL process.
• Coordinated with offshore site in developing and deploying mappings.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Created database tables, indexes in Oracle Database by implementing various business rules using appropriate constraints and database triggers.

Environment: Informatica power center 9.x, Informatica Server Manager, Informatica Repository Manager, Workflow manager, Workflow monitor, Oracle 9i, Erwin 4.1, SQL 2005/2000, Flat Files, Windows XP.

Confidential, MN

Informatica Developer

Responsibilities:

• Converting the business requirements to design document.
• Extensively used All Fusion-ERwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Involved in creating and maintaining various database objects like SQL Joins, Synonyms, Aliases, Views, aggregate conditions, and worked on various databases and their connectivity from various parts of the source systems.
• Used Informatica Power Center for (ETL) extraction, transformation, and loading data from heterogeneous source systems into the target database.
• Provided the Production Support by running the jobs and fixing the bugs.
• Developed Mappings using Designer to extract, transform data according to the requirements and loaded into database.
• Handled slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in the data warehouse.
• Developed Mapplets, and reusable transformations to prevent redundancy of transformation usage and maintainability.
• Imported various heterogeneous source files using Source Analyzer in the Designer.
• Used all the various kinds of transformations available in Informatica designer.
• Scheduled Informatica Workflows and sessions using Autosys
• Monitoring the ETL jobs and fixing the Bugs.
• Used Stored Procedure, Views, and Functions for faster processing of bulk volume of source data.
• Involved in developing SQL Scripts for extraction and loading of data-to-data warehouse.
• Create and maintain shell scripts for pre/post session operations and various day-to-day operations.
• Generated various business reports using Cognos Power Play, Report Studio, and Query Studio.
• Implemented the Error log tables for all the dimensions.

Environment: Informatica Power Center 8.1, PL/SQL, Oracle 9i, SQL Server 2000, TOAD, UNIX, Windows 2000, AutoSys and MS-Office tools.

Confidential, New York City

Informatica Developer

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance
• Designed Informatica mappings by translating the business requirements.
• Worked on Informatica Power Center tools- Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Develop, Workflow Manger and Workflow Monitor.
• Created the Source and Target Definitions in Informatica Power Center-Designer
• Designed and developed Informatica Mapping for data load and data cleansing
• Extracted source data from VSAM files using Informatica, and loaded into DB2 targets.
• Created Stored Procedure, Functions and Triggers as per the business requirements
• Used update strategy and Lookup transformation to insert, delete, update or reject the records based on business requirements
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL tool
• Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes
• Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading
• Identified the dependencies between heterogeneous source systems and effectively administered the Job scheduling process using Ctrl-M
• Created, refined and delivered functional test materials corroborated with test cases; set up test plans, schedules and scenarios using Rational Test Manager
• Conducted Unit testing and Integration testing.
• Responsible for drafting documentation for end user usage and develop training material.
• Worked in offshore onshore model of the project.

Environment: Informatica 7.1 (Repository Manager, Repository Sever Administration Console, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Windows 2000, Erwin 4.0, PL/SQL, Windows NT 4.0, mainframe Z/OS.

Confidential

ETL Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Extensively used All Fusion-Erwin for Logical / Physical data modeling and Dimensional data modeling, and designed Star join schemas.
• Designed and developed Star Schema, Snowflake Schema and created Fact Tables and Dimension Tables for the Warehouse and Data Marts and Business Intelligence Applications using Erwin Tools.
• Used Informatica Designer to create mappings using different transformations to move data from source to a Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Router, Rank, Filter and Sequence Generator transformations.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled the sessions to Extract, Transform and Load data into warehouse database as per Business requirements. Improved the session performance by pipeline partitioning.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Worked with various kinds of input source files ranging from flat file to DB2 tables.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for Data ETL.
• Worked in offshore onshore model project.

Environment: Informatica 7.1 (Repository Manager, Repository Sever Administration Console, Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Windows 2000, Erwin 4.0, PL/SQL, Windows NT 4.0, mainframe Z/OS.