SUMMARY:

• Over 11 years of professional experience, which includes development of Database, Data warehouse, Report applications using various technologies like Informatica 9.x/8.x/7.x, Oracle 9i/10g/11g, SQL Server 2005/2008/2008 R2/2012, Shell Scripting, Business Objects, OBIEE and many other tools as per the client application environment.
• Worked in the entire project life cycle, including case studies, analysis, design, development, testing, debugging, implementation and Production Support.
• ETL Informatica: Expert - level in designing and developing complex mappings to extract data from multiple sources such as flat flies and RDBMS tables using Informatica Power Center, Developer clients - IDQ, Power Exchange, Informatica MDM.
• Designer tools - Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager and Workflow Monitor.
• Created complex mappings to load the data and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Lookup, Update Strategy, Rank etc., transformations.
• Experience in Debugging mappings using the Debugger in the designer tool to troubleshoot, test and fix the mappings accordingly.
• Experience in performing data cleansing, scrubbing and validating the data before loading the data into Data warehouse.
• Experienced in designing Slowly Changing Dimensions and Fact tables either to maintain historical data or capture recent changes.
• Over 8 years of Dimensional Data Modeling experience on Data modeling, ERwin 9.5/8.2/7.2.5/7.2, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamart, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Extracted data from various sources like Oracle, DB2, Flat files, SQL Server and loaded into Oracle and Netezza database.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in working with Tools- TOAD, Oracle SQL Developer,SQL Server Management Studio and SQL Plus.
• Experience in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Familiar with the BI reporting tool OBIEE in generating and developing reports.
• Excellent team player with good communication skills and ability to work independently and manage business expectations with a delivery-focused approach.
• Excellent troubleshooting, analytical, problem-solving skills and logical skills.
• Received client appreciation in April 2014 for Successful data conversion and loading.
• Received Client appreciation in June 2012 for contributing in building the Data load tool.
• Received POB (PAT on Back) award for the GNE Project in GSK, Satyam.
• Eager, Easier and Enthusiastic to learn New Technologies.

TECHNICAL SKILLS:

DW Tools: Informatica PowerCenter 9.5.1/8.6/7.5.1/7.3.1, informatica Developer 9.5.1, Power exchange, Informaticxa MDM 9.7.1, OBIEE, Business Objects

Databases: Oracle 8i/9i/10g/11g, SQL Server 2014/2012/2008/2008 R2/2005, Teradata, Netezza

Operating Systems: Windows, UNIX

Languages: C, C++, SQL, PL/SQL, Perl, XML

Tools: Toad 11.6/10.2.0.2/8.6, SQL Server Management Studio, SQL Developer, SQL Navigator, Win SQL, Quality Center, Bugzilla, Maestro, Harvest, Erwin, Microsoft Office

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Informatica Lead/Architect

• Provided Architectural Road Map, direction and work packets for ETL needs.
• Created technical specification documents like system design and detail design documents for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.
• Ensure SDLC life cycle is followed for project delivery related to design, development, testing and deployment.
• Created detail ETL Migration Processes for Informatica, Database, Scheduling, O/S and H/W teams.
• Implemented projects in Agile methodology.
• Provide estimations for ETL deliverables and oversee the progress for quality ETL Deliverables.
• Designed and developed ETL process using Informatica tool to load data from wide range of sources such as Sql Server 2005,Oracle 11g/10g and Flat files etc.
• Responsible for migrating the folders, mappings and sessions from development to test environment and Created Migration Documents to move the code from one Environment to other Environment.
• Created Mappings as per the requirements to extract, transform and load data from one application(FlowCal,PDR,Oracle Enterprise applications, TIPS etc.,) to downstream systems.
• Change Data Capture is done using Informatica Power Exchange.
• Based on the Business logic, Developed various mappings & mapplets to load data from various sources using different transformations like Source Qualifier, Filter Expression, Lookup, Router, Update strategy, Sorter, Normalizer, Aggregator, Joiner, SQL transformations, XML Transformation in the mappings.
• Used connected, unconnected lookup, static and dynamic cache to implement business logic and improve the performance.
• Developed mappings/sessions using Informatica Power Center 9.5.1 for data loading.
• Extensively worked on ETL performance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Used Partitions in Sessions to improve the performance of the database load time.
• Involved in writing SQL queries and PL/SQL stored procedures and functions for validating data.
• Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data warehouse.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Collaborate with data architects for data model management and version control.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL).
• Running and maintaining batch jobs in Unix environment.
• Created shell scripts to execute Oracle packages as informatica Pre/post commands.
• Created sessions and used pre and post session properties to execute scripts and to handle errors.
• Used Email task, Control task, Link and command tasks in Informatica Workflows.
• Involved in Unit testing to test Scripts developed by me.
• Maintained Detail Design Documents and Mapping Documents.

Environment: Informatica Power Center 9.5.1, Oracle 11g/10g, Informatica developer - IDQ, Power Exchange (CDC), Informatica MDM 9.7.1, SQL Server 2008, SQL Loader, Informatica scheduler, Toad for Oracle 11.6, SQL Developer, ERwin, MS-Office tools, SQL Server Management Studio, Flat files,UNIX, Putty.

Confidential,Houston, TX

Senior Informatica Developer/Lead

• Gathering the Functional requirements from the Business stakeholders.
• Translate the Functional requirements to Technical specifications.
• Ensure SDLC life cycle is followed for project delivery related to design, development, testing and deployment.
• Work with Project manager on status, project tracking and management of technical issues, risks, costs and communications.
• Created Mappings as per the requirements to migrate data from legacy system to new applications.
• Designed, Developed and Deployed data migration tool to the customer.
• Assisted and supported other regions of the customer in installing and usage of the migration tool.
• Developed mappings/sessions using Informatica Power Center 9.5.1/8.6.1 for data loading.
• Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Data cleansing and profiling was done using Informatica developer 9.5.1.
• Involved in writing SQL queries and PL/SQL stored procedures and functions for data validations.
• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using Toad.
• Running and maintaining batch jobs in WINDOWS Environment.
• Involved in Unit testing to test Scripts developed by me.
• Maintained Detail Design Documents and Mapping Documents.

Environment: Informatica Power Center 9.5.1/8.6.1, Informatica developer 9.5.1, Informatica Power Exchange (8.6.1/8.5), Oracle 10g, SQL Loader, Toad for Oracle, SQL Developer, MS-Office tools, Flat files, MS-Dos, XML, SAP MM, SAP SRM, SAP MDM.

Confidential,Anchorage, AK

Senior Informatica Developer/Lead

• Gathering the Functional requirements from the Business stakeholders.
• Translate the Functional requirements to Technical specifications.
• Ensure SDLC life cycle is followed for project delivery related to design, development, testing and deployment.
• Work with Project manager on status, project tracking and management of technical issues, risks, costs and communications.
• Created Mappings as per the requirements to migrate data from legacy system to new applications.
• Designed, Developed and Deployed data migration tool to the customer.
• Assisted and supported other regions of the customer in installing and usage of the migration tool.
• Developed mappings/sessions using Informatica Power Center 8.6.1 for data loading.
• Data cleansing and profiling was done using Informatica developer 9.5.1.
• Involved in writing SQL queries and PL/SQL stored procedures and functions for validating data.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for new data warehouse.
• Running and maintaining batch jobs in WINDOWS Environment.
• Involved in Unit testing to test Scripts developed by me.
• Maintained Detail Design Documents and Mapping Documents.

Environment: Informatica Power Center 8.6.1,Informatica developer 9.5.1, Informatica Power Exchange (8.6.1/8.5), Oracle 10g, SQL Loader, Toad for Oracle, SQL Developer, MS-Office tools, Flat files, MS-Dos, XML, SAP MM, SAP SRM, SAP MDM.

Confidential,Hartford, CT

Senior ETL Informatica Developer

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production.
• Created complex mappings that involved implementation of Business Logic to load data in to dimensional tables of a Data Warehouse.
• Extract data from Siebel CRM and loaded into Analytics Data warehouse.
• Developed mappings/sessions using Informatica Power Center 8.1.1 for data loading.
• Used Serena Dimensions to raise ECR’s and DCR’s.
• Used Quality Center for executing test cases.
• Involved in writing SQL queries and PL/SQL stored procedures and functions for validating data.
• Running and maintaining batch jobs in UNIX Environment
• Involved in Unit testing to test the applications developed by me.
• Maintained Detail Design Documents and Mapping Documents.

Environment: Informatica Power Center 8.1.1, Siebel CRM, OBIEE, Oracle 10g,SQL Loader, Win SQL, SQL Navigator, Autosys, Quality Center, Serena, MS-Office tools, Flat files.

Confidential,Columbus, OH

Senior ETL Informatica Developer

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in analysis of a particular application and to be discussed with Architect for approval.
• Created complex mappings that involved implementation of Business Logic to load data in to dimensional tables of a Data Warehouse.
• Replaced Netezza loader scripts into Informatica mappings for loading data into staging area.
• Developed mappings/sessions using Informatica Power Center 8.6 / 7.3.1 for data loading.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, Sequence generator etc.,
• Involved in Defects fix occurred in production.
• Used Quality Center for tracking defects.
• Modified some existing procedures for better performance.
• Wrote and modified UNIX shell scripts for batch processing.
• Involved in Unit testing to test the applications developed by me.
• Involved in SAT to check the functionality and performance of an application, by running the jobs in UNIX environments.
• Involved in analyzing source systems and designing the processes for Extracting Transforming and Loading the data to Netezza database.
• Prepared detailed documentation for the entire process.

Environment: Informatica Power Center 8.6/7.3.1,Power connect, Netezza, Teradata V2R5, Oracle 10g, SQL Loader, Netezza Loader, Win SQL, Maestro, Toad, Quality Center, Harvest, MS-Office tools, Flat files, XML, UNIX.

Confidential

Informatica Developer

• Created complex mappings that involved implementation of Business Logic to migrate data into target Database.
• Developed mappings/sessions using Informatica Power Center 7.5.1/ 6.2 for data loading.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, sorter, Sequence generator etc.,
• Involved in upgrading of mappings from Informatica version 6.2 to 7.5.1.
• Developed PL/SQL stored procedures for database updates and to create the necessary indexes in the target tables.
• Worked with SQL*Loader to load the data into the staging tables.
• Wrote shell scripts in UNIX for doing batch processing.
• Involved in Unit testing and UAT for the developed process.
• Prepared detailed documentation for the entire process.

Environment: Informatica Power Center 7.5.1/6.2,Oracle 9i, Teradata, Maestro, Toad 8.6, UNIX, SQL Loader.

Confidential

Informatica Developer

• Developed a system design document from Business User requirements.
• Worked on Informatica Power Center 7.3.1 tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Developed mappings using Informatica Power Center 7.3.1 to load data from source systems to target database.
• Designed and developed Lookup, Sequence Generator, Aggregator, Joiner, Router, Rank, Normalizer and Update transformation rules (business rules).
• Writing PL/SQL, Stored procedures, Cursors for processing business logic.
• Debugging the failed Sessions and Mapping.
• Worked extensively in Performance Tuning by removing the performance bottlenecks that occurs in the Source, Mapping, Session and Target.
• Documented processing times for each module, developed test cases and used them to run through each process.

Environment: Informatica Power center 7.3.1, Oracle 9i, SQL Server UNIX, Toad.

Confidential

Oracle/Informatica Developer

• Develop Informatica mappings for loading of data from Source to Staging layer and Staging to Detail layer.
• Created Procedures for extracting of data from source.
• Involved in unit testing by authoring and executing the unit test cases.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, Toad, UNIX.