SUMMARY:

Extensive experience in Extraction and transform and load process of datawareware house applications. Worked with Informatica as an ETL tool for the extration of data from various sources like Oracle, flat files, Db2, COBOL files, DB2, SQL Server. Worked with Kimballs SDLC technology and a very good knowledge of Dimensional models. Created ETL mappings, mapping documents, mapplets, reusable transformations, sessions, batches, workflows, Worklets, scheduling of ETL process, written PL/SQL procedures, worked on performance tuning of ETL mappings, debugged mappings and mapplets, written unix scripts, worked on production support, Worked with modeling tool Erwin, created test cases and test plans, moved objects between dev to test and test to production environments. Has Knowledge of datawarehouse concepts and slowly changing dimensions.

PROFESSIONAL EXPERIENCE:

ETL Informatica Consultant

Confidential, MA

Environment: Informatica Power Center 10.4, Power Exchange, DB2, Oracle 19c, Unix, SQL, IP Switch, Data Studio, Sharepoint

Responsibilities:

• Created the Technical Specification documents for the business requirements.
• Participated on the meetings with the SME's to get understanding the source systems and the requirements on the target data load.
• Performed Data Analysis, Data Validation and Data verification.
• Extracted the healthcare Provider data from the source systems and loaded into the Target systems.
• Worked on the Agile project management process including the daily stand ups and Sprint planning methodology.
• Worked with the Informatica Power exchange to connect the Legacy DB2 database for extraction.
• Extracted data from DB2 source tables and load into the Informatica MDM Staging Oracle tables using Informatica Power Center.
• Worked on the Unit Testing and Integration Testing on the ETL processes.
• Created informatica Mappings, mapplets, reusable transformations.
• Worked with Onsite ETL resources and offshore ETL resources.
• Created Informatica Mappings to extract the outbound license data for the State mandate

ETL Informatica Consultant

Confidential, NC

Environment: Informatica Power Center 10.1, Informatica, Power Exchange (SAP Netweaver), SQL Server, DB2, Oracle, Unix, SQL, SAP BW, ECC, Toad Analyzer, ESP Scheduler, Sharepoint, HP ALM.

Responsibilities:

• Created Business Requirement Documents, Functional Specification documents and the Technical Specification documents.
• Participated on the meetings with the SME's to get understanding the source systems and the requirements on the target data load.
• Performed Data Analysis, Data Validation and Data verification.
• Created the Data migration plan and Informatica Code Migration Checklist.
• Created implementation plan for the ETL objects migration into the higher environments including Production.
• Created the documents for the ESP job submission request.
• Worked with the banks Financial Transactional data and Statistical data.
• Designed and developed Informatica Process to extract the data from the source systems and load into DB2, SAP BW and SAP ECC.
• Conducted code reviews on the new ETL process and the updated ETL Processes.
• Worked with the ALM tool to run the SIT and UAT test scripts.
• Worked with the ETL Testing team on the Integration Testing & Parallel testing processes.
• Expert on working with Change Requests, Defects and incidents.
• Performed the Informatica Administration tasks to support the team.
• Work with the DRM’s Master Data management and loaded the master data (Hierarchical data into the Mart and into BW).
• Worked with Onsite ETL resources and offshore ETL resources.
• Worked on the Production Support on the ETL applications.
• Worked with Job scheduling tool ESP.
• Extracted data from legacy systems using the Informatica power Exchange.
• Extracted data from the SQL Server database.
• Worked with CD (Connect Direct) for file transfer between Inbound and Outbound from the Applications.

Confidential, CO

Environment: Informatica Power Center 8.1, Oracle 9I, PL/SQL, Unix, Shell Scripting, Toad.

Responsibilities:

• Developed Informatica process to load data from the staging area to the vault area (target) and from vault area to Data marts.
• Configured Workflows with worklets, Sessions, event tasks, email tasks etc.
• Performed unit testing and integration testing.
• Configured the sessions with mapping parameters and parameter Files.
• Used parameters and variables at mapping and session levels to tune The performance of the mappings
• Worked on scheduling the Informatica processes.
• Created mapplets and used them in many mappings.
• Created reusable transformations and used them in the mappings.
• Extracted Data from SAP systems and load into the Datawarehouse
• Using Informatica Power Center.
• Extensive experience in working with the source analyzer, warehouse
• Designer, transformation designer, mapplet designer, mapping
• Designer, Workflow manager, Workflow monitor etc.

Confidential, PA

Environment: Informatica PowerCenter 7.1, Oracle 9I, PL/SQL, Unix, Shell Scripting, Toad, DB2, Mainframe Files (Data maps), MS Access.

Responsibilities:

• Created mappings, mapplets and reusable transformations.
• Created Workflows, Sessions, Tasks, worklets.
• Prepared test cases and test plans and unit tested the mappings.
• Used MS - excel and MS-Word for creating documentations.
• Worked with DB Link to connect mainframe using Oracle.
• Worked with Striva Details.
• Loaded IMS Data into the target tables using Informatica.
• Worked with mapping parameters and parameter files.
• Designed the technical mapping documents with the business Validation rules and the error handing conditions.
• Created PL/SQL stored procedures and used them with the stored Procedure transformation.
• • Extensively worked with Informatica to load data from flat filesDB2, Oracle to the target system.
• Followed the Informatica Naming standards in designing the
• Mappings, sessions, and workflows.

Confidential, IN

Environment: Informatica Power Center 6.2, Oracle 9I, PL/SQL, Erwin, Unix, Shell Scripting, Toad, Flat Files.

Responsibilities:

• Created the mapping documents based on the data model and the client requirements.
• Created Informatica mappings to load Clinical trial data into the data warehouse tables.
• Involved in requirement gathering and project planning.
• Worked on production support.
• Tested and executed the Informatica Mappings and resolved the issues within the mappings.
• Created Workflows, Sessions, Tasks, worklets, executed them and monitored them from workflow monitor.
• Written the PL/SQL procedures for loading data into the Warehouse.
• Responsible for testing of ETL maps
• Prepared test cases and test plans.
• Worked on performance tuning.
• Involved in analysis of data in various modules of the project.
• Worked with the data modeling tool Erwin.
• Written Unix Shell scripting for job scheduling.
• Worked with MS-Excel and MS-Word for documentation.