SUMMARY:

• Software Professional around 9 years of IT experience in Business Requirements Analysis, Designing, coding and testing of Data Warehousing implementations.
• Well versed with Informatica PowerCenter (9.5.1/9.1/8.5/8.1.1 ) and Strong experience in performing ETL using Informatica PowerCenter Designer,Power CenterExchange, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in interacting with Business Users to gather Business Requirement Specifications (BRS) and prepare Technical Specifications.
• Worked with whole spectrum of application development cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Expertise in analyzing data through out each project phase, and provide relevant outputs and results from the data quality procedures, including any ongoing procedures that will run after project end.
• Good experience in the field of Data Warehousing, OLAP (online analytical processing), OLTP (online transaction processing) using ETL Informatica tool.
• 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.
• Experienced in preparing Technical design document, mapping documents, data definition documents and Detail design document for the Source/Target mapping.
• Strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Understanding & working knowledge of Informatica CDC (Change Data Capture).
• Strong knowledge of software development life cycle (SDLC).
• Extensive experience in the ETL testing, manual testing and Business Intelligence Applications.
• Experienced in integrating from various data sources like Flat Files, databases (Oracle, SQL Server, and MS Access) and handling large volumes of data.
• Developed UNIX Shell Scripts for triggering the Informatica workflows.
• Good Experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using SQL, PL/SQL.
• Experience with performance tuning of Oracle using Oracle Partitioning and Indexes.
• Well versed with tools like TOAD and SQL plus for development and customization.
• Worked on automating the Informatica jobs, Informatica Scheduler, Autosys, and UNIX scripts for automation.
• Excellent problem solving skills with a strong technical background and good interpersonal skills Proven ability to work as a part of a team as well as independently
• Excellent Analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i, IBM DB2, SQL Server 2005,2008, TeradataETL Tools: Informatica Power Center 8.6 9.1 9.5,Informtica Power Exchange 9.5/9.1

Scheduling Tools: Control - M, Autosys

Operating Systems: Windows, Unix, Linux, Sun-Solaris, HP-UX

Utilities: TOAD, SQL developer, Putty, MS Visio, Teradata, SQL Assist,:

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte NC

Team Lead/ Sr. ETL Informatica developer

Responsibilities:

• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Assisted in creating test data and test cases and execute function system tests as needed and tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience translating business problems into actionable data quality initiatives
• Meeting with business users and defining Functional and Technical business requirements.
• Extensively created Reusable Transformations and Mapplets to implement the business logic for loading to the target database.
• Extensively used all the Transformations like source qualifier, aggregator, filter, joiner, Update Strategy, Unconnected and connected Lookups, Router, Sequence Generator etc. and used transformation language like transformation expression, constants, system variables, data format strings etc.
• Extensively worked on Workflow Manager and Workflow Monitor to create, schedule, monitor Workflows, Worklets and various tasks like command, assignment, control and session tasks
• Extracted data from various source systems like Oracle, Teradata, SQL Server and flat files as per the requirements.
• Designing the ETL process flows to load the data into Oracle Database from Heterogeneous sources.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Developed post-session and pre-session shell scripts for tasks like merging flat files after Creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Optimized query performance, session performance.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control totals, automate the process of loading, pulling and pushing data from and to different servers.
• Involved in Structural and Functional Testing and Migrating the Code to Production.
• Onsite - Offshore team coordination.

Environment: Informatica PowerCenter 9.5.1/9.1,Informatica PowerExchange 9.5/9.1, Oracle 10g/9i, TOAD 9.0, SQL Developer, PL/SQL, UNIX.

Confidential, New York

Sr.ETL Informatica developer

Responsibilities:

• Involved in system study, analysis of the requirements and designing of the complete system.
• Worked on handling large amounts of data in millions per day.
• UNDP is a utilities project where we handle live data which usually comes in millions depending on the number of customers.
• Extensively designed, developed, tested Informatica mappings to extract data from external flat files, oracle tables using Informatica.
• Written SQL overrides in Source Qualifier and Lookups according to business requirements.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow variables and Session Parameters.
• Extensively used the Expression, Router, Filter, Lookups (Connected/Unconnected), Update strategy and Aggregator transformations.
• Implemented Informatica Pass through partitions extensively to improve the performance of the mappings.
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Created connected and unconnected lookup transformations to look up the data from the source and target tables.
• Created UNIX shell scripts in order to schedule the workflows based on requirement.
• Created Unit test cases and also documented each of them.
• Performed Informatica code migration from development to testing and testing to production systems.
• Onsite - Offshore team coordination.
• Implemented standards for naming Conventions, Mapping Documents, Technical Documents, and Migration form.

Environment: Informatica PowerCenter 9.5.1/9.1,Informatica PowerExchange 9.5-9.1,Oracle 11g/9i, MS Access, TOAD 9.0, SQL, UNIX.

Confidential

ETL developer

Responsibilities:

• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Used Informatica Designer to Create, Load, Update mappings using different transformations to move data to different data marts in Data warehouse.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Successfully Loaded data into different targets from various source systems like Oracle data base, Flat files, SQL Server etc into Staging tables and then into Target Database.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager.
• Created Source, Target, Transformations, Sessions, Batches, and defines Schedulers for the sessions.
• Performed Incremental aggregation to load data into aggregate tables.
• Onsite - Offshore team coordination.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating Re-usable Transformation Objects and Mapplets.
• Extensive use of Persistence cache to reduce session processing time.
• Used Debugger in Mappings to debug the Complex mappings and fixed the Errors.
• Involved in moving Mappings, Sessions, and Workflows between development and production environments.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Worked on Reference Data table generation and to create and run data quality rules in Informatica Data Quality.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production environment.
• Prepared and used test data cases to verify accuracy and completeness of ETL process.
• Actively involved in Production Support and helped other team members.

Environment: Informatica PowerCenter 9.1/8.5, SQL SERVER 2008, Oracle 10g, SQL Assist, Toad, Unix Shell Scripts.

Confidential

ETL developer

Responsibilities:

• Responsible for gathering suit of business requirements, Prepare source to Target Mapping specifications and Transformation rules.
• Involved in System study, analyze the requirements by meeting the client and designing the system.
• Developed Mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica Power center.
• Extracted data from different Sources like Oracle, Flat files and loaded into ODS.
• Designed and developed complex Aggregate, Join, Lookup Transformation rules(Business rules) to generate consolidated (Fact/ Summary) data identified by dimensions using Informatica ETL tool
• Created Connected and unconnected Lookup transformation to look up the data from the source and target tables, used Update Strategy transformation.
• Implemented SCD- Type 1 and Type 2 according to the business requirements in the dimension tables.
• Workflow Manager used for creating and maintaining the sessions, Monitor, edit, schedule, copy, abort, and delete session.
• Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Workflow Manager, pmcmd and also using scheduling tools.
• Involved in Performance Tuning for sources, targets, mappings, sessions.
• Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating the connect strings and synchronizing the connect strings and connection objects in Dev, Test and Prod environments.
• Involved in end to end testing and created Test cases for those mappings.
• Worked with testing team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait Task, Decision task, Email task, Command task.
• Actively Participated in Team meetings and discussions to propose the solutions to the Problems.

Environment: Informatica PowerCenter 8.5, Oracle 9i, MS SQL SERVER, SQL, PL/SQL, UNIX Shell Script, Win 2000/NT.

Confidential

ETL developer

Responsibilities:

• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using Informatica.
• Worked on Data cleansing, data conversion & process implementation.
• Worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Involved in performance Tuning at the Mapping, Session and Target Level.
• Created Shell scripts to drop and Re create indexes to load data efficiently and decrease load time.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Implemented Informatica Power Exchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
• Developed Mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Union, Aggregate, Update Strategy, Joiner, Filter and Router.
• Implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
• Generated SQL loader scripts and shell scripts for automated daily load processes.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Created support documents for the mappings and sessions & Provided Production Support for business users.

Environment: Informatica PowerCenter 8.1, SQL Server 2000/2005, Oracle 8i, Linux, TOAD, SQL, PL/SQL, SDLC