SUMMARY:

• Over 7+ years of professional work experience in System Analysis, Design, Development, Database design, SQL, Data Warehouse/Data Mart design, testing and Implementation of business application systems
• Experience in Requirements Gathering and Business Analysis.
• Experience in building Dimensional Models using Star Schema and Snow Flake Schema and created Physical and Logical data Models using Erwin.
• Expertise in implementing Business rules by creating mappings, Mapplets, and reusable transformations using Informatica Power Center and Power Mart.
• Automated the process of executing workflows using Job Scheduling tools like Autosys.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Experienced with working on flat files/Legacy/Multiple source System, Siebel CRM as Source Systems.
• Worked on integrating data from heterogeneous sources like Oracle, flat files, DB2, COBOL and XML files.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Triggers, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Router, Normalizer, etc.
• Extensive experience in writing Unix Shell Scripts for automation of ETL Process.
• Excellent understanding of Domain knowledge in Heath Care, Insurance, Retail and Service oriented industries.
• Knowledge of full life cycle development for building a Data Warehouse.

TECHNICAL SKILLS:

ETL Tools: Informatica 6.x/7.x/8.x/9.x (Power Center & Power Connect), Autosys. MSSQL Server 2008 (Integration Services, Analysis Services, Reporting Services)

Data Modeling: Erwin, Star: Schema Modeling, Snowflakes Modeling

Operating Systems: Windows NT/200X, RedHat Linux 4.0, UNIX

Databases: Oracle 8i/9i/10g/11g,DB2, SQL Server 2003/2005/2008/2012 , SQL*Plus 8.x/9.x, SQL Developer, TOAD,SSMS, MS Access

Languages: Shell Scripting, SQL, PL/SQL,TSQL

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Informatica/ETL Developer

Responsibilities:

• Actively participated in all phases of SDLC: Requirement Gathering, Design & Development, Testing, and Defect Handling under theAgileProject Methodology.
• Actively involved in analyzingthe Functional and Technical Requirementsto understand the requirements and convert them into proper ETL/Database designs and Developments.
• Extensively worked on creating ETL Mapping Documents, Process Flow Diagram, Unit Test Document, and Release Notes.
• Developed Complex Mappings to work on Data Validation and Error Handling Process using large number ofTransformationslike:Lookup (connected and unconnected), Store Procedure, SQL, Sequence Generators,Update Strategy,Transaction Control, etc..
• Experience working on creating staging and target databases,schemas, tables, constraints, etc. and creating stored procedures,functions, views etc. and data validation by queryingthe respective source/target objects.
• Actively involved in Gap Analysis of BRD Versions in - respect of implemented and planned ETL and Database designs,development and impact todownstream applications.
• Worked onCDC/Incremental Loading and on creating SCD tables with the help of executing Stored Procedure at Session level Post SQL.
• Worked on existing mappings (Incremental) and used Debugger to fix the issues
• Performed Unit Testing and helped SIT/UAT team to setup the data for testing
• Executed Sessions, Sequentialand Concurrentbatches for proper execution of mappings and setup email delivery after execution.
• Implemented efficient Performance Tuningto eliminate the bottlenecks at source, target, mapping and session levels.
• Performed as Release Coordinator; involved in Deploying/Migrating the ETL and Database objects fromDevelopmenttoSITandUAT environments.
• Scheduled and monitored jobs using Workflow Manager.

Environment: Informatica Power Center 9.5, Oracle 11g, SQL Server 2012, DB2, Confidential OIF, Flat File, Toad, HPALM, SharePoint, Windows XP.

Confidential

ETL Informatica Developer

Responsibilities:

• Analyzed the requirements provided by various business users.
• Identify source systems, connectivity, tables, and fields to ensure data suitability for mapping.
• Designed and developed complex Informatica mappings using different transformations like Source qualifier, Aggregators, Connected & Unconnected Lookups, Update Strategy, Filter and Sequence Generator.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions
• Performance tuning of the mapping where goal was to insert thousands of rows to target by identifying bottleneck at target, source, mapping and session level.
• Wrote pre-session and post-session stored procedures to drop the indexes, to re-create the indexes, and to make joins in the database.
• Used session partitions, dynamic cache memory, and index cache to improve the performance of Informatica server.
• Developed and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Created mapplets in place of mappings which were repeatedly used like formatting date or data type conversion.
• Created variable ports to compare the current record with previous records and calculated the required values.
• Also provided the Production Support and Monitored the Daily ETL Routines.
• Developed Unix Shell Script as well for various preload and post load validation and activities.
• Used Autosys to run the solution in scheduled time intervals.

Environment: Informatica PowerCenter 8.5.1, Informatica Repository Manger, Designer, Server Manager, Workflow Monitor, Workflow Manager, Oracle 11g, DB2 8.0, Toad, Autosys, Excel, Windows XP.

Confidential, Milwaukee, WI

ETL Informatica Developer

Responsibilities:

• Involved with the business analysts in gathering user requirements.
• Involved in Dimensional Modeling to Design and Develop Star Schemas using Fact and Dimension tables.
• Worked with various heterogeneous sources such as SQL Server, Oracle, and Flat Files to load the data into the target Oracle database.
• Developed complex mappings in Informatica Power Center 8.6.1 using different transformations such as Source Qualifier, Aggregator, Lookup (connected and unconnected), Update Strategy, Sequence Generators, Filter, Router, Sorter, Expression, Stored Procedure etc.
• Performance tuned the transformations, mappings and sessions for optimization by eliminating the bottlenecks
• Used Update Strategy and Lookup transformation to implement the Type1 and Type2 SCD’s.
• Used Informatica Debugger for debugging the mappings associated with the failed sessions.
• Employed Workflow Manager Tasks such as Email, Command task, Event raise, Event wait, Decision, Assignment to build Workflows and Worklets.
• Implemented efficient performance tuning procedures to eliminate the bottlenecks at source, target, mapping and session levels.
• Created effective Test data developed and performed thorough Unit test cases to ensure successful execution of the data loading processes.
• Documented the ETL process.
• Conceptualized a Migration strategy to migrate from Dev to QA to Production environment.
• Used PL/SQL programming procedures, packages to implement business rules.

Environment: Informatica Power Center 8.6.1,Siebel CRM 8.1.1, Oracle 11g,SQL Server 2008, SQL, Unix, RedHat Linux 4.0

Confidential, Dublin, OH

Informatica ETL Developer

Responsibilities:

• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Worked with different sources such as Oracle, MS SQL Server and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Used control-M for Scheduling, Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 8.1 (ETL), Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Server, Windows, HP-Unix.