SUMMARY:

• Over 7 years of experience in the Development and Implementation of Data Warehousing with information Power Center, OLTP and OLAP using Data Extraction, Transformation, Loading and Analysis.
• Experience in designing and implementingData Mart / Data Warehouse applications usingInformaticaPower Centre 9.5/ 8.x / 7.x.
• Worked on developing and implementing complex business rules by creating Mappings, Mapplets, Sessions, Workflows, and worklets for data loads.
• Experienced in requirements gathering,project estimating, planning design, build, maintenance, report design,usernavigation design, testingandimplementation.
• Knowledge of complete SDLC including Requirement analysis and gathering, Project Management, Design, implementation, development and Testing.
• Using agile methodology for SDLC and utilize scrum meetings for creative and productive work.
• Extensively used various transformations such as Filter, Expression, Update Strategy, Look - up, Sequence, Joiner, Router, Aggregate, and Stored procedure transformation.
• Expertise in Dimensional data modeling, Star schema, Snowflake schema, Data Normalization, informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Strong expertise inRelational database systemslikeOracle 8i/9i/11i/10g, Teradata, MS Access, designanddatabase developmentusingSQL, PL/SQL, SQL PLUS, TOAD
• Design and developed complex mappings such as Slowly Changing Dimensions Type 2 (SCD Type 2).
• Experience in writing/debugging/enhancing UNIX Shell Scripts.
• Extensively Worked on UNIX shell scripts to handle Job Control Process.
• Expertise in writingOracle PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers.
• Ability to meet deadlines and handle pressures coordinating multiple tasks in project environment, excellent communication, interpersonal, analytical skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/8.6/7.1,, Informatica Power Analyzer/ Power mart 9xOperating System: Windows 08/07/XP/2003, UNIX, Linux

RDBMS: Oracle 11g/10g/9i, SQL Server, DB2, Teradata, MS Access

Programming Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, XML/XSD, Unix Shell Scripting, Quality Center 9.0/8.2

Web Technologies: HTML, XML, Front page, Dreamweaver

Reporting Tool: SSRS, SSAS, Cognos, SAP BO

Other Tools: SQL *Plus, Toad, MS Office, Microsoft Visio, Microsoft Project

Dimensional Data Modeling: DDM (Dimensional Data Modeling). Start & Snow Flake modeling, Erwin, Putty, WinScp

PROFESSIONAL EXPERIENCE:

Confidential, Dillon, Montana

ETL/Informatica Developer

Responsibilities:

• Interacted with the Business Users in gathering and analyzing the Business requirements.
• Worked on Designing, Development and Testing of Workflows and Worklets according to Business Process Flow.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created technical design specifications for data Extraction, Transformation and Loading (ETL).
• Extensively worked on Change Data Capture/Incremental loading of SCD Type I/II.
• Design theETLprocess and schedule the stage and mart loads for the data mart.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer for defining Source and Target, and coded the process from source system to data warehouse.
• Extensively used transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement business logic.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Extracted the data from various Flat files and Loaded in Data warehouse Environment and written Unix Shell scripts to move the files across the Servers.
• Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Coordinated with testing team to make testing team understand Business and transformation rules that have been used throughout ETL process.

Environment: Informatica Power Center 9.5, Power Mart, Oracle Oracle11g, PL/SQL, Teradata, SAP BO, SSRS, Windows, UNIX, ERwin, Putty, WINSCP, Windows XP, Linux, IBM Mainframes.

Confidential, Los Angeles, CA

ETL/Informatica Developer

Responsibilities:

• Worked on Informatica Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Integrated data from different sources like SQL, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.
• Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica.
• Extensively worked on integrating data from Mainframes to Informatica Power Exchange.
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation, Mapplet and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Used output xml files, to remove empty delta files and to FTP the output xml files to different server.
• Worked with the Business Analyst during to analyze and functional design and technical design phases.
• Worked with database connections, SQL joins, Union, aliases, views, aggregate conditions.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, Mapplets in Shared folder.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, connected & unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, XML Transformations and Update Strategy & Sequence Generator.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used XML Generator transformation accepts data from multiple ports and writes XML through a single output port.
• Integrated data in to EDW by sourcing it from different sources like Mainframes copy books (COBOL files), DB2 and Teradata tables.
• Used SQL, PL/SQL to validate the Data going in to the Data Warehouse.
• Worked on Informatica Schedulers to schedule the workflows.
• Used Message broker as translate messages between the interfaces.
• Created mappings to read parameterized data from tables to create parameter files.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL server 08, Toad 10.6, XML,SQL,PLSQL, Erwin4.0, Unix Shell Scripts, Windows XP/Vista, AutoSys.

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Created new mappings and updating old mappings according to changes in Business logic.
• Performed major role in understanding the business requirements and designing and loading the data into data warehouse (ETL).
• UsedETL(Informatica)to load data from source toDWH.
• UsedInformaticaclient tools -Source Analyzer,Warehouse designer,Mapping Designer,Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• ImplementedSlowly Changing Dimensions - Type I & IIin different mappings as per the requirements.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Involved in performance tuning of Targets, Sources, and Mappings. Improved performance by identifying performance bottlenecks.
• Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail and timer for scheduling of the workflow.
• UsedInformaticaWorkflow ManagerandWorkflow Monitorto schedule and monitor session status.
• Used Debugger to troubleshoot the mappings.
• Developed mappings inInformaticato load the data from various sources into the Data Warehouse, using different transformations likeJoiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.

Environment: Informatica8.6, Oracle 10g, Erwin 4.5, Oracle Applications, PL/SQL, TOAD 9.0, SQL,UNIX, Quality Center 9.0

Confidential, Lansing MI

Informatica Developer

Responsibilities:

• Designed and deployed overallETLstrategy including SCD’s, Partition Management, Materialized Views and other complex mapping logics.
• Transform and Load data into Enterprise Data Warehouse tables usingInformaticafrom the legacy systems and load the data into targets byETLprocess through scheduling the workflows.
• Implemented appropriate Error handling logic, data load methods and capturing invalid data from the source system for further data cleanup.
• Involved in designing logical and physical database designing usingERWIN tool.
• Developing shared objects inInformaticafor source/target/lookup transformations, developed complex mappings, sessions/workflows/worklets, database connections.
• Entered metadata descriptions at both the transformation and port level in complex mappings
• Design theETLprocess and schedule the stage and mart loads for the data mart.
• Debugging and TroubleshootingInformaticaMappings.
• Developed wrappershell scriptsfor callingInformaticaworkflows usingPM/CMD commandand Createdshell scriptsto fine tune theETLflow of theInformaticaworkflows.
• SQL Query tuning including Explain Plan, using Optimizer Hints, Indexes and Histograms.
• Involved in Postproduction support and enhancements.
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse
• Worked closely with the Requirements Manager and business Analysts on the requirements collection process.
• Assisted the tester in developing the test cases and reviewed them.
• Have thorough experience on Defect Management.

Environment: InformaticaPower Center 8.1, ORACLE 9i, UNIX Shell Scripts, WinSCP, HP QC.

Confidential, Columbia, MD

Informatica Developer

Responsibilities:

• Used various transformations like Joiner, Aggregator, Expression, Lookup, Filter, Update Strategy and Stored Procedures.
• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Created and scheduled workflows using Workflow Manager to load the data into the Target Database.
• DevelopedInformaticamappings, transformation, reusable objects by using mapping designer, and transformation developer and Mapplet designer inInformatica Power Center.
• Created reusable transformations and Mapplets and used them in mappings.
• UsedInformaticaPower Center for extraction, loading and transformation (ETL) of data in the data warehouse.
• UsedInformaticaPower CenterWorkflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings inPower CenterDesigner using Aggregate, Expression, Filter, Sequence Generator, Lookup, Joiner and Stored procedure transformations.
• Involved in meetings to gather information and requirements from the clients.
• Involved in Designing the ETL process to extract, translate and load data from flat files to warehouse data base.
• Involved in reading and Translating logic from SQL Server Stored Procedure and Functions intoInformaticaDesign.
• Wrote SQL Queries, PL/SQL Procedures, Functions, and Triggers for implementing business logic and for validating the data loaded into the target tables using query tool TOAD.

Environment: Informatica Power Center 7.1, ETL, PL/SQL Developer, Oracle, UNIX, Microsoft SQL Server, TOAD.