SUMMARY:

• Over 7 years of experience in Analysis, Design, Development of various business applications in different platforms Informatica 9.1/8.x/7.1/6.2,Oracle 9i/10g/11g.
• Experience in Application Design, Data Extraction, Data Acquisition, and Data Mining Development, Implementations and Testing of Data warehousing and Database business systems.
• Expertise in using Informatica 8.6x/8.1/7.1/6.2 (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) and DAC (Data ware house Application Console).
• Good working knowledge of OLTP systems, Analysis E - R Modeling, Data Modeling using data modelers, Star schema, Snowflake schema, Fact and dimensions table using ERWIN.
• Experience in integration of various sources like Oracle,DB2,Tera data, SQL Server, Fixed width, Delimited Flat Files, XML Files and Main Frames .
• Have a good experience in creating Repositories, Folders, Groups, User assigning privileges to users.
• Strong experience on Workflow Manager Tools - Task Developer, workflow and Work let Designer.
• Used and created ODS for OLTP systems for daily transactions.
• Extensively used Source Qualifier, Connected and Unconnected Lookup, Normalizer, Router, Filter, Expression, Aggregator, Stored Procedure, Sequence Generator, Sorter, Joiner, Main Frame Source Qualifier, Update Strategy, Java Transformation, Union Transformations, Mapplets.
• Experience in Mappings, Mapplets, Worklets, Reusable Transformations, Sessions/Tasks, Workflows and Batch Processes in Informatica Server.
• Extracted data from multiple operational sources for loading staging area, Data warehouse, Data Marts using SCD’s (Type 1/Type 2/ Type 3) loads.
• Involved in PL/SQL Programming (Stored Procedures, Triggers, and Packages) Using Oracle.
• Created ETL Mappings using Informatica Power Center to move Data from multiple sources like XML, DB2, SQL Server, Flat Files, and Oracle into a common target such as Data Marts and Data warehouses.
• Involved in Data Profiling using Data Explorer.
• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, MVS, COBOL files & XML Files.
• Also have good knowledge in Performance Tuning at both Database Level and Informatica.
• Good Experience in UNIX Shell Scripting and ETL Process Automation Using Shell Programming.
• Experience in working with tools like TOAD, SQL Server SSIS, and SSAS.
• Strong logical and Analytical Reasoning Skills, Excellent Communication with Good Listening Presentation and Intrapersonal Skills.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.x/7.x/6.x/5.x (Power Center/Power Mart/Power Exchange (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect).

Data Modeling: Star Schema Modelling, Snow Flake Modelling, MS Visio, Rational Rose Suite (UML).

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008, DB2, My SQL, Sybase, DB2/400, Teradata.

Languages: T: SQL, PL/SQL, Perl, Unix Shell Script.

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

Scheduling Tools: Corn, TWS.

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

PROFESSIONAL EXPERIENCE:

Confidential, Palo Alto, CA

Sr. Informatica Developer

Responsibilities:

• Playing Senior ETL developer role in End to end development of data mart.
• Attended multiple requirement gathering discussions and formed BRDs(Business Requirement Spec)
• Framed global ETL design based on the requirement spec.
• Design and Development of ETL (Extraction Transformation Loading) using Informatica 8.5.1, Oracle 10g.
• Identified the sources, targets and developed ETL mappings using Informatica 8.5.1.
• Using Informatica Server Manager for Creating, running the Batches, Sessions and scheduled to run at specified time.
• Participated in testing the mappings by peer reviews.
• Involved in Extraction, Transformation and Loading (ETL) Process .
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, Mapplets, dynamic lookups and reusable transformations in ETL maps.
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Extracted, transformed data from various sources such as Flat files, COBOL files and transferred data to the target data warehouse.
• Developed complex Stored Procedures, Packages, Triggers, Cursors and Shell Scripting which were in turn used in Informatica for mapping purposes based on certain conditions.
• Developed number of Control Files and Data files to pull data from Flat Files into the Oracle tables.
• Performance Tuning at both Database Level and Informatica.
• Developed sessions, workflows which involve command tasks to invoke the ETL jobs from UNIX shell scripts.
• Also responsible for capturing the changes on the Script by creating the CDC maps that runs continuously for 24 hours to capture the changes.
• Designed various ETL jobs for pulling data from various legacy systems and for loading into the integrated database.
• Performing data profiling to provide high quality of data to business users and customers.

Environment: Informatica Power Center 9.1/8.6.1, Oracle 11g/10g, IBM Db2 V9.5, SSH Secure Shell 3.2.9, IBM Rational Clear Quest, Microsoft Visio, Toad 9.0, Power Exchange, Windows XP.

Confidential, San Jose, CA

ETL Developer/ IT Analyst

Responsibilities:

• Interacted with Business Users and understood the design requirements of the users.
• Used different kinds of transformations like Router, Sorter, Source Qualifier, Joiner, Aggregator, Lookups both Connected and Unconnected Lookups, Expression, Expression, Sequence Generator, Union, Update Strategy to load data into target tables.
• Extensively used Power exchangeto import source files from Mainframe systems
• Extensively used ETL to load data from wide range of source such as flat files, Mainframes to DB2.
• Used Debugger in troubleshooting the existing mappings.
• Extensively used Toad for DB2 for executing the queries.
• Used IBM Rational Clear Quest to track the Incidents.
• Implemented both SCD’s (Slowly Changing Dimensions) TYPE-1 and TYPE-2.
• Used Mapping Parameters and Variables, Dynamic parameter files, Shortcuts, Reusable Transformations.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating Connect Strings and synchronizing the Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked with QA Team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait task, Decision task, Email task, Command task.
• Created UNIX shell scripts to run session workflows for Informatica mappings.

Environment: Informatica Power Center 9.1/8.6.1, SQL, Erwin 4.0, Oracle10g, PL/SQL, Shell Scripting, Toad, Selenium IDE, UNIX, Windows XP.

Confidential, Detroit, MI

ETL Developer

Responsibilities:

• Worked since the Requirement Phase and played a major role in gathering the documents from the business users as per the ETL needs.
• Played a vital role in Data analysis of the Legacy data structures and ODS data structures.
• Played a vital role in organizing the team meetings.
• Developed complex ETL mappings like slowly changing dimensions, Fact tables and aggregated tables with Dynamic Lookups using various stages like Expressions, Routers, Update Strategies, Sequence Generator and Mapping parameters/variables global to that mapping.
• Implemented Archival Strategy to hold data up to 13 months.
• Developed Control Files and Data files using SQL loader and successfully loaded the data from the flat files into the main tables.
• Responsible for creating and maintaining the stored procedures. Creating data base objects like tables, indexes, Views and Sequences.
• Created several complex PL/SQL Packages, Procedures, Triggers and Functions to implement business logic at front end and also perform validations on the imported data from legacy system.
• Improved Performance of database queries and ETL maps using various Optimization Techniques like Query Tuning, avoiding unnecessary/repetitive database calls, persistent cache, and Modifying Buffer size at session level.
• Responsible for Backup recovery to all the mappings, sessions and workflows at the repository server.
• Worked on PL/SQL code optimization techniques and error handling mechanisms.
• Worked on SQL Tuning using Explain Plan and TKPROF.

Environment: Informatica Power Center 8.6.1, Informatica Power Center Connect, Informatica Data Profiling, SSIS, Power Exchange, DB2, Oracle 10g, SQL, PL/SQL, XML, UNIX, Toad, Windows XP.

Confidential, Thousand Oaks, CA

Informatica Consultant

Responsibilities:

• Involved in the development of system requirements and design specifications.
• Interacted with the users to evolve the Security matrix for the system based on role-based-access.
• Rational Unified Processing approach was used for the Object Modeling.
• Verified the functional aspect as per the Business Process and validated the user interfaces.
• Developed complex mappings in Informatica to load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Involved in snowflake and star schema using data modeling tool Erwin 3.0.
• Developed Mapplets to implement business rules that involved complex logic.
• Created and scheduled Sessions and Workflows through the Informatica Workflow Manager.
• Setup folders, groups, users, permissions and performed Repository administration using Repository Manager
• Designed and documented the validation rules, error handling and test strategy of the mappings.
• Tuned the mappings and sessions for better performance by eliminating various performance bottlenecks.
• Maintained effective communication with non-technical client personal and handled the change requests.
• Worked with mapping variables, Mapping parameters and variable functions like Set Variable, SetCountVariable, SetMinVariable and SetMaxVariable.
• Developed Re-usable transformations, Mapplets to use them for data load to data warehouse and database (Oracle).
• Developed and tested all the mappings that have complex lookups and update strategies.

Environment: Informatica Power Center 8.1.1, Teradata,Erwin3.0,Oracle 10g, SQL,PL/SQL, Linux, Unix, Toad, Shell Scripting, Window XP.

Confidential, Plymouth, MN

Informatica Consultant

Responsibilities:

• Involved in End to End development of OLTP (Online Transactional Processing).
• Resolved many database bottlenecks like deadlocks at database due to circular references among entities, the performance issues with de-normalization and resolved many to many and self recursive issues with complex business data flow.
• Developed ETL design spec based on business requirement specifications.
• Documentation at every stage of the software development life cycle.
• Coordinated with DBAs and UNIX administrators in setting up the physical databases.
• Using Oracle 10g and Informatica 7.1.3 for data based needs and ETL.
• Incorporated various transformations, Lookups, Expressions, Routers, Sequence generators, Mapplets, dynamic lookups and reusable transformations in ETL maps
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Performed Database/ETL migrations from Dev environment to Test/Training/ UAT/Staging and PROD environments.

Environment: Informatica Power Center 8.1, Power Exchange 8.1,SSIS,SQl Server, Oracle 9i, SQL, DB2, Mainframe, UNIX Shell Scripting.

Confidential

Software Engineer

Responsibilities:

• Driving the technical design along with customer team, preparing design specifications, functional specifications and other documents.
• Involved in all aspects of software development life cycle.
• Generated DDL queries of new database objects like tables, views, sequences, functions, indexes, triggers, packages, stored procedures.
• Produced SQL reports, data extractions, data loading, and scripts for various schemas.
• Involved in performing backend testing by writing SQL queries to extract the data from SQL database using oracle.
• Worked on Linux Environment.
• Performed Testing using Selenium IDE.
• Wrote DDL, DML scripts for Schema, Table space, Cluster creation and Alteration.

Environment: Oracle 9i, Linux, TOAD, SQL, PL/SQL, SDLC, Selenium IDE.