SUMMARY

• 9 years of IT experience in analysis, design, development, testing and Implementation Informatica Workflows using Data Warehousing/Data mart design, ETL, OLAP client /server applications.
• Experience in using Informatica Client tools: Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experienced with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.
• Strong ETL experience using Informatica Power Center with various versions 9.x/8.x/7.x/6.x Client tools - Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor and Server tools - Informatica Server, Repository Server manager and Power Mart .
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle 11g/10g/9i, SQL Server 2008/2005, IBM DB2, Excel sheets, Flat Files.
• Hands on experience with managing Slowly Changing Dimensions (SCD) such as Type I, II, III and Cleansing, Profiling, Conversion, Aggregation, and Performance Optimization and setting up Change Data Capture (CDC) mechanisms.
• Strong Experience in creating Transformations such as Aggregation, Expression, Update Strategy, Lookup, Joiner, Rank, Router and Source Qualifier Transformations in the Informatica Designer.
• Comprehensive knowledge of Dimensional Data Modelling like Star Schema, Snowflake Schemas, Facts and Dimension Tables, Physical and Logical Data Models and knowledge in designing tools like MS Visio, Erwin.
• Demonstrated proficiency in improving re-usability, automation of data loads, performance tuning in Informatica by identifying bottlenecks and database performance by using EXPLAIN PLAN to improve performance and de-bugging/rectification of data load errors.
• Experience in gathering, analyzing and documenting business requirements, functional requirements, designing and developing the mapping based on the requirements.
• Experienced in implementing the business rules by creating transformations (Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union), and developing Mappings.
• Strong knowledge on Data warehousing concept, Data mart, Star Schema and Snow Flake Schema modelling, Fact tables and Dimensional tables.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Experience in Migration of objects between environments, from Local (DEV) to Test (QA)
• Experience in writing complex SQL queries, simple stored procedures and Unix Shell Scripting.
• Excellent experience in Performance tuning in Informatica Power Center and query optimization.
• Strong knowledge on Relation databases like Oracle 9i/10g/11g, SQL SERVER, TERADATA on different platforms like Windows/Unix Linux using GUI tools like TOAD, SQL DEVELOPER, SQL PLUS, SQL*PLUS, MICROSOFT VISUAL
• Analytical and Technical aptitude with the ability to solve complex problems.
• Strong interpersonal skills with ability to interact with end-users, managers and technical personnel.
• Exposure to develop reports using Business Intelligence tools such as Business Objects.
• Maintain outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Involved in Unit Testing, Integration testing and QA Validation

TECHNICAL SKILLS

ETL and BI Tools: Informatica Power Center 6.x/7.x/8.x/9.x, Informatica Power Exchange 9.x, Hyperion Financial Data Quality Management 9.x.

DBMS/RDBMS: Oracle 11g//10g/9i/8i/7.x, SQL server, Microsoft Access, DB2 8.1

Operating Systems: UNIX, Linux, DOS, Windows XP/2003/2000/NT

Languages: SQL, PL/SQL, Unix Shell Programming, C, MS-Excel, Basic, COBOL.

Reporting and Analysis Tool: Business Object6.x, Hyperion Financial Management 9.x, OLAP HFM Financial reporting Training.

Version Control System: PVCS, Tortoise SVN(Subversion)

Job Scheduling Tool: Autosys, Control-M

GUI Tools: SharePoint, Visual Basic, Visual FoxPro, ASP

Web Technologies: HTML, JavaScript, XML

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Sr. Informatica Developer

Responsibilities:

• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files and Teradata.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas.
• Involved in performance tuning and query optimization.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Monitored and improved query performance by creating views, indexes, hints and sub queries.
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica PowerCenter 9.1, Oracle 11i, SQL Server 2008, Netezza, Teradata, MS Access 2010, SQL*Loader, UNIX, Winscp, Putty, Erwin 7.2, SQL, PL/SQL.

Confidential, Madison WI

Informatica Developer

Responsibilities:

• Worked closely with the business analyst and Data warehouse architect to understand the source data and need of the Warehouse.
• Involved in designing of star schema based data model with dimensions and facts.
• Created mappings with heterogeneous sources like flat files, MS Access, Oracle databases and created targets in Oracle data warehouse using Informatica PowerCenter 8.6.2.
• Created Source to Target mapping from design and requirement documents.
• Built reusable transformations for recurring business logics using mapplets and used them in multiple mappings.
• Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Router, Sequence generator, Expression, Filter and Rank transformations.
• Designed and developed test cases for unit and system testing.
• Modified Unix Shell Scripts for executing the Informatics workflows. Knowledge of Epic.
• Created aglobal schema with common source and target tableto be used across different data marts and implemented shortcuts to the objects within each mart folder so that it is easy to maintain and control the changes to the source and targets
• Created parameters and variables for incremental data loading effectively using Informatica workflow manager.
• Created event raise, event-wait tasks for maintaining dependencies between workflows.
• Efficiently interacted with UAT team and supported system testing and fixed bugs in mappings during QA phase.
• Excellent knowledge on ETL tools such as Informatica to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Optimized or tuned mapping/ sessions during load testing in QA environment.
• Designed, developed, and tested various enhancements.

Environment: Informatica Power Center 8.6.2, Oracle 10g, Teradata,Autosys 4.5, XML, SQL Plus, PL/SQL, SQL, UNIX, Toad, Erwin 7.2, Powermart

Confidential - Charlotte, NC

Informatica ETL Developer

Responsibilities:

• Involved in Dimensional modeling of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed number of complex Informatica mappings, mapplets, and reusable transformations to implement the business logic and to load the data incrementally.
• Worked on performance tuning of SQL and mappings by usage of SQL Overrides in Lookups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• As per the requirement of the business users to manage change data capture, implemented slowly Changing Dimensions type I and type II.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used PowerCenter Workflow manager for session management, database connection management and scheduling of jobs to be run.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Created List, Crosstab, Chart type reports for the sales data using Crystal Reports.

Environment: Informatica Power Center 8.6, Erwin 7.2, Oracle 10g, SQL Server 2005, SQL*Loader, SQL, TOAD, UNIX, Autosys, Test Director 7.2, MS Office

Confidential, Norwood, MA

Informatica Developer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Experience on working with complete Software Development Life Cycle of the application..
• Involved in monitoring and maintenance of the Unix Server performance.
• Involved in creating database tables, views, triggers.
• Worked on Markit EDM.
• Worked with PL / SQL to create new stored procedures and also modify the already existing procedures as per the change requirements from users.
• Created many PL/ SQL batches and executed them through Unix Shell scripts.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Optimized SQL queries for better performance..
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, PL/SQL Developer, DataFlux, BPM (Business Process Management), Win CVS, Window XP, DB2, UNIX, Markit EDM.

Confidential, Dearborn, MI

Informatica ETL Developer

Responsibilities:

• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Developed many complex mappings and mapplets using various transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into Data Warehouse.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Created various Reusable and Non-Reusable tasks like Session and other tasks like Decision and email tasks.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.
• Responsible for monitoring sessions that are running, scheduled, completed and failed.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.

Environment: Informatica 8.5, Oracle 9i, MS-Access, Window NT.

Confidential

ETL Consultant

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow.
• Designed and developed Informatica Mappings, Workflows to load the data into Oracle DB, SQL server.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign User Privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Used Debugger to test the mapping and fixed the bugs.
• Involved in Performance Tuning of Sessions and Mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Created and maintained UNIX Shell Scripts for pre/post session operations and various day-to-day operations.
• Developed Unit and System testing test cases, using System Procedures to check data consistency with adherence to the data model defined.

Environment: Informatica Power Center 8.0, Oracle 9i, Erwin, SQL server 2005, UNIX, SQL Plus, TOAD, MS Access, Windows XP.

Confidential

Informatica ETL Developer

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams tounderstand business requirements and the source data.
• Involved in designing logical models for staging, production warehouses using ERWIN.
• Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
• Extensively used all the features of Informatica including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Partitioned sources to improve session performance.
• Created users in Informatica, assigned them various permissions.
• Backup/Restoration of repositories.
• Upgradation of repositories when upgrading to new versions of Informatica.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Improved session run times by partitioning the sessions. Was also involved heavily into database fine tuning(creating indexes, stored procedures, etc), partitioning oracle databases.
• Derived various complex calculations as per the report specification.
• Writing SQL, PL/SQL, stored procedures and triggers in Oracle9i..
• Implemented Filters, Calculations, Conditions, and Graphs.

Environment: Informatica Power Center 7.1, Oracle9i, Erwin, Shell Scripting, PL/SQL, UNIX, Windows 2000.