PROFESSIONAL SUMMARY:

• Around 8 Years of Professional experience in different areas of Data warehousing, RDBMS, Data modeling, Data extraction, Data acquisition, Analysis, Application design, Development and Implementation of data warehousing, business Intelligence system using Informatica Power Center, Data Conversion and various business applications in different platforms.
• Informatica Power Center 9.6/ 9.1/8.6/8.5/8.1/7.1 Oracle 11g/10g/9i(SQL/PL SQL). Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Pharmaceutical, Finance and Insurance industries.
• Experience in Dimension Data Modeling concepts like Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
• Worked in Data Conversion of various data sources like Oracle, MS SQL Server, Oracle Apps, MS Access, Fixed Width and Delimited Flat Files, COBOL files and XML Files.
• Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Strong Experience on Workflow Manager Tools – Task Developer, Workflows & Worklet Designer and Managing, Scheduling, and Monitoring of Informatica workflows.
• Worked on all the transformations like Connected and Unconnected - RemoteLookup, Aggregator, Expression, Filter, Router, Update Strategy, Connected and Remote Stored Procedure and SequenceGenerator, Sorter.
• Knowledge of Advanced Programming for data transformation (JAVA) Created ETL mappings using Informatica Power center to move Data from multiple sources like Flat files, Oracle, DB2 into a common target area such as Data Marts and Data Warehouse.
• Extensive knowledge with Teradata SQL Assistant.
• Developed Teradata BTEQ scripts to Load data from Teradata Staging area to Data Warehouse, Data Warehouse to data marts for specific reporting requirements.
• Experience in PL/SQL Programming (Stored procedures, Triggers, Packages) using Oracle (SQL, PL/SQL), SQL Server and UNIX shell scripting to perform job scheduling.
• Good communication and interpersonal skills and Strong understanding of ETL best practices.
• Assigning work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6/9.5/9.1/8.6/8.5/8.1 ( Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server)Power Exchange,Talend.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/7.0/6.5 , Sybase, Teradata, MS Access 7.0/2000, Netezza, SQL Server (DTS/SSIS/SSRS),

Data Modeling tools: ERWIN 4.x and Concepts like Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Development Tools: SQL *PLUS, TOAD, SQL Navigator.

Programming Languages: Unix Shell Scripting and Perl Scripting, Batch Scripting, VB.NET 05/08, XML, HTML, C, C++, UML (Rational Rose), Java, Oracle PL/SQL OBIEE,(Stored Procedures, triggers, Indexes).

Packages: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint

Scheduling Tools: AUTOSYS, Tivoli, Control-M,TIDAL.

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS, IBM S/3,MVS/ESA

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA
ETL Developer/Production support

Responsibilities:

• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time. Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Monitor system integrity through daily system checks, to ensure a high standard of service is provided to clients.
• Remain calm under pressure and ensure IT management and business stakeholders are kept fully updated on progress of critical issues.
• Escalate issues and remediation steps effectively and in a timely manner.
• Perform troubleshooting analysis and resolution of critical applications and batch processes.
• Coordinate with vendors to troubleshoot and resolve issues.
• Support the Client Reporting Production Environment as a first priority.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions..
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Create change management strategy .Identify, analyze, prepare risk mitigation tactics Identifying and manage anticipated resistance
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Participated in the full development life cycle within the reporting framework, from developing business intelligence requirements to QA and production deployment
• Written SQL Scripts and PL/SQL Scripts to extract data from Databases Power Exchange Change Data Capture has been done for data updates.
• Worked on Informatica Data Quality to resolve customers address related issues. Worked on Informatica On Demand to mainly import data from Sales Force.
• Developed data models according to company standards. Used DB2 Connect to extract multiple database source systems to single analytical system for large databases and also 24*7 Production support for data warehousing

Environment: Informatica Power Center 9.6, Power Exchange, Seibel OBIEE, DB2 Exchange, Oracle 11g, Control-M, Obiee, SalesForce, PL/SQL, UNIX.

Confidential, New York City, NY
Informatica ETL Developer

Responsibilities:

• Involved in design, development and implementation of ETL process in power center. Responsible for managing, scheduling and monitoring the workflow sessions
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area which is the source for stage loading.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements
• Used Data Profiling to Minimize the risk of data quality problems proliferating throughout the organization
• Worked Extensively on Siebel Answers to create reports as per the client requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Implemented ETL process to load data into target Oracle tables.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query performance.
• Responsible for Error handling, bug fixing, Session monitoring, log analysis Implemented various Data Transformations using Slowly Changing Dimensions
• Worked on Power Mart client tools viz. Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developers
• Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications..
• Performed optimization of SQL queries in SQL Server.
• Constructed PL/SQL by using cursors, triggers and procedures to bring data into database based on the design Generate scripts for Data Migration and Data Validations as specified in the technical design
• Installation and Configuration of ETL tool Informatica for creating Data ware housing Analyzed OLAP cubes data to compare actual results to budget results, to assess performance in Analysis studio.
• Collaborate with and mentor current development staff in the use of Business Intelligence (OBIEE), Informatica, and Oracle coding language based on numerous prior development activities in these environments
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.

Environment: Informatica Power Center 9.1.6, Power Exchange, Seibel OBIEE, DB2 Exchange, Oracle 11g, Tivoli, Unix.

Confidential, Dayton, OHIO
Informatica ETL Developer/Support

Responsibilities:

• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Participated in the Integration testing and Unit Testing along with the Development team.
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Provided production support to various manuals and deployment.
• Monitored functional requirements and mapped all documents.
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Preparing the documents for test data loading.

Environment: Informatica Power Center 9.5 .0.Power Exchange, Seibel Obiee, DB2 Exchange, Oracle 11g, DB2, XML, TSQL,SQL Server, UNIX (AIX), UNIX Shell.

Confidential, Caramel, INDIANA
Informatica ETL Developer

Project Description:

MDM (Master Data Management) has the objective of providing processes for collecting, aggregating, matching, consolidating, and quality-assuring, persisting and distributing such data throughout an organization to ensure consistency and control in the ongoing maintenance and application use of this information.

Responsibilities:

• Participated in design sessions where decisions are made involving the transformation from source to target.
• Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (pl and sql), packages, triggers,
• Managed and compile documentation for all ETL processes.
• Created detailed process flow designs and drafts high-level Standard Operation Procedures.
• Performed Informatica Administration tasks.
• Performed tuning for PL and SQL procedures, Views, and Informatica objects.
• Designed and implements the error handling strategy for ETL team.
• Monitored data warehouse month-end loads to ensure successful completion
• Mappings, Mapplets and Sessions for data loads And data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center
• Gather and analyze business requirements.
• Design logical and physical data models and data processing i Confidential .
• Provide production database support, enhance existing system and design and develop new systems.
• Monitor the usage of database space and performance.
• Performance optimization of the database and applications.
• Involved in ETL process from development to testing and production environments.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.

Environment: Informatica Power Center 9.1Power Exchange, Erwin, Business Objects 6.5,Cogons, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell, SalesForce.

Confidential, Dublin, OHIO
ETL Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Generated Adhoc reports Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Involving in extracting the data from Oracle and Flat files Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects. .
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Tuning of the mappings and SQL Scripts for a better performance.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• Analyzed the various bottlenecks at source, target, mapping and session level.

Environment: Informatica Power Center 9.2 Power Exchange, Erwin, Business Objects 6.5,Cogons, Tivoli, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, UNIX (AIX), UNIX Shell.

Confidential, New York City, NY
ETL Informatica Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users. Informatica Power Center 8.5 is used to extract, transform and load data from different Operational data sources like Oracle as an ODS, DB2 and flat file.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse Target schema design (star schema) and maintenance.
• Experience working on performance tuning and optimization of Teradata queries.
• Involved in Data Migration between Teradata, MS SQL server, DB2 and Oracle Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development using Teradata and Oracle Used mapping Parameters and Variables to pass the values between sessions.
• Developed mappings with Transformations Mapplets confirming to the business rules.
• Worked on Database Triggers, Stored Procedures, Functions and Database Constraints. Performing Unit, Integration and Regression testing and preparing Test Cases for the same. Coordinating work offshore team.

Environment: Informatica Power Center8.5v (Repository Manager, Designer Tools like Source Designer, Warehouse Designer, Mapping and Mapplet Designer, Workflow Manager, Workflow Monitor) Power exchange, DB2 8.0, Oracle 10g, UNIX Shell Scripting, Autosys, Java, and Java scripts, Obiee.

Confidential
ETL Informatica Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering and project coordination. Design and Development of ETL routines using Informatica Power Center 8.1.
• Within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Maplets, connected and unconnected stored procedures / functions, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers was extensively done.
• Design and Development of data validation and load processes (using PL/SQL, SQL) and pre-session, post-session routines and batch execution routines using UNIX Shell Scripts. Implemented slowly changing dimensions.
• Logical and Physical Data Modeling (relational and multi-dimensional) using ERWIN and used Power Plug to forward engineer to Informatica Repository Performance Monitoring and tuning of SQL using Explain Plans and Oracle Hints and tuning of Informatica mappings using SQL overrides and source filters and managing cache file allocations and sizes. Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle. Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Developed and tested all the informatica Data mappings, sessions and workflows - involving several Tasks.
• Generated Adhoc reports using Query studio in Cogon’s. Strong Experience writing SQL Queries, PL/SQL Procedures in Oracle Database, DB2 UDB. Implementation of stored procedures and packages utilizing PL/SQL for the enhancements of the existing application level data warehouse.

Environment: Informatica Power Center 8.1, Oracle 10g, Cognos, UNIX (HP-UX 11.x), Sun Solaris (2.6), Windows 2K, UNIX Shell Scripts, PL/SQL, DB2 Connect, TOAD.