PROFESSIONAL SUMMARY:

• Around 7 years overall experience in the Information Technology Industry.
• Experienced in design, development, and documentation and testing of ETL jobs using Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange
• Experience in all the phases of Data Warehouse Life Cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Worked on software development methodologies such as Waterfall and Agile.
• Strong experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata, DB2, and worked on integrating data from XML files and flat files like fixed width and delimited
• Experience in AIX - UNIX working environment, writing AIX-UNIX shell scripts for Informatica pre & post session operations
• Experienced with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Implemented Slowly Changing Dimension (SCD) methodology for accessing the full history of accounts and transaction information and Change Data Captures (CDC).
• Extensively used Partition by Range, Partition by Hash Function, Sub Partition, and List Partitions.
• Moved Data from external source into Oracle Database using SQL Loader.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Solid experience in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling using Erwin
• Experienced in coding using SQL, PL/SQL stored procedures/functions.
• Experienced in Performance of Mapping Optimizations in Informatica.
• Good Experience in writing Test plans, Test cases, Unit testing
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

SKILLS:

Data Warehousing/ETL: Informatica Power Center 9.1/8.x, Informatica Power Exchange 8.x, Data Profiling, Data cleansing, OLAP,MDM

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling, Erwin 4.5, 4.0/3.5.2,MS-Visio.

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005 , Teradata, My SQL, DB2, MS-Access, Mainframes

Programming: SQL, PL/SQL, HTML, C, Core Java, UNIX Shell Scripting.

Environment: Win XP/2000/NT/Server, UNIX, Sun Solaris, IBM AIX

Other tools & Utilities: SQL*Plus, SQL Developer, Toad, Autosys, MS-Office, FileZilla.

PROFESSIONAL EXPERIENCE:

Confidential, Bluffton, SC

Sr. Informatica Consultant

Responsibilities:

• Involved in analysis, requirements gathering, function/technical specifications and development, deploying and testing.
• Prepared LLDs based on the HLDs to meet the business requirements
• Created Complex Informatica Mappings to load data using transformations like Source Qualifier, Aggregator, Expression, Router, Union, and Joiner, Connected and Unconnected lookups, Filters, sequence generator and Update Strategy.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Developed the mapping to pull the information from different tables and used SQL Override to join thetables instead of Joiner transformation to improve the performance
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Reviewed and validated the ETL mappings and data samples loaded in the test environment for data validation.
• Developed Unix Shell scripts to Migrate data from different legacy systems in databases.
• Incorporated policy/rule/plan for sensitive elements to be masked using ILM tool
• Used ILM tool to mask the sensitive data as per the business requirement document.
• Worked on Informatica Power Exchange to pull policy data from Mainframe system for a specific business requirement.
• Created and Configured Workflows and Sessions to transport the data to target warehouse tables using Workflow Manager.
• Created Informatica parameter files with workflows and sessions. (For batches and segments).
• Created reusable sessions and workflows.
• Developed Shell scripts using UNIX to drop and recreate indexes and key constraints.
• Used Autosys for scheduling the workflow level tasks.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. And also to debug the mapping the failed session.
• Involved in analyzing performance-related issues.
• Involved in partitioning the warehouse tables, configuring partitioned sessions for performance improvement.
• Developed data mapping spread sheet to present the transformation process.
• Tuning the ETL-Informatica code in Mapping level, and session level.
• Involved in Code migration from Informatica 8.6.1 to Informatica 9.5.1/9.1
• Involved in migrated the dev objects from Dev Repository to Test repository.
• Performed unit testing to validate the data loads in different environments
• Resolved the defects and updated in quality center which are raised by the QA team.

Environment: Informatica Power Center 9.5.1/9.x/8.6., Power Exchange, Erwin 4.5, Flat files, Oracle 11g/10g, MS SQL Server 2005/2000, PL/SQL, Autosys, Shell Programming, IBM DB2 8.0

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Worked on power center designer client tools like source analyzer, warehouse designer, mapping, Mapplet designer, workflow manager, workflow monitor and transformations developer.
• Status reporting for offshore development.
• Worked with the Business Analysts to gather Requirements and to implement business
• Responsible for testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Analysis of data-mart requirements and source-maps.
• Creation of technical requirement documents.
• Extensively worked with history and incremental loading using parameter files, mapping variables and mapping parameters.
• Developed Informatica parameter files to filter the daily data from the source system.
• Used Informatica MDM for Data cleansing.
• Resolved Inconsistent and Duplicate Data to support strategic goals with Multi domain MDM
• Built Workflows and Worklets to schedule, sequence and parameterize data loads into the different DataMart’s and the Enterprise Data Warehouse.
• Worked extensively on different types of transformations like source qualifier, expression, aggregator, router, connected and unconnected lookup, sorter, normalizer and sequence generator.
• Creating sessions, Worklets and workflows for carrying out test loads. Performed the performance evaluation of the ETLs for full load cycle.
• Supported the UAT and production deployment.

Environment: Informatica 8.6, Oracle DB, Flat Files, MS Excel, SQL, TOAD, UNIX, MS Word, FileZilla,SQL Developer.

Confidential, Warren, NJ

Informatica Developer

Responsibilities:

• Taking Knowledge transfer sessions i.e. Requirement gathering from client and delivering same to the offshore team.
• As an onsite coordinator, I am responsible for weekly status meeting and answering all question asked by client.
• Analyze of the Change Request (CR) raised by the client and understand the problem area.
• Responsible for designing and preparing AUDs and Technical Design Documents for client, offshore team.
• Responsible for getting sign off from client and maintaining all documents and their versions of same on share point.
• Responsible for Deployments of all developed code to TEST environment and providing on call support along with WebEx meeting while deploying the code
• Scheduled ETL process on daily basis, weekly Basis, monthly basis.
• Scheduling the sessions to load the data into the target for testing.
• Tuned queries for performance improvements.
• Performing Unit Test and preparing the Test Cases for all possible scenarios and maintaining UTPs as well as integration testing of the system with full load.

Environment: Informatica Power Center 8.6.1/9.1, Oracle 10g, SQL Server 2005, SQL Developer, UNIX, Erwin 4.0, SQL, PL/SQL, Windows XP

Confidential, Wisconsin

Informatica Developer

Responsibilities:

• Involved in the design, development and implementations of the Enterprise Data Warehouse (EDW) process and Data mart.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy and Sequence Generator etc.
• Worked Efficiently with Designer tools including Source Analyzer, Warehouse designer, Mapping.
• Extensively used SQL coding for overriding the generated SQL in staging and also tested the data loaded into the database.
• Created reusable transformations and Mapplets to use in multiple mappings.
• Gained knowledge with MDM Core components such as Hub Server, Hub Cleanse, Hub console, Cleanse Adapters and Hub Resource Kit.
• Maintaining existing data flow mappings and fixing any defects associated with them as reported by the QC team.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Handled large volumes of data warehouse database.
• Unix Scripts were written at various situations like event automation and job scheduling.
• Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas as per client requirements.

Environment: Informatica Power Center 8.6, Oracle 9i, UNIX, SQL*Plus, Windows NT/XP, SQL Developer.

Confidential

ETL Developer

Responsibilities:

• Coordinated with Business Analysts in gathering and analyzing the user requirements.
• Development of different types of fact and dimension, loading mappings using Designer Tool, Integration of data from different sources and identifying the significant fields for extraction.
• Worked extensively on different types of transformations like normalizes, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 8.1/8.6.
• Developing and testing all the Informatica mappings involving complex Router, lookups and update strategies.
• Created workflows and sessions to run the mappings.
• Implemented variables and parameters in the mappings.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.
• Wrote stored PL/SQL procedures for certain Business Requirements.
• Monitoring the Workflows, Worklets and Tasks using Workflow Monitor Tool
• Fix the bugs using Debugging Tool in the Designer
• Observing and curtailing the Performance bottlenecks at different stages like Sources, Targets, Mappings and Sessions
• Validating the data in the database.
• Perform unit testing using test cases and validate the data as per business requirement.

Environment: Informatica Power Center 8.1/8.6, Oracle, SQL, SQL*Plus, PL/SQL, DB2, Windows NT, UNIX