SUMMARY:

• Over 8 years of IT experience in the areas of analysis, design, development in client server environment with focus on Data Warehousing applications using ETL/OLAP tools like Informatica, Business objects with Oracle, Sybase, SQL Server, Teradata,DB2 databases.
• Good understanding of Data Modeling (Star and Snow Flake Schemas), Physical and Logical models, DWH concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Elaborate experience in databases like Oracle, Sybase and IBM DB2 and database tools like TOAD, AQT, Win - SQL, and SQL Developer.
• Experienced in testing Data Warehouse/ Confidential /Business Intelligence projects with emphasis on requirements gathering, business analysis, logical and physical database design, database optimization and implementation, reports, application.
• ILM tool for discovery and finding sensitive data.
• Use TDM (Test Data Management) to define masking rules, domains, create workflow and mask data.
• Use of Informatica Data Validation Object (DVO) to verify data after masking.
• Experience with Oracle 11g/10g/9i/8i, DB2 10.5/8.2, MS SQL Server 2008 R2/2005/2000, Teradata, Flat Files and UNIX and Linux.
• Worked extensively with all Informatica designer tools i.e. Repository manager, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow manager, Workflow monitor.
• Experience in designing and developing complex mappings applying various transformation logic such as stored procedure, lookup, source qualifier, update strategy, router, sequence generator, aggregator, filter, and joiner and sorter transformations.
• Proficient with Warehouse Modules like Informatica Server and Client tools like Designer, Workflow Manager, and Repository manager.
• Worked on various Domains like Health and Welfare, Financial.
• Team Player; Excellent Interpersonal skills; Ability to work effectively with different stakeholders in a project

ETL TOOLS: Informatica Power Centre 9.5/9.1/8. /8.1DATABASES Oracle 11g /10g/ 9.1, DB2, MS SQL Server 2008/2005

DATABASETOOLS: Oracle SQL Developer, TOAD 10.5. TeredataV12.

SCRIPTING LANGUAGE: UNIX Shell Script

TOOLS: Win-SCP, Notepad++, Win merge

PROFESSIONAL EXPERIENCE:

Confidential

Informatica / Teradata Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data in the data-mart.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and SQL server to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, fast-export, multi load, and fast load.
• Extensively used ETL processes to load data from various source systems such as SQL Server and Flat Files, into target system Teradata by applying business logic on transformation mapping for inserting and updating records when loaded.
• Mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Lookup, Update Strategy, Normalizer and Sequence generator transformations.
• Implemented the concepts of Slowly Changing Dimensions (SCD) Type 1 and Type 2.
• Execute workflows on a daily and weekly basis using Active Batch.
• Worked with Teradata utilities such as M-load, F-load, export etc. to load or extract tables.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.

Environment: Teradata V13/V14, Teradata SQL Assistant, Informatica Power Center 9.6, SQL Server, Active Batch.

Confidential, Pleasanton, CA

Informatica Developer

Responsibilities:

• Interacted with Business to collect the technical and business requirements for the project.
• Involved in Development, test and implementation of scripts, Informatica transformations and workflows for extracting the data from the multiple systems and then importing the given feeds.
• Implementing work scheduling and work tracking to ensure the adherence to the project plan.
• Involved in creating tech specifications for the ETL process based on mapping document.
• Designed and developed complex ETL process as per the tech specification.
• Created reusable components like Transformations, Mapplets, Worklets, etc.
• Extracted data from different sources like SQL Server, Oracle, Excel and Flat files and load the data into the Target database.
• Developed complex mappings using transformations such as the Source qualifier, Aggregator, Expression, Sql Transformation, Static Lookup, Dynamic Lookup, Filter, Router, Union, Normalize, Sequence Generator, Update Strategy and Joiner.
• Performed tuning of Informatica sessions by implementing database partitioning, increasing block size, data cache size, sequence buffer length, target based commit interval.
• Scheduled and ran Extraction, loading processes using Informatica Scheduler.
• Developed unit test case scenarios for thoroughly testing ETL processes and shared them with testing team.
• Developed Informatica workflows and sessions associated with the mappings.

Environment: Informatica Power Center 9.6/9.1/8.6, Oracle 11g/10g, PL/SQL, DB2 10.5, Flat Files, Toad 10.5, Informatica Scheduler, WinSCP, Oracle SQL Developer, Teradata.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved in Requirement Analysis and Development for extracting from the source systems and loading it into the DataMart.
• Developed complex mappings to load data from Source System Oracle and flat files to Teradata.
• Worked on Teradata SQL Assistant querying the target tables to validate the BTEQ scripts.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Created different transformations like Source Qualifier, Expression, Filter, Lookup transformations for loading the data into the targets.
• Wrote complex SQL scripts to avoid Informatica joiners and look-ups to improve the performance as the volume of the data was heavy.
• Automated the Informatica process to update a status table in Teradata when maps are run successfully, following this a view will be run.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental load mappings to provide data for enterprise data warehouse.
• Developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Prepared documentation for business data flow from source to mart and also for the changes made to the mappings/sessions existing to eliminate the errors.

Environment: Informatica Power Center 9.1, Oracle 11g, TeradataV12, SQL Developer, Unix, Autosys scheduler, HP Quality Center, Business Objects.

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Requirement Gathering and Analysis of each individual application with application AD team on masking in/out of scope fields
• Run ILM tool for analysis to find out sensitive data based on PII, Domains and metadata profiles defined in bank
• Discuss with application team and finalize sensitive data.
• Use ILM Archive based on application need and requirement,
• Coordinate with all downstream apps for testing to make sure no breach in app due to masking of upstream application
• Verify data with Informatica Data Validation Object (DVO) that data is correctly masked or not.
• Maintain the defect life cycle, traceability matrix.
• Prepare Project Status, Test Status and Metrics report.

Environment: Informatica Power center (v9.5), TDM, Data Quality, Power Exchange, Oracle, Sybase, SQL Server, Unix

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with different sources such as Oracle, SQL and flat files.
• Gained Knowledge of slowly changing dimension tables and fact tables.

Environment: Informatica Power Center 8.1.1 (ETL), Oracle 9i/8i, SQL Developer, SQL, Windows NT/2000/95.