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 usingIDQ and Powercenter workflows, Mappings, Mapplets, Exception tables, ad - hoc reporting, Data quality score cards.
• Over 6 years of extensive experience on Informatica Power Center with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, Sybase, SQL Server.
• Experienced in logical and physical data modeling of staging and warehouse environments using Datamodeling tools like Erwin, Rational Rose and Oracle Designer.
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• 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

Job Scheduling Tools: Autosys 4.5

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

Modeling Tools: ER Studio, Erwin 4.1,UML

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

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, 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
• Tested data quality using IDQ
• Tested data quality metrics and targets
• 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 9.1, Windows, IDQ 9.1, 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.
• Tested reference data and data quality rules using IDQ
• Involved in cleansing the data using IDQ and closely worked with data stewards
• 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 8.6, Oracle, My SQL, IDQ 9.1, UNIX, Windows XP, Mac, TOAD.

Confidential, Atlanta, GA

ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Document or review documentation of steps in specification development, coding, testing and user acceptance for future reference and for internal control purposes.
• Developed slowly changing dimension Type 2 mappings to maintain the history of the data.
• Developing severalmappings in Informatica a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables and Parameter files in Mapping Designer.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Sources, Targets, mappings, and sessions to provide maximum efficiency.
• Develop test plan and/or test application in development status or debug application in production mode.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Created Workflows with worklets, event wait, email and command tasks using Workflow Manager and monitored them in Workflow Monitor.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.

Environment: Informatica Power center 7.1.4, 8.6., Oracle, SQL Server, Windows NT, Unix Shell Scripts.

Confidential

Software Tester

Responsibilities

• Understanding the requirements and project functionality.
• Involved in discussions with the clients and coordination with development team in sorting the functional requirements.
• Actively involved in preparation of Test Plan.
• Writing, review and executing Test cases.
• Performed Integration testing, Regression, database testing and Functional testing of important modules in the application and Mapping the client requirements with the same.
• Involved in discussions with development team.
• Analyzed the functional requirements.
• Reporting the test activity progress and testing status to the test lead.
• Participated in Review meeting and client meeting.
• All the documents are written and managed in Microsoft tools

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