SUMMARY

• Over 6+ years of Experience in all the phases of the Data warehouse life cycle involving design, development & analysis and testing of Data warehouses using ETL.
• Designed and developed different slowly changing dimension procedures for multiple data extracts based on business requirements.
• Strong in DWH concepts, Dimensional Table, Fact Table, Dimensional Data Modeling, Star Schema and Snowflakes Schema methodologies.
• Extensive knowledge in design of Extract, Transform, Load environment usingInformaticaPowerCenter9.1/8.x/7.x/6.x.
• Extensively worked on ETL process consisting of data transformations, data sourcing, mapping, conversion and loading.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, WinSQL, SQL*Loader,Netezza
• Extensively worked withNetezzadatabase to implement data cleanup, performance tuning techniques.
• Experience in managing SSIS packages and DTS 2000 packages within SQL Server Management Studio(SSMS)
• Expertise in creating reports using SQL Server Reporting Services (SSRS), Crystal Reports and Excel Spreadsheet.
• Experienced in Performing Unit testing, system testing and system integration testing.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situations at all levels.
• Have Experience in designing and developing UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from & too different servers.
• Have ability to understand and interact with technically-oriented team members. Skilled in using MS Office applications for day to day activity, MS Visio for drawing flow diagrams.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.

TECHNICAL SKILLS 
Operating Systems : UNIX, Linux, Windows XP/2000/98/95
Databases : Netezza4.6.8, Oracle 10g/9i/8i/7.x,
ETL Tool : InformaticaPower Center 9.x/8.6/8.5/8.1, 7.1, 6.2/6.1
Business Intelligence Tools: Business Objects, Micro Strategy 8x/9x
Office Tools : MS Excel, Access, Visio, PowerPoint, Word

Client:Confidential, Manchester, NH May 2011-Present
Sr. ETL Developer

Project 
Confidential is one of the world\'s leading media, entertainment and communications companies. Comcast is principally involved in the operation of cable systems through Comcast Cable and in the development, production and distribution of entertainment, news, sports and other content for global audiences through NBCUniversal. Comcast Cable is one of the nation\'s largest video, high-speed Internet and phone providers to residential and business customers.

Responsibilities:

• Expertise in of the Extract, Transform and Load process and development of transformation standards and processes usingInformaticabest practices.
• Designed the architecture of customer master Project in team.
• Usedinformaticapower center 9.0.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources likeOracle and flat files.
• Used various transformations like Source Qualifier, Lookup, Router, Filter, Update, Expression, Aggregator, Sorter, Sequence Generator etc.
• Used unconnected lookup where different expressions used the same lookup and had multiple targets, which use same logic executed and return one value.
• Developed mappings of Customer, Specialty, State license number, Organization, Provider and Location dimensions implementing the ETL logic.
• Loaded Data into target Data warehouse from 12 different sources.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouseNetezzatables usingInformaticaWorkflow Manager.
• Used workflow monitor to see the work flows running and get the session properties and session log.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Created workflow documentation for each of the developed mapping.

Environment:Netezza4.x, Oracle 10g,InformaticaPower Center 9.0.1 , Flat Files, Unix Shell scripts, Windows XP. 

Confidential, MI Jan’10 – Mar’11
Informatica Developer

Confidential implemented several programs that are designed to help its schools ensure they are safe and supportive, there by improving student outcomes. MDE is conducting surveys during the school year and compiles the responses to assess schools in multiple dimensions (Safety, Bullying, Drug and Alcohol usage, Violence etc). Informatica is used to extract survey data and apply business rules and the data is loaded into the reporting database. The extracted data is used for generating reports.
Responsibilities:

• Interacted with business users and gathered requirements based on the changing needs. Incorporated identified factors into Informatica mappings to build the DataMart.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in system documentation of dataflow and methodology.
• Created technical design specification documents based on the functional design documents and the physical data model.
• Responsible for design and developing of ETL (Extract, Transform and Load) processes usingInformatica PowerCenter8.6.1/8.5.1.
• Extracted data from data Sources like Flat files, Relational Databases and Heterogeneous sources.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Used transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, Lookup, Rank, Joiner, Expression and Update Strategy in the mappings to meet business needs.
• Worked on Mapping parameters, Mapping variables and passing parameters between sessions.
• Worked extensively on schema (Star schema) creations in data warehouse.
• Created sessions, batches for incremental load into staging tables, and schedule them to run daily.
• Involved in performance tuning in the ETL processes.
• Worked on slowly changing dimensions(Type1 and 2)
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used SQL tools likeWinSQL to run SQL queries and validate the data in warehouse.

Environment: Informatica Power Center 8.6.1/8.5.1, Oracle 10G/9I, WinSQL, Windows XP/2008, Microsoft Office 2007, Unix Shell Scripting.

Confidential, New York, NY Jul’08 – Dec’09
ETL Consultant

This Data Warehouse was designed for the Business Line Reporting for Confidential. This warehouse reports the historical data stored in various databases and Flat Files. Data from different sources was brought intoNetezzausingInformaticaETL.

Responsibilities:

• Analyzed the source data coming from Oracle, Flatfile . Worked with Data Warehouse team in developing Dimensional Model.
• UsedInformaticaDesigner to create mappings using different transformations to move data to a Data Warehouse. Developed complex mappings inInformaticato load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner, and Rank.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse usingInformaticaWorkflow Manager.
• Involved in identifying the bottlenecks in Sources, Targets & Mappings and accordingly optimized them.
• Worked with NZLoad to load flat file data intoNetezzatables.
• Good understanding aboutNetezzaarchitecture.
• Assist DBA and Architect to identify proper distribution keys forNetezzatables.
• Created mappings using pushdown optimization to achieve good performance in loading data intoNetezza.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouseNetezzatables usingInformaticaWorkflow Manager.

Environment:InformaticaPower Center (Designer 7.x, Repository Manager 7.x, Workflow Manager 7.x), Flat files,Netezza4x, UNIX, WinSQL and Shell Scripting

Confidential, NY July 07 - Jun’08
Informatica Developer

Worked as Informatica developer to design and develop mappings to load into Data warehouse. The project involves building and maintaining data warehouse to meet the organization reporting needs. Data warehouse will function as the central repository of all sales data which is extracted from various sources and loaded into Data warehouse.
Responsibilities

• Worked closely with the Data Modelers for Designing and customizing data models for Data warehouse, supporting data from multiple sources in real time.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, and Union to develop robust mappings in the Informatica Designer.
• Developed Mapping parameters and Variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loaded into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Involved in performance tuning for sources, targets, mappings and sessions.
• Involved in preparing the migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 7.1.4/7.1.1, Oracle 9i, SQL Plus, Windows 2005/XP, Microsoft Office 2003, Shell Scripting.
Confidential, Los Angeles, CA March 06 - July 07
ETL Developer

Confidential is an international biotechnology company headquartered in the Newbury Park section of Thousand Oaks, California. The sources of the data consist of feeds from applications residing on the mainframe to applications residing on Netezza and Oracle. The data is extracted from the various sources and is loaded into the staging tables from where it is consolidated and a number of measures are calculated and is finally loaded into the data mart.

Responsibilities

• Worked with business analysts to identify appropriate sources for Data warehouse and to document business needs for decision support data.
• Designed the ETL processes usingInformaticato load data from Flat Files to target Oracle Data Warehouse database.
• Performed data manipulations using variousInformaticaTransformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Involved in creating logical and physical data modeling with STAR and SNOWFLAKE schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Written SQL overrides in source Qualifier according to business requirements.
• Written pre session and post session scripts in mappings.
• Created sessions and workflow for designed mappings.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
  Developed PL/SQL procedures for processing business logic in the database.
• Migrated the mapping to the testing and production department and introduced the concepts ofInformaticato the people in testing department.
• Produced documentation as per the company standards and SDLC.

Environment:Informatica6.x,Netezza, ORACLE9i ,UNIX, Windows NT, UNIX Shell Programming.

EDUCATION:
Certification in MIS, 
B. Sc. Computer Science,