PROFESSIONAL SUMMARY:

• Over 8 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing and Software Applications.
• Design & implement data quality & business rules usingPowercenter workflows, Mappings, Mapplets, Exception tables, ad - hoc reporting.
• Experienced in logical and physical data modeling of staging and warehouse environments using Datamodeling tools like Erwin, Rational Rose and Oracle Designer.
• Extensively involved in ETL Data warehousing using Informatica Power Center 7.x/8.x/9 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Used best practices on Process Sequence, reference table,, Data Quality Lifecycles, Naming Convention, Version Control, Integrated IDQ rules in Power Centre mapping.
• Understanding & working knowledge of Informatica Change Data Capture (CDC)
• Implemented Real Time Change Data Capture (CDC) using Informatica Power Exchange
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Developed complex quality rule, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL
• Developed complex quality rule, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception, notification and reporting with ETL
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
• Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins.
• Experience in scheduling the batch jobs using workflow monitor, Control m and FTP methods.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing dimensions (SCD) Type1/2/3 dimension mappings.
• Experience in creating configuration files to deploy the SSIS packages across all environments
• Experience in Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, SQL*Plus, PL/bod, Procedures/Functions, Triggers and Packages.
• Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers.
• Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.

TECHNICAL SKILLS:

ETL Tools: Informatica IDQ, Power Center 9.5, 9.0.1, 8.x, 7.x (Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server, Administration Console).

RDBMS: Oracle11g / 10g / 9i, SQL Server 2000/2005/2008

Operating System: UNIX, Linux, Mac, Windows NT/2000/XP/7

Languages: SQL, SQL*PLUS, PL/SQL, XML, C, SSIS

Other Tools: MS-Office, Sigmaplot, ORIGIN, PRISM, Adobe Illustrator, Qlick View.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

ETL/InformaticaDeveloper

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• This also gave some good expertise with some of the tool migration techniques.
• Identified and tracked the slowly changing dimensions to capture the changes, in heterogeneous sources and determined the hierarchies in dimensions.
• Speeding up of work by using re-usable transformations and work-lets, for further lowering of errors and enhancing work flow performance. Developed schedules to automate the update process and Informatica Batches/Sessions.
• Generated data profile and score card and cleanse data using IDQ and loaded into landing tables from various sources.
• Extracted data from Oracle, MS SQL Server and loaded them into Oracle.
• Worked with team, that was focused on capturing mainly changes in customer plans.
• Also, generate notices to customers, where the contracts would expire in a span of less than 3 months, and give them more advantage over choosing rate plans depending on there using. This was achieved through an extensive of LOOK-UP’s and analysis of Data.
• Used the Dynamic look up to implement the CDC.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• Implemented Informatica Data Quality as a service Web Services architecture which is called by third party process /application using Informatica Data Services.
• Used Address Validator to validate US postal codes utilized match score and mail able indicator.
• Developed data Mappings between source systems and warehouse components.
• Created various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router etc.
• Organized data in order to capture the basic nature of the business environment, providing a stable view of the data associated with the core business processes.
• Monitored sessions that were scheduled, running, completed or failed
• To retrieve the data from various Tables and to test the database, wrote SQL Queries.
• Worked on Documentation to describe program development, logic, coding, testing, changes and corrections
• Participated in Enhancements meeting to distinguish between bugs and enhancements.

Environment: Informatica PowerCenter, IDQ, Windows, Oracle 10g, Flat Files, TOAD, SQL Developer, UNIX, My SQL, Mac, MS-Office.

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Analysis, involved in acquiring Requirements from Business Requirement Document (BRD), function/technical specification, development, deploying and testing by Business Analysts, UAT, TQA and Developers.
• Converted the business requirements into technical specifications for ETL process by populating the fact and dimension tables of data warehouse.
• Created and executed SQL scripts in oracle to test the data flow from OLTP systems to data warehouse.
• Designed & assisted Informatica ETL developer to create new Aggregate.
• Created Informatica mappings for initial load and daily updates.
• Developed several mappings (Source Qualifier, Lookup, Filter, Joiner, Aggregate, Sequence Generator, Expression, Lookup, Router, Normalizer, and Update Strategy) to load data from multiple sources to data warehouse.
• Created sessions, workflows and database connections using Informatica Workflow Manager.
• Worked with pre and post session SQL commands to drop and recreate the indexes on data warehouse using source qualifier transformation of Informatica Power center.
• Involved in troubleshooting the load failure cases, including database problems.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Involved in Design and Data Modeling using Star schema.
• Configured environments for full ETL and incremental data loads from OLTP to OLAP data sources using DAC and Informatica routines.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Configured new customized mappings and work flows in DAC for new customized subject area.

Environment: Informatica 7.1.4, Oracle, My SQL, UNIX, Windows XP, Mac, TOAD.

Confidential, Atlanta, GA

Informatica Developer

Responsibilities:

• Design and developed Oracle PL/SQL Scripts for Data Import/Export, Data Conversions and Data cleansing.
• Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
• Created Mapplet and used them in different Mappings.
• Provide Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mapping.
• Developed Complex mappings and workflows using Power Center designer and Workflow manager for loading data into Data warehouse from staging.
• Developed and maintained custom PL/SQL packages and procedures for analysis of source system data and also for data validation
• Extensively involved in creating design documents for loading data into Data warehouse and worked with the data modeler to change/update the Data warehouse model when needed.
• Reporting based on Slowly Changing Dimension of SCD1 and SCD2.
• Responsible for Performance Tuning at the Source & Target level, Mapping Level and Session Level.

Environment: Visual Studio, Manual, SQL Server, Windows, Unix, All the Ms-Office tools, Adobe Illustrator, Graphing tools like PRISM, SIGMAPLOT, ORIGIN.

Confidential, OHIO

Programmer analyst

Responsibilities:

• Collaborated with Business Analysts and the DBA to gather requirements, business analysis and designing of data marts.
• Analyzed the logical model of the databases and normalizing it when necessary.
• Involved in identification of the fact and dimension tables.
• Involved in design and development of Business Requirements in liaison to business users and Technical teams by gathering requirement specification documents and identifying data sources and targets.
• Translated Business processes into Informatica mappings for building Data marts by using Informatica Designer which populated the Data into the Target Star Schema on Oracle 9i Instance.
• Extensively used Router, Joiner, Lookup, Aggregator, Expression and Update Strategy Transformations.
• Extensively used ETL to load data from wide range of source such as flat files (csv, fixed length), Oracle and XML to ORACLE.
• Extensively worked in the performance tuning of the mappings, ETL Procedures and processes.
• Developed re-usable transformations, mappings and mapplets confirming to the business rules. Used Debugger to test the mappings and fix the bugs.
• Performed Unit Testing on the developed Mappings.
• Supported QA Testing and Production Testing by identifying the bugs and also helped to resolve various Data issues.
• Involved in the Migration process from Development, Test and Production Environment
• Wrote stored procedures and triggers in Oracle 9i for managing consistency and referential integrity across data mart.
• Unix shell scripts are used for scheduling to automate the load process.
• Developed Reports for the clients using business objects.

Environment: Informatica PowerCenter 6.1, Sun Solaris 8, Oracle 9i, SQL*Loader, Erwin 3.7, TOAD 7.6, Windows 2000, SQL, PL/SQL, Business Objects.