PROFFESIONAL SUMMARY:

• Over 7 years of diversified experience in the field of Information Technology with an emphasis on Data warehousing using Informatica PowerCenter/Power Mart 9.0.1/8.6/ 8.1/7.1/6.2 Target Databases and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism - using Informatica.
• Involved in Various projects in analysis, design in Financial, Sales, Warehouse, Storage and Telecom Industries.
• Expertise in designing the architecture of the Extract, Transform and Load process and development of transformation standards and processes using Informatica best practices.
• Experience in Informatica PowerCenter for development, implementation, administration and support of ETL processes for large-scale data warehouses.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources such as Oracle, DB2, SQL Server, XML Files, Flat Files and VSAM files to target (Warehouse / Data Mart) data bases such as Teradata and Oracle.
• Involved in developing mappings and mapplets using Informatica Source Analyzer, Warehouse designer, Mapping Designer & Transformation Developer.
• Used various Transformations such as Expressions, Filters, and aggregators, Lookups, Routers, Normalizer, and Sequence Generator etc. to load consistent data in to Oracle, SQL, and Sybase and Teradata databases.
• Used Teradata load utilities to load data using Informatica loader connections
• Expertise in SQL/PLSQL programming, developing & executing Packages, Stored Procedures, Functions, Triggers, Table Partitioning, Materialized Views.
• Developed Datastage server jobs to extract, transform and load data into data Warehouse from various sources like relational databases (DB2), Oracle 9i, flat files etc.
• Experienced in writing UNIX shell scripts to schedule the informatica sessions automatically.
• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions.
• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Experience in Integration of various data sources like Oracle, SQL Server, DB2 and Flat Files in various formats like fixed width, CSV and excel.
• Have in depth knowledge and experience in implementing the best practices for design and development of data warehouses using Star schema & Snowflake schema design concepts.
• Involved in Data modeling techniques like normalization, denormalization, physical database design, relational models, star schemas, snowflake schemas, etc.
• Extensively involved in project coordination activities by keeping track of various project milestones and organizing weekly project reviews throughout the entire SDLC.
• Worked on data analysis and data validations and preparing Unit Test Cases.
• Performed unit testing and integration testing for the developed data load process.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.0.1/ 8.6/8.5/8.1/7.1/6.2 (Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect)

Data Modeling: Erwin 7.3,Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000,SYBASE

Software Tools: SQL*Loader, SQL*PLUS, Crystal Reports, MS Office.

Programming Languages: C, C++, JAVA, PL/SQL, SQL

Operating Systems: Windows XP/ 2003/2000/UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg, PA

Sr. ETL/Informatica Developer

Responsibilities:

• Informatica migration from version 8.1.1, 8.6.1 to 9.0.1.
• Informatica Folder/Object Level Migration.
• Informatica object Migration using Repository Manager.
• Informatica Administration activities (using Admin console).
• Hotfix Implementation.
• Performance tuning of informatica application.
• Performed Code review of mappings of various applications.
• Give expert solutions to the users for problems in informatica.
• Created Windows Batch scripts to automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, and FTP to the desired locations as required by the user.
• Data Warehouse and Data Mart design and data modeling using Erwin 7.3.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various tables in Data Marts.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance
• Created Folders, new Connections for existing folders, new user addition/privileges requests.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Used reusable look-up transformations, Shortcuts to sources, targets across the folders.
• Designed Mappings using B2B Data Transformation Studio to transform unstructured to structured forms.
• Used major components like Serializers, Parsers, Mappers and Streamers in DT Studio for conversion of XML files.
• Created reusable mapplets using Mapplet Designer which involved date conversions.
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Created Sessions and partitioned using different partition types like key range partitioning.
• Used Parameter files to manage the control dates for the incremental load times.
• Tuned SQL Queries in Source qualifier Transformation for better performance
• Designed/developed Stored Procedures for data mappings to implement complex business logics.
• Worked on Informatica Data profiling to analyze the quality of incoming data.
• Performance tuning of T-SQL and PL/SQL Code, Informatica mappings.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Prepared documentation of standards for Informatica code development.
• Involved in creating Dashboards and drill through reports to display various metrics.

Environment: Informatica PowerCenter 9.0.1/ 8.6.1/8.1.1 , Unix, Oracle10g/11g, XML, Flat Files, Batch script, Robo-FTP, Windows XP/NT, TSQL,PL/SQL, Benthic, Erwin 7.3, Cognos8.

Confidential, Harrisburg, PA

Sr. ETL/Informatica Developer

Responsibilities:

• Working onODP(Office of Developmental Programs)for Provider and SCO monitoring reports
• WroteWindows Batchscriptsto automate the process of renaming the Flat files with a timestamp extension, Compressing, Archiving, and FTP to the desired locations as required by the user.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various tables inData Marts.
• Created Connected, Unconnected andDynamic Lookuptransformations for better performance
• Usedreusable look-uptransformations, Shortcuts to sources, targets across the folders.
• Built re-usable mapplets using Informatica Mapplet Designer which involved date conversions.
• Developed complexmappinglogic using varioustransformationslike Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, Sequence generator and Normalizer.
• UsedParameter filesto manage the control dates for the incremental load times.
• TunedSQLQueries in Source qualifier Transformation for better performance
• Created triggers,PL/SQLstoredprocedures and responsible for SQL tuning
• Involved in Database design using Erwin 7.3
• Responsible for writing complex SQL scripts to avoid Informatica joiners and Look-ups to improve the performance of heavy volumes of data.
• Involved in FTPprocess to transfer the filesfrom one server to other.
• Raised change requests, analyzed and coordinated resolution of program flawsfor the Development environment and hot fixed them in the QA, pre-prod and Prod environments, during the runs.
• Interacted with thethird party vendors regarding data issueswith incoming and outgoing daily data extract.
• Created sessions, worklets, workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Designed and developed complex mappings that involvedSlowly Changing Dimensions, Error handling, Business logic implementation
• Prepared documentation ofstandardsfor Informatica code development.
• Coordinated with theQA team and Operations (production)team while the code was being migrated across the servers

Environment: Informatica PowerCenter 8.6.1/8.1.1 , Oracle9i/10g, 11g, Flat Files, Batch script, Windows XP/NT, CVS, PL/SQL, Benthic, and Erwin 7.3.

Confidential, NY

ETL Developer

Responsibilities:

• Actively participated in understanding the business requirements, involved in analysis and design, development, testing and implementation phases.
• Extensively used Informatica for extracting, transforming and loading data from relational sources and non-relational sources.
• Responsible for handling the change requests for data issues and performance issues on multiple applications.
• Extensively used all the transformations like Source Qualifier, Sequence Generator, Expression, Filter, Router, Sorter, Aggregator, Joiner, Lookup, Update Strategy and so…
• Developed reusable components in Informatica such as re-usable transformations, mapplets and reusable tasks.
• Extracted data from different sources such as Oracle, DB2, SQL Server, VSAM and Flat files to load into Operational Data Store (staging area) and then load into Data Warehouse.
• Experienced in writing new and modifying the existing PL/SQL code in oracle to support the process.
• Designing and developing of an Automatic Processes and Information and database management with tools of Oracle ETL tools like Workflow
• Extensively used mapping parameters and variables to support SQL override and reusability.
• Expertise in tuning the performance of the jobs by identifying the bottlenecks at the informatica workflows
• Experienced in partitioning the data to improve the load processing in Informatica.
• Good experience in using the Appworx scheduling tool to automate the process and to set the dependencies.
• Proficient in using the UNIX commands and in writing the UNIX Shell scripting in automating the process.

Environment: Informatica Power center 8.6, Oracle 10g, Flat files, SQLServer 2000, TOAD, Perforce, TOAD, workflows, Solaris UNIX and Appworx

Confidential, PA

ETL Consultant

Responsibilities:

• Involved in gathering of business scope and technical requirements and created technical specifications.
• Developed complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Created synonyms, used the sequence generator transformation type to create sequences for generalized dimension keys and Lookup transformation to identify slowly changing dimensions.
• Fine-tuned existing Informatica maps for performance optimization.
• Worked on Informatica Designer tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and monitor.
• Involved in the development of Informatica mappings and also tuned for better performance.
• Created mappings by creating logic that sends the error rows to error table so that they can be corrected and re-loaded into a target system.
• Used Teradata load utilities to load data using Informatica loader connections
• Involved in the Unit testing and System testing.
• Analyzed existing system and developed business documentation on changes required.
• Involved in making the adjustments in Data Model and SQL scripts to create and alter tables.
• Extensively involved in testing the system from beginning to end to ensure the quality of the new system up-gradation.
• Worked on various issues on existing Informatica Mappings to deliver the results.
• Efficient Documentation was done for all phases like Technical Specs, development, testing, migration and maintenance.

Environment: Informatica Power center 8.5, Oracle 10g,teradata HP UNIX 11.0, FTP, MS VISIO, Remedy, PVCS, TOAD for Oracle and MS Visual Source Safe.

Confidential, CT

ETL/ Data Warehouse Developer

Responsibilities:

• Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse
• Handled the documentation of entire ETL Process from the ODS, Staging, to the MDW warehouse environment
• Used all the Informatica client components like Designer, workflow Manger, Workflow Monitor, Repository Manger, and Repository Admin Console.
• Installed Informatica Server on the Linux Box and configured the clients on windows environment
• Created repositories, folders, and users for the development, staging, and production environment
• Designed mappings from the scratch and also did performance tuning of the mappings that were previously implemented
• Extensively worked with incremental aggregation
• Responsible for performance tuning at various levels like mapping level, session level, and database level
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Worked with various kinds of partitions like Round Robin Partitioning, Hash Partitioning, Key Range Partitioning, and Pass-through Partitioning.
• Extensively worked with Connected and Un Connected Look up Transformations in the Designer of Informatica Powercenter.
• Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
• Scheduled and ran the Informatica mappings according the business logic
• Extensively worked with Linux and wrote several shell scripts

Environment: Informatica Power Center 7.1.3(Repository Manager, Designer, Workflow Manager, Workflow Monitor), Business Objects, T-SQL, Oracle 9.2.0.6, UDB DB2, Sybase, Linux, Windows XP, Control M

Confidential, San Bruno, CA

Data Warehouse Developer

Responsibilities:

• Involved in the analysis and designing of the data warehouse system requirements.
• Extracted data form Flat files and Oracle database, and applied business logic to load them in the central oracle database.
• Responsible for data extraction and data cleansing from databases external to the company.
• ETL was developed using Informatica to transform and load the data.
• Implemented various transformations like Expression, Lookup, Sequence Generator, Source Qualifier, Rank, and Aggregator etc. to load the data from Staging area to DW.
• Developed Mappings/Transformation/Mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter7.1.
• Created and Monitored Sessions and Batches using Informatica Server Manager. Managed the Metadata within the repository.
• Used FTP to transfer the files between UNIX and Windows.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.

Environment: Informatica PowerCenter 7.1 (Repository, Designer, Work Flow Manager), SQL Server, Oracle 9i, Flat Files, SQL, PL/SQL, UNIX, Windows 2000/NT.

Confidential, Pittsburg, PA

DW Developer

Responsibilities:

• Designed and maintained logical and physical Data warehouse schemas using ERWIN.
• Consolidate data from various departments into the data warehouse by identify the common data and solve the discrepancy on data values and created various data marts.
• Involved in the requirement definition and analysis in support of Data Warehouse and ODS efforts.
• Developed ETL mappings, transformations using Informatica Power Center 6.1.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL (Power center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalizer, Union, Stored Procedure and sequence generator.
• Created, launched & scheduled Workflows/sessions. Involved in the Performance Tuning of Mappings and Sessions
• Scheduled the batches using UNIX.
• Used Informatica repository manager to backup and migrate metadata in development, Test and production systems.
• Automation of job processing, establish automatic email notification to the concerned persons.
• Involved in Design, Development and Implementation of Enterprise Wide Reporting system using Cognos Suite.
• Supported to Production team for solving the issues.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Center 6.1, Oracle 9i, MS SQL Server 2000, T-Sql, ERWIN 3.5, Toad 7.3, Sybase, Unix Shell Scripts, UDB DB2, Business Objects, HP-UX 11i,Test Director, Sun Solaris 5.4

Confidential

Programmer

Responsibilities:

• Planned the application schema, designed database objects like Tables, Indexes, views, sequences and integrity constraints using technical documents.
• Worked closely with system administration during software installation and upgrades
• Involved in analysis, design, coding, testing, data conversion and implementation
• Used complex SQL queries to the query the database
• Used bulk collect, collection objects and ref cursor
• Used hints for query optimization
• Generated summary and detailed reports
• Created test cases and done all types of testing
• Rebuild the indexes for better performance
• Resolved the bottlenecks in the performance issues and helped in tuning the application
• Pinned the frequently used packages and procedures in the memory

Environment: Oracle 8.x/7.x, Reports 2.x/3.0, PL/SQL, SQL, MS Office, Windows 95/98