SUMMARY

• Over 7.6+ years of IT experience as an ETL Developer/Program analyst, which includes Data Warehouse/Database Developer experience using InformaticaPowerCenter9.1/8.x/7.x.
• Hands on experience in Optimizing Databasequerying, datamanipulation and population using SQL and PL/SQL in Oracle, Teradata, DB2 and SQLServerdatabases.
• Hands on experience with InformaticaAdministration and various upgrades.
• Two years of experience of CDCReal time using InformaticaPowerExchange9.1/8.6.
• One year of experience of reporting using OBIEE11g tool.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensionalmodeling of STAR, SNOWFLAKE schema, and OLAP, ROLAP, MOLAP, Fact and Dimension tables.
• Good understanding of development lifecycle of projects with Informatica, Oracle, DB2and Teradata.
• Experience writing and modifying ETL design documentation, testresultsdocumentation and standardoperatingprocedures (SOP) documentation.
• Proven experience with writing and technical requirements analysis.
• Worked with Teradata loading utilities like MultiLoad, FastLoad, TPump and BTEQ.
• Experience in developing Shellscripts on UNIX and experience with UNIX command line.
• Knowledge of SoftwareTesting and QualityAssurance.
• Excellent communication and writing skills and capable of working successfully both in teams and independently.
• Ability to self - managetime and taskpriorities to meet projecttimelines, and identify potentialprojectrisks.

TECHNICAL SKILLS

ETL TECHNOLOGY: DMExpressSyncsort, Informatica Power Center 9.1/8.x/7.5, Power Exchange 9.1/8.6, BODI, DMExpress 7.5

DATA WAREHOUSE: Multidimensional Model Design, Star Schema Development

DATA MODELLING: Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin 7.1

DATABASES: Oracle11g/10g/9i, MS SQL Server7.0/2000,MySQL, Teradata12/V2R6

PROGRAMMING: C, C++, SQL, PL/SQL, HTML,UNIX Scripting,SOQL

REPORTING&SCHEDULING TOOLS: OBIEE 11g, TIDAL

OPERATING SYSTEMS: Windows 2000/XP, Sun Solaris, UNIX, MS-DOS

APPLICATIONS: MS Office, MS Project, FrontPage, Toad 9.2/8.6, Autosys

MANAGEMENT TOOLS: MS-Office 2007, MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

Sr. ETL Developer

Responsibilities:

• Extracted the data from the flat files into staging area and populated onto Data Warehouse.
• Prepared Low Level Design (LLD) documents as per the business requirements.
• Developed Mappings & Workflows as per Business logic, quality and coding standards prescribed for the module.
• Data Quality Analysis to determine cleansing requirements. Responsible for populating the business rules using mappings. Understand the business needs and implement the same into a functional database design.
• Developed number of complex mappings using connected - unconnected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, normalizer, sequence generator, Update Strategy, Transactional Control, SQLT Transformations, mapplets to implement the business logic and load the data incrementally
• Handled slowly changing dimensions of Type1, Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Documented Mappings, Transformations and Informatica sessions for further maintenance and support.
• Worked on optimizing the mappings by creating re-usable transformations and Mapplets.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads.
• Designed and developed efficient Error Handling methods and implemented throughout the mappings.
• Configured the sessions using workflow manager to have multiple partitions on Source data and to improve performance.
• Developed DMExpressSyncsort jobs and tasks to meet the presented business requirements.
• Testing the intermediate files produced by Syncsort for a complete analysis of a DMExpress mapping.
• Developed a CDC alternative to extract batches from source side and push batch data into cif files.
• Created a Technical Design Document for the CDC alternative.
• Integrated procedures and a variety of PLSQL code into kroon jobs and other ETL processes.
• Created kron jobs to monitor incoming claims to be packaged into zip files for further processing.
• Assisted with production support for tasks such as Processed Batch Analysis (PBA), Diff Count Report (DCR) those are local to the scope of the company’s process.

Environment: DMExpress 7.5,Oracle (Standard Edition), Oracle Exadata (Source system and production)Toad 11.5, Kron, Linux.Informatica Power Center 9.1, Teradata 14, DB2, OBIEE 11g, PL/SQL, SQL, Erwin 7.5,Remedy, ESP.

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Worked on understanding the ETL tool (BODI) used for the legacy system and documenting the code for further usability in the new ETL tool (Informatica).
• Created both simple and complex Informatica mappings which include stage load, ODS load, dimensional an fact loads using transformations like Expression, connected and unconnected lookup, Router, Aggregator, Sequence generator, Update strategy.
• Used basic Insert else update, Upsert ( Confidential local) strategies for stage to ODS mappings.
• Used SCD’s (Slowly Changing Dimension) strategies for Incremental loading of Dimension and Fact tables.
• Created Technical Design Documents of a subject area, helped preparing Release notes for SIT phase and helped identify the pre-deployment and post deployment tasks for the same.
• Created Mapping documents explaining the logic (Source Qualifier SQL’s, joins etc.), column definition, transformation per column, test cases with corresponding results for every development cycle.
• Used Salesforces Local Database Query LanguageSOQL( Confidential Object Query Language) to query their source data for testing purposes.
• Scheduled ETL jobs with the help of TIDAL (Cisco). Set variables, parameters, actions and events in tidal to deal with complex scheduling challenges.
• Was involved in performance tuning measures by determining bottlenecks at the session level, particularly thread selection tuning on source, target and transformation definitions and a few other measures like mod partitioning.
• Performed unit testing through every development and/or test cycle and prepared a QE document containing test cases of DML execution and the corresponding results.

Environment: Informatica Power Center 9.5.1, BODI, SQL Developer, TIDAL, Oracle 11g, Linux.

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Worked with businessanalyst for requirementgathering, businessanalysis, and testing and project- coordination.
• Created the Detail Design Documents which have the ETL technical specifications for the given functionality, overall process flow for each particular process, Flow diagrams, Mapping spreadsheets, issues, assumptions, configurations, Informatica code details, shell scripts etc. and conducted meetings with the clients for the Approval of the process.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Configured Informatica Power Exchange connection and navigator.
• Created Registration, DataMap, configured Real-Time mapping and workflows for real-time data processing using CDC (Change Date Capture) option of Informatica PowerExchange.
• Wrote Script to loadmultiple tables and used MLOAD utility.
• Used Debugger utility of the Designer tool to check the errors in the mapping and made appropriate changes in the mappings to generate the required results.
• Performing ETL & database code migrations across environments.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Created and maintained the ShellScripts and Parameterfiles in UNIX for the proper execution of Informatica workflows in different environments.
• Created Unittestplans and did unittesting using different scenarios separately for every process. Involved in Systemtest, Regressiontest& supported the UAT for the client.

Environment: Informatica Power Center 9.1, Informatica Power Exchange 9.1, Toad, UNIX Shell Scripting, OracleExadata, SQL Server 2008, Teradata 13, Mercury Quality Center, Autosys, Linux.

Confidential

Informatica Developer

Responsibilities:

• Responsible for logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including DB2, SQL Server, Oracle, Flat file etc.
• Successfully collaborated with businessusers to capture & define business requirements and contribute to defining the data warehouse architecture (data models, data analysis, data sourcing and data integrity)
• Analyzed sourcedata for potentialdataquality issues and addressing these issues in ETL procedures.
• Developed technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules.
• Design, develop, test, maintain and organize complex Informatica mappings, sessions and workflows.
• Translated the PL/SQL logic into Informatica mappings.
• Provided support for existing systems and worked on new development initiatives simultaneously.
• Actively participate in design and analysis sessions to ensure sound team decision-making.
• Support system and user acceptance testing activities, including issue resolution.
• Complete technical documentation to ensure system is fully documented.
• Design and develop ETL using CDC using Power Exchange 8.6 in Mainframe DB2 environment.
• Created registration and data map for mainframe source.
• Created restart token for various workflows.
• Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy.
• Worked with SAP data Services for Data Quality and Data Integration.
• Participate in Developing PL/SQL procedures, Korn Scripts to automate the process for daily and nightly Loads.
• Developed complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy.
• Worked with Mapping/Session/Worklet/Workflow variables and parameters, running Workflows in RHEL Unixshellscript.
• Design and created Informatica recovery process for Real time workflows.
• Created restart token for various workflows.
• Created Unix script for identifying CDC hanging workflows.
• Involved in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables and Table portioning in DB level.
• Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production.
• Experience in writing SQL, PL/SQL codes, stored procedures and packages.
• Experience in full and partial push down optimization.
• Worked on Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensionaltables, Physical and Logicaldatamodeling using Erwin.

Environment: Informatica Power Center 8.6, Power Exchange 8.6, SQL Server 2008, Teradata V2R5, UNIX, Toad, Harvest, Sun Solaris and Erwin7.5.

Confidential, West Bend, WI

ETL Developer

Responsibilities:

• Analysedexisting Client systems to understand the existing architecture.
• Extensive experience in DataWarehouseDevelopment in Extraction, transformation and loading(ETL), Data Migration and Data Conversion Projects.
• Responsible for development of code on the basis of high-levelrequirementdocument.
• Developed complex ETL mapping and its corresponding sessions&Worklets, workflows and ETLmappingdocument for each Dimension and Fact table.
• End to Endtesting of Data warehouse/Data Mart load.
• Connection related issues were solved which includes server to databaseconnectivity, databaseconnectivity to importsource and targets in Informaticadesigner and get access to sourcedata.
• Performancetuning of Mappings, Session performance &Created Execution plan, run and monitor it.
• Building the reusablemapplets, Transformations and tasks to extract data from Oracle.
• Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer and MappletDesigner to Extract Sources, Transform Data and load into Target.
• Used Informatica Workflowmanager to create Workflows and Sessions.
• Developed effectivequery, performance tuning and optimization.
• Conducted Performance GapAnalysis to determine the components to be built for the development.
• Scheduled the workflows and monitored them

Environment: Informatica PowerCenter 8.6, MS SQL Server 2008, DB2, Oracle 11g, Windows, UNIX, Putty, Control M.

Confidential, Chicago, IL

Consultant Data Analyst

Responsibilities:

• Used SQLdeveloper to run the queries to verify the data with the existing GUI functionality.
• Involved in creation of testplan and testcases for testing the enhanced functionality of MBOX.
• Involved in documentation to describe development, logic, coding, testing, changes and corrections.
• Developed ETLcode by the businesslogic defined in the FunctionalDesignDocument.
• Analyzed the systems, met with end users and business units in order to define the requirements.
• Conducted businessrequirements and sourcesystemanalysis to arrive at optimal ETLdesigns.
• Extracteddata from various sources like Flat files, Oracle and loaded it into Target systems using Informaticapowercenter.
• Developed mappings using various transformations like updatestrategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center WorkflowManager to create sessions, batches to run with the logic embedded in the mappings.
• Tunedmappings and SQLqueries for better performance and efficiency.
• Performed Unittesting and validated the data.
• Created &Ranshellscripts in UNIX environment.
• Develops new ETL applications from simple to moderately complex scope, works with basic applications systems design specifications; and utilizes Company standards, procedures, and techniques.
• Partnering with project managers, development resources to assist with design changes and decisions.
• Worked with creation of reports for decisionsupport.
• Involved in analysis of the data in the development and testenvironment.
• Work with analogteam to test the existingapplication.
• Involved in logging defects in JIRA and monitor the progress until it goes to UAT environment.

Environment: Informatica Power Center 8.1, MBOX (digital and analog), Oracle 10g, SQL developer 2000, UNIX, Windows XP, JIRA

Confidential, Grand Rapids, MI

Informatica Developer

Responsibilities:

• Involved in creation of LogicalDataModel for ETLmapping and the process flowdiagrams.
• Worked with SQLdeveloper to write the SQLcode for datamanipulation.
• Worked on Informatica versionedrepository with check in and checkout objects feature.
• Used Debugger extensively to validate the mappings and gain troubleshooting information about data and error conditions.
• Provided guidance to less experienced personnel. Conducted quality assurance activities such as peerreviews.
• Participate in the businessanalysis process and the development of ETL requirements specifications.
• Worked with productionsupportsystems that required immediatesupport
• Develop, execute and maintain appropriate ETL development best practices and procedures.
• Assisted in the development of testplans for assigned projects.
• Monitor and tuneETL processes for performance improvements; identify, research, and resolve data warehouse load issues.
• Involvedin unit testing ofthe mapping and SQL code.
• Developed mappings to loaddata in slowly changing dimensions.
• Involved in performancetuning of source&target, mappings, sessions and workflows.
• Worked with connected, unconnectedlookups and reusabletransformations and mapplets.
• Utilized UnixShellScripts for adding the header to the flatfiletargets.
• Involved in designing the starschema and populating the fact table and associated dimension tables.

Environment: Oracle 10g, SQL Developer, Informatica Power Center 7.5,Sybase, Windows XP, Visio 2000, Business objects XIR2, Linux.