SUMMARY

• Over 11 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.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in development and designing ofETL methodologyfor supporting data transformations and processing in a corporate wide environment using Informatica Power Center 9.x/8.x & MS SSIS 2008.
• Experience in integration of various heterogeneous data sources like Flat files, Sybase, Salesforce, XML, DB2, Oracle, SQL Server.
• Experience in Software full development lifecycle (SDLC)from requirements gathering through development & its approaches like Waterfall & Agile.
• 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 PL/SQL, Oracle 11g/10g / 9i / 8i / 8.0, MS SQL Server 2008, and Sybase database applications. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views. Experience in writing, testing, and implementation of thetriggers, cursors, procedures, and functionsat database level usingPL/SQL.
• 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.x/8.x, MS SSIS 2008

Reporting Tools (OLAP): Business Objects XI, Crystal Reports XI

Languages: PL/SQL, UNIX Scripting, XML

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

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

Data Modeling & Design Tool: Microsoft Visio

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

Version Control Tools: PVCS, IBM Clear case, Virtual Source Safe, TFS, Git/Stash/Jenkins

PROFESSIONAL EXPERIENCE

Confidential, Durham, North Carolina

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.
• Extracted data from Salesforce.com (SFDC) & data files using Informatica ETL mappings and loaded it into the Oracle tables.
• Worked onKey-Range, Round-Robin &Pass-through partitionsat PowerCenter session level.
• Created ETL process to generate XML files from Oracle tables using Informatica.
• 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

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.
• Involved in the design of the overall database using Entity Relationship diagrams.
• Created new PL/SQL Packages/procedures to update the Advisor Contact information into the database.
• CreatedSlowly Changing Dimension (SCD) Type 2mappings for developing the dimensions to maintain the complete historical data.
• 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

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

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.
• Extracted data fromXML, flat files and oracle databases and loaded it into Oracle usingInformatica.
• 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

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

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

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

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.