Professional 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 with Business Intelligent Tools COGNOS 8.0.
• 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 Competencies

Professional Experience

Confidential

Informatica Developer

Responsibilities

• Involved in gathering the requirements, performing scope analysis.
• 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.
• 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.
• 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.
• 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.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Unit testing, User Acceptance Testing and provided complete Production support
• Provide written status reports to management regarding project status, task and issues.
• Scheduling of sessions and workflow and loaded data into data marts on a daily basis.

Environment: Informatica Power Center 9.5, Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP.

Confidential

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 incorporate 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 9.1 and 9.5, Informatica Metadata Manager, Oracle 11g, Cognos 8.0, Autosys, UNIX, Toad, Windows XP, Erwin.

Confidential

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 and 9.1, SQL Server 2008 and SQL Server 2012 R2, Fixed Width and Delimited Files, SQL Developer, Windows XP, Cognos 8, Unix.

Confidential

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

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.