SUMMARY

• Around 9 Years of IT experience in Data Warehousing (Business Intelligence) Development as an ETL Developer using Informatica.
• Experience in Information Technology Industry with strong technical and functional domain knowledge (Finance, Healthcare, Insurance, Banking, Corporate and Transportation) in Informatica and DWH.
• Experience in ETL/DWH Project Design, Development, Implementation, Testing, support, Upgrade and Maintenance using Informatica Power Center 9.x/8.x/7.x. and Oracle.
• Implementing Change data capture techniques with slowly growing target, Simple Pass through mapping, slowly changing dimension (SCD) type1 and type2.
• Well experienced in doing Error handling, Troubleshooting using various log files and problem fixing in Informatica as well as the performance tuning and also review of Informatica code & preparing the Unit test case.
• Proficient in Data Warehousing concepts.
• Expertise in Data Warehousing projects using Informatica 9.x/8.x/7.x, Informatica Data Quality (Data Analyst) IDQ 9.5.1, Oracle 10G/9i, Teradata, SQL & PL/SQL.
• Experience in data profiling & data quality rules development using Informatica Data Quality (IDQ) tools
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Experience on Installing and configuring Informatica components on Windows environment.
• Collaborated with Developers during Unit testing and debug Informatica Jobs.
• Self - starter and ability to adapt and learn new things quickly.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/8.6.1/8.1.1 Informatica Analyst 9.5.1(IDQ), Informatica Developer 9.5.1Mapping Architect Visio (MAV), ODI 10.1.3.5, BODI 11.7

Reporting Tools: Business Objects XI, Cognos, OBIEE 10.1.3.4, SSIS, Crystal Reports

Databases & Tools: Oracle 9i/10g/11g, Teradata 12.6, MS SQL Server 2000, DB2

Operating Systems: Microsoft Windows 2000/XP/NT, Linux, UNIX

Other Tools: SQL * Loader, Toad, PL/SQL Developer, Teradata SQL Assistant, Erwin r9.2Putty, SSH, WinSCP, HPSM 9.4

Languages: SQL, PL/SQL, UNIX

Scheduling Tools: Cronacle 6.0.2, Autosys, Control-M

Software: MS Office, MS Project, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

DW ETL - Analyst & Developer

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and Mapplets to transform the data according to the business rules.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.
• Using HPSM Record and classify receive, Investigate and diagnoseIncidents and undertake an immediate effort in order to restore a failed IT Service as quickly as possible
• Log all Incident/Service Request details, allocating categorization and prioritization codes

Environment: Informatica Power Center 9.5.1, Oracle 10g (Toad, Oracle, SQL Developer), UNIX, Putty, ESP Scheduler, HPSM 9.4

Confidential, Bridgewater, NJ

DW ETL - Analyst & Developer

Responsibilities:

• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Used Workflow Manager to create session task and other tasks.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Used debugger to test the mapping and fixed the bugs.
• Analyzing the dependencies between the jobs and scheduling them accordingly using the Work Scheduler.
• Support and Enhancement
• Improved the performance of the mappings, sessions using various optimization techniques.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Power Center 9.5.1, Oracle 10g (Toad, Oracle SQL Developer), UNIX (SSH-Secure File Transfer)

Confidential, Atlanta, Georgia

ETL Developer

Responsibilities:

• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Develop ETL flows and framework to support ETL development
• Development of ETL processes utilizing Oracle Data Integrator
• Developed interfaces to load the data from flat files.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL Developer 7.1.3., UNIX, Control-M.

Confidential, Beaverton, OR

DW ETL - Analyst & Developer

Responsibilities:

• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc for data loads and data cleansing.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• Created transformations and mappings using Informatica Power center to move data from multiple sources into targets.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Developer 9.5.1 (IDQ), Informatica Administrator 9.5.1, Informatica Cloud, Informatica Power Center 9.5.1, Oracle 10g (Toad, Oracle SQL Developer), UNIX (SSH-Secure File Transfer)

Confidential, Lake Forest, IL

DW ETL - Analyst & Developer

Responsibilities:

• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Designed and developed Informatica DQ Jobs, Mapplets using different transformation like Address validator, matching, consolidation, rules etc for data loads and data cleansing.
• Preparation of technical specification for the development of Extraction, Transformation and Loading data into various stage tables.
• Created transformations and mappings using Informatica Power center to move data from multiple sources into targets.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1(IDQ), Informatica Developer 9.5.1, Oracle 10g (Toad), UNIX (SSH Secure Shell Client)

Confidential, Portland, ME

DW ETL/IDQ - Analyst & Developer

Responsibilities:

• Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Extensive knowledge and worked with Informatica Data Quality (IDQ 9.5.1) for data analysis, data cleansing, data validation, data profiling and matching/removing duplicate data in using of Informatica.
• Created source to target mappings, edit rules and validation, transformations, and business rules. Analyzed client requirements and designed the ETL Informatica mapping.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings
• Created transformations and mappings using Informatica Power center & Informatica Developer to move data from multiple sources into targets.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.5.1(IDQ), Informatica Developer 9.5.1, DB2, MS SQL Server 2000,Teradata SQL Assistant, UNIX (Winscp, Putty)

Confidential, Jacksonville, FL

DW ETL - Analyst & Developer

Responsibilities:

• Worked with business users to get the requirement and to involve in complete SDLC life cycle of RUP.
• Analyzed source data and gathered business requirements from the business users.
• Developed end-to-end ETL processes for RUP.
• Involved in Designing ETL Specification.
• Developed bulk mapping through PowerCenter mapping architect for Visio & MacroExcel.
• Designed and developed Informatica Mappings, and Sessions for data loads and data cleansing.
• Developed complex mappings and SCD type-I, Type-II mappings in Informatica to load the data from sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank, Router and XML transformations.
• Used Workflow Manager to create session task and other tasks.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.

Environment: Informatica Power Center 9.5.1, Oracle 10g, BO XI 3.1, Toad, UNIX, Mainframe, PowerCenter Mapping Architect for Visio (MAV)

Confidential, New York, NY

ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users
• Developed end-to-end ETL processes for US Public Finance.
• Extracting, Transforming and Loading data from Oracle, XML, Flat files and placing it into Data warehouse.
• Worked closely with business analysts to understand the business needs for decision support data.
• Worked on source Analyzer, Designer Mapping and Mapplet Designer and Transformations.
• Used Transformations like Router, Sequence Generator, Expression, Filter and Normalizer Transformations in Mappings.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
• Used Workflow Manager to create session task and other tasks.
• Used pre-session and post-session scripts for implementing various functionalities.
• Scheduled and Run Workflows in Workflow Manager and monitored sessions using Informatica Workflow Monitor.
• Improved the performance of the mappings using various optimization techniques.

Environment: Informatica Power Center 9.1, Oracle 10g, TOAD, BO XI, UNIX, Autosys, SQL*Loader, PowerCenter Mapping Architect for Visio, Microsoft Office Outlook

Confidential, Fairfield, CT

ETL Developer

Responsibilities:

• Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Testing and Preparation of the Documents
• Tested data through Informatica Data Validation and Data Profiling
• Monitoring the workflows till the end of loads
• Resolved the issues raised by the user
• Support and Enhancement

Environment: Informatica Power Center 8.6.1, Informatica Data Profiling, Oracle 9i, SQL/PLSQL, TOAD, UNIX

Confidential, Shelton, Connecticut

ETL Developer

Responsibilities:

• Set up the Topology including physical architecture, logical architecture and context.
• Created new models for the data sources - flat files, Oracle.
• Did reverse engineering for the data sources and targets.
• Develop ETL flows and framework to support ETL development
• Development of ETL processes utilizing Oracle Data Integrator
• Developed interfaces to load the data from flat files.
• Conducted code reviews and planned the knowledge transfer to client.

Environment: Informatica Power Center 8.6.1, Oracle 10g, PL/SQL Developer 7.1.3., UNIX, Control-M.

Confidential

ETL Developer

Responsibilities:

• Understanding the Business Requirements culminating in the preparation of the Technical Design Document.
• ETL design and development, Creation of the Informatica mappings, sessions and workflows to implement the Business Logic.
• Developed bulk mapping through PowerCenter mapping architect for Visio & Macro Excel.
• Unit testing.
• Follow Confidential coding techniques.
• Knowledge and understanding of processing data across multiple platforms.

Environment: Informatica Power Center 8.6.1,Informatica Power Exchange CDC, Power enter Mapping Architect for Visio, Oracle 10g, BO XI,SQL, Oracle SQL Developer.

Confidential

ETL Developer

Responsibilities:

• Gather the user requirements by interacting with Client.
• Configure the Data Integrator Job Server, Data Integrator Access Server, and repository usage & Prepare and review the ETL specs as per the design.
• Cleansing data in DI using proper data types and mappings
• Perform simple and complex transformations in Data Flows
• Creating, Testing and Executing Data Integrator jobs using Data Integrator Designer to transfer data from source to target
• Data integrator XI (ETL) in design and implementation of work flows, data flows and DI scripting.
• Debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data
• Deployment & Production Moves

Environment: Business Objects Data Integrator 11.7, Oracle 9i, BO, SQL/PLSQL, TOAD, Shell Script.

Confidential, Shelton, Connecticut

ETL Developer

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin
• Developed end-to-end ETL processes for Data Mart
• Extracted source data from flat files (UTF-8 & EBCDIC code page) and XML.
• Worked on source Analyzer, Designer, Mapping and Mapplet Designer and Transformations.
• Used Transformations like Router, Sequence Generator, Expression and Filter Transformations in Mappings.
• Used Joiner, Aggregator, Expression Update Strategy and Lookup Transformation to manipulate data related to Customers.
• Imported various heterogeneous and homogenous sources using Informatica PowerCenter Source Analyzer
• Responsible for Tuning and optimization Informatica mappings and oracle scripts.

Environment: Informatica Power Center 8.1.1, Oracle 9i SQL/PLSQL, TOAD, SAPBW, OBIEE, UNIX, Shell Script.

Confidential, Stamford, Connecticut

ETL Developer

Responsibilities:

• Resolve tickets, including analysis, bug fixes, data reconciliation, end-user testing and signoff, migration of fixes to production using GEHC’s Change Control process.
• Provide the necessary technical application support for the applications in scope.
• Interface with other support teams within GEHC, e.g. Production Support & Monitoring, Architecture, DBA’s etc. as required for application support, design & development, testing and deployment.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules and using Analyze, Explain Plan and optimizer hints.
• Documentation, Development and Unit testing of enhancements as per GEHC guidelines.
• Scheduled workflows, BTEQ Scripts, UNIX shell scripts using Redwood Cronacle Scheduling tool.
• Report on a weekly basis the status of Clarify Tickets & Enhancements, in a format approved by GEHC RTS Manager.

Environment: Informatica Power Center 8.1.1., Teradata 12.6 (Utilities like BTEQ, Mload), Oracle 9i, Redwood Cronacle, TOAD, UNIX.

Confidential, Fairfield, CT

ETL Developer

Responsibilities:

• Analysis and gathering of the Business Requirements.
• Interaction with IT team of the client for the purpose of business needs and understanding.
• Creating file specs and ETL specification.
• Data load strategy i.e. Insert/Truncate and CDC-technique
• Analyze, design and develop ETL applications and workflows based on business requirements.
• Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.
• Use Unix-script for trigger the file, dat file check validation, generate the indirect file, create the backup file after loading the into target

Environment: Informatica Power Center 7.1.3, Oracle 9i, Toad, UNIX