SUMMARY

• Around 10 years of IT experience as an Informatica developer and expertise in Oracle PL/SQL/T SQL, System Analysis, Design, Development & Support of Oracle Servers 8.0, 9.i and 10 g, 11g as well as MS SQL Server 2008, SSRS in Production, Staging, Development environments
• Expertise in datawarehousing concepts and bringing data from various sources like sharepoint, Oracle, sql server, XML files, flat files using Informatica.
• Expertise in ETL development using Informatica by using complex business logic like splitting teh files according to size, date etc.
• Expertise in various type of transformations.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning teh SQL queries and PL/SQL packages and procedures
• Expertise in scheduling jobs using Informatica, PL/SQL and Autosys.
• Has good experience in writing PL/SQL and TSQL scripts for teh database objects like Tables, Views, Materialized views, Procedures, Functions, Packages, Database Triggers, Indexes and Sequences.
• Expertise in using advanced features of Oracle for PL/SQL programming like Arrays, Varrays, Nested Loops, Dynamic SQL, LOB, CLOB, Records, Objects, Exception Handling and also several new features in 11g
• Expertise in Table Partitioning, Index Partitioning and Exception Handling.
• Solid experience in performance tuning and Query Tuning (Generating Explain Plan, Optimizer wif Hints).
• Extensive experience in using Cursors, Ref - cursors, Bulk Binds and Bulk Collects for processing of data.
• Solid experience in data warehouse environments.
• Data loading from other databases and text files into Oracle Database using SQL Loader.
• Excellent experience in Normalization and Denormalization.
• Familiar wif UNIX shell scripts and good at file handling mechanism.
• Experience in Relational and Dimensional Data modeling, Physical and Logical Data modeling using Erwin. Sound understanding of Relational and Normalized databases.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Self-motivated and committed person wif excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.

TECHNICAL SKILLS

ETL tool: Informatica Power center 9.6.1

Databases: Oracle 11g, 10g,Oracle 9i, Oracle 8i, MS Sql Server 2008

Languages: PL/SQL, SQL, UNIX Shell Programming

Tools: Oracle Enterprise Manager, Informatica PowerCenter 9.6.1, Autosys, TOAD 10.1.8, Putty, Tectia, Winscp, CoreFTP, SmartFTP, SQL Developer 1.2.1, Navigator 5.5, PL/SQL Developer 7, ERWIN 4.14/4.0, SQL Loader, Export / Import, SSRS

Operating Systems: UNIX (Sun Solaris, HP-UX, AIX), Linux, Windows 2003/2000/XP/98

PROFESSIONAL EXPERIENCE

Confidential

Informtica/PL/SQL ETL Developer

Responsibilities:

• Efficiently led a whole ETL project by bringing teh data from various sources like sharepoint, oracle, sql server etc using Informatica.
• Involved in gathering and analyzing teh requirements and preparing business rules.
• Designed and developed complex mappings by using Soap queries, HTTP, Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, Java etc., transformations to implement complex logics while coding a mapping. Efficiently developed high complex packages and procedures and functionsin PL/SQL
• Efficiently worked on calling oracle PL/SQL procedures and Unix commands in informatica.
• Extensively worked on Pre and Post SQLs in informatica
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract teh data from multiple source systems like Sharepoint, Oracle, SQL server and Flat files and loaded into Oracle.
• Extensively worked on Autosys jobs for ETL loads as well as daily reports to users using SQL and PL/SQL through JOB Framework.
• Involved in creating new table structures and modifying existing tables and fit into teh existing Data Model.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.6.1.
• Generated queries using SQL to check for consistency of teh data in teh tables and to update teh tables as per teh Business requirements. Extensively worked on recon queries using sql and created pl/sql triggers to log teh changes in teh base tables
• Involved in Performance Tuning of mappings and PL/SQL packages and sqls
• Efficiently worked on oracle PL/SQL Packages to replace control characters, special characters and HTML tags
• Efficiently worked on production deployments through CRQ releases
• Efficiently used HPDMA tool and SQL Plus for deployments
• Extensively worked on upgrades to new version
• Good understanding of source to target data mapping and Business rules associated wif teh ETL processes.

Confidential

Informatica/PL/SQL ETL Developer

Responsibilities:

• Involved in creating Detail design documentation to describe program development, logic, coding, testing, changes and corrections.
• Extensively involved in writing ETL Specifications for Development and conversion projects.
• Created shortcuts for reusable source/target definitions, Reusable Transformations, mapplets in Shared folder.
• Involved in requirement definition and analysis in support of Data Warehouse.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, sequence generator, etc.
• Worked wif XML files generation through ETL process.
• Defined and worked wif mapping parameters and variables.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Performed teh performance evaluation of teh ETL for full load cycle.
• Checked Sessions and error logs to troubleshoot problems and also used debugger for complex.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Created test cases for unit testing and functional testing.
• Coordinated wif testing team to make testing team understand Business and transformation rules being used throughout ETL process. Efficiently worked on migration through releases.
• Efficiently developed high complex packages and procedures and functions in PL/SQL.
• Efficiently used advanced features of Oracle for PL/SQL programming like Arrays, Varrays, Nested Loops, Dynamic SQL, LOB, CLOB, Records, Objects, Exception Handling, calling web services from procedures and also several new features in 11g
• Efficiently worked on production support activities by resolving high priority tickets.
• Extensively worked on batch uploads by writing shell scripts and using sql loader.
• Extensively worked on code changes

Confidential, Trenton NJ

Informatica/PL/SQL Developer:

Responsibilities:

• Participated in requirement gathering meetings wif business analysts and ETL architect to understand Source Data, Data Warehouse data model, Technical Metadata, etc.
• Documented required technical metadata such as source and target definitions.
• Created technical design specifications for mappings, sessions, workflows, etc.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files for data extraction.
• Created complex mappings in Informatica Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup, Joiner transformations etc. Implemented Type II inserts/updates using update strategy.
• Created reusable transformations and mapplets to reuse while creating ETL mappings.
• Configured and used teh Debugger to troubleshoot teh Informatica mappings.
• Proficient in using Informatica Power Center Designer, Informatica workflow manager, workflow monitor to create, schedule and control mappings, workflows, tasks, and sessions.
• Worked wif DBA team to fix performance issues at Database.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Worked wif export and import utilities in Repository manager.
• Involved in upgrading from Informatica Power Center 6.1 to Informatica Power Center 8.6

Confidential, Secaucus NJ

PL/SQL/Informatica Developer

Responsibilities:

• Extensively worked on production support on informatica load jobs.
• Database Design for Admin module to achieve great scalability, efficient security and flexibility to accommodate country’s specific needs.
• Database Design for Time module.
• Wrote complex yet fast and efficient procedures, functions, packages by using cursors and collections to interact wif Data Access Layer of teh application.
• Efficiently used Bulk collect for bulk insert and bulk update.
• Efficiently Partitioned tables from Time module for date range.
• Wrote cross-tab queries to import legacy data from corporate card charges and HR Feed.
• Created Materialized views to access Employee related data from GFIS-HR.
• BLOB and CLOB operations were used to store and retrieve serialized objects across application. These were also used to store and retrieve design templates for various Reports.
• Involved in application tuning of database by defining teh suitable indexes, hints and tuning SQL queries.
• Optimized and enhanced teh existing procedures and SQL statements for teh better performance using EXPLAIN PLAN, HINTS to tune SQL queries.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Usage of UTL FILE package to load teh data from external files dat is exported from Server.
• Used Cursors, Exception Handling and also used teh Pragma Exception Init in order to associate our own created error messages wif teh error codes.

Environment: Informatica powercenter 8.6,Oracle 11g, PL/SQL, Toad 9.1, Putty, WinSCP, Toad 9.6.1, C#, ASP.Net, Win forms