SUMMARY:

• 9+ years of professional IT development and implementation experience in Data Warehouse/ETL with emphasis on business requirements analysis, planning, design, development, testing, implementation and maintenance of ETL and Data Integration Solutions.
• Proven ability to apply Technical and Analytical Skills for the achievement of business solutions.
• Actively involved in all phases of SDLC.
• Extensively worked on designing and development of Complex Mappings, Mapp lets, Transformations, Web Services, Sessions and Concurrent Workflow Instances for data loads using Informatics Power Center.
• Strong understanding of Data Warehousing methodologies, Dimension Modeling such as Star and Snow - flake schemas.
• 9 years of experience with Relational Databases such as Oracle, SQL Server.
• Experienced in writing Stored Procedure for ETL processes and working knowledge of UNIX.
• Experienced in developing Test Cases based on Technical Specification to perform Unit/System/ Integration/User Acceptance Testing.
• Excellent skill in analyzing and validation of transformed Data Loads.
• Experienced in Performance Tuning/Optimization of Mappings and Sessions.
• Designed, developed and implemented Complex Error Handling for ETL processes.
• Ability to quickly adapt to changing priorities and requests.
• Ability to handle multiple tasks and enjoy working as a team member as well as independently.
• Excellent writing, communication, presentation, proven analytical & problem solving skills.

TECHNICAL SKILLS:

ETL Tool: Informatics Power Center 9.x/8.x/7.x

Database: Oracle 11g/10g/9i, SQL Server 2008/2005/2000

Languages: SQL, PL/SQL, T-SQL

Operating Systems: Windows 7/Vista/XP/2000, UNIX

Version Control: MS Visual Source Safe (VSS), IBM Rational Clear Case, MS SharePoint

Tools: MS-Office, TOAD, MS SQL Server Management Studio

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer

Responsibilities:

• Designed, developed and successful implementation of data integration module for Order Motion.
• Extensively interacted with business analyst to gather requirements and review sessions.
• Designed and developed complex Mappings for data integration for Order Motion.
• Demonstrated excellent understanding of technical specifications for order processing in BI.
• Scheduling of workflows with dependencies.
• Code deployments to various environments.
• Performance Tuning/Optimization of mappings and sessions.
• Designed, developed and implemented complex Error Handling for ETL process.
• Validated source data and target loads using TOAD, MS SQL Server Management Studio and Toad for MySQL.
• Resolved issues in a timely and proficient manner during System/Integration/User Acceptance Testing.
• Production support.

Technical Environment: Informatics 9.x, Cognos, Tableau, MS SQL Server 2012, MS SQL Server Management Studio, Oracle, TOAD, MySQL, Toad for MySQL, UNIX, MS Windows 7, MS SharePoint, MS Visio, MS Office, JIRA.

Sr. ETL Developer

Responsibilities:

• Designed, developed and successful implementation of data integration module for PeopleSoft Financial.
• Setup Development Standards for Informatics mappings, sessions and workflows.
• Extensively interacted with business analyst to gather requirements and review sessions.
• Designed and developed complex Mappings/Mapp lets/ Web Service components/Workflows for data integration for interfaces like - Concur, FedEx, and Legacy Source Systems using Common Source Template.
• Demonstrated excellent understanding of technical specifications for PeopleSoft Financial.
• Parameterization of workflows/sessions and configured Concurrent Workflow Instances for Concurrent Execution of workflows. Code deployment.
• Performance Tuning/Optimization of mappings and sessions.
• Designed, developed and implemented complex Error Handling for ETL process.
• Validated source data/DI tables/target loads using MS SQL Server Management Studio.
• Resolved issues in a timely and proficient manner during System/Integration/User Acceptance Testing.
• Key player during Technical code review sessions.

Environment: Informatics 9.x, OBIEE 11g, MS SQL Server 2008, MS SQL Server Management Studio, MS Windows 7/XP, MS SharePoint, MS Visio, MS Office, HP Quality Center 11

Sr. ETL Developer

Responsibilities:

• Understanding the client requirements, source CCMS Core Data, business objectives & participated JAD sessions of data models, ETL specifications and identification of dimensional attributes and facts to fulfill requirements.
• Translated functional specifications document into technical specifications. Explained business and technical transformation rules.
• Prepared business test case scenarios using Requirements Traceability to ensure effective coverage testing is achieved.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Designed and developed Mappings, Mapp lets and Workflows using Informatics Power Center.
• Scheduled the workflows using Informatics scheduler.
• Validated the data loads using TOAD.
• Coordinating with source system owners for proper data feeds, day-to-day ETL progress monitoring.
• Participated in Bug Triage and Status Review meetings.

Environment: Informatics 8.6/9.0.1, Oracle 11g, UNIX, TOAD, Windows XP

ETL Developer

Responsibilities:

• Involved in gathering technical requirements for the Data Warehouse.
• Experience in developing Informatics mappings to read data from XML source.
• Involved in analyzing, designing and developing ETL processes using Informatics Power Center for the data migration between various data layers.
• Implementation of ETL Mappings for the source systems Data Extractions, Data Transformations, Data Loads to staging, Data Warehouse/Data Marts.
• Experience in performance tuning of ETL processes for data migration.
• Coordinating with source system owners, different work stream leads and day-to-day ETL progress monitoring.
• Participated in bug triage and status review meetings.

Environment: Informatics 8.1.1, oracle 9, SQL Server 2000, TOAD, XML