SUMMARY

• Over 7 + years of ETL and data integration experience in developing ETL mappings and scripts usingInformatica Power Center 9.x/8.x/7.x and databases as Oracle, SQL Server.
• Experience in all the phases of Data warehouse life cycleinvolving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working withbusiness analysts to identify, study and understandrequirements and translated them into ETL code in Requirement Analysis phase.
• Worked on various Domains like Banking,Supply Chain, Inventory and Procurement.
• Expertise in OLTP/OLAP System Study,Slowly Changing Dimensions types(SCD'S) Analysis and development.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank)
• Mappingsusing Informatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Experience in creatingReusable Tasks(Sessions, Command, Email) andNon - Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensively worked on developing and debugging Informatica mappings, sessions and workflows.
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions.
• Experience in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writingTest Scriptsby decomposing Business Requirements, and developingTest Scenariosto support quality deliverables.
• Expertise in writingSQL QueriesusingOracle and SQL Serverin validating data into Data Warehouse/ETL applications.
• Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
• Expertise inDefect management,Bug tracking,Bug Reportsand generating the graphs using Test Management Toolssuch asQuality Center.
• Experience in writing, testing and implementation of thePL/SQL triggers, stored procedures, functions, packages.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.5/7.2

Databases: Oracle 11g/10g, Teradata, SQL Server 2000

Scripting Languages: SQL, PL/SQL, UNIX Shell Script

Data Base Development Tools: Toad, SQL Developer, SQL Assistant

Operating Systems: Windows, UNIX, Linux

Scheduling Tools: Dollar Universe, Zena Scheduler, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Informatica Developer

Responsibilities:

• Involved in Requirement Analysis, ETL Design and Development for extracting the data from various sources like Oracle, VSAM files, Flat files.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Developed mappings to load large amount of data from different sources to staging area, mappings for load the data from staging area to Dimension and Daily/MonthlyFacts.
• Implemented slowly changing dimension Type 1 andType 2 for Change data capture.
• Developed Health check processto do post load validation.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse
• AnalyzedSource to StageandStage to Targetmapping document based on Facts & Dimensions and validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business rules to be applied on target tables.
• Tested loading of various source data (IM, ST, ALS, RMS, Loanserve) to Pre-Staging, Staging, Data Store, Dimensions Facts target Oracle systems.
• Involved in creation ofTest Plans, Test Cases, and Test Executionbased on mapping specs to validate the platform data.
• UsedTOAD for Oraclein creating & executingSQL queriesfor testingETL process.
• TestedFull load & Incremental loadby entering the sample test data to couple of entities and making sureInserts & Updatesof loading the data is done correctly.
• ValidatedType II SCD for loading current and historyof Customer, Instrument, Address, Dealer, Product dimensions based on the natural key.
• UsedQualityCenter11.0as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.
• FollowedDefect management life cycleand raised the defects based on priority and severity level in QC.
• PreparedTraceability Matrixfor each entity and marking down Test requirement, Test Head line, Actual result & Expected result.
• Implemented Iterative and IncrementalAgile - ScrumMethodology for rapidly changing or highly emergent requirements and following parallel development and testing.

Environment: Informatica Power Center 9.5/9.1,oracle 11g/10g,Unix, Unix Shell Script, Tidal, TOAD, Teradata, SQL Assistant

Confidential, San Jose, CA

Sr. Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the CSCORE project.
• Analyze source systems like SJPRD, CFNPRD, QTCPRD & BVPRD for purchase, receipts, invoice, involve hold and payments related data.
• Based on analysis of source system present design document into client. So that client can have full utilization of data available into source system.
• CreatedMapplets, reusable transformationsand used them in different mappings.
• Created Workflowsand used various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Sessionin the workflow manager.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation ofInformatica mappingsfor source compatibility due to version changes at the source.
• Implementeddaily and weekly audit processfor theClaimssubject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Involved in writingSQL scripts, stored procedures and functionsand debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scriptsfrom development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Coordinate with the client team, and present on a weekly basis to the client the progress and issues related to the project.
• Actively involved inproduction support. Implementedfixes/solutionsto issues/tickets raised by user community.
• Reviewed Informatica mappings and test cases before delivering to Client.

Environment: Informatica PowerCenter 9.x/8.x,oracle 11g/10g,Unix,Unix Shell Script,Dollar Universe, OBEII 10.1, TOAD, Teradata, SQL Assistant

Confidential, Branchville, NJ

Informatica Consultant

Responsibilities:

• Building, Maintaining and Tuning ETL mapping to load data from XML source to Relational Pre Staging, then from Pre Staging to Staging, then from Staging to Data ware house using Informatica Power Center 7.1.1 & 8.1.
• Worked with heterogeneous source to Extracted data fromOracle database, XMLand flat files and loaded to a relational Oracle warehouse.
• Extensively usedSource Qualifier Transformationto filter data at Source level rather than at Transformation level.
• Created different transformations such asSource Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Validating the reporting objects in the reporter against the design specification document.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Reviewed Informatica mappings and test cases before delivering to Client.
• Written TestCases for ETL to compare Source and Target database systems.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.
• Ensured that the mappings are correct and conducted data validation testing.
• Worked with production team to resolve data issues in Production database.

Environment: Informatica 7.1.1 & 8.1, SQL Server 2000/2005, Zena Scheduler2.1.

Confidential

ETL Developer

Responsibilities:

• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Extensive use ofPersistent cacheto reduce session processing time.
• Identifiedperformance issuesin existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Used Workflow Manager for creating, validating, testing and running thesequential and concurrent sessions.
• UsedDebuggerto test the data flowand fix the mappings.
• Developed shell scripts for file transferring
• CreatedTasks, Workflows, Sessionsto move the data at specific intervals on demand using Workflow Manager.
• Involved inUnit testing, Iterative testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Preparing and usingtest data/casesto verify accuracy and completeness of ETL process.
• Created and monitored workflows and taskusing Informatica PowerCenter Workflow Manager.

Environment: Informatica PowerCenter 7.1.3, Oracle, SQL Server,Windows XP, UNIX,UNIX Shell Script, TOAD.