SUMMARY

• 9 years of software experience in analysis, design, development, testing includes using Informatica ETL (Extraction, Transformation and Loading Tool) PowerCenter / PowerMart in various domains like Pharmaceutical, Financial, and Banking sectors.
• Experience in Development and Designing of ETL methodology for supporting data transformations using Informatica Power Center 9.1/8.6/8.5 (Designer, Workflow manager, Workflow monitor and Repository Manager).
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer, XML.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes modeling, Fact and Dimension Tables modeling of data at all the three levels: view, logical & physical.
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center. Experience in working with scheduling tools like Autosys and Control M.
• Skilled with the Integration of various data sources like Oracle 11g/10g/9i/8i, SQL Server 2008/2005, MS Access, files, Teradata, XML, EBCDIC files and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Fair amount of knowledge in Business Objects suite like BO reporter, Supervisor, Designer Web Intelligence, Info View and Broadcast Agent.
• ETL experience in development of mappings and tuned existing mappings for better performance using InformaticaPowerExchange, InformaticaPowerCenter as per the business rules.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors, Triggers.
• Expertise Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Expert in Informatica B2B Data Transformation maintains architectural separation of protocols, formats, and interfaces updates than competitors. And Informatica B2B Data Transformation’s universal deployment capability.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Experience with UNIX commands, vi editor and writing Shell scripts.
• Experience in creating reports using Oracle Business Intelligence 10x, and Siebel Analytic
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS

ETL/Middleware Tools: Informatica 9.x/8.x/7.x/6.x (Power Center, Power Mart,PowerExchange)

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.x, Oracle Designer.

OLAP/Reporting Tools: OBIEE 10.1.3.x,Siebel Analytics7.x,Oracle BI apps

RDBMS: Oracle 11g/10g, MS SQL Server 2005, DB2 UDB 7.1, MySql, MS Access.

Programming Skills: Oracle SQL Developer 3.1, Unix Shell Scripting, Autosys, Control-M, Syncsort, SQL, PL/SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, XML,C, C, C++, Java.

Modeling Tool: Erwin 7.3, MS Visio.

Operating Systems: Win 2000/2003/2008 , HP-Unix 11/10/9, AIX, Sun Solaris 10.

Scheduling Tool: Autosys, Informatica Scheduling.

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, Al

Sr.Informatica Developer

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router transformations.
• Worked Informatica power center tools like Mapping designer, mapplet and transformations and Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.
• Developed Slowly Changing Dimensions Mapping for Type 1 SCD and Type 2 SCD and Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Setting up sessions to schedule the loads at required frequency using Power Center,Workflow manager, PMCMD and also using scheduling tools.
• Extensively used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Developed and Implemented Informatica parameter files to filter the daily data from the source system.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors that occur while loading.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings and workflows and to keep track of the changes in the development, testing and production environments.
• Performed Unit Testing and Integration Testing on the mappings
• Developed scripts for automating workflows using ksh and Bourne shell scripting.
• Involved in designing Audit process for the sessions loaded as part of mapping design as well querying against informatica repository tables
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution

Environment: Informatica Power Center 9.1/8.6 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations),Power Exchange Tool, Sql Server 2005,Oracle 11g, Quest Central, SQL Developer, SQLplus, PL/SQL (Stored Procedure, Trigger, Packages), Erwin, MS Visio, Windows 2003,SUN SOLARIS UNIX HP-U.

Confidential, MO

Sr. Informatica Consultant

Responsibilities:

• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Creating mappings, sessions, workflows, transformations, and reusable mapplets in development environment and later moved them to testing and production environments.
• Implemented Transformation Developer to create the filters, lookups, and stored procedure, Joiner, update strategy, expressions and aggregations transformations.
• Quickly understood and provided alternate solutions to requirement changes by simplifying mappings, sessions and workflows and improving their performance by using transformations like source filters and sorted input in aggregator while still achieving the desired results within the stipulated timeframe.
• Created the repository manager, users, user groups and access to their profiles.
• Created Logical & Physical models and used ERwin for data modeling and Dimensional Data Modeling and also process flow using Erwin Tool..
• Created various stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed.
• Designed and developed sophisticated workflows and data transformations involving informatica B2B components dx (Data Exchange) and DT (Data Transformation).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as Mapplets using Informatica Designer.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of Informatica server. Performed extensive testing of changes and fixes in different environments.
• Writtte Shell scripts to schedule batches on Cron Jobs and Worked on UDB/ DB2 on AIX, Tested the target data against source system tables by writing some QA Procedures.
• Used Informatica scheduler to run the workflows on UNIX box and monitored the results and Used pmcmd command line tool to schedule sessions.

Environment: Informatica Power Center 8.6.1,9.1, UNIX AIX 5.3, MS SQL Server 2008, WinSCP, IBM DB2 v9, Flat Files - Fixed Width, Tab Delimited and Spread Sheets, Control Center, IBM Cognos Cubes, UNIX AIX 5.4 .

Confidential

Sr. Informatica Developer

Responsibilities:

• Extensively Worked on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Responsible for the Data Modeling and populating the business rules using mappings into the Repository for Meta Data management .
• Involved in running the loads to the data warehouse and data mart involving different environments and Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Configured incremental aggregator transformation functions to improve the performance of data loading and also Worked Database level tuning, SQL Query Tuning for the Data warehouse and OLTP Databases
• Working with Informatica Data Quality (IDQ) tool for data consolidation, standardization, de-duplication, and cleansing the data while extracting from different sources
• Wrote Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules and written PL/SQL stored procedures to load data into time dimension table.
• Developed post and pre session UNIX shell scripts and also Involved in troubleshooting and performance tuning of data loading process.

Environment: Informatica Power Center 9.1,8.6.1, UNIX AIX 5.3, MS SQL Server 2008, WinSCP, IBM DB2 v9, Flat Files - Fixed Width, Tab Delimited and Spread Sheets, Control Center, IBM Cognos Cubes, RUMBA, UNIX AIX 5.4

Confidential, WA

ETL Developer

Responsibilities:

• Involved in gathering of business scope and technical requirements and written technical specifications and Involved in massivedata cleansingand data profiling of the production data load.
• Extensively used Informatica to load data from flat files, Oracle, Teradata database and used various Functions like LTRIM, RTRIM, ISNULL, ISDATE, TO DATE, Decode, Substr, Instr and IIF function.
• Responsible for Studying the existing data warehouse which is in PL/SQL and also working on PL/SQL packages, stored procedures, triggers and functions
• Used Various transformations like Aggregator, Expression, Lookup, Rank, Update Strategy, Stored procedure and Sequence Generator
• Knowledge of slowly changing dimension tables and fact tables
• Responsible for Creating workflows and worklets. Created Session, Event, Command, Control Decision and Email tasks in Workflow Manager
• Wrote Pre-session and Post-session shell scripts for dropping, creating indexes for tables, Email tasks and various other applications.
• Creation of different types of reports, such as Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects.
• Involved in Unit, System integration, User Acceptance Testing of Mappings .
• Used Update Strategy DD INSERT, DD UPDATE to insert and update data for implementing the Slowly Changing Dimension Logic.
• Involved in designing and analyzing the data warehouse using Reverse engineering and Forward engineering methodology in Embarcadero Star schemas and the respective dimension tables were designed and generated.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, 8i, OBIEE, Flat Files,DB2, SQL Server 2000, Mainframe DB2, AIX, Sun Solaris UNIX, COBOL, TOAD, Quest Central for DB2, Windows 2000, UNIX AIX 5.1, Business Objects 6.5, Cognos Cube, SQL, PL/SQL.

Confidential, CA

Sr. ETL Consultant

Responsibilities:

• Used Source Analyzer, Target Designer, Transformation Developer and Mapping Designer to map data sources to targets.
• Involved in designing the informatica mappings by translating the business requirements and extensively worked on informatica lookup, update and router to implement the complex rules and business logic.
• Load data using Informatica mappings to Data Warehouse (from Transient to Staging to Data warehouse).
• Designed and developed complex aggregate, join, lookup transformation rules to generate consolidated (facts/summary) data identified by dimensions using Informatica ETL tool.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent batches and sessions.
• Monitored the workflows in the workflow monitor and resolved the issues in the process using the Session logs .
• Worked with Shell scripts and pmcmd to interact with informatica server from command mode.
• We tuned PL/SQL Procedures for better performance. Fine-tuned the stored procedures, queries by changing the join orders and giving all combinations of joins and fixed them with the help of explain facility tools.
• Created Materialized views for summary tables for better query performance.
• Scheduled the ETL jobs daily, weekly and monthly based on the business requirement and Developed Parameter Files for Data Integrity.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality and data Integrity.

Environment: Informatica Power Center 8.1 (ETL), Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Navigator, TOAD, Perl, UNIX (Solaris),, SQL Server 2000, Windows NT/2000, HP-Unix.

Confidential, Fremont, CA

Sr.ETL Developer

Responsibilities:

• Extracted data transformed and loaded into Oracle database according to the specifications.
• Used various transformations like lookup transforming the Sales Force Data according to the business logic update strategy, router, filter, sequence generator, source qualifier/Joiner on data and extracted as per the technical specifications.
• Created Mapplets using Mapplet Designer to reuse Mapplets in the mappings.
• Experience in performing the Analysis, Design, and Programming of ETL processes for Teradata.
• EDI Standard Evolution and Migration Solution Speciation-Driven Transformation.
• Used by Informatica to provide up-to-the-minute pre-built transformations in support of Industry standards.

Environment: Informatica Power Center 7.1, Oracle 9i, SQL/PLSQL, Worked with Kimball methodology, Business Objects 5.0, TOAD, Erwin 4.5/4.0/3.x, and Windows NT/ WINDOWS SERVER 2003, UNIX(SUN SOLARIS).

Confidential 

ETL Developer

Responsibilities:

• Developed and supported the Extraction, transformation and load process (ETL) for a Data Warehouse from their OLTP systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica.
• Database design, rebuilds, troubleshooting, and performance tuning.
• Prepare SQL queries for consumer analysis reports and Expertise in writing SQL queries for cross verification of data.
• Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements.
• Used various Transformations like Expression, Filter, Joiner and Lookups for better data massaging to migrate clean and consistent data.
• Extensively worked on creations of external tables and importing data from flat files into the external tables using Informatica .
• Hold significant responsibility in the Data Mining Team and to coordinate with the team for successful result oriented work.
• Working closely and iteratively with technical staff and business owners to produce logical and normalized data models that reflect business processes.

Environment: Informatica 6.x, SQL, Erwin 4.0, PL/SQL, Windows 2000, Unix, Oracle 9i, IBM DB2, MS SQL Server 2000.