SUMMARY:

• 7+ years of Data Warehousing experience in analysis, design, development, testing, maintenance and implementation of ETL (Extract Transform Load) using Informatica with Oracle, DB2, MS SQL server and Teradata databases on windows and UNIX platforms.
• Strong experience in designing and developing complex mappings to extract data from diverse sources including flat files - fixed width and delimited files, Oracle, SQL Server, XML files, Applications and Teradata into a common reporting and analytical Data Model using Informatica Power Center.
• Extensively used Expression, Aggregator, Unconnected/Connected Lookup, Router, Source Qualifier, Union, Update Strategy, Filter and Stored Procedure transformations to extract and integrate teh data from different databases and files
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Refreshed teh data by using fastexport and fastload utilities.
• Coded complex scripts for teh Teradata Utilities and fine-tuned teh queries to enhance performance.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like Teradata SQL Assistant, BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Most experienced with BT/ET (Begin Transaction and End Transaction) scripts.
• Widely used Power Centre/Power Mart to design multiple mappings with embedded business logic
• Great experience in formulating User requirements, Systems Design, Technical Specifications, Test Scripts and User Training Manuals
• Strong knowledge in Data Modeling using data Modelers, Star Schema/Snow flake schema, FACT & Dimensions tables, Physical & logical data modeling.
• Expertise in Performance tuning and Optimization of Database and ETL processes in teh production environment
• Strong experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Expertise in automating workflow and BTEQ scripts using scheduled tool
• Solid experience in implementing Star Schema and Snow Flake Schema according to teh design and reporting requirements
• Involved in Data Migration from MS SQL server, Oracle, PeopleSoft, My SQL and Progress SQL to Teradata.
• Profound Experience in Project Environment setup such as Installation, configuration and Administration of Informatica products Client/Server environment.
• Strong Production support experience in maintaining teh mappings, sessions and workflows to load teh data seamlessly into Data warehouse
• Good at writing PL/SQL and SQL
• Experience in designing and developing Unix Shell Scripts for automation of ETL Processes, Error handling and auditing.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms
• Good at extensive unit testing of each mapping being developed
• Extensively worked on creating, executing test cases and test scripts using Manual/Automated methods.
• Good knowledge in performance tuning of SQL and ETL code and writing efficient and complex queries on huge volumes of data at mapping level, session level, source level, and at target level
• Extensively used Mapplets for use in mappings theirby saving valuable design time and effort.
• Quick learner and adaptive to new and challenging technological environments.
• Excellent Interpersonal Skills with teh ability to work independently and with teh team.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.

TECHNICAL SKILLS:

Data Warehousing ETL: Informatica Powercenter 9.5/9.1/8.6/8.1/7.x/6.x(Repository Manager, Designer, Work Flow Manager, Work Flow Monitor, Source Analyzer, Warehouse Developer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Developer, Workflow Designer, Shortcuts)

Data Modeling: Erwin 4.2/3.5

Databases: Oracle 11g/10g/9i/8i/7.x, Teradata 14/13/13.10/V2R12, MS SQL Server, Sybase 12.0/11.x, Siebel, DB2 UDB 8.0/7.0/6.0, MS Access 7.0/2000

Job Scheduling: CA Autosys, BMC Control M, Tidel

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

Programming GUI: SQL, PL/SQL, Unix, Perl, Shell Scripting, Transact SQL, ANSI SQL, VB .Net/6.0/5.0

PROFESSIONAL EXPERIENCE

Confidential Princeton, NJ

Sr. Informatica Developer

Responsibilities:

• Reviewing teh requirements and providing views on teh code building based on Business Requirement Document on teh business logic involved in creation of feeds.
• Solid experience in performance tuning on Teradata SQL Queries and Informatica mappings
• Worked on Teradata SQL Assistant, Teradata administrator, Teradata view point and BTEQ scripts.
• Designed and developed Informatica mappings to build business rules to load data.
• Designed mapping documents and developed ETL mappings using Informatica.
• Used Teradata utilities like BTEQ scripts, MLOAD and FLOAD scripts to load teh huge volume of data.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned teh tables.
• Implemented Target Load Plan and Pre Session and Post Session Scripts.
• Created complex Informatica mappings, re-usable transformations and prepared various mappings to load teh data into different stages like landing, staging and target tables.
• Used teh debugger in Informatica to test teh mapping and fix teh mappings.
• Worked on various lookup caches like static, dynamic and persistent.
• Created SQL Queries to validate teh data in both source and target databases.
• Worked on moving teh code from DEV to QA to PROD and performed complete Unit Testing,
• Extensively worked on Informatica Lookup, Aggregator, Expression, Stored Procedure and Update Strategy Transformations to implement complex rules and business logic.
• Implemented Slowly Changing Dimension type 2, for teh data which were used to analyze teh data.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Involved in importing Source/Target Tables from teh respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, and Aggregator).
• Created multiple Mapplets to make teh most of teh code reusable.
• Extensively worked on teh Database Triggers, Functions and Database Constraints.
• Performed Unit & regression testing for teh Application.
• Conduct a thorough code review and ensure dat teh outcome is in line with teh objective and all teh processes and standards are followed.
• Handling environmental issues and resolving them by coordinating with Informatica Support.
• Established process to streamline changes and approval mechanisms to ensure SOX compliance.

Environment: Informatica Power Center 9.5/9.1, Teradata 14/13.10, Teradata SQL Assistant, Mload, Fastload, FastExport, BTEQ, Oracle 11g, Windows, UNIX, SQL Server, SQL Developer, Autosys, HP Quality Center, SharePoint.

Confidential . Morrisville, NC

Informatica Consultant

Responsibilities:

• Coding all teh Teradata SQL part of teh project.
• Responsible for implementation of data integration from source systems into Teradata Data marts.
• Worked on Teradata SQL Assistant, Teradata administrator, Teradata viewpoint and BTEQ scripts.
• Refresh data across environments from Informatica mappings.
• Established production load standards, designed and implemented Informatica workflows, error handing, pre and post processes.
• Extensively worked with IMS Data.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored teh results using workflow monitor.
• Used teh Teradata FLOAD utility to load data to empty tables.
• Involved in working with Sample History Module to send data to third party vendors like IMS.
• Developed load reports, produced production run time instructions and recovery/restart procedures.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Teradata and Delimited Flat files.
• Tuned teh performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing teh run time of workflows.
• Studied performance details and monitored system performance to eliminate source and target bottlenecks.
• Provided technical leadership on teh TEMPeffective use of Informatica to teh data warehouse extract, transform and load (ETL) team, diagnosed and resolved technical issues.
• Created and facilitated presentations and demonstrations for Informatica.
• Scheduled Informatica workflows using Shell Scripts.
• Applied business and application knowledge to design teh data loads for consistency and integrity.
• Worked closely with teh Database Administrator to halp insure teh physical design meets teh functional and performance requirements of teh application.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Jointly worked with Data Architect to influence standardization in new and existing legacy systems.
• Closely worked with teh reporting team to ensure dat correct data is presented in teh reports.

Environment: Informatica Power Center 8.6, Teradata 13, Teradata SQL Assistant, Fastload, FastExport, Oracle 11g, ERWin 4, TOAD, Business Objects XI, UNIX, Autosys.

Confidential, NY

Informatica Developer

Responsibilities:

• Analyzed teh Performed Data profiling on source systems data and teh current reports at teh client side to gather teh requirements for teh Design inception.
• Extracted and transformed data from high volume data sets of delimited files and relational sources to load into target Database.
• Used parameters and variables extensively in all teh mappings, sessions and workflows for easier code modification and maintenance.
• Created mappings for various sources like Oracle, SQL server, flat files and XML files to load and integrate data to warehouse.
• Implemented Lookups and other transformations like Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure in mappings.
• Worked with teh MULTILOAD utility of Teradata database for better performance.
• Worked with Teradata BTEQ to run teh scripts in batch mode.
• Wrote Functions and Stored procedures in Teradata Database.
• Created Teradata security macros to create, modify and remove users and Grant/Revoke their access privileges.
• Gatheird business requirements from users and groups to create Base views and secref (security Reference) views as per their roles.
• Extensively used BTEQ, Query Man and WinDDI for database creation, moving space between databases altering spool space and user creation and management in Teradata.
• Error handling and support of existing applications for failed reloads using Teradata MLOAD, BTEQ and Fast Load.
• Analyzed existing sql queries, tables and indexes for performance tuning and advised based on teh loading time.
• Performance tuning has been done to increase teh through put for both mapping and session level for large data files by increasing target based commit interval.
• Developed Pre and Post Sessions Scripts for Emails and Failure Messages.
• Scheduled sessions and work flows using Autosys, Informatica scheduler and pmcmd command.
• Developed unit test cases and did unit testing for all teh developed mappings.
• Executed Perl and Unix Shell scripts to automate workflows and to populate parameter files.
• Worked with End users in understanding requirements and ticket resolution.
• Worked closely with reporting team and halped them whenever they had any ETL issues.
• Created technical, low level design documents and Run books.

Environment: Teradata V2R12, Teradata SQL Assistant, Mload, Fastload, BTEQ, Informatica 8.6, Oracle 10g, Unix, TOAD, ERWin, SQL Developer, Tortoise SVN.

Confidential, IL

Informatica Developer

Responsibilities:

• Responsible for developing several complex mappings for processing teh feeds, re-defined existing process to accommodate batch schedule-using Worklets and developed E-Mail Tasks in teh Workflow Manager for sending successful or failure messages.
• Teamed together with client resources to design teh to-be processes, applying standards and facilitating teh industry best practices.
• Implementation of best practice integration methods based on Informatica framework.
• Responsible for teh Design, Analysis & implementation of teh Interface Gateway for a global gateway process to handle multiple feeds from several different regions of Citigroup Europe, Asia-Pac rim, Australia & North America.
• Responsible for identifying reusable logic to build several Mapplets, utilizing shared folders to incorporate them as shortcuts, which would be used in several mappings.
• Scheduled several jobs using Autosys tool, creation of Autosys jils, changing job definition & handling scheduling issues.
• Developed processes for automation of loading data to multiple instances using worklets, parameter driven sessions for batch schedule of processes, verification and re-conciliation of data stored in several different source systems.
• Involved in developing several UNIX shell scripts for performing validations.
• Responsible for maintaining processes for managing data quality across teh enterprise.
• Provided automation of teh mentioned process for loading data into several different instances.
• Created Test cases by taking input from Business Analysts and Technical Manager.
• Tested teh feeds regarding teh functionality and Performance manually.
• Validated teh feed processing in different stages like File Watcher conditions, PRE ETL, ETL, POST ETL and Oracle Apps Import/Post processes.
• Execution of Test plan, Implementation Plans & identified areas for process improvement of workflows, mappings in Informatica.

Environment: Informatica 8.1, Oracle 10g, Oracle Apps 11i, Autosys, TOAD, ERWin, Unix, SQL server.

Confidential, Dulles, VA

ETL Developer

Responsibilities:

• Designed, developed and debugged ETL mappings using Informatica designer tool.
• Performed unit, integration and system level performance testing. Associated with production support team in various performances related issues.
• Worked closely with Business Analyst in understanding teh requirements.
• Provided production support by monitoring teh processes running daily.
• Created mappings using Aggregator, Expression, Joiner, Filter, Sequence, Procedure, Connected & Unconnected Lookup, Filter and Update Strategy transformations using Informatica Power center designer.
• Extensively used ETL to load data from different sources such as flat files, XML to Oracle.
• Worked on mapping parameters and variables for teh calculations done in aggregator transformation.
• Tuned and monitored in Informatica workflows using Informatica workflow manager and workflow monitor tools.
• Created, Scheduled and configured workflows, worklets and sessions using Informatica workflow manager.

Environment: Informatica Power Center 7.1, Oracle 9i, Toad, Erwin4.x, UNIX, and Windows, Tel Net.