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 noledge 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 .
• Has 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 has good noledge 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 wif tools like TOAD, SQL Server SSIS, and SSAS.
• Strong logical and Analytical Reasoning Skills, Excellent Communication wif 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 teh requirement spec.
• Design and Development of ETL (Extraction Transformation Loading) using Informatica 8.5.1, Oracle 10g.
• Identified teh sources, targets and developed ETL mappings using Informatica 8.5.1.
• Using Informatica Server Manager for Creating, running teh Batches, Sessions and scheduled to run at specified time.
• Participated in testing teh 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 wif 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 teh 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 teh Oracle tables.
• Performance Tuning at both Database Level and Informatica.
• Developed sessions, workflows which involve command tasks to invoke teh ETL jobs from UNIX shell scripts.
• Also responsible for capturing teh changes on teh Script by creating teh CDC maps dat runs continuously for 24 hours to capture teh changes.
• Designed various ETL jobs for pulling data from various legacy systems and for loading into teh 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 wif Business Users and understood teh design requirements of teh 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 teh existing mappings.
• Extensively used Toad for DB2 for executing teh queries.
• Used IBM Rational Clear Quest to track teh 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 teh Connect Strings and Connection Objects in Dev, Test and Prod environments.
• Involved in Unit Testing and created Test Cases for those mappings.
• Worked wif 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 teh Requirement Phase and played a major role in gathering teh documents from teh business users as per teh ETL needs.
• Played a vital role in Data analysis of teh Legacy data structures and ODS data structures.
• Played a vital role in organizing teh team meetings.
• Developed complex ETL mappings like slowly changing dimensions, Fact tables and aggregated tables wif Dynamic Lookups using various stages like Expressions, Routers, Update Strategies, Sequence Generator and Mapping parameters/variables global to dat mapping.
• Implemented Archival Strategy to hold data up to 13 months.
• Developed Control Files and Data files using SQL loader and successfully loaded teh data from teh flat files into teh main tables.
• Responsible for creating and maintaining teh 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 teh 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 teh mappings, sessions and workflows at teh 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 teh development of system requirements and design specifications.
• Interacted wif teh users to evolve teh Security matrix for teh system based on role-based-access.
• Rational Unified Processing approach was used for teh Object Modeling.
• Verified teh functional aspect as per teh Business Process and validated teh user interfaces.
• Developed complex mappings in Informatica to load teh 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 dat involved complex logic.
• Created and scheduled Sessions and Workflows through teh Informatica Workflow Manager.
• Setup folders, groups, users, permissions and performed Repository administration using Repository Manager
• Designed and documented teh validation rules, error handling and test strategy of teh mappings.
• Tuned teh mappings and sessions for better performance by eliminating various performance bottlenecks.
• Maintained effective communication wif non-technical client personal and handled teh change requests.
• Worked wif 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 teh mappings dat has 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, teh performance issues wif de-normalization and resolved many to many and self recursive issues wif complex business data flow.
• Developed ETL design spec based on business requirement specifications.
• Documentation at every stage of teh software development life cycle.
• Coordinated wif DBAs and UNIX administrators in setting up teh 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 teh technical design along wif 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 teh 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.