PROFESSIONAL SUMMARY:

• Around 7+ Years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart Data Warehouse applications using ETL tools like Informatica power center 9.x/8.x/7.x/6.x/5.x and power exchange 8.x
• Strong experience in Data Warehousing (ETL & OLAP) environment and acquired excellent analytical, co - ordination and interpersonal skills
• 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 implementing complex business rules by creating transformation, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup, Router, Rank, Joiner, Update Strategy), and developing complex Mapplets, Mappings, and Triggers
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center
• Extensive work experience in ETL processes consisting of data sourcing, data transformation, mapping and loading of data from multiple source systems into Data Warehouse using Informatica Power Center 9.5/9.1/8.6 and 7.1
• Good Understanding of relational database management systems, experience in integrating data from various data source like Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008/2012 , Teradata 13/12/V2R5, Flat files and XML, Netezza into staging area
• Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server
• Experience in Agile, Waterfall and UML Methodologies
• Experience in UNIX shell and batch scripting, Perl, FTP and file management in various UNIX/Windows environments
• Performed unit testing at various levels of the ETL
• Experience in production support to resolve critical issues and mingle with teams to ensure successful resolution of the reported incident
• Proficiency in writing technical documentation to describe program development, logic, coding, testing, changes and corrections

TECHNICAL KNOWLEDGE:

ETL Tool: Informatica Power Center 9.5/9.1/8.6/8.5/8.1 , Informatica Power Exchange 8.6/7.1, Informatica Power Connect

Databases: Oracle 10g/9i/8i/7.x, MS Access, Teradata 13/12/V2R5, DB2 UDB, SQL Server 2012/2008/2005

Data modeling Tools: Erwin r7/r4/r3.5, Microsoft Visio 2007/2010 and Power designer

Utility tools: PL/SQL, SQL* loader, TOAD

Operating Systems: UNIX, Linux,Windows XP/Vista/7/8, Windows server 2003/2008/2010

Scheduling Tools: Autosys, Control-M, and Microsoft Project

Programming Languages: HTML, PL/ SQL, ASP.NET, Java, UNIX Shell Scripting, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

ETL Developer

Responsibilities:

• Responsible for building the staging area tables by bringing data from different sources.
• Used Power Exchange as a connector for Power Center to import data from complex data 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
• Captured Incremental Data in Power Center using Power Exchange CDC.
• 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.
• 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
• Applied appropriate field level validations like date validations, Applying Default values for cleansing the data
• Prepared Test Plans and performed Negative testing, Positive testing
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Back end data validation and testing using SQL queries
• Reconcile and verify data mapping from flat file (source) to the target file
• Running the Jobs/Workflows for ETL process
• Prepared sql queries to verify the data and Verifying the ETL data in target database
• Column Mapping between source and target databases
• Designed and Peer reviewed the test cases.
• 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, PL/SQL server,Netezza, Unix/Linux, Autosys, XML Files, Flat files, HP Quality Center 10.0

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Created new Informatica mappings and modified existing mappings for the integration 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, Normalized 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, Terad ata 13, Sun OS 5.10, Control-M.

Confidential, Glendale, 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