PROFESSIONAL SUMMARY:

• Over 8 years of experience in Data Warehousing/Integration using ETL Tool Informatica PowerCenter 9.x/8.x/7.x across the business areas such as Pharmaceutical, Healthcare and Finance.
• Extensive experience in using Informatica PowerCenter 9.x/8.x/7.x and 6.x to carry out the Extraction, Transformation and Loading process as well as Administering in creating domains, repositories and folder.
• Knowledge of complete software development life cycle including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Actively involved in Performance Tuning.
• Experience in implementing update strategies and incremental loads.
• Usage of Informatica mapping variables/parameters and session variables Strong in UNIX Shell scripting.
• Scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Control-M.
• Expert in Oracle 11g/10g, IBM DB2 8.1, Sybase, SQL Server 2008/2005/2008, SQL, PL/SQL Stored procedures using Toad.
• Excellent communication, interpersonal skills, enthusiastic, knowledge-hungry self-starter, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS:

PROFESSIONAL EXPERINCE:

Confidential

ETL Developer

ETL Responsibilities:

• Gathered requirements from senior developers and stakeholders for implementing Pentaho Data Integration
• Used Pentaho Data Integration Designer 4.2.1 to create all ETL transformations and jobs.
• Used different types of input and output steps for various data sources including Tables, Text File and Excel and CSV files.
• Identify and analyze data discrepancies and data quality issues and works to ensure data consistency and integrity.
• Saved Pentaho jobs in enterprise repository and scheduled them to run in production on daily basis.
• Involved in the process of migrating code and scenarios from development to test and to production and building migration documents.
• Experience in using Configuration management tools Version Controllers like SVN, Clear Case Tools.

Environment: Oracle11g,Oracle SQL Developer, Pentaho Data Integration PDI/Kettle ,Pentaho Design Studio 4.2.1 ,SVN, UC4 Scheduler and UNIX shell scripts .

Confidential

ETL Developer

RESPONSIBILITIES:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Migration of objects across various environments
• Creation of Unit Test Cases.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue. Preparing the documents for test data loading.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.
• Actively involved in knowledge sharing, documentation and troubleshooting any SAP business objects related problems
• Actively involved in Migration of objects across various environments

Environment: Informatica Powercenter8.6.5,TOAD,OracleSQL,PL/SQL and SAP Business Objects3.1 Database: Oracle11g/9i, Sybase and Control M Scheduler.

Confidential

ETL Developer

• As one of the world's leading specialty biopharmaceutical companies, Shire has emerged as a company fully focused
• On a single purpose: to enable people with life-altering conditions to lead better lives.
• Shire has a global sales and marketing infrastructure with a broad portfolio of products and its own direct marketing capability in the US, Canada, UK, Republic of Ireland, France, Germany, Belgium, Italy and Spain.

RESPONSIBILITIES:

• Extraction, Transformation and Loading of the data using Informatica.
• Designed the target load process based on the requirements documents.
• Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Creating the ETL run book.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Recovering the failed Sessions and Batches.
• Involving in extracting the data from Oracle and Flat files
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue. Preparing the documents for test data loading.
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level. Developing, Testing and debugging the mappings in Informatica.

Environment: Informatica Power center 9.01, WinSQL, TOAD, Oracle SQL, PL/SQL and UNIX shell scripts Database: Netezza, Oracle10g/9i, SQL Server, DB2 8.0, and UC4 Scheduler.

Confidential

Position : ETL/Informatica Developer

Responsibilities:

• Gathered business requirements from business users and prepared functional specifications for various interfaces and Data Migrations.
• Developed ETL jobs to load data into XML files from Oracle database.
• Developed various mapping to migrate the data from ADMIN/LIMS to Darwin.
• Developed various interfaces like Darwin to Smart lab bi-directional interface, ADMIN/LIMS to Smart Lab bi-directional interface, MDI interface etc.
• Used Integration Manager to load data from XML files into Darwin system.
• Extensively worked on developing and modification of ETL Mappings using various Transformations like Source Qqualifier, Expression, Lookup, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Router transformations in Informatica Designer
• Extensively worked on creating Workflows for various Interfaces and Data Migrations
• Developed UNIX shell scripts to execute interfaces and data migration mappings.
• Scheduled workflows using UNIX command tasks to automate the entire process of fetching the source file from a different path and ftp it onto the server.
• Involved in creation of target tables in Oracle and Informatica mappings and workflows and executing them through UNIX Shell Scripts.
• Worked with heterogeneous sources from various channels like Sybase, Oracle, Flat files.
• Developed FTP scripts to move files across different servers.
• Files, XML Files and Excel files to target Oracle Data Warehouse.
• Loading the OLTP data into the Warehouse OLAP and built the Re-usable
• Created various UNIX Shell Scripts for scheduling, data cleansing and loading process
• Used pmcmd command in the UNIX shell scripts.
• Involved in Testing of Interfaces and Data Migrations.

Environment: Informatica PowerCenter 9.0.1,Integration Manager,Oracle11g , SQL,PL/SQL,Unix Shell Scripts Korn ,Windows XP ,TOAD 8.5,MQ series,ClearCase Explorer, Documentum.