SUMMARY:

• 8.1 years combined IT experience in analysis, design, development, coding, testing, implementation, support of various projects using Data Warehousing tool, Informatica, Programming in Unix Shell Scripting, PL/SQL and Databases like Oracle, MS SQL Server.
• Very Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center, Power Mart (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Experience in Informatica PowerCenter Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, views, materialized views, Cursors at database level using SQL, PL/SQL for Oracle 9i/10G.
• Experience in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, testing, implementation and maintenance.
• Experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)
• Experience in using SQL, PL/SQL, TOAD, PL/SQL Developer.
• Expertise in using SQL*LOADER to load Data from external files to Oracle Database.
• Have experience in developing ETL mappings and testing them with various created test plan docs, test results and the code migration documents for SIT and PROD environment.
• Experience in writing Map Reduce programs for both Hive and pig in java.
• Experience in data load management, importing and exporting data using Sqoop and FLUME.
• Experience in creating Hive Internal/External tables and views using shared metastore, writing scripts in HiveQL, data transformation & file processing using Pig Latin Scripts.
• Excellent interpersonal skills; comfortable presenting to large Groups, preparing written communications and presentation material.
• Flexible & Quick learner, who can adapt and execute in any fast paced environment.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.x/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server) ETL, Repository, Metadata, DataMart, FACT & Dimensions tables, Physical & logical data modeling, Data replicator

Reporting Tools: Oracle BI Business Intelligence (OBIEE 10.1.3.x, Siebel Analytics 7.x.), Business Objects, Cognos 8.4 (Awareness)

Data Modeling: Physical and Logical Data Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow - Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 7.0/4.1/5.1

Databases: Oracle 10g/9i/8.0, MS SQL Server 7.0/2000/2005, OLTP,Teradata

Programming: SQL, PL/SQL,SQL*Loader, Unix Shell Scripting, C, SQL Tuning/ Optimization

Other Tools: TOAD, Excel, Word, Autosys, Teradata, SQL- Developer, MS-Office, SSRS, SSIS, Autosys, Secure FTP (SSH).

Environment: UNIX, Windows 2000/NT, Win XP

PROFESSIONAL EXPERIENCE:

Confidential, Jersey City, NJ

ETL Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Converted business requirements into technical documents - BRD, explained business requirements in terms of technology to the developers.
• Developed ETL Mappings and Test plans.
• The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plans to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Developed Complex Informatica Mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Designed various Mappings for extracting data from various sources involving Flat files, Oracle and SQL Server.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked on Performance Tuning to optimize the Session performance by utilizing, Partitioning, Push down optimization, pre and post stored procedures to drop and build constraints.
• Created UNIX Script for ETL jobs, session log cleanup and dynamic parameter.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor and Scheduler alert editor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.

Environment: InformaticaPowerCenter9.5/9.1, Oracle11g, MS SQL Server 2008 R2, Erwin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Shell Scripting, AIX, Putty, OBIEE 11g.

Confidential, Oaks, Pennsylvania

ETL Informatica Developer

Responsibilities:

• Responsible for full life cycle development including gathering requirements.
• Analyzing, coding, testing, and assisting with user acceptance testing, production implementation and system support for the IMS Data Warehouse Application.
• Will be a part of interviewing, gathering, documenting requirements and determining project scope from our Users; analyzing user requirements to create system designs, either coding all or sharing in the coding and development, unit testing, system testing, final implementation and post implementation monitoring.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Involved in Debugging and Troubleshooting Informatica mappings.
• Populated error tables as part of the ETL process to capture the records that failed the migration.
• Used Informatica Power Center 9.1/9.01/8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented various Data Transformations for Slowly Changing Dimensions.
• Hands on experience as an Administrator involving Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments
• Working on the changes in the Informatica Mappings and testing them for Analyze and Fix gaps in Daily Jobs related to IMS project.
• Respond and resolve ad hoc requests from application and business users. Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Environment: Informatica Power Center 8.6.1/9/1, SQL Server 2005/2008, TSQL, MS Excel, Windows XP/2003/2008, CA Scheduler.

Confidential, San Jose, CA

ETL Developer

Responsibilities:

• Involved in system study, analyze the requirements by meeting the client and designing the complete system.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in InformaticaPower Center 8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created E-mail notifications tasks using post-session scripts.
• Designed and developed unit test cases for system integration testing.
• Involved with the users in the creation of test scripts for the user acceptance testing
• Developed some scripts to take weekly backups of certain tables using korn shell and import/export utilities.
• Worked on tuning some individual mappings and oracle queries that causing performance bottlenecks.
• Written documentation to describe program development, logic, coding, testing and changes made.
• Working on data request tickets and assisting business users (non technical) to understand the quality of the data.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, DB2, SQL Server 2005/2008, PL/SQL, Toad, MS Access, Windows 2003, Shell Scripting, Sun Solaris 9.0, Windows 2003/2008, AutoSys.

Confidential, Burbank, CA

ETL Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Worked on Informatica tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules.
• Designed and developed various Mappings and Mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
• Extracted the source definitions from various relational sources like Oracle and Flat Files.
• Developed transformation logic for different mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Developed reusable transformations, Mapplets and Worklets and utilized mapping parameters, session parameters, user defined functions to optimize the performance.
• Worked on different transformations like Source Qualifier, Joiner, Filter, Update Strategy, Lookup, Rank, Expression, Aggregator and Sequence Generator to load data into target database.
• Responsible for Data Staging Development and Deployment.
• Handled Slowly Changing Dimensions of Type1/ Type 2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Extensively used Stored Procedures, Functions, Triggers and Packages using PL/SQL for creating Connected and Unconnected Stored Procedure Transformations.
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Utilized Informatica debugger for trouble-shooting and to test the data flow.
• Reviewed session log files to trace causes of bottlenecks and optimized them by tuning the transformation logic in mappings and SQL queries involved.
• Developed and Implemented UNIX shell scripts and scheduled different Informatica jobs.
• Created UNIX shell scripts and called as pre-session and post-session commands.
• Involved in Unit Testing and Integration Testing of the application.
• Documented the entire process. The documents included the mapping document, unit testing document and system testing document among other

Environment: Informatica Power Center 8.1, Oracle 10g, Flat files, UNIX Shell Scripting, PL/SQL, SQLServer, Toad.

Confidential, Maple Grove, MN

Informatica Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and requirements gathering.
• Worked with users and developers on requirements and gap analysis.
• Developed and Implemented ETL processes using Informatica client tools - Source Analyzer,Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
• Designed and developed complex aggregate, join, look up transformation rules to generate consolidated (fact/summary) data.
• Involved in Change data capture process using Slowly Changing Dimensions.
• Involved in Optimizing and Performance tuning on targets, sources, mappings, and sessions to increase the efficiency of session.
• Scheduled Workflows using AutoSys.
• Involved in developing SQL Scripts for extraction and loading of data to data warehouse.
• Developed Test Cases for Unit Testing, also involved in Integration, system, and performance testing levels.
• Create and maintain shell scripts for pre/post session operations.

Environment: Informatica 7.1.1, Oracle 10g, PL/SQL, SQL Server 2000, TOAD, AIX UNIX 5.1, Autosys.

Confidential, Bethesda, MD

Database Developer

Responsibilities:

• Involved in all phases of the application development.
• Wrote procedures to call various stored procedures from database.
• Designed the Database.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions.
• Developed various backend application programs, such as Triggers using SQL and PL/SQL language for the management for decision making.
• Wrote the validation XML files and properties file needed for validating user inputs.
• Developed Presentation layer using JSP, HTML and XML.
• Performed unit testing, system testing and user acceptance test.

Environment: JSP, Eclipse, Oracle database, PL/SQL, JavaScript, HTML, CSS.