SUMMARY

• Over 8 years of diversified experience in the field of Information Technology with an emphasis on Data warehousing tools using industry accepted methodologies and procedures.
• 8 years of solid Informatica PowerCenter development experience with at least one year of recent experience in PowerCenter version 9.
• 5 years of information technology experience delivering complex applications.
• 4 years experience in Data Warehousing,Oracle 10g/11i,DB2 with Strong understanding of data warehouse concepts designs, methodologies, tools, SDLC, and approaches.
• Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier.
• Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Analyzed and designed the database. Involved in database normalization process.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources
• Experience in integration of various data sources like Oracle, SQL server and MS access and non - relational sources like flat files into staging area.
• Extensively worked with SQL loader for bulk loading into the oracle database.
• Strong in Data warehousing concepts,dimensionalStar Schema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience with SQL Plus and TOAD as an interface to databases, to analyze, view and alter data.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment.
• Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.
• Proficient in understanding business processes/requirements and translating them into technical requirements.
• Experience in using performance monitor/SQL Profiler to resolve Dead Locks/Long running queries thereby optimizing query execution plan.
• Extensively used advanced PL/SQL concepts like Bulk collect, PL/SQL tables and Dynamic SQL for DML operations for better performance.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center/PowerMart 8.x/7.x, Power Exchange 8.x

Business Intelligence: Business Objects 6.5/5.1.7

Databases: Oracle 10g/9i/8i, SQL Server, Greenplum 4.0/4.1

MS SQL Server 2000/2005/2008 :

Languages: UNIX, Shell scripting, SQL, PL/SQL, C

Web Technologies: HTML, DHTML, Joomla 1.6

Design: ERWin Platinum 4.0/3.5

Tools: MS Office Suite 2003, TOAD, SQL Plus, SQL Developer, Autosys r11.x PGAdmin III, SQL Developer Data Modeler

Operating Systems: UNIX, Windows 9x/2000/XP/VISTA, DOS

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Hines, IL

Responsibilities:

• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• 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.
• Created mapping documents to outline data flow from sources to targets.
• 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.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• 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.
• Created mapplets to use them in different mappings.
• 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.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 8.6.1, Workflow Manager, Workflow Monitor, Informatica Power Connect /Power Exchange, Data Analyzer 8.1, PL/SQL, Oracle 10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX Toad 9.0, Cognos 8.

ETL Consultant

Confidential, Stamford, CT

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica Power Center created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Have generated reports using OBIEE 10.1.3 for the future business utilities.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica Power Center Designer 8.6/8.1, Informatica Repository Manager, Oracle10g/9i, DB2 6.1, Erwin, TOAD, SAP Version: 3.1.H, Unix- SunOS, PL/SQL, SQL Developer.

Sr. ETL/Informatica Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Designed ETL specification documents for all the projects.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Migrated the code into QA (Testing) and supported QA team and UAT (User).
• Created detailed Unit Test Document with all possible Test cases/Scripts.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Modified existing mappings for enhancements of new business requirements.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Involved in production support.
• Works as a fully contributing team member, under broad guidance with independent planning & execution responsibilities.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQLServer2008, IBM I Series (DB2), MS Access, Windows XP, Toad, Tidal, Cognos 8.4.1., SQL developer.

ETL Developer

Confidential

Responsibilities:

• Developed mappings in Informatica Power Center 6.1that catered to the Extraction, Transformation, and Loading from various source systems to target systems.
• Used Informatica tool to handle complex Mappings and extensively used the various Transformations like Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter etc.
• Used Informatica Power Center 6.1for mapping and workflow design including the use of maplets, reusable transformations and worklets.
• Extensively used workflow manager to create tasks and workflows.
• Used PL/SQL with Informatica Power Center 6.1for Oracle 8i database.
• Developed mapping using Informatica Power Center Designer to bulk load data from Oracle and Flat file source system to target database.
• Used Informatica tool to handle complex mappings and extensively used various Transformations including Source Qualifier, Aggregators, Lookups, Filters, Update Strategy, Expression, Sequence generator and Sorter.
• Developed, implemented and enforced ETL best practices standards.

Environment: Informatica Power Center 6.1, Flat files, Oracle 8i, BO 5, Windows 2000