SUMMARY:

• 7+ years of IT experience in development and design of ETL methodology for supporting data transformations and processing including Analysis, Design, Development, Implementation, Migration of Warehouse applications built in a corporate wide ETL Solution using Informatica PowerCenter 9.x/8.x/7.x/6.2/5.1.
• Proficient in all phases of the Software development lifecycle (SDLC).
• Has Strong knowledge in the Data Analysis, Data Modeling and Data Extraction, Transformation and Loading - ETL functions in Data Warehouse and Integration projects
• Expertise in using Data Modelling Tools for creating Conceptual, Logical and Physical Data Models and Source-to-Target mappings at every phase from OLTP to Staging area to Data warehouse to Data marts to OLAP cubes and Decision support system reports.
• Expertise in Extraction/Transformation/Loading of the legacy data to Data Mart/Data Warehouse using ETL Tool Informatica.
• Have functional knowledge in RDBMS and technical experiences include PL/SQL, Oracle, Teradata, SQL Server.
• Good understanding of both dimensional and relational modeling concepts like star-schema modeling, snow flaking, ER modeling at logical, physical and presentation levels.
• Expertise in Mappings, Sessions, Workflows, Mapplets, Reusable Transformation, Shared Folders, Shortcuts, Reusable tasks and Worklets.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer according to the business requirements.
• Worked with transformations like Source qualifier, Aggregator, Expression, Connected/ Unconnected Lookups, Filter, Router, Sequence Generator, Update strategy, Rank Etc.
• Implemented performance tuning techniques on Targets, Sources, Mappings and Sessions.
• Experience in implementing update strategies, incremental loads and change Data capture.
• Implemented Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.
• Excellent capabilities in integration mappings including dynamic cache lookup, shared, and persistence mappings for Type I, Type II, Type III SCD.
• Experience in UNIX working environment, writing UNIX scripts for parsing and data modification, data validation and FTP.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual. Experience in working with Off-shore and Near-shore models.

TECHNICAL SKILLS:

Operating System: MS-DOS, MS-Windows, UNIX, OS/390, Z/OS

ETL tools: Informatica Power Center 9.x/8.x/7.x, Informatica Data Quality (IDQ) 8.6

DB Load Utilities/Tools: SQL DEVELOPER, TOAD, TERADATA SQL ASSISTANT AUTOSYS,TIVOLI,CA-7,CRONTAB

Languages: SQL, PL/SQL, C, COBOL, JCL, CICS, REXX

DBMS: DB2, VSAM, Oracle, MS SQL Server, Teradata, Netezza, ADABAS

Scripting Languages: UNIX Shell Scripting

Mainframe: ISPF, COBOL, JCL, VSAM, CICS, FILEAID, ENDEAVOR, SMART TEST, PANVALET, QMF, SPUFI, IBM Utilities, SORT, REXX, CLIST

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

ETL Developer

Responsibilities:

• Created the Mappings and Mapplets using PowerCenter 9.5.1/9.1/8.1 Designer to extract and transform data from Oracle, Teradata, Mainframe Flat files to load into Oracle DW
• Widely used various Transformations in Informatica PowerCenter
• Extensively Worked on Shared Folders, Shortcuts, Mapplets, Reusable Transformations,Reusable tasks, Worklets
• Used Constraint Based loading & Target load ordering to efficiently load tables with PK-FK relation in the same mapping
• Created the Shell scripts and Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Session Actions
• Implemented SCD methodology including Type 1, Type 2 to keep track of data changes.
• Debugger is used to test the data flow and fixed the mappings
• Developed Test cases, Unit tested and reviewed the test results along with the QA team.
• Developed many UNIX Scripts to fix the historic and erroneous data in many tables.
• Trouble shooting of long runningSessionsand fixing the issues.
• Created Workflowsand used various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Session in the workflow manager.
• Involved in implementation/deployment of the projects. Help and coordinate with the team on technical issues
• Work with Quality control team to validate the test cases and test result documents.
• Worked on migrating the code from Informatica PowerCenter Versions 8.1 through version 9.5 and worked on updating the logic to accommodate the changes
• Supported production environments and users on a daily basis by responding to emergency requests
• Used debugger to test the mapping and fixed the bugs.
• Scheduled and executed batch and session jobs on Autosys.
• Experience with Informatica Advanced Techniques - Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.

Confidential, Nashville, TN

ETL Developer

Responsibilities:

• Involved in requirement gathering from the business users and converted them into mapping documentation.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Rank Etc.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Identified the Bottlenecks, Removed the Bottlenecks and implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Wrote SQL overrides in source qualifiers for extracting only the required rows for optimal performance.
• Created complex transformations using connected/unconnected Lookups.
• Created Reusable Transformations and Mapplets in the designer using transformation developer and mapplet designer according to the business requirements.
• Performed Unit Testing of the mappings developed and ETL process to check if the transformations are executing as expected.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Validate the updates in oracle schemas after workflow success.
• Developed UNIX scripts for parsing & modifying data, data validation and FTP.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Used Multi-load, Fast Load and Tpump utilities in Teradata.

Environment: Informatica Power Center 8.6.0/8.1.1, Oracle 10g, DB2, WinSQL, Oracle SQL Developer, Teradata, UNIX AIX, Rational Clear Quest, RMT, MS Access, MS Office.

Confidential, Lexington KY

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, and development and testing.
• Interacted with business representatives for Need Analysis and to define Business and Functional Specifications. Participated in the Design team and user requirement gathering meetings, and prepared technical and mapping documentation.
• Initial design phase included in identification of our Fact and Dimension tables.
• Involved in the development of Informatica mappings and Mapplets.
• Extensively used parameter files.
• Worked with transformations like Source qualifier, Aggregator, Expression, Lookups, Filter, Router, Sequence Generator, Update strategy, Rank Etc.
• Analyzed Session Log files in case the session fails in order to resolve errors in mapping or session configurations.
• Coordinated with the DBA to increase the performance of the ETL process in the mapping by creating indexes on the target tables as needed, by analyzing the tables.
• Created and ran the UNIX shell scripts which in turn ran the "pmcmd" command to run workflows.
• Used WinSCP to transfer blended XML files between local and a remote computer.
• Enhanced the existing Informatica mappings to meet the new requirements.
• Wrote pre-session and post-session commands for processing shell scripts.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.

Environment: Power Center 7.1.2, Oracle 9i, Sun Solaris 2.9, SQL*Plus, SQL*Loader, TOAD, PL/SQL, Flat files, UNIX scripts, Test Director 8.0/7.x/6.0.

Confidential

ETL- Informatica/ Oracle Consultant

Responsibilities:

• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica PowerMart/PowerCenter 6.2.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules. Loading data to staging area (Oracle 8i) using Informatica PowerCenter 6.2, worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Translated business-reporting requirements into data warehouse architectural design.
• Setting the security management that entailed creating user groups and assigning privileges.
• Documenting the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Writing PL/SQL packages to achieve numerous tasks
• Fixing the problems in PL/SQL code and any problems with DDL scripts for tables and indexes and escalating the issues in severe cases to the development and other support teams..
• Tuning SQL statements using Explain Plan Tool and Optimizer Hints for best response time.
• Created naming and system standards for lookup, transformation and target tables.
• Loaded consolidated data using SQL*Loader in parallel and direct mode.

Environment: Oracle 8i, Erwin, Informatica Power Mart 6.2, SQL*Loader, UNIX, Windows NT, Crystal reports.