EXPERIENCE SUMMARY:

• Five Plus years of experience in Information Technology with a strong background in Informatica Power Center, SQL and Data Warehousing.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tools Informatica Power Center 8.6./9.1/9.5
• Proficiency in using Informatica Power Center tool to design data conversions from wide Variety of source system.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping conversion and loading.
• Strong in Data warehousing concepts, Dimensional Star Schema and Snowflakes Schema methodologies.
• Extensively used Flat files to load data from source systems to targets using direct and indirect methods.
• Proficient in understanding business processes / requirements and translating them into Technical requirements.
• Extensively worked on Informatica Tools - Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Excellent knowledge of Teradata 14.0, ORACLE 9i/10g/11g, SQL Server 2005.
• Experience in integration of various data sources like Teradata, Oracle, SQL Server, Flat Files into the data warehouse.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Excellent expertise with different types of data load strategies and scenarios like Historical dimensions, Surrogate keys, Summary facts etc.
• Have performed various testing activities like unit testing, Integration-system Testing and user acceptance testing and ensured that the code is ideal.
• Experience in UNIX Shell Scripting on UNIX & Linux platform.
• Well-developed interpersonal and communication skills.
• Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet project & operational deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica Power center 9.5/9.1/ 8.6

Methodologies: Star Schema, Snow Flake Schema, FACT and Dimension Tables.

RDBMS: Oracle 11g/10g/9i, Teradata 14.0, SQL Server 2005/2000, MS Access.

Operating System: Windows 7, Windows Vista/XP/2000, UNIX/Linux.

Development tools: Toad for Oracle, Teradata SQL Assistance, SQL Developer. Programming/Languages SQL, PL/SQL, UNIX shell scripting, C, C++, Java.

PROFESSIONAL EXPERIENCE:

Confidential, Walpole, MA

ETL/Oracle PLSQL Developer

Responsibilities:

• Responsible for development of theETL(Extract, Transform and Load) usingOracle11g Database, Documented the Queries.
• Created Extract query from Oracle database joining many table using multiple table of joins as per the Report requirement for loading target database using SCOPE (ETL tool) tool.
• Created the Test Script/template for Query validation of source and target table.
• DevelopedOracle SQL Script for secondary Calculation for special type of report.
• Updated existing queries and views for eliminating extra table and removed it and added the new table for filter the data as per new ETL rules.
• Join the multiple table to get appropriate data as per Scope(Reporting tool) Requirement.
• Used multiple type of Join, Inner query, Sub query, Union, minus feature for fetch required data from tables.
• Tested source and target table using secondary calculation for validation.
• Created E-R Diagrams for understanding data flow queries for other user.
• Used TOAD for Oracle and SQL Developer to Developed SQL queries and validate and testing the data.

Environment: Oracle 11g, TOAD, SQL Developer, Relational Tables, Flat Files, Windows 7.

Confidential, Atlanta, GA

ETL Informatica Developer

Responsibilities:

• Responsible for development of theETL(Extract, Transform and Load) processes usingInformatica Power Center 9.5/9.1.
• Developed an ETL Informatica mapping in order to load data into staging area. Extracted from flat files and Relational Table and loaded into Teradata 14.0 and Oracle 11g target database.
• Worked with various Informatica Power Center tools - Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Workflow Monitor.
• Created mappings using the transformations likeSource Qualifier, Aggregator, Expression, Look Up, Router, Union, Update Strategy, Joiner, Sequence GeneratorsandStored Procedure and created and usedreusable Mapplets.
• Used mappingParametersandVariables.
• DevelopedTeradata Stored Programs (Procedures, Mecro and Functions )for load the on the fly table for special type of report.
• UsedWorkflow Managerfor Creating, Validating, Testing and Running the sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• CreatedSessions,WorkletsandWorkflowsfor carrying out test loads.
• Done Error Handling and debugging using Informatica debugger, Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Closely worked with the Cognos report developer to ensure that correct data is presented in the reports.
• Update the source view and target table definition as per the requirement change.
• Used Teradata SQL Assistance, TOAD for Oracle to run SQL queries and validate and testing the data.

Environment: Informatica Power Center 9.5/9.1, Teradata 14.0, Oracle 11g, Teradata SQL Assistant, TOAD, Relational Table, Flat Files and Windows 7.

Confidential, MA

ETL Developer/Data Specialist

Responsibilities:

• Responsible for development of theETL(Extract, Transform and Load) processes usingInformatica Power Center.
• Developed an ETL Informatica mapping For Extracting data from different type of source like flat files and Relational Table and loaded into Oracle 10g target database.
• Worked with Source Analyzer, Target designer, Mapping Designer & Mapplet, Transformations -various Informatica Power Center tools.
• Used transformations likeSource Qualifier, Aggregator, Expression, Look Up, Router, Filter, Update Strategy, Joiner, Sequence GeneratorsandStored Procedure for Creating Informatica mappings.
• UsedSlowly Changing DimensionMappings of type II and I.
• Createdreusable transformationsandMappletsand used them in complex mappings.
• Transformationsand integrate them with Informatica programs.
• UsedWorkflow Managerfor Creating, Validating, Testing and Running the sequential and concurrentBatchesandSessions, scheduled them to run at a specified time.
• Used mappingParametersandVariables.
• CreatedSessions,WorkletsandWorkflowsfor carrying out test loads.
• Analyzed Session log files to resolve errors in mapping and managed session configuration.
• Created, configured, scheduled and monitored the sessions and workflows on the basis of run on demand, run on time using Informatica Power Center Workflow Manager.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Used SQL developer, TOAD to run SQL queries and validate and testing the data.

Environment: Informatica Power Center 9.1/8.6.1, Oracle10g, SQL Server 2008, TOAD, SQL developer, Relational Table, Flat Files, Linux, Windows XP.

Confidential

Informatica Developer

Responsibilities:

• Developed and implemented ETL processes using Informatica Power Center to move data from different sources into Data mart.
• Knowledge of Repository, Folders, Users, and user privileges using Repository Manager.
• Define, create and access data source layouts and target data warehouse and data mart Schemas through Informatica Power Mart Designer.
• Developed various Mappings, Transformations and Mapplets for migration of data using Informatica Designer.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookups, Update strategy, router, joiner, rank, sequence generator transformations in Informatica.
• Prepared SQL Queries to validate the data in both source and target databases.
• Done data migration, data cleansing and aggregation while transformation.
• Done Performance tuning in Informatica level.
• Done Error Handling and debugging using Informatica debugger.
• Involved in Performance tuning of various queries understanding the need of indexes after having complete note of the Explain Plan.

Environment: Informatica 8.6 Power Center, SQL, PL/SQL, Oracle, TOAD, Relational Table, Flat File and WINDOWS XP.

Confidential

Jr. ETL Developer

Responsibilities:

• Understood the business requirements to transform the data.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Utilized Informatica to develop detailed mappings for data extract, transformation and loading.
• Involved in development/testing of Mapping using Informatica Designer, Debugger.
• Worked with Informatica Transformations like Sorter, Filter, lookups, Update strategy, router, joiner, rank, sequence generator
• Created parameter files, session and workflow and worked with workflow monitor to monitor running workflows.
• Supported DBA functions such as creating user account, grant permissions, ran some DDL and DML Script, Schema Scripts.
• Wrote PL/SQL stored procedure, triggers and function to implement business rules using SQL Developer and Toad.
• Developed SQL Scripts for extracting the data from the Oracle tables.
• Developed complex SQL queries, PL/SQL programs, procedures, functions, database triggers, tables, views, packages Using Toad Developer Tool.
• Involved in Creating indexes and dropping indexes as per the requirement.
• Creating table, update table and deleting unwanted table from the database as per the requirement.
• Reducing the bottlenecks helping the query to execute by dropping or creating the indexes as per required.

Environment: Informatica 8.1 Power Center, SQL, PL/SQL, Oracle, TOAD, SQL Developer, Relational Table, Flat File and WINDOWS XP.