SUMMARY

• Over 7+ years of experience in IT industry with expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Expert knowledge in working with Informatica Power Center 9.0.1/8.x/7.x (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor).
• Well acquainted with Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse Designer.
• Expert - level mastery in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Experience with high volume datasets from various sources like Oracle, Flat files, SQL Server .
• Expertise in Tuning the DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks.
• Experience in Performance Tuning of targets, sources, mappings and Sessions
• Experience in integration of various data sources like Oracle, DB2, SQL server and MS access into staging area
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.
• Thorough knowledge of the Data Warehouse Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using PowerCenter .
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL, SQL PLUS and TOAD Quest Software Extensive.
• Extensive database experience using Oracle 11g/10g/9i, DB2, Teradata, MS SQL Server 2008/2005, MySQL, MS-Access, SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Excellent communication, analytical and interpersonal skills.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 9.0.1/8.x/7.x, Informatica Power Exchange 8.x, Talend 5.1

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005, My SQL, DB2, MS-Access

Programming: SQL, PL/SQL, SQL Plus, MS SQL, UNIX Shell Scripting

Environment: Win 2000, Win XP, UNIX, Sun Solaris.

Other tools & Utilities: SQL*Plus, Business Objects 6.5, Teradata, SQL Navigator, Toad, SQL tools, Autosys, Quest, MS-Office.

PROFESSIONAL EXPERIENCE

Confidential, NYC

ETL Developer

Responsibilities:

• Works with the Business Users and Business Analysts for gathering functional requirements and analysis.
• Analyzed source systems for data profiling and creation of source to target mapping specs.
• Designed and developed mappings, workflows to pull data from different source systems like Arctic (MS SQL Server Views), GMI (Flat Files) and Aurora (Flat Files), Vienna(Flat Files).
• Involved in designing the whole flow, right from the interface with the source systems to the final delivery of the reports.
• Deployment of ETL and DB changes to higher environments.
• Used Triggers, Functions and PL/SQL Procedures to apply and maintain the Business Rules.
• Implemented partitioning at database and Informatica mapping level.
• Data quality checking and interacting with the business analysts.
• Knowledge of using Quality Center to write/execute use cases during unit testing.
• Performed Unit Testing and Component Integration testing before handing over the code to QA
• Worked with QA team for defect resolution during System Integration Testing through Quality Centre
• Supported QA and UAT phases.
• Design and Development of Unix shell Scripts

Environment: Informatica 8.6.1, Oracle11g/10g, SQL Server 2008, Flat Files, PL/SQL, SQL, TOAD, HP Quality Center 10.2, Cognos 10, UNIX, Windows XP.

Confidential, TX

Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, variables and dynamic Cache.
• Performance tuning using round robin, hash auto key, Key range partitioning.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Designed and Deployed UNIX Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica Power Center, Workflow Manager, Business Objects 5.1, PL/SQL, Oracle 10g/9i, DB2 8.0, SQL Server 2000, HP-UX 10.20, Windows Server 2003, Toad.

Confidential, Horsham, PA

Informatica developer

Responsibilities:

• Designed and Developed mappings using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements
• Extensively used PL/SQL programming procedures, packages to implement business rules
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Workflow Manager
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL
• Extensively used ETL to load data from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle
• Used Update strategy and Target load plans to load data into Type-2/Type1 Dimensions
• Created and used reusable Mapplets and transformations
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels
• Design and Developed pre-session, post-session routines and batch execution routines
• Debugging and Trouble Shooting Of Mappings

Environment: Informatica Power Center, Oracle 8i, SQL server 2005/2000, XML, Windows, UNIX and PL/SQL Developer.

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
• Used extensively in Functionality and Logic testing for all Mappings used in populating the Data Layer.
• Created different target definitions using warehouse designer of Informatica Power center.
• Identified and tracked the slowly changing dimensions.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Used Debugger to check the errors in mapping.
• Generated UNIX shell scripts for automating daily load processes.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.
• Involved in quality assurance of data, automation of processes
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among others

Environment: Informatica Power Center 8.1, Oracle 8i, DB2/UDB, XML, Windows, UNIX and PL/SQL Developer.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in Business Analysis and requirement gathering.
• Designed the mappings between sources to operational staging targets.
• Used Informatica PowerCenter as an ETL tool for building the data warehouse.
• Employed the Aggregator, Sequencer and Joiner transformations in the population of the data.
• Data transformed from SQL Server databases and loaded into an Oracle database.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 7.0, SQL Server 7.0, Oracle 10g