SUMMARY

• Over 7+ 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 usingIDQ and Powercenter workflows, Mappings, Mapplets, Exception tables, ad - hoc reporting, Data quality score cards.
• 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.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
• 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 Optimizing the Performance of SQL scripts and Oracle database/application tuning.
• Excellent in coding using SQL, SQL*Plus, PL/SQL, 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 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

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

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

ETL/Informatica Developer

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.
• 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.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager
• 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: InformaticaPowerCenter, 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.
• Configured DAC to run nightly data loads on daily basis.

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.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC).

Confidential 

Informatica developer

Responsibilities:

• Developed mappings and workflows in Informatica to extract data files in disparate file formats (XML, csv, fixed width, delimited, etc.) for automated feeds to third party vendors
• Developed a JAVA-based multi-thread program that downloads and processes data files which are then picked up by Informatica for loading into Oracle9i databases
• Responsible for analyzing, designing and coding of the applications primarily in Perl, Java and Apache
• Was part of the team that developed aFaqs e-commerce high traffic portal with features like product listings, shopping cart and news feeds
• Involved in website and portal enhancements and maintenance.

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