SUMMARY

• Data warehousing and ETL Solutions Developer with over 9 years of development and design experience.
• Excellent knowledge of building DW and OLTP systems and applying ETL methodologies in VLDB (multiple terabytes) environments in the pharmaceutical, media, Healthcare, finance, and Insurance industries.
• As designer and developer, delivered numerous high - performance ETL Solutions built on integrated, scalable, and extensible platforms. Can quickly understand business requirements and provide end to end innovative solutions for the same.
• Dedicated professional with strong technical, analytical, oral, problem solving, written skills and a committed team player, always involving in performance tuning of Informatica mappings and sessions.
• Experienced in loading data into Data Warehouse/Data Marts using informatica, Oracle, SQL Server and SQL * Loader.
• Extensively used Erwin to design Logical/Physical Data Models, forward/reverse engineering modeled the Data Warehousing Data marts using Snow/Star Schema.
• Experienced in Client/Server technology area with Oracle Database, SQL Server and PL/SQL for the back end development of packages, Stored Procedures, Functions and Triggers.
• Experience in analytical, programming, written and verbal communication skills with ability to interact with individuals at all levels.
• Excellent Team player and can work on both development and maintenance phases of the project.
• Developed processes for IDQ, Transforming, Extracting, Integrating and Loading data with use of Informatica Power Center.
• Self motivated, Adaptive to new and challenging technological environments.
• Worked with the team in ILM which helps to understand life cycle and improve the standard and performance using informatica
• Determines Customers Business Requirements and establish a strategy / road map for DW/ETL solutions.
• Provide ETL Implementations from inception to final implementation to meet Clients deliverable and deadlines.
• Executed Client Assessments, Designs, Specifications, Data Mapping and Test plans/scripts.
• Performance tuning and Optimization techniques.
• Extensively worked on Informatica tools Repository manager, Designer, Work-flow manager, Work-flow monitor.
• Hands on databases like Oracle 11i/10g/9, MS SQL server 2005/2008, DB2, Teradata.
• Use of Database tools such as SQL*Plus, Toad, SQL Navigator, SSIS .
• Experience in usage of Operating Systems such as UNIX, WINDOWS XP/NT/2000/98/95.
• Hands on languages such as C, SQL, PL/SQL, XML.
• Created mappings using the transformations like Source qualifier, SQL, Aggregator, Expression, look-up, Router, Filter, Update Strategy, Joiner, Stored procedure and etc. transformations.

PROFESSIONAL EXPERIENCE

Confidential, ATL,GA

ETL Developer

Responsibilities:

• Worked closely with design team, shared ideas with them for building an Mexico, Argentina and Uruguay data warehouse and also suggested schema names.
• Helped in developing Star Schema by following referential integrities among Facts and Dimensions.
• Assed in assigning needed attributes required for 22 facts and dimensions and also assigned privileges to various users to do testing and data validations.
• Data is loaded into GDW database in schemas NGDWSRC in the form of SAP Idocs which is transformed and loaded into schema NGDWSTG with integration of CRM data from great plans.
• Data loaded into NGDWSTG is than transposed into final NGDWDM schema using incremental load.
• Developed new mappings and loaded 22 facts and dimension tables and also improved the performance of those mappings by doing performance tuning.
• Implemented SCD type1 and SCD type 2 logic at various stages in loading data into final tables.
• Deployed mappings in various environments from DEV to QA and finally to PROD using deployment groups and Export/Import.
• Dynamically created parameters in target directory and used them subsequently at various session levels to do incremental load.
• Wrote new Functions, Store Procedures and called them at various mappings.

Environment: Informatica Power Center 9.1, Visio, Oracle 11g,, Toad 11g, SQL Server version 2008 .

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Worked on creating new mappings to load the fact tables keeping referential integrity with the dimension tables based upon the study ids.
• Loading the history tables in parallel to the fact tables based upon SCD type 2 with new timestamps and existing timestamps.
• Optimizing the existing mapping before sending to production by checking sorted inputs when getting tables from multiple databases at joiner transformation and also checking sequence of columns to find the checksum when working on CDC.
• Loading the data into EDW schemas from CAL components RDM and CDM and putting the timestamps for those records.
• After successful loading of Edw schemas they are subsequently loaded into ODS schemas based upon incremental loading.
• Refactoring of the sql query for loading tables in various environments R3 to R4 based upon the business requirements.
• Dynamically created Parameters in target directory and used them at workflows for various session when doing an incremental load.
• Deployed mappings using deployment groups or export/ import from Dev. to Test for further testing and finally to Prod at the Informatica Repository Manager.
• Understand the sql query sent and respectively created mapping based upon those queries, also improve performance of the mapping by balance the load to database and Informatica respectively.
• Worked in creating web Intelligence reports individually and with team using business object
• Understand and analyze universe with different relations to the various entities and their join conditions.

Environment: Informatica Power Center 9.5, Visio Oracle 11g,, Toad 11g, Erwin 7.2,Business Objects 3.1.

Confidential, Kansas, MO

ETL Lead Developer

Responsibilities:

• Migration of workflows from Teradata prods to Oracle prod. The version used is informatica power center 9.0.1.
• All the workflows are tested in QA Oracle environment and migrated into Oracle prod. They are thoroughly optimized for speed and also to improve performance.
• All the workflows are assigned with integration server after successfully migration into various environments.
• Every day loads are monitored and also followed up with users for any delay in source files or missed files to finish daily loads based on which reports are triggered.
• Kick off various workflows using schedule task and command tasks and also delete the source files immediately after they are loaded so that we can receive next day new source files and load new data without any replication of data.
• Processed monthly loads every month by using TCG Spinoff process which would get records for the current month and also for subsequent months to load costs.
• Keep in touch frequently with database people for analysis of store procedure which are used to do direct insert or updates to particular backup tables.
• Trigger reports based upon completion daily loads
• Designed and Developed Informatica Data maps to pull data from source systems and implemented various filter criteria’s which will be useful while pulling the data from source systems
• Worked with team on informatica ILM to reduce storage, control data growth, and improve performance of databases and application as a part of effective application information life cycle management.
• Enhanced ETL routines to maintain current and history data in major base tables by using CDC(Change Data Mechanism) with informatica Type-2 logic.
• Worked in creating web Intelligence reports individually and with team using business object.
• Understand and analyze universe with different relations to the various entities and their join conditions.

Environment: Informatica Power Center 9.0.1, Visio Oracle 10g, Teradata, Toad, Erwin 7.2, Business objects 4.0 .

Confidential, Chesterbrook, PA

ETL Lead Developer

Responsibilities:

• Involved in doing low level design documentation with the team and also analyze high level flow of the data with the requirements provided.
• Worked as team in integration of the workflows and represented team in coordinating the same to next level superiors as necessary.
• Worked from staging to hub doing an incremental load of data using parameters both at session level and also at workflow levels.
• Was responsible in doing unit testing and migrated informatica mappings and sessions to various environments such as testing and productions, and also resolved after production issues for existing mappings according to users needs.
• Worked on creating headers and footers for the flat files and also worked on checking the quality (IDQ) of data based upon the tolerance levels assigned according to company standards to accept the data into relational tables or to refuse the data.
• Worked on Account management, Product management, territory management for the sales rep and do necessary changes with data for new reps recruited and also updated changes of territories for existing sales reps.
• Worked on slowly changing dimensions like type 2 and 3 and also assign flags for logical deletes in the mappings.

Environment: Informatica Power Center 9.0.1, Power Exchange, Force.com, Apex Explorer, SQOL, Netezza, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin, & UC4,SSIS.

Confidential, Temecula, CA

ETL Developer

Responsibilities:

• Managed projects by providing analysis, design and ETL development for a broad variety of Managed Territory Alignment, Product Management, Account Management, Brand Segmentation, and Formally Management -requirements for sales force.
• Responsibilities include maintaining the ETL best practices and guidelines and enforcing them at enterprise level, mentoring direct and indirect reports.
• Responsibilities include data analysis for identifying domain of values, data integration issues, data inconsistencies and identifying cleansing issues and finally reporting data validation reports.
• Data Integration (project to merge and link data from various disparate sources into standardized ODS and loading into Veeva/iRep Application load.
• Experience in SFDC development using Force.com SOQL.
• Delivered Custom Alignment, Targeting Process, Call Center and iRep (i Pad) application apart from supporting above Veeva Modules
• Was responsible for Unit testing and migration of Informatica mappings and sessions to Quality assurance and Production standards and doing performance tuning on the mappings and session. i Cue Data loads (SFA Data Integration) from Veeva to DWH and back to Veeva
• Agile development methodology using configuration and change management.
• ImplementedVariablesandParametersin the mappings for incremental data loads.

Environment: Informatica Power Center 9.0.1/8.6, Power Exchange 9.x/8.6, Force.com, Apex Explorer, SQOL, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin, Autosys and BOBJ,SSIS.

Confidential, Fremont, CA

Responsibilities:

• Involved in analysis of source systems, business requirements and identification of business rules and creating low-level specifications.
• Responsible for developing, unit testing and supporting various testing phases for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Extracted data from various source systems like XML, flat-files, CSV, Oracle
• Implemented Slowly Changing Dimensions (Type 1 2, & 4).
• Created mappings using the transformations like Source qualifier, SQL, Aggregator, Expression, look-up, Router, Filter, Update Strategy, Joiner, Stored procedure and etc. transformations.
• Instrumental in performance tuning of mappings/session at database and Informatica level to improve ETL load timings.
• Involved in the process in documentation of source-to-target documentation design documentation of the Data Warehouse Dimensional Upgrades. Extensively used Informatica for loading the historical data from various tables for different departments.

Environment: Informatica Power Center 8.6, SQL/PL SQL,MS SQL Server, Oracle 10g, XML, Toad, SQL Navigator,SSIS.

Confidential, Pittsburgh, PA

Responsibilities:

• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer and Informatica Repository Manager.
• Unit testing/integration testing of Informatica mappings and procedures.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Look-ups, Source filter in Source Qualifier and data flow management into multiple targets using Router transformations
• Involves in maintenance issues, analyzing data discrepancies, enhancements, escalation and providing resolution for technical issues.
• Keep track of new changes raised and smoothly deploy them through production.
• Supporting System & Integration testing, User Acceptance Testing
• Created themappingsusingtransformationssuch as the Source qualifier, Aggregator,Expression, Look-up, Router, Filter, Joiner and Update Strategy that extracted data from various sources
• Extensively worked with Slowly Changing Dimensions Type1, Type2, for Data Loads
• Involved in design and development of common framework forerror logging and parameter managementfor the project.

Environment: Informatica Power Center 7.1.2, SQL/PL SQL, Oracle 10g, 4D, Toad

Confidential, Piscataway New Jersey

ETL Developer

Responsibilities:

• Created technical and design specification documents for Informatica mappings using best practices and quality assurance standards for ETL solutions Designed and created ETL Architecture for automated ETL runs. Created complex Informatica mappings and Production support for the same.
• ImplementedSlowly Changing Dimensions methodologyto keep track of historical data.
• Extensively worked on performance tuning andheader and footer file isolation in a singletextfile.
• Extensively used Oracle Database Partitioning for many ODS and Data mart tables using oracle 9i Created stored procedures in Oracle to be called from Informatica sessions to create temp tables dynamically and exchange them with master tables using oracle partitioning. Performance tuning of mappings as the database is in terabytes and each run accounting to around 150 millions plus rows for each table. Unit and integrated testing for data in VLDB databases for performance and data correctness.Worked with business users to understand NDC data and deliver Early View, Final View (Weekly) and Monthly Projections data.
• Created complex Informatica mappings with transformations involving stored procedure and reusable transformations through Informatica, UNIX Korn Shell to load data from flat files and other data sources into the staging, Conformed area and the data mart of the oracle database.

Environment: Informatica Power Center 7.1.2/6.1.1 , DB2,COBAL,XML, Flat-files, Oracle 9i, 4D, Toad

Confidential, Oldsmar, FL

ETL Developer

Responsibilities:

• Worked onInformaticatools Source Analyzer, Warehouse designer, Mapping Designer and Work-flow Manager and work-flow Monitor.
• Created Reusable Transformations andMapplets to use in Multiple Mappings
• Created mappings for Staging/Data Mart using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, joiner, Stored Procedure, look-up, update strategy, Sequence generator and Normalizer.
• Performance tuning for data loads at Informatica session/ mappings levels and SQL queries on Oracle database.
• Designed the mappings between sources (external files and databases) to operational staging targets.
• Involved in data cleansing, mapping transformations and loading activities.
• Developed Informaticamappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Used Informaticadebugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Implemented Slowly Changing Dimension methodology for Historical data.
• Designing mapping templates to specify high level approach.

Environment: Informatica Power Center 7.1.2, Oracle 8i, Flat-file, Toad