SUMMARY

• 8 years of experience in information systems with secure background in Data Warehousing, SDLC, 7+ years of strong Data Warehousing experience using Informatica Power Center 9.x/8.x/7.x/6.x/5.x, Informatica Power Mart 7x/6x, Power Connect, Power Exchange.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Experience in Data warehousing, Data Extraction, Transformation and loading (ETL) data from various sources like Oracle, SQL Server, Microsoft Access, Microsoft Excel and Flat files into Data Warehouse and Data Marts using Informatica Power Center 9.0/8.6.0/8.1.1/7. x/6.x.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), Data Warehousing (ETL)
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Expert in using debugger in the InformaticaPowerCenter Designer to test and fix errors in the mappings.
• Extensive experience in developing complex mappings from varied transformations like Router, Filter, Sorter, Connected and Unconnected lookups, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files
• Expertise in SQL/PLSQL programming development and execution of Stored Procedures, Functions and Packages. Experience in Loader utilities including SQL Loader and Teradata Tpump, Fast Load, Multiload.
• Extensively worked on overall SDLC implementation that includes requirement gathering, development, testing, debugging and deployment as well as Documentation, Production Support.
• Experience working on End - To-End implementation of Data warehouse and Strong understanding of Database and Data warehouse concepts, ETL, Star and snowflake Schema, Normalization, Business Process Analysis, Reengineering, Data modeling.
• Experience in writing UNIX shell scripting and Parameter Files.
• Experience in using the Informatica command line utilities like PMCMD to control workflows in non-windows environments
• Maintained outstanding relationship with Business Analysts and Business Users to gather information needs as per the business requirement. Experience in working with offshore and onsite co-ordination.
• Systematic, disciplined and has an analytical and logical approach in problem solving. Ability to work in tight Schedules and efficient in time management.
• Excellent Written, Communications and Analytical skills with ability to perform independently as well as in a team.

TECHNICAL SKILLS

ETL Tools: Informatica 9.X/8.x/7.x (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2000, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell Script

Tools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Nashville, TN

ETL/Informatica developer

Responsibilities:

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like MS SQL Server, Oracle, flat files, XML files and loading into Staging and Data warehouse Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed and developed the logic for handling Slowly Changing Dimension Table Type 1/ Type 2.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL Mappings, Using Informatica Mapping Designer within the Informatica Power Center, Usage of Active transformations Joiner, Rank, Aggregator and the Passive transformations Lookups, Expression, XML, Mapplet, connected and unconnected stored procedures, Lookups, SQL Overrides usage in Lookups, Source filter and SQL Override usage in Source Qualifiers and data flow management into multiple targets using Routers were extensively done.
• Invoked and Executed Stored Procedures to transform the Data and worked extensively with PL/SQL for various needs of the transformations while loading the data into Oracle Database. Converted MS SQL Server DTS Packages logic into Informatica Mappings.
• Created Mappings with shared objects/Reusable Transformations/Mapplet using Mapping/Mapplet Parameters/Variables.
• Used mapping variables, parameters, workflow variables & parameter files to support change data capture(CDC) and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Configured workflows with Email Task, which would send mail with session log file for Failure of a sessions and for Target Failed Rows.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Worked with UNIX shell scripts for job execution and automation. Scheduled Informatica workflows using ControlM to run at regular intervals.

Environment: Informatica Power Center 9.5.1, Power Exchange, ControlM, Cognos, Oracle 10g/11g, MS Access, MS SQL Server 2008, Sybase, IBM DB2, SQL PL/SQL, SQL*Plus, TOAD, Oracle Applications 11i, Erwin, Unix,, Sun Solaris, Windows XP

Confidential, St.louis, MO

ETL/ Informatica Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse.
• Extensively worked with staging area to perform data cleansing, data scrubbing, data filtering and data standardization process.
• Implemented code using various Informatica Transformations like Source qualifier, Joiner, Union, Expression, Lookup, Aggregate, Filter, Router, Normalizer, XML and Update Strategy.
• Developed SQL overrides in Source Qualifier and Lookup transformations according to business requirements.
• Used connected /Unconnected Lookup Transformation to lookup the values in Flat Files and relational sources and targets.
• Implemented SCD Type 2 Slowly Changing Dimensions to maintain the historical data in sales data mart as per the business requirements.
• Implemented different Tasks in workflows which include Session, Command, E-mail, Event-Wait, Event - Raise, Timer etc.
• Involved in Performance Tuning of SQLQueries, Sources, Targets, Transformation and sessions by identifying and rectifying performance bottlenecks.
• Used stored procedures for creating & dropping the indexes before the session run to improve the session performance and rebuild them after completion of session.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent sessions and scheduling them to run at specified time with required frequency.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Automation of job processing using Tidal scheduler, establishing automatic email notifications to the concerned persons by creating email tasks in workflow manager
• Tested all the mappings and sessions in Development environment and migrated into Production environment after everything went successful.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2008, Teradata, SQL Loader, Toad 8.5, Delimited Flat Files, SQL*Plus, PL/SQL, UNIX Shell Scripts, Tidal, Solaris 5.8, Windows XP

Confidential, Chicago, IL

Sr. ETL Informatica Teradata Developer

Responsibilities:

• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Teradata utilities like Fast load, Multiload to load data into target database.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflowmanager and Workflow Monitor.
• Analyzed the source data coming from different sources (Oracle and SAP Flat files) and worked on developing ETL mappings.
• Created Parameter files, User Defined Functions for converting SAP values and validation scripts.
• Used FakeMload connection and created used customMload Scripts from command task.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and session level.
• Worked extensively on SQL, BTEQ Scripts and UNIX shell scripts.
• Performed Unit testing and Data validation testing using Validation scripts.
• Proven Accountability including professional documentation and weekly status report.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.

Environment: Informatica Power Center 8.6, Oracle 10g, SAP BW Flat Files, Teradata 13, UNIX, Win XP, SQL * Plus, SQL Assistant, Control-M, Putty, BTEQ, OBIEE 10.1.3.

Confidential

Jr. ETL Developer

Responsibilities:

• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse.
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, Lookup Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Developed several Re usable Transformations and Re-Usable Mapplets by using the Power Center Designer.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Extensive worked on debugging and troubleshooting the Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.
• Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server, Sybase, Flat Files, UNIX, Windows XP, CA Autosys, StarTeam.

Confidential

Oracle Developer

Responsibilities:

• Created Entity Relationship diagrams, Functions Relationship diagrams, data flow diagrams and enforced all referential integrity constraints using Oracle Designer.
• Involved in the creation of schema objects like indexes, views, stored procedures and synonyms.
• Administrated Daily DBA activities like maintaining User Accounts, roles and privileges, constraints, UNDO, TEMP Table space management, alert log files, trace files etc.
• Created SQL tables with referential integrity and developed queries using SQL, SQL*Plus and PL/SQL.
• Involved in writing triggers which internally called procedure and functions.

Environment: Oracle 8, Oracle Designer, UNIX.