PROFESSIONAL SUMMARY:

• SDLC: 6+ years of IT experience in Enterprise Development for Data Warehouse solutions its functionalities using ETL and OLAP tools, in areas of Finance, Property Casualty (Auto), Mortgage Insurance, Banking with various levels of SDLC - Project analysis, design, development, coding and implementation of Data warehouse, Database and Data Marts.
• ETL Informatica: Strong experience in Informatica Power Center 9.1, 8.6.1, 8.1.1(Installation & Configuration), OLAP, OLTP concepts. Expert-level in designing and developing complex mappings to extract data from multiple sources such as flat flies, XML files, RDBMS tables. Informatica Designer tools - Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager and Monitor.
• Data Analysis: Experience in Data Design and Analysis, User Requirements its Analysis, Data Transformations, Data Cleansing, Web Service Integration, Database Relationships, Source Systems Analysis and Reporting Analysis
• Methodologies: Complete Knowledge of Data Warehouse methodologies its concepts like Ralph Kimball and Bill Inmon, Operation Data Store (ODS), Enterprise Data Warehouse (EDW) and Metadata repository, Data Migration Technique from legacy system to Oracle 9i using Informatica.
• Installation and configuration of Informatica Server and Informatica Repository Server in Windows-UNIX Operating Systems.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extracted data from various sources like Oracle, DB2, Flat file, SQL Server, XML files and loaded into Oracle database.
• Quality Assurance: Good experience in Performance Tuning of Mappings/Sessions, Develop complex database SQL and PL/SQL to validate ETL & Report testing.
• Databases: Good work experience on Database Systems like Oracle 10g, 9i, 8i, SQL Server 2008.
• Extensive experience and knowledge of the Project Life Cycle, including Requirement gathering, and Test Plans Development and Execution.
• Experience on Performance Tuning of Mappings and Sessions and Batches and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Expertise in Data warehouse Development, Implementation, Documentation, Data Base Testing, Data warehouse Testing, ETL Testing and Production support.
• Expertise with various tools like SQL Developer, TOAD & Putty.
• Excellent working knowledge of UNIX Shell scripting and Job scheduling of multiple platforms.
• Experience in Developing Integration system Testing scenarios, Test scripts and Test execution using Quality Center.
• Closely working with Dev lead, Test lead, Project Manager, Business Analysts and Developers.
• Team player, motivated and dynamic with excellent oral and written communication skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.1.1, 8.6.1, 9.1, DW Designer, Mapping Designer, Work Flow Manager, Work Flow Monitor, Repository Manager, SOAP, OLAP, OLTP

Database Technologies: ORACLE 8i /9i/10g, SQL Server 2005, 2008 and DB2

Database Tools: SQL Developer, TOAD, SQL*PLUS, SQL Server Management Studio

Languages: SQL,PL/SQL,T-SQL,C, Java, UNIX Shell Scripting

Operating Systems: MS-DOS, UNIX, Windows

Virtual Tools: VMware Workstation, Virtual Box

Utilities and Tools: Putty, MS-Excel, MS-Access, MS-Word, Quality Center, Autosys, Control-M, ERwin, MS-Visio

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Senior Informatica Developer

RESPONSIBILITIES:

• Understanding existing legacy system and extensively worked on the requirement definition and analysis in support of Data Warehousing efforts.
• Participating in Business, Functional requirement walk through.
• Using Transformations to clean the data from staging area as per the Data Warehouse requirements.
• Extraction, Transformation and loading of data from DB2, MS-Access, MS-Excel, flat file sources into oracle database.
• Developed and implemented the coding of Informatica Mapping for the different stages of ETL.
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Successfully Implemented Slowly Changing Dimensions (SCD). Used Type 2 dimension to keep the history changes.
• Partitioned Sessions for concurrent loading of data into the target tables.
• Involved in Error handling strategies, Unit, System testing, UNIX test scripts, test scripts and fix bugs in the application.
• Troubleshoot and tune SQL using EXPLAIN PLAN.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Created and Monitored Tasks, Workflows and Worklets using Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Environment: Informatica 9.1, UNIX, Oracle 10g, Autosys, MS-Excel, MS-Access, TOAD, DB2

Confidential, Trenton, NJ

ETL Developer

RESPONSIBILITIES:

• Study and analyze mapping document, the required source tables, data types, required transformations based on Business requirements and Technical specifications.
• Using Informatica Power Center, extracting data from Mainframes, SQL Server, XML files and Flat Files.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Extensively worked with various Passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Created Materialized views for summary tables for better query performance.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.
• Providing extensive changes as a part of User acceptance testing and deployment of mappings at client place.
• Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the dimension tables and fact tables properly.

Environment: Informatica 8.6.1, ORACLE, TOAD, SQL SERVER 2008, Control-M, Quality Center.

Confidential - Jersey City, NJ

ETL Developer

RESPONSIBILITIES:

• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Worked with Informatica power center client tools like Source Analyzer, Warehouse Designer, and Mapping.
• Worked with Kimball's Data Modeling concepts including data modeling, data marts, dimensional modeling, star and snowflake schema, fact aggregation and dimension tables, slowly changing dimensions and surrogate keys.
• Extensively developed various Mappings which perform Extraction, Transformation and Loading of Source data into the OLAP Schema, and used different Transformations like Source Qualifier, Expression, Lookup, Update Strategy, Aggregator, Stored Procedure, Filter, Router, Joiner etc.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica PowerCenter.
• Improved performance using Oracle Partitions, Indexes and other Performance Tuning techniques.
• UsedOracle SQL Developerfor testing SQL code.
• Load operational data from COBOL, SQL Server, flat files, Excel Worksheets into various data marts.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Utilized Informatica debugger for trouble-shooting the Mappings.
• Created UNIX shell scripts and called as pre session and post session commands.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Involved in Unit Testing and Integration Testing of the application.
• Preparing the code review and peer review documents.
• Scheduled the ETL jobs daily, Weekly and monthly based on the business requirement.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email, command and pre/post SQL.
• Involved in performance tuning of the mappings/sessions.

Environment: Informatica 8.1.1, UNIX, PUTTY, Oracle, MS-Access, SQL Developer

Confidential .

SQL Developer

RESPONSIBILITIES:

• Involved in Requirement Gathering, Analysis, Design & Development and Configuration Management for the above project.
• Involved in the Design & Development of Database Tables, Views, Procedures, Functions & Triggers.
• Involved in writing complex queries for various requirements Generated Test Cases like Unit, System and Integration Test cases.

Environment: Java, Oracle, SQL* PLUS