SUMMARY

• Around 8 years of work experience in IT Industry in Analysis, Development and Maintenance of various software applications in Data warehouse environment.
• Strong experience in providing Business Intelligence solutions using Informatica Power Center 9.x/8.x/7.x/6.x/5.x.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inmon) - Star Schema, Snowflake, SCD, Surrogate keys.
• Experience in integration of various data sources with Multiple Relational Databases like Teradata, Oracle, SQL Server, and XML files, Main Frames, IBM DB2, SAP R/3, SAPBW and Worked on integrating data from flat files like fixed width and delimited.
• Strong experience in activities related to the development, implementation, administration and support of ETL processes for large-scale data warehouses using Power Center and Power Exchange.
• Excellent knowledge of Informatica Administration. Involved in grid management, creation and up gradation of repository contents, creation of folders and users and their permissions. Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Unconnected / Connected Lookups and Aggregator.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• Extensive knowledge with Teradata SQL Assistant, Fast Export, Fast Load, Multiload, BTEQ, Coded complex scripts for the Teradata Utilities and finely tuned the queries to enhance performance.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions Cursors, Indexes and Triggers and involved in Query Optimization.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
• Strong experience in Performance Tuning of sources, targets, transformations and sessions.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Responsible for generating all scripts required to transform the source data into the Teradata physical tables including the associated processes necessary to provide robust recovery and performance.
• Created personalized version of reports as well as statements for customers using the data from Informatica metadata.
• Experienced In working with various Scheduling tools like Autosys, Control-M, Informatica Scheduler.
• Developed test cases for business and user requirements to perform Unit/ System/ Integration / Performance testing.

TECHNICAL SKILLS

ETL tools: Informatica Power center 9.1/8.6/7.1/6.2 , Power Exchange 8.6/7.1

Reporting tools: Cognos 8.x,7.1, Business Objects 6..x,5.x, OBIEE 10.1.3.4/10.1.3.3

Databases: Oracle 11i/10g/9i, MS Access, DB2 v8.1, Teradata 12/v2 R5/V2 R4, MS SQL Server 2008/2005/2003/2000

Data Modeling tools: Erwin R7/R4/R3.5, MS Visio 2008

Programming: PL/SQL

Operating systems: UNIX (Sun-Solaris, HP/UX), Windows 98/00/NT/XP/7

Scripting languages: Unix Shell script, PERL Script

Web technologies: HTML, DHTML, XML

Other tools: Autosys, Control M, Informartica Scheduler, SQL* PLUS, SQL* LoaderPVCS, Teradata SQL Assistant

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr ETL Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modeling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Extracted data from various data sources such as Oracle, Flat files, DB2, SQL Server and transformed and loaded into targets using Informatica.
• Created users, groups and gave read/write permissions on the respective Folders of repository.
• Used mapping parameters and variables.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Created deployment groups in one environment for the Workflows, Worklets, Sessions, Mappings, Source definitions, Target definitions and imported them to other environments.
• Performed Upgrading Informatica Power center Version 8.6 to Informatica Power center 9.1
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Involved in migration of ETL code from development repository to testing repository and then to production repository.
• Created and debugged the Stored Procedures, Functions, Packages, Cursors and triggers using PL/SQL developer.
• Queried against the Oracle Database to retrieve Millions of records using PL/SQL.
• Development of PL/SQL blocks and multi-thread Pro*C programs for ETL purposes.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages.
• Used set explain utility for collecting detailed SQL query plans and execution statistics using Informix.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Automated UNIX shell scripts to verify the count of records added everyday due to incremental data load for few of the base tables in order to check for the consistency.
• Worked on SQL optimization. Identified bottlenecks and performance tuned the Informatica mappings/sessions.
• Created various documents including high-level design documents, mapping documents and knowledge transfer documents.
• Prepared Run book for the daily batch loads giving the job dependencies and how to restart a job when it fails for ease of handling job failures during loads.
• Reviewed the Testing progress and issues to be resolved by conducting walkthroughs.
• Responsible for regression testing ETL jobs before test to production migration.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Environment: Informatica Power Center 9.1/8.6, DB2 Power exchange 8.1, MS SQL Server 2008, WINSCP, HPQC, Oracle 11g/10g, DB2, Flat Files, Autosys, TOAD, SQL, PL/SQL, Windows XP, UNIX

Confidential, Milford, CT

Sr. ETL Developer

Responsibilities:

• Involved in gathering requirements and acquired application knowledge from Business Analysts & Application Owners for the development of new applications.
• Prepared detailed level functional document based upon the high level specifications provided.
• Involved in Logical and Physical Data Modeling was implemented using Erwin for database in Star Schema.
• Used Informatica Power Center for extraction, transformation and loading of data into target data warehouse.
• Extracted the data from heterogeneous source systems like SQL Server, Oracle, Flat Files, XML Files and Access into Data warehouse.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager.
• Used Type 2 SCD mappings to update slowly Changing Dimension Tables and to keep track of historical data.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Scheduled Workflows based on demand, run on time or run only once using task developer, worklet designer and workflow designer in Workflow Manager.
• Extensively used workflow variables, mapping parameters and mapping variables to improve performance.
• Involved in optimizing source and target and performance tuning the session and workflows for better performance.
• Worked extensively on Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Used PowerCenter's wizard-driven XML editor to create views, modify components, add columns, and maintain view relationships on XML definitions imported using PowerCenter Designer.
• Extensively used PL/SQL programming in backend and front-end functions, procedures, packages to implement business rules.
• Developed SQL Queries to validate the data in both source and target databases.
• Written and used Unix Shell scripts to automate the data load processes to target data warehouse.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Participated in status review team meetings.
• Addressed and track requests for system enhancements, improvements from end users/customer and also resolved production issues.
• Developed recovery process in case of workflow failure due to Database issues or Network issues.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.0, DB2 Power exchange 8.1, MS SQL Server 2008, Erwin, TOAD, SQL, PL/SQL, Flat files, Oracle 11I/10g, Unix Maestro

Confidential, Richmond, VA

ETL/Informatica Developer

Responsibilities:

• Involved in the Data Warehouse Data modeling based on the client requirement.
• Analyzed various sources, requirements and existing OLTP systems and identified required dimensions and measures from the database.
• Used Informatica Designer to create complex mappings using different transformations to move and update data and store it into a Data Warehouse according to the specifications.
• Created Reusable transformations and Mapplets using Transformation Developer and Mapplet Designer.
• Implemented SCD methodology including Type 1, Type 2 changes to handle data loads.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Created various Sessions, Workflows and Control Tasks to migrate data to target data warehouse tables using Workflow Manager.
• Managed sessions and Scheduled Jobs on daily or one time basis using Workflow Manager.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks.
• Extensively used Debugger Process to modify data and applying Break Points while Session is running.
• Created and used SQL Queries for performing updates where Informatica is taking more time on huge dataset tables.
• Written UNIX Shell Scripts to automate the bulk load & update Processes.
• Coded BTEQ scripts to populate data mart tables from EDW to cater specific reporting needs.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Worked on loading of data from several flat files sources to staging using Teradata TPUMP Multiload (MLOAD) and Fast load (FLOAD).
• Worked on exporting data to flat files using Teradata Fast Export (FEXPORT).
• Prepared test scenarios and test cases and involved in unit testing of mappings and user acceptance testing and fixed the errors to meet the requirements.
• Provided production support involving monitoring and error handling for all the workflows involved in the application.

Environment: Informatica Power Center 8.1, Teradata V2 R4, Erwin, SQL, PL/SQL, TOAD, Flat files, Oracle 10g, Teradata SQL Assistant, Unix Maestro

Confidential, Lebanon, NJ

ETL Developer

Responsibilities:

• Created Technical specification Documents based on the requirement document provided by the business users.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted sources from flat-files, DB2 Oracle, SQL Server and load them into target database.
• Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings.
• Developed number of simple to complex Informatica Mappings using various transformations like Aggregator, Expression, Filter, Joiner, Router, Lookup, Update Strategy and more.
• Created Mapplets and Reusable Transformations for Monthly or Yearly Loading of Data.
• Modified existing mappings to meet new business requirements.
• Used Workflow Manager for Workflow and Session Management, database connection management and Scheduled jobs to be run in the batch process.
• Wrote complex SQL scripts on SQL to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Removed bottlenecks at source level, transformation level, and target level for the optimal usage of sources, transformations and target loads.
• Written and used UNIX shell scripts extensively for scheduling jobs and automating the process.
• Provided System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 7.1, DB2 Power exchange 7.1, MS SQL Server 2005, TOAD, SQL, PL/SQL, Flat files, Oracle 9i, Unix Maestro

Confidential

System Analyst

Responsibilities:

• Extensively worked on Informatica to extract data from Flat files, Excel files, and RDBMS tables and applied business logic to load the data into the target database.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Created Tasks, Workflows and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Provided technical support and worked on issues raised during production phase.
• Participated in weekly end user meetings to discuss data quality, performance issues.

Environment: Informatica Power Center 6.2, SQL Server 2003/2000, TOAD, SQL, PL/SQL, Flat files, Oracle 9i, Unix Maestro

Confidential

Software Engineer

Responsibilities:

• Responsible for designing, testing and debugging new database applications and maintaining existing systems.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Implemented integrity constraints on database tables.
• Responsible for performance tuning activities like Optimizing SQL queries, explain plan and by creating indexes.
• Worked in Database structure changes, table/index sizing, transaction monitoring, data conversion and loading data into Oracle tables using SQL*Loader.
• Performed Unit testing in development environment and had close interactions with system test and user acceptance team to complete technical and functional testing.

Environment: Oracle 7.x, PL/SQL, SQL*Plus, SQL*Loader, Visual Basic 6.0, ODBC, Windows NT, UNIX, and Shell Scripts.