SUMMARY

• 7+ years in Data Warehousing Technology and ETL methodologies includes Requirement Analysis, Data Analysis, Application Design, Development and Testing in Data Warehouse. Experience on Informatica Metadata Manager.
• Good Understanding of Ralph Kimball and Bil Inmon approaches and experience in Dimensional
• Data modeling, Star schema modeling, Snow - Flake modeling, identification of fact and Dimension tables, Physical and Logical data modeling.
• Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding in different domains.
• Involved in Full life cycle (analysis, design, networking, design, development and deployment) of ETL applications.
• Strong experience on Informatica Metadata Manager, Involved in pulling metadata from multiple sources such as Informatica Powercenter, ERStudio, OBIEE into Metadata Manager to run the end to end Data Lineage.
• Strong Oracle database experience using Indexes, Cursors, Constraints, Triggers, Indexes and Views. Highly proficient in large volume data migration to Enterprise Data Warehouse using Data pump, Oracle Export, Import, SQL*Loader modules.
• Proficient in requirements gathering, systems design, user-interface design, application architecture. Strong experience in Performance Tuning.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements. Exposure to Relational, Data Marts and Star/Snowflake Schema design concepts and experienced in Data Requirement Analysis and Implementation of Business Applications.
• Good understanding of relational database management systems like Oracle, SQL Server and Teradata, DB2, Sybase and extensively worked on Data Integration and Migration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Ability to interpret and implement complex business rules.
• Extensively worked on data warehousing techniques for slowly changing phenomenon (type1, type2, type3) using various kinds of transformations like Expression, Source Qualifier, Aggregator, Filters, Connected/ Unconnected lookups, Router, Sequence generator, Update strategy and more.
• Extensive Knowledge in writing UNIX shell scripts, PL/SQL procedures, Views, Functions and JIL scripts to automate jobs using Automated tools like Autosys, Control M
• Proficient in Performance tuning of sources, transformations, targets, mappings, worklets, workflows and sessions.
• Experience in Informatica Power Center Administration and Informatica server installation, repository configuration and debugging.
• Experience with Business Intelligent Tools COGNOS 8.0, Business Objects XI.
• Experienced in supporting end-user reporting needs using Informatica. Efficiently involved in interacting with Business Analysts, Department Managers and Business Users. Competence to Manage and deliver results on multiple tasks by effectively managing time and priority constraints. Ability to address any ongoing or changing Business needs.
• Involved profusely in Production support, Deployment and Testing. Good problem solving, reporting and statistical skills with excellent communication and inter-personal skills.
• Demonstrates excellent troubleshooting and analytical abilities. Demonstrated ability to work both in independent and team-oriented environments.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.x/7.x/6.1 (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager), Informatica Power Mart 6.x/5.x, Power Exchange, Power Connect, Power Analyzer Data Profiling, Data Migration and Data cleaning, Flat file system (Fixed width, Delimiter), Cognos 8.0, Business Objects XI

Dimensional Modeling Tools: Dimensional Data Modeling, Star Schema, Snow - Flake Modeling, FACT and Dimensions tables, Physical and Logical Modeling, Erwin 5.1/4.1

Database: Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2 UDB 9, MS Access 2000, Tera Data.

Other Tools: TOAD 8.6, SQL * Loader, SQL * Plus, Autosys, Control M

Internet Technologies and Microsoft tools: HTML, XML, MS Office toolset ( Word, Excel, Visio, Power point, Share point)

Languages: C, C++, SQL, PL/SQL, Unix Shell Scripting, Java

Operating Systems: Windows XP/NT/2000, Windows Vista, Unix, Sun Solaris 8.0/9.0

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

ETL Developer

Responsibilities:

• Involved in gathering the requirements, performing scope analysis.
• Involved in requirements gathering, functional/technical specification, Designing and development of End-to-end ETL process for Sales Data Warehouse.
• Worked on Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems and flat files, which includes fixed-length as well as delimited files.
• Involved in creating the Business Glossary with the business terms in Informatica Metadata Manager.
• Involved in pulling metadata from Informatica Powercenter, ERStudio, OBIEE in to Metadata Manager and run the Data Lineage to see the data flow end to end.
• Executing the data lineage across source repositories and databases and analyzing the metadata.
• Involved in providing feedback and recommendations for managing metadata from the various metadata sources and in corporate Velocity standards for Metadata Management.
• Imported Source/Target Tables from the respective databases and build the code using various transformations, reusable transformations, Mapplet by creating Mappings using Designer module of Informatica.
• 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.
• Created complex workflows, with multiple sessions, worklets with consecutive or concurrent sessions and other tasks like Timer, Event Raise, Event Wait, Decisions and Email to transport the data to data warehouse tables using Informatica Workflow Manager.
• Worked on various issues on existing Informatica Mappings to produce correct output and used ETL debugger extensively to identify the performance bottlenecks within the mappings.
• Created Stored Procedures for data transformation purpose.
• Tuning Informatica Mappings and Sessions for optimum performance and designed and implements the error handling strategy for ETL team.
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
• Created a shell script to copy files from one folder to another and developed UNIX shell scripts using PMCMD utility to scheduled ETL load.,
• Tested all the applications and transported the data to the target Warehouse Oracle tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica work flow manager.
• Responsible for writing unit test cases and performing the unit testing for data validity based on business rules.
• Active member in providing on-call support for daily and weekly batch loads and helped with troubleshooting of ETL connectivity and response time issues.
• Involved in writing test scripts, unit testing, system testing and documentation.

Environment: Informatica Power Center 8.6 and 9, Informatica Metadata Manager, Oracle 10g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP, Erwin.

Confidential, Pittsburg, PA

Sr. ETL Developer

Responsibilities:

• Involved in gathering the requirements, performing scope analysis.
• Developed STAR Schema’s including identifying FACTS and Dimensions and Designed tables.
• Migrated data Developed STAR Schema’s including identifying FACTS and Dimensions and Designed tables.
• Migrated data from legacy system to Data Warehouse using ETL methodologies.
• Developed Complex ETL (Extract/Transform/Load) procedures to provide a way to update/insert/delete data from multiple heterogeneous sources.
• Used Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Developed mapping using parameters and Variables.
• Used Workflow Manager for creating validating, testing and running sequential and concurrent batches.
• Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database.
• Created Stored Procedures for data transformation purpose.
• Tuning Informatica Mappings and Sessions for optimum performance and designed and implements the error handling strategy for ETL team.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Created Mappings to pull data from the source table and loaded data into Oracle database. Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.
• Used TOAD front-end tools to issue SQL commands matching the business requirements to Oracle RDBMS.
• Scheduling of sessions and workflow and loaded data into data marts on a daily basis.

Environment: Informatica Power Center 8.6, SQL Server 2005, Fixed Width and Delimited Files, SQL Developer, Windows XP, Cognos 8, Unix.

Confidential, Irving, TX

Informatica Developer

Responsibilities:

• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings
• Migrated data from legacy system to Data Warehouse using ETL methodologies.
• Developed Complex ETL procedures to provide a way to update/insert/delete data from multiple heterogeneous sources.
• Creating and running Sessions & Batches using Work flow Manager to load the data into the Target Database.
• Did performance tuning of Informatica components for daily and monthly incremental loading.
• Involved in migrating ETL code from DEV to QA and QA to PROD by using Import/Export method.
• Tested the target data against source system tables by writing some QA Procedures, Functional and regression testing for deploying applications.
• Involved in Unit testing, User Acceptance Testing and provided complete Production support
• Provide written status reports to management regarding project status, task and issues.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Created and maintained several custom reports, universes for the client using Business Objects and generated reports using BO tools querying databases
• Coordinate with onshore business team and offshore development team to implement the project.
• Documented and presented the production/support documents for the components developed, when handing-over the application to the production support team.

Environment: Informatica Power Center 8.6, SQL Server 2005, Fixed Width and Delimited Files, SQL Developer, Windows XP, Cognos 8, Erwin, Unix.

Confidential, Tampa, FL

ETL Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Involved in ETL process from development to testing and production environments.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Created & Ran shell scripts in UNIX environment and written stored procedures in Oracle.
• Modified all the existing Informatica Mappings by applying performance tuning techniques for better performance.
• Checking the data flow and extensively using SQL Queries to extract the data from the Database and conducted data quality profiling and Oracle explain plan. Writing PL/SQL procedures for processing business logic in the database.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Performed Unit testing to validate mappings and populate the databases
• Scheduling of sessions and workflow and loaded data into data marts on a daily basis.

Environment: Informatica Power Center 8.1.1, Informatica Power Connect, Power Analyzer, Power Exchange, Oracle 9i, SQL, PL/SQL, MS Visio, DB2, Windows XP, TOAD, UNIX.

Confidential, Boston, MA

Informatica ETL Specialist

Responsibilities:

• Performed major role in under standing the business requirements and designing and loading data into data warehouse (ETL).
• Created and developed a series of mappings for handling different cases of input data in the same source table.
• Analysis of certain existing mappings, which were producing errors and modifying them to produce correct results. Used parameters and variables in mappings.
• Extensively used VBScript to check the file status, creating files and move the files from one directory to another directory.
• Worked on creating and editing sessions using Informatica Server Manager Source Settings, target Settings, Pre and Post-session commands, performance and advanced options, log time instructions, error handling settings, session level override for transformations.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.
• Responsible for monitoring all the sessions that are scheduled, running completed and failed.
• Involved in debugging the Mappings that failed using debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Created Mappings to pull data from the source table and loaded data into Oracle database.
• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions, Batch Jobs/Worklets and Workflows.

Environment: Informatica Power Center 7, UNIX, SQL Server 2000, Flat Files, Windows 2000

Confidential

ETL Developer

Responsibilities:

• Involved in gathering requirements from business users.
• Created Mappings using various transformations like Update Strategy, Lookup, Router, Joiner, Expression and Aggregator.
• Optimized various Mappings, Sessions, Sources and Target Databases.
• Worked with Mapping variables, Mapping parameters and variable functions.
• Involved in performance tuning of source, targets, mappings and sessions.
• Schedules and ran Extraction, Loading processes and monitored sessions using Informatica Workflow manager.
• Calculated values in a single row by specifying input/output ports before writing to the target using Expression Transformation.
• Created and developed a series of mappings for handling different cases of input data in the same source table.

Environment: Informatica Power Center 7, Oracle 8i, Microsoft SQL Server 2000, Flat Files, Windows 2000, Unix.

Confidential

DW Developer/SQL DBA

Responsibilities:

• Responsible in developing the logic and Data map for the enhancements.
• Creating Mappings specifications according to Business requirements.
• Responsible for Unit Test Development configuration.
• Creates sessions and executed batches using server Manager.
• Involved in creating the database procedures and triggers.
• Validate the data in warehouse and data marts after loading process balancing with source data.
• Supported, monitored and tuned Informatica ETL processes.
• Involved in production support.
• Involved in Unit Testing, Integration Testing and UAT
• Involved in performing daily DBA tasks.
• Worked on tickets to solve the issues.

Environment: Windows 2000, Informatica 6.2, SQL Server 2000, Perl