SUMMARY

• Data Warehouse ETL Professional with 8+ Years of experience in Analysis, Design, Development, Testing, Implementation, maintenance, and support of Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store (ODS), Data Warehouse (DW)/Data Mart (DM), ETL, OLAP, Client/Server, and Cloud applications on Windows and Unix platforms
• Working experience with clients from Financial, Life Sciences (Pharma), Insurance, Retail Industries.
• Worked extensively on Data Analysis, Data Validation, Data Cleansing, and Data migration.
• Extensive ability to perform root cause analysis, performance monitoring and application related issues.
• Extensive hands - on expertise using Informatica Power Center 6.2/8.1.1/ 8.6.1/9.1.0 , Informatica Cloud, Oracle (SQL & PL/SQL), MS SQL Server (TSQL), Teradata (BTEQ).
• Good knowledge in interacting withInformatica Data Explorer (IDE), and Data Quality (IDQ).
• Experience in using SQL, PL/SQL, Dynamic SQL, Stored procedures/functions, Triggers and Packages, Complex Joins, Correlated Sub-Queries, Aggregate functions, Analytic functions, Views, Materialized Views, Indexing, Partitioning and Performance tuning the same using explain plan.
• Experience with querying SAP BW.
• Good Knowledge on SAP BW Data Architecutre.
• Hands on experience in identifying and resolving performance bottlenecks at sources, targets, and performance tuning of SQL queries, ETL Code.
• Designed, implemented and tested complex mappings using the Informatica Power Center with the purpose of loading data into Type II slowly changing dimensional tables.
• Strong mapping development skills using heavy use of lookup, update strategy, filter, sorter, joiner, aggregator, expression, stored procedure and XML transformations.
• Strong in debugging and troubleshooting the Informatica mappings and workflows.
• Strong understanding of Ralph Kimball and Bill Inmon Data Warehousing Methodologies.
• Strong understanding of the principles of DW using Fact Tables, Dimension Tables, Star Schema, and Snowflake Schema Dimensional modeling.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Involved in writing UNIX, PERL Shell Scripts and experience in executing scripts from Informatica Power Center.
• Able to work independently and in a team with good communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g, MS SQL Server 2005/2008, DB2, Netezza 5.0xTeradata

ETL Tools: Informatica Power Center 6.2/7.1/8.1.1/ 8.6.1/9.1.0 , Informatica Data Quality (IDQ) 8.6.1/9.10, Informatica Power Exchange, Informatica Power Connect, Informatica Cloud, Informatica B2B, SQL Server Integration Service (SSIS)

Reporting/BI Tools: OBIEE 10.1.3.4.1 , Business Objects 6.2, SAS, Tableau, Cognos

DB Tools: SQL-TOAD, PL/SQL Developer, SQL-Navigator, MS SQL Server Management Studio, WinSQL, SQL*PLUS, SQL* Loader

Scheduling Tools: CA Autosys, Tidal Enterprise Scheduler 5.3.1, Tivoli’s Maestro, Crontab

Operating System: Sun Microsystems UNIX 5.9, HP UX 10.20/11i, DG-UNIX 5.4, AIX 3.0, Windows XP, Vista, Windows Server 2003

Languages: Basics in C, C++, C#, Java

PROFESSIONAL EXPERIENCE

Confidential, Chandler, AZ

Sr. Informatica Developer

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts and prepared functional and technical design documents
• Extracted/loaded data from/into diverse source/target systems like Teradata, Oracle, SQL Server, Salesforce, COBOL, XML and Flat Files.
• Created standard and reusable Informatica mappings/mapplets using Lookup, Joiner, Rank, Source Qualifier, Sorter, Aggregator, and Router transformations to extract, transform and load data mart.
• Developed complex mapping in order to implement Change Data Capture (CDC).
• Created and executed test cases/scripts and completed unit, integration and system tests successfully.
• Worked with QA team to coordinate the testing efforts of Datamart before moving to UAT and Prod.
• Created the Repository manager, users, user groups and their access profiles.
• Deployment of Informatica Objects from Dev to QA, UAT, and Production environments.
• Successfully developed Adhoc reports using Tableau.
• Data Analysis and Visualization using Tableau.
• Involved in the performance tuning of Informatica code, SQL, PL/SQL scripts, Database using standard performance tunings steps for better performance and thereby improving the load time.
• Created SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Automated ETL process flow using batch scripting.
• Supported daily nightly productions jobs on rotation basis
• Created JIL files and scheduled the tasks using Autosys.

Environment: Informatica Power Center 8.6.1/9.1.0 , Informatica Cloud, Teradata, Flat files, Oracle, DB2, SQL server 2005, SQL, PL/SQL, Tableau, Putty, Winscp, Omniture

Confidential, MO

Informatica Consultant

Responsibilities:

• Involved in gathering the Functional Requirements.
• Created dimensional model star schema using Kimball methodology.
• Involving in extracting the data from Oracle, DB2 and Flat files.
• Creating and Run Sessions using Workflow Manager and Monitoring using Workflow Monitor.
• Defined Target Load Order Plan for loading data correctly into different Target Tables.
• Defined mapping variables and parameters to capture load history, row counts and to log errors of a session run.
• Developed wrapper workflow with command tasks to control execution of workflows in loop.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Developed complex Informatica load maps and informatica error maps for Extraction, Loading and Transformation (ETL) of data as per the business requirements.
• Developed Reusable Mapplets and Reusable Transformations for standard business units to be used in multiple mappings.
• Worked withInformaticaData Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Analyzed and created indexes and hints in database to improve query performance.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in Autosys for automatic execution at the specific timings.
• Involved in System Testing, Regression Testing, Security Testing.
• Created Test Function matrix and preparation of Test Execution Report.
• Involved in preparation of reports Using Cognos 9.x.

Environment: Informatica Power Center 8.6.1, InformaticaData Quality 8.6.1 (IDQ), Cognos 9.x, Oracle 11g/ 10g, TOAD, UNIX Shell Scripting, XML, DB2, MS Excel, Flat Files, Legacy Systems, PL/SQL, Autosys, Windows XP.

Confidential, NH

Informatica Consultant

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Extracted data from sources like DB2, Oracle and Fixed width and Delimited Flat files Transformed the data according the business requirement and then Loaded into the Oracle Database
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Maintained existing mappings by resolving performance issues.
• Imported and Created Source Definitions using Source Analyzer,
• Imported and Created Target Definitions using Warehouse Designer.
• Created Mappings using Mapping Designer to load the data from various sources using different transformations like Aggregator, Expression, Stored Procedure, External Procedure, Filter, Joiner, Lookup, Router, Sequence Generator, Source Qualifier, and Update Strategy transformations.
• Created Mapping Parameters and Variables.
• Handled operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Created and Scheduled Sessions and Batch Processes based on demand using Informatica Server Manager.
• Involved in Optimizing the Performance by eliminating Target, Source, Mapping, and Session bottlenecks.
• Used pmcmd command to schedule sessions and batches.

Environment: Informatica Power Center 8.6.1, Business Objects, HP UNIX, WindowsNT, DB2, Oracle 10g, Erwin 4.0, SQL, PL/SQL, SQL * Loader, Putty

Confidential, Mclean, VA

Informatica Developer

Responsibilities:

• Involved in design, development of Pharma Sales and Marketing Data Warehouse.
• Involved in technical requirement gathering with different source teams and third party data provider teams.
• Involved in territory alignment enhancement project to align the sales data to the new territory alignment hierarchy.
• Worked on the reporting ODS enhancement project to report historical data from ODS.
• Responsible for migrating Informatica processes from 7.x to 8.x.
• Informatica ETL mapping processes to load Monthly and Weekly IMS and NDC data.
• Designed and Developed Informatica mappings, creating sessions and workflows for Data Loads.
• Tuned SQL queries and mappings for better performance. Used different techniques table partitions and parallelism in Informatica. Used explain plan, gather statistics, different types of indexing.
• Responsible for creating metadata tables and processes for automating QA processes.
• Responsible for automating IMS and NDC sales data load processes. Used extensive shells script techniques to automate the load and QA the sales data.
• Developed PL/SQL procedures, Functions using Dynamic SQL, PL/SQL tables, BULK Load features.
• Used Maestro Tivoli, Unix Cron schedulers to automate the load processes.
• Created Materialized views for aggregate tables from IMS and NDC fact tables. The aggregate tables are created for different time measures to ease the calculations at the time of reporting.
• Generated various ad-hoc reports as per the requirements.
• Developed Shell scripts for ETL automation and scheduled them in Tivoli Maestro Scheduler including the capability to dynamically create parameter files through scripts
• Responsible for creating and maintaining user documents, functional documents, technical documents and mapping design documents.
• Developed complex mappings and mapplets using transformations like Connected and Unconnected Lookup, Router, Filter, Expression, Aggregator, sorter, Joiner, sequence generator, Update Strategy.
• Created mappings to migrate data from Flat files, Oracle, MS Access to data warehouse.
• Implemented slowly changing dimensions methodology to keep track of historical data using Connected, Unconnected lookup transformations with Update Strategy transformation.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Schedule and Monitor Workflows using Workflow Manager/monitor.
• Created partitions for parallel processing of data and used Debugger to troubleshoot the mappings.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in Unit, Integration, system, and performance testing levels.
• Provide solutions for Test Problem Reports.

Environment: Informatica 8.1.1, Business Objects 5.1, Oracle 9i, Teradata, SQL Server, MS Access, ERWIN 4.1, Toad 8.0, Windows XP, Teradata SQL Assistant, WinScp.

Confidential

Programmer Analyst

Responsibilities:

• As a technical team member I involved in development of different modules and PL/SQL procedures.
• Identifying the business user requirements.
• Developed transformation logic and developed various mappings in Designer.
• Extensively used Informatica Power Center an ETL tool to extract, transform and load data from remote sources to DW and worked with various active & passive transformations.
• Developed complex Informatica mappings and tuned them for better performance.
• Extensive Use of SQL Overrides and substituted them in place of multiple transformations.
• Used transformations for data joins, complex aggregations.
• Responsible for improving query and session performance.
• Created complex mappings using Lookup, Aggregator and Router transformations for populating target table in efficient manner.
• Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Sequence generator and joiner transformations.
• Created, launched & scheduled sessions and batches using Server manager.
• Define mappings slowly changing dimensions and slowly growing Targets.
• Performed Unit testing.

Environment: Oracle 9i, PL/SQL, Informatica Power Center 8.1, Windows, SQL Plus, SQL