SUMMARY

• 7+ years of Professional experience as Software developer in the field of Information Technology, including in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design.
• Over 6+ years of experience in using ETL Informatica PowerCenter 9.5.1/9.0.1/8. x/7.x
• Worked on BFSI, Health Care and Telco Domains
• Strong Data warehousing experience specializing in ETL Concepts and RDBMS.
• Experience in integration of various data sources such as Oracle, Teradata, Netezza,IBM DB2 MS Excel and Flat Files into staging area, ODS.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, and scheduling the Workflows and sessions.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Implemented Slowly changing dimensions and change data capture using Informatica.
• Extensively developed Complex mappings using various transformations such as Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Union and more.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non - windows environments.
• Knowledge on Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Experience in developing Shell scripts on UNIX that are used by ETL processes.
• Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
• Strong analytical, problem-solving, communication, learning and team skills.

TECHNICAL SKILLS

ETL TECHNOLOGY: Informatica Power Center 9.5.1/9.0.1/8. 6.1/8.0.1/7.5/7.1, Control-M, Autosys, SharePoint, Erwin

DATA WAREHOUSE: ODS, Normalized Data Mart, Dimensional Star and Snowflake Modeling

DATABASES: Oracle 11g/10g/9i, MS SQL Server 7.0/2000, Teradata,Netezza,DB2

PROGRAMMING: SQL, SQL Developer, PL/SQL, Toad 9.2/8.6, SQL Plus, Microsoft Office

OPERATING SYSTEMS: HP-UX, Sun Solaris 2.6/2.4, Linux, Windows XP

PROFESSIONAL EXPERIENCE

Confidential, El Monte, CA

Informatica Developer

Responsibilities:

• Worked as a lead of the project with the combination of DBA with informatica using change data capture and Digital to Analog converter.
• Involved in gathering and analyzing the requirements and preparing business rules
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Sybase and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• 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.0
• Developing Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Creating BTEQ (Basic Teradata Query) scripts to generate Keys.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements
• Involved in Performance Tuning of mappings in Informatica
• Good understanding of source to target data mapping and Business rules associated with the ETL processes

Environment: Informatica 9.5.1, Oracle 11g, Sybase 15.5.0.0, SQL, T-SQL, PL/SQL, Rapid SQL 8.0, Erwin4.x, Unix, perforce, Auto sys R11

Confidential, Phoenix, AZ

ETL / Informatica Developer

Responsibilities:

• Worked closely with business analysts and gatheird functional requirements. Designed technical design documents for ETL process.
• Developed ETL mappings, transformations using Informatica Power Center 9.0.1/8.6.1 .
• Implemented Change Data Capture (CDC) process to load into the staging area.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, and Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, & Excel.
• Developed reusable Mapplets, Transformations and user defined functions.
• Extensively used Mapping Debugger to handle the data errors in the mapping designer.
• Experience using transformations such as Normalizer, Unconnected/Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Union, Sorter, and reusable transformations.
• Created event wait and event raise, email, command tasks in the workflows manager.
• Responsible for tuning ETL procedures to optimize load and query Performance.
• Good Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Created Teradata objects likeTables and Views.
• Extensively worked on to convertORACLE scripts into Teradata scripts.
• Involved in writing shell scripts for file transfers, file renaming and concatenating files.
• Created debugging sessions for error identification by creating break points and monitoring the debug data values in the mapping designer.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment: Informatica - Power Center 9.0.1/8.6.1, Oracle 11g/10G, Sybase, and Delimiter files, UNIX Shell Script, Windows XP, Toad for oracle, isql, Erwin.

Confidential, New York, NY

Sr. ETL/Informatica/ PL/SQL Consultant

Responsibilities:

• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor as a senior Informatica Developer.
• Extracted data stored in Oracle 11g, Oracle 10g and Oracle 9i and Flat files and loaded data into Oracle Data warehouse
• Worked with Source Analyzer, Data Warehouse Designer, Workflow monitor, Mapping Designer, Mapplets, and Transformation Developer in Informatica designer
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly and monthly loading of Data
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update Strategy transformations to model various standardized business processes
• Used Informatica features to implement Type me, II changes in slowly changing dimension tables
• Created Data Breakpoints and Error Breakpoints for debugging the mappings using Debugger
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Participated in reconciling data drawn from multiple systems across the company like Oracle 11g, Oracle 10g, flat files into Oracle data warehouse
• Involved in data Transformations between different Informatica folders and also Repositories along with DBA team.
• Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Experience using different transformations like Aggregator, Lookup (connected and unconnected), Filter, Expression, Router, Update Strategy and Sequence Generator for data transformations.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Developed reusable transformations to load data from various data sources to the DW.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Scheduled Informatica sessions and workflows using Informatica Scheduler in Business process as Requested in SLA.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including partitioning, memory tuning and cache management.
• Created and maintained various project related documents like high level design documents etc.
• Created, executed and documented associated test cases.

Environment: Informatica Power Center 9.1/8.6.1/7.1 (Informatica Designer, Workflow Manager, Workflow Monitor), Oracle 10g,Oracle 11g, Flat files, ODBC, Windows NT, UNIX, Shell Scripts, Toad 7.5,Apex explorer/loader, SQL.

Confidential, Jersey City, NJ

Sr. ETL Developer

Responsibilities:

• As part of SDLC process, created Software Requirements Specifications (SRS) Document and System Design Specifications (SDS) Document before Development phase.
• Worked heavily with Business Analyst to understand the business and to design the architecture of the data flow.
• Developed Logical and Physical data models that capture current and future state data elements and data flows.
• Designing and customizing data models for Data Warehouse supporting data from multiple sources (Oracle, DB2, Excel, COBOL files, Flat Files
• Designed and developed Informatica mappings to Extract, Transform and Load data into target tables.
• Worked with Memory cache for Static and Dynamic cache to enhance throughput of sessions containing Rank, Lookup, Joiner, Filter, Sorter, Normalizer and Aggregator transformations.
• Extensively worked onInformatica Designer and Workflow Manager.
• Extensively used almost all transformations of Informatica including Lookups, Stored Procedures, Update Strategy and others.
• Extensively worked on Performance Tuning of ETL Procedures and processes.
• Extensively used PL/SQL programming in backend and front-end functions, procedures and packages to implement business rules.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed mappings for Type 1, Type 2 Slowly Changing Dimension (SCD
• Worked with Session Logs, Workflow Logs and Debugger for Error Handling and Troubleshooting in all environments.
• Reviewed QA Test Plans and provided technical support during QA and Stage testing (UAT
• Provided 24X7 on call support, which included monitoring morning and nightly jobs and emergency production fixes.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution ofInformaticaworkflows in different environments.

Environment: InformaticaPower Center 8.1, TOAD, AQT, UNIX (Sun-Solaris), Harvest, Erwin, Visio, Oracle 8i, IBM Mainframes DB2 7.0, Mercury Quality Center.

Confidential, Boston, MA

Sr. ETL Developer

Responsibilities:

• Responsible for documentation, version control of schema and version release.
• Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Interpreted logical and physical data model for business users to determine common data definitions and establish referential integrity of the system.
• Participated in the analysis of development environment of Extraction process and development architecture of ETL process.
• Coordinated with customer in finding the sources and targets for data conversion.
• Involved in the preparation of documentation for ETL standards, Procedures and Naming conventions as per ETL standards.
• Created newInformaticaMappings with Source qualifier, Union, Aggregator, connected and unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, Expression and Sequence Generator transformations while transforming the Sales/Marketing data.
• Created Reusable transformations and Mapplets for use in Multiple Mappings.
• Created multiple universes and resolved loops by creating table aliases and contexts.
• Used session partitions, Dynamic cache memory and Index caches for improving performance ofInformatica server.
• Extracted data from SQL server Source Systems and loaded into Oracle Target tables.
• Involved in writing shell scripts for automating pre-session, post-session processes and batch execution at required frequency using power center server manager.
• Involved in the loading and Scheduling of jobs to be run in the Batch process.
• Optimized and performed Tuning in mappings to achieve higher response times.
• Involved in the migration of existing ETL process to Informatica Power center.
• Created effective Test data and developed thorough Unit test cases to ensure successful execution of the data loading processes.
• Organized data in reports using Filters, sorting, ranking data with alerts.
• Created reports using business object functionality like queries, slice and dice, drill down, functions and formulas.

Environment: InformaticaPower Center 7.1, Oracle 9i, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Confidential 

Programmer/ Analyst

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system gather and define business requirements, improve business processes.
• Designed and developed PL/SQL functions, stored procedures, cursors, triggers and packages.
• Involved in designing the ER diagrams to create a normalized database
• Organized data in reports using Filters, sorting, ranking data with alerts.
• Created tables, views and stored Procedures
• Developed client side validation programs using Java Script to check the input.
• Provided End User Training and Support

Environment: Oracle 8i, PL/SQL, SQL*Plus, Oracle Forms 6i and Reports 6i, HTML, PHP, JavaScript, Windows XP.