PROFESSIONAL SUMMARY:

• Above 10.5 years of IT experience in ETL Architecture, Development, Enhancement, Maintenance, Production support, Data Modeling, Reporting including Business requirement, system requirement gathering of Enterprise Data warehouses for Insurance, Banking and Finance domains.
• Ability to coordinate the flow of development initiatives and Experience in Requirement Analysis, Design, Development, all the phases of Testing like Unit testing, Integration Testing, Regression testing, Performance, Acceptance testing.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Hands on experience using Informatica Power Center 9.x/8.x, SSIS and Business Objects.
• Expertise in Developing Mappings, Define Workflows & Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Sybase, XML, DB2, Oracle, SQL Server.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, Transaction Control, Java and update strategy.
• Extensively Implemented Error Handling Concepts, Testing, Debugging skills and Performance tuning of targets, sources, transformation logics.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Expertise in doing the RCA (Root Cause Analysis).
• Strong skills in analyzing the database design, Coding using SQL and PL/SQL, Oracle 10g / 9i / 8i / 8.0, SQL Server, and Sybase database applications. Coded Stored Procedures, Packages and Triggers using PL/SQL. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
• Experience in Git, PVCS, Virtual Source Safe (VSS), Clear Case and TFS for version controlling and promoting the code to higher region.
• Automation, Scheduling and monitoring of jobs with CTRL M, CRONTAB, DIS & AppWorx scheduler's.
• Experience in working with UNIX Shell scripts, Linux scripts, Batch scripts and necessary Test Plans to ensure the successful execution of the data loading process.
• Closely worked with business users at various stages of the project lifecycle, including requirements gathering, design, development, testing and post - production support.
• Ability to adjust to the people, circumstances & responsibility, with a Drive for results through self-motivation & self-candor.
• Management skills include Team Management, Project Planning, and Monitoring, documentation, presentation skills and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS:

Data Warehousing Tools: Informatica Power Center 9.1.0, MS SSIS 2008

Reporting Tools: Business Objects, Crystal Reports

Languages: PL/SQL, UNIX Scripting, XML

Databases: Oracle-11g, MS SQL Server 2000/2008

Tools: /Utilities: Toad, ORACLE SQL Developer & ICEM

Scheduling Tools: CTRL-M, Appworx & DIS (In-House Scheduling Tool)

Version Control Tools: PVCS, Clear case, Virtual Source Safe, TFS, Git

PROFESSIONAL EXPERIENCE:

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9.1.0, Oracle 11g, SQL Server 2008, Shell scripting, ICEM & CTRL M Scheduling Tool

ETL Team Lead (Onshore) & Sr. Developer

Responsibilities:

• Working closely with the business Analyst to understand the requirements and converting them into project level technical capabilities & reviewed it with an architect & Informatica Forum team.
• Created new PL/SQL Packages/procedures to update the DOL data into the database and to retrieve the same data to display it in the UI (Web service).
• Sourced the data from SQL Server and Oracle tables & created the XML target.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator and Stored Procedure.
• Parameterized the mappings and increased the re-usability.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• ICEM tool for code deployment to non-production environments.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Creating primary objects (tables, views, indexes) required for the application.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Creating the deployment documents and migrating the code to the production environment.
• Scheduling and monitoring of jobs with CTRL M scheduling tool.

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9.1.0, Oracle 11g, Shell scripting, CTRL M

ETL Team Lead (Onshore) & Sr. Developer

Responsibilities:

• Working with the business analyst to convert the business requirements into SDS/SRA & then convert them into project level technical capabilities (TSD).
• Reviewed it with an architect & Informatica Forum team.
• Created new PL/SQL Packages/procedures to update the Advisor Contact information into the database.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time and load it from staging database to the Live database.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Used Record Separator (RS) character while generating the flat file output to handle the new line, Carriage return etc. special characters.
• Parameterized the mappings and increased the re-usability.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Creating primary objects (tables, views, indexes) required for the application.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Creating the deployment documents and migrating the code to the production environment.
• Scheduling and monitoring of jobs with CTRL M scheduling tool.

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9.1.0, Oracle 11g, Shell scripting, CTRL M

ETL Team Lead (Onshore) & Sr. Developer

Responsibilities:

• Working as Team Lead, Assigning a task, tracking the assigned task and discussed different approaches with the developer team.
• Working closely with the business users to understand the requirements and converting them into project level technical capabilities (TSD).
• Created new PL/SQL Packages/procedures to update the PLAN - FBI data into the database and to retrieve the same data to display it in the UI (Web service).
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Used Java transformation to split the concatenated strings & Aggregator to concatenate it again.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator and Stored Procedure.
• Parameterized the mappings and increased the re-usability.
• Designed & implemented common modules of error handling for all the jobs using Relational database and send rejected data to the production support team.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Creating primary objects (tables, views, indexes) required for the application.
• Involved in creating the ETL design document and reviewed it with an architect & Informatica team.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Creating the deployment documents and migrating the code to the production environment.
• Scheduling and monitoring of jobs with CTRL M scheduling tool.
• Also, used Golden Gate tool to replicate the date from MDM to ODS database.

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9.1.0, Oracle 11g, Shell scripting, CTRL M

ETL Team Lead (Onshore) & Sr. Developer

Responsibilities:

• Working as Team Lead, Assigning a task, tracking the assigned task and discussed different approaches with the developer team.
• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Created new PL/SQL Packages/procedures to update the DOL data into the database and to retrieve the same data to display it in the UI (Web service).
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Sourced the data from XML files, flat files, and Oracle tables. Also, Created the XML target.
• Used Dynamic lookup to load the target tables. Also, implemented the persistent cache for lookup.
• Used Java transformation to split the concatenated strings & Aggregator to concatenate it again.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Sequence generator and Stored Procedure.
• Used Golden Gate tool to replicate the date from MDM to ODS database.
• Designed & implemented common modules of error handling for all the jobs using Relational database and send rejected data to the production support team.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
• Creating primary objects (tables, views, indexes) required for the application.
• Involved in creating the ETL design document and reviewed it with an architect & Informatica team.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Creating the deployment documents and migrating the code to the production environment.

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9, Oracle 11g, Shell scripting & CTRL M

ETL Team Lead (Onshore) & Onsite Coordinator

Responsibilities:

• Worked closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Lead an offshore team of 5 members, assigning a task, tracking an assigned a task and discussed different approaches with the developer team.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Used Java transformation to generate images/LOGO from the BLOB column in WIDE CRM Distribution hub.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Carrying out impact analysis for change requests.
• Designed & implemented error handling for all the jobs using Relational database and send rejected data to the production support team.
• Implemented session statistics/monitoring for all the jobs using Informatica MX Views.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements. Involved in Fine-tuning SQL overrides for performance Enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Involved in creating the ETL design document and reviewed it with an architect & Informatica team.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Analysis of various functionalities for self & team to come up with solutions/logic.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Creating the deployment documents and migrating the code to the production environment.
• Followed Informatica recommendations, methodologies and best practices.

Confidential, Durham, North Carolina

Tools: Informatica Powecenter 9, Oracle 11g, SQL Server 2008

Sr. Developer (Onshore) & Onsite Coordinator

Responsibilities:

• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse from Salesforce.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Parameterized the mappings and increased the re-usability.
• Developed complex mappings in Informatica to load the data from various sources.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Analysis of various functionalities for self & team to come up with solutions/logic and participated in design discussions.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Prepared Test Plans for Unit test and System Integrated testing of Informatica Session and Workflows.
• Co-ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans.
• Creating the deployment documents and migrating the code to the production environment.
• Documentation for all the ETL processes carried in Informatica.

Confidential, Richmond, Virginia

Tools: Informatica Powecenter 9.1.0, MS SSIS 2008, SQL Server 2008

Sr. Developer (Offshore)

Responsibilities:

• Extracted data from MS SQL Server database and applied business logic.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the database.
• Extensively used Transformations like Router, SQL, Joiner, Expression & Update strategy.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Confidential, Charlotte, North Carolina

Tools: Informatica Powecenter 9.1.0, SQL Server 2008

Sr. Developer & Production Support (Onsite)

Responsibilities:

• Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used SQL Query Analyzer utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections (DIS User Guide).
• Followed Informatica recommendations, methodologies and best practices.
• Schedule jobs on a daily/weekly/Monthly/Yearly basis Using DIS Tool.

Confidential

Tools: Informatica Powecenter 9.1.0, MS SSIS 2008, Oracle 10g, SQL Server 2008, Appworx, Crystal Reports & Business Objects

Sr. Developer & Onsite Coordinator

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle & MS SQL Server database and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center & MS SSIS for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Extensively used Toad & PL/SQL Developer utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.
• Schedule jobs on a daily/weekly/Monthly/Yearly basis Using Appworx.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Interaction with the offshore team on a daily basis on the development activities.

Confidential

Tools: Informatica Powercenter 8, Oracle, and UNIX Scripting

Sr. Developer & Onsite Coordinator

Responsibilities:

• Interaction with business and Solution analysts for requirements gathering & Detailed analysis of requirements.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Analysis of existing system to provide an impact analysis and high level estimates.
• Analysis of various functionalities for self & team to come up with solutions/logic and participated in design discussions.
• Coordination with Change control team.

Confidential, Lynchburg, Virginia

Tools: Informatica Powercenter 8, Oracle, Appworx

Sr. Developer & Onsite Coordinator

Responsibilities:

• Co-ordination with Business for any query/Issue resolutions & Mapping of business requirements to system requirements
• Interaction with the offshore team on a daily basis on the development activities.
• Development of ETL using Informatica 8.6.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and PL/SQL Developer to develop queries and create procedures and packages in Oracle.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created various tasks like Session, Command, Timer and Event wait.
• Documentation of the new functionality developed.