SUMMARY

• 7+ years of IT experience in Analysis, Development, Implementation, Testing, and support for Data warehousing applications.
• 6+ years of extensive experience in using Informatica PowerCenter tool 9.5.1/9.0.1/8. x/7.x for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Have clear understanding of Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirement analysis, design, development, testing and implementation.
• Extensive experience in ETL of data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter (Repository Manager, Designer, Workflow manager, Workflow Monitor).
• Experience in integration of various relational and non relational sources such as Oracle, DB2, SQL Server, Flat Files, XML files and Cobol files.
• Hands on experience in data warehousing techniques such as data cleansing, Surrogate key assignment, Slowly Changing Dimensions SCD TYPE 1, SCD TYPE 2 and Change Data Capture (CDC)
• Extensive worked in ETL process consisting of Informatica Data Transformation (Filter, lookup, Sorter, Normalizer, Update strategy Transformation, Router) Data Sourcing, Mapping Conversion and Loading
• Extensively used heterogeneous data sources, flat files to load data from source systems to targets using Direct and Indirect method
• Vast experience in error handling and troubleshooting in Informatica. Experience in Performance Tuning of Source, Targets, mappings, sessions and Transformations.
• Experience in Scheduling and monitoring jobs using informatica scheduler as well as control - M.
• Over 7 years of experience working on Databases such as Oracle 11g/10g/9i/8i, SQL Server 2000, Microsoft SQL server-2008, Sybase, DB2 and MS Access.
• Strong experience working with SQL, PL/SQL Stored Procedures, Triggers and Packages. Experience in UNIX shell scripting to support the ETL process.
• Expérience in on-shore and off-shore support model activities.
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented.
• Excellent analytical and problem solving skills; proven ability to effectively manage time and resources and prioritize tasks in order to consistently complete projects on time

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications. Extensively worked on Process Design, Development, Testing and Implementation of the Project.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
• Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
• Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Defined Target Load Order Plan for loading data into Target Tables. Used Informatica’s features to implement Type II changes in slowly changing dimension tables.
• Created tables, views, primary keys, indexes, constraints and sequences.
• Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
• Different database triggers containing PL/SQL were created and stored in the database and fired off when contents of database were changed.
• Used debugger to test the mapping and fixed the bugs.
• Created and configured workflows, Worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in the architecture and management of data governance with Business Intelligence team.
• Used Control-M Tool to schedule shell scripts and Informatica jobs. Performed Unit Testing and validate results with end users.

Environment: Informatica Power Center 9.5, Oracle 11G, DB2, Clear Quest,AIX, Control M, PL/SQL Developer, SQL, Toad.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in translating business requirements to Technical specifications. Work with source system SMEs to identify the source data to be brought down to the Data mart.
• Involved in full project life cycle - from analysis to production implementation and support.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Developed the source to target mapping document for ETL development in Informatica.
• Worked Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data mart tables according to the source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.1, enabling the extract, transport and loading of the data into target tables and loading into the Teradata.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements, Troubleshoot, optimize, and tune ETL processes.
• Update the data dictionary on system data and mapping information.
• Responsible to create interactive Dash board reports as per the Business requirements. Documented and maintained and ensured the process and quality of the system.

Environment: Informatica Power center 9.1, Oracle, Teradata, Sybase Power Designer 15.2, XML, SQL Server, Toad for DB2 4.5, Flat Files, Quality Center, UNIX and ESP, Business Objects.

Confidential

ETL Informatica Developer

Responsibilities:

• Responsible for requirement definition and analysis in support of Data Warehousing efforts. Developed ETL mappings, transformations using Informatica PowerCenter 9.1/8.6.1.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensively used ETL Tool Informatica to load data from Flat Files, Oracle, SQL server.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Developed reusable Mapplets and Transformations.
• Developed and tested all the Informatica mappings and update processes.Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Joiner, Update Strategy, Java Transformations.
• Created events and tasks in the work flows using workflow manager.
• Responsible for tuning ETL procedures to optimize load and query Performance. Extracted and Loaded data into Teradata using FastLoad and mLoad.
• Designed data mappings for loading date for the Star Schema modeling, and FACT and Dimensions tables.
• Tested the mapplets and mappings as per Quality and Analysis standards before moving to production environment.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Involved in writing shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created debugging sessions before the session to validate the transformations and also used existing mappings in debug mode extensively for error identification by creating break points.
• Worked closely with business analysts and gathered functional requirements. Designed technical design documents for ETL process.
• Developed Unit test cases and Unit test plans to verify the data loading process.

Environment: Informatica PowerCenter 9.1.0/8.6.1 , Power Exchange, Oracle 11g/10g, SQL Server 2008, UNIX Shell Script, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Performed requirements gathering, developed Analysis & Design document (A&D), developed Project time line
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Developed standard mappings using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter for weekly, quarterly process to loading heterogeneous data into the data warehouse. Source files include delimited flat files, and SQL server tables
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL, Java and Sequence generator
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like event wait, event raise, email and command
• Used Informatica for loading the historical data from various tables for different departments
• Developed Informatica mappings for Slowly Changing Dimensions Type 1 and 2.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes
• Involved in the Unit & Integration testing of the mappings and workflows developed for the enhancements in the application.
• Code migration the Informatica jobs from Dev. to Test to Prod. Ensuring the Unit testing, Integration Testing, Job & Environment parameters testing along the way
• Scheduled and ran Extraction and Load processes and monitored tasks and workflows.
• Tuned the MMW databases (stage, target) for better, faster and efficient loading and user query performance.
• Created Informatica mappings with PL/SQL stored procedures/functions to in corporate critical business functionality to load data.
• Extensively worked on performance tuning of mappings, sessions, Target, Source and various ETL processes

Environment: Informatica 9.0.1, Oracle, DB2, Erwin, Oracle, SQL server, Shell scripting, TOAD.

Confidential

Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Involved in Analysis of the current system and Design solutions to create a centralized data warehouse as well as planning migration solutions from the current system to the new system.
• Used Informatica to extract data from different Source systems DB2 and Flat files then into Oracle Target system
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Involved in Development and Data Integration of the main components using Informatica Power Center.
• Used different Transformations like Expression, Router, Filter, Sequence Generator, Stored Procedure, Connected and Un-connected Look ups etc.
• Actively involved in the design and implementation of Physical and logical Data warehouses and Data marts, OLAP solutions, Multidimensional analysis.
• Developed logical models building hierarchies, attributes and facts extracting tables from warehouse
• Was part of scripting team for shell script to automate and migrate data from ODS to Data warehouse.
• Used the command line program pmcmd to communicate with the Informatica Server and for monitoring the workflow and tasks.
• Involved in performance tuning, monitoring and optimization of ETL loads. Involved in different team review meetings.
• Created the mapping and Functional Specs
• Managed software releases after each stage of the testing and defect removal. As well as resolving issues from UAT, System testing.

Environment: Informatica Power Center 8.6, Oracle 9i, Toad, Quest Central for DB2, UNIX, Windows NT, XML, Teradata, IBM DB2, MS Excel 97, Flat files, SQL, PL/SQL and UC4 Scheduling tool.