SUMMARY

• Seven Years of experience in Development and Maintenance of various software applications emphasizing on Data warehousing and IT
• 5+ Years of Data Warehousing ETL experience using Informatica Power Center 9.1/8.6
• Domain experience in Healthcare, Retail and financial
• Experience in the Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas and Snow flake Schemas
• Relational and Dimensional Data Modeling experience
• Extensively Worked on Data warehousing with Data Marts, ODS, Data Modeling, Data Cleansing, ETL tool Informatica
• Experience in working with data extraction, transformation and loading using Informatica Power Center
• Experience in working with all Informatica Power center modules like Designer, workflow manager, workflow monitor
• Experience in integration of various data sources like Oracle, Flat files, Netezza and Teradata
• Executed Workflow using Unix Shell Scripts.
• Experience in using Unix Shell Scripts to check the status of Integration Service.

TECHNICAL SKILLS

ETL Tools: Informatica 9.1/8.x/7.x

Data Modeling: Erwin 4.0/3.5, MS Visio.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000, DB2, Teradata.

Languages: T - SQL, PL/SQL, Unix Shell Script, XML, Java, ASP.Net

DB Tools: Toad, SQL* Loader, DB Visualizer, SQL Navigator.

Scheduling Tools: Corn tab, TWS, Autosys, Control-M.

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Responsible for building the staging area tables by bringing data from different sources.
• Developed Informatica mappings, sessions and workflows
• Designed and developed complex ETL mappings making use of transformations like router, update strategy, lookup, expression, joiner
• Handled different relational data Sources like sql server, oracle, flat files data using Informatica.
• Loaded historical data & current data
• Optimizing SQL Queries, trouble shooting and tuning the Informatica mapping for performance.
• Developed process for error handling and auto reloading.
• Created reusable objects in Informatica for easy maintainability and reusability
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Analyzed the exceptions rose during the ETL process and resolved them.
• Involved in performance tuning of Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Created and used different Tasks like Decision, Event Wait, Event Raise, Timer and E-mail etc.
• Responsible for regression testing ETL jobs before test to production migration.
• Created unit test cases and prepared documents for QA
• Executed Workflow using Unix Shell Scripts.

Environment: Informatica Power Center 9.5.1, Oracle 11g, sql server, Netezza, Unix/Linux, Autosys

Confidential, Raleigh, NC

ETL Developer

Responsibilities:

• Created new Informatica mappings and modified existing mappings for the intergration project
• Worked on Informatica tool - Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations
• Applied the Business logic in Populating the necessary integration tables
• Using Informatica Designer designed Mappings that populated the Data into the Target Star Schema
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Router, Normalizer etc.
• Conducted SQL testing for DB sources for Insert and Update timestamps, Counts, Data definitions, Control, and Error logic for Facts and Reference tables
• Involved in performance tuning of the Mappings, SQL statements, Query optimization, and Explain Plan utilities for Optimum Performance and used Informatica Debugger
• Used data base objects like Materialized views, Sequences, Parallel Partitioning and Stored Procedures for accomplishing the complex logical situations and Memory Management

Environment: Informatica 8.6, Oracle 10g, Teradata 13, Sun OS 5.10, Control-M.

Confidential, CA 

Data Warehouse Developer

Responsibilities:

• Analyzed the source data arriving from different source systems like Vendor Management Inventory, Invoice Processing System, Materials Forecasting, Purchase Orders and Requisition on Stores
• Extensively worked with SQL / PL/SQL Concepts like Developing Data base objects, Involved in Performance issues
• Metadata driven utility design for Data Extraction, Transform and Data processes using Informatica Power Center
• Used Informatica Designer to create complex mappings, transformations, and source and target tables
• Administer the repository by creating folders and logins for the group members and assigning necessary privileges
• Performed Type1 and Type2 mappings
• Created Tables, Stored procedures, Functions, and Queries in Oracle SQL/ PL/SQL
• Used session parameters and parameter files to reuse sessions for different relational sources or targets
• Developed PL/SQL and UNIX Shell Scripts
• Created sessions & Batches using Server Manager to load the data into the Target Database

Environment: Informatica 7.1.2, Oracle 9i, SQL,TOAD, UNIX