PROFESSIONAL SUMMARY:

• Over Seven (7) years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Pharmaceutical, Financial and Manufacturing Sectors.
• Experience working inAgile - Scrum and Waterfall environment.
• Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications, Business Objects.
• Testing ETL experience using Informatica 9.6.1/8.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Hands on experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Worked on various types of transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregator, Rank, Router, Normalizer, Sorter, External Procedure, Sequence, Generator, and Source qualifier.
• Experience in monitoring the environments and suggesting improvements for stability and performance tuning using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Expertise in working with relational databases such as Oracle 11g/10g, SQL Server 2008/2005, DB2, Teradata, MS Access.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Experience in using Automation Scheduling tools like Autosys.
• Worked extensively with slowly changing dimensions.
• Hands on experience in designing and developing Complex Mappings to extract data from diverse sources including RDBMS Tables, Flat Files and Legacy System Files.
• Experience in both integration and reporting areas of Data Warehouse using Informatica, Cognos, Business Objects and Oracle.
• Day-to-day responsibilities include reviewing system documentation, identifying development objectives, developing/updating change requests, fixes, defects, and executing functional and regression Informatica batch testing.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Creating Checklists for Coding, Testing and Release for a smooth, better & error free project flow.
• Expertise in the QA process of ETL mappings like Unit, Functional and Integration testing.
• Strong trouble-shooting, problem solving, analytical and design skills.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Power Exchange, SQL Server SSIS

Languages: SQL, PL/SQL, T-SQL, C, HTML, Java Script,.NET, XML, Java

Operating Systems: UNIX, Windows XP/2007.

Tools: PL/SQL, SQL, Toad 8.x/9.x/10.x

Databases: Oracle 11g/10g, SQL Server, DB2, Teradata, Netezza

BI Tool: IBM Infosphere, Cognos, Tableau, Business Objects

Data Modeling: Erwin, Visio

Job Scheduling: Autosys

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati OH

Sr. ETL/Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Created mapping documents to outline data flow from sources to targets.
• Used Informatica Power Center 9.6.1 to developed ETL mappings and transformations.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Monitoring and improving performance of daily jobs on Oracle database.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Experience in managing off shore team.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica 9.x, Oracle 11g, UNIX, PL/SQL, SQL, Oracle 11g, ERStudio Data Architect, TOAD 10.1.1, Autosys, Putty, Erwin 8.0, IBM Infosphere, Agile-Scrum, Business Objects XI.

Confidential, New Brunswick, NJ

Informatica Developer

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 9.1
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Experienced in designing and developing Informatica IDQ environment.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. dis led to better session performance.
• Scheduled workflow daily basis for incremental data loading.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Used Autosys scheduler to schedule and run the Informatica workflows on a daily/weekly/monthly basis.
• Provided Production Support at the end of every release.

Environment: Informatica Power Center Designer 9.1, Oracle 10g/9i, SQL Server2000/2008, UNIX, ERWIN 3.5, Toad, SQL, PL/SQL, Visio, Autosys.

Confidential, Columbus OH

Informatica Developer

Responsibilities:

• Analysed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Centre 8.6 Designer client tools like Source Analyser, Target Designer,
• Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Involved in providing 24/7 production support to solve critical issues.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Created Data Validation document, Unit Test Case Document, Technical Design Document.
• Informatica Migration Request Document and Knowledge Transfer Document.
• Responsible for developing data ingestion routines, creating standards and reusable code and performing Informatica Data Transformation (B2B) development
• Converting unstructured data into target database with B2B tool of Informatica.

Environment: Informatica Power center 8.6, Informatica Exchange, Oracle 9i, UNIX, PL/SQL, Windows 2000/XP, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Used Informatica Power Centre 8.6 for migrating data from various OLTP databases and other applications to the Radar Store Data Mart.
• Created complex Informatica mappings with extensive use of Aggregator, Union, Filter, Router, Normalizer, Joiner and Sequence generator transformations.
• Created and used parameter files to perform different load processes using the same logic.
• Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Used different Tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control) in the creation of workflows.
• Performed performance tuning of source level, target level, mappings and session.
• Coordinated with testing team to make testing team understandbusiness and transformation rules being used throughout ETL process.
• Worked on Workflow Manager, Workflow Monitor and Worklet Designer to create edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Loaded data from various sources like DB2, SQL Server, Flat files into Oracle data warehouse
• Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc
• Designed and developed initial and incremental data loads using Informatica

Environment: Informatica Power Center 8.3, Oracle 10g, SQL, PL/SQL, TOAD.