SUMMARY:

• 8 years of IT professional experience in Analysis, Design, Modeling, Development, Testing Implementation and Support of Data Warehousing applications in banking domain.
• Extensive experience in development and designing of ETL methodology for supporting data transformations and processing in a corporate wide environment using Informatica PowerCenter v8.6/ 9.6, Oracle (SQL, PL/SQL), Teradata, UNIX and Scripting.
• Involved in the Software development lifecycle (SDLC) from requirements gathering through development and support for Financial institution using Informatica PowerCenter, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Involved in creating data maps for mainframe datasets using Informatica Power Exchange 9.6.
• Knowledge of data warehousing techniques like Star/ Snowflake schema, Facts, Dimensions, Slowly changing dimension, Data Integration and other ETL methodologies.
• Experience in integration of various data sources like SQL Server, Oracle, Teradata and Flat Files.
• Involved in Informatica PowerCenter Migration from v8.6 to v9.6.1. In past, upgraded Informatica from v8.6 to v9.1.
• Skilled in Performance tuning, Error handling and Production Support.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, router, Expression, Lookup, Aggregator, Sorter, Update Strategy, Sequence generator and stored procedure transformations.
• Experienced with advanced Informatica concepts like Session Partitioning, High Availability, Push Down Optimization, Concurrent workflows etc.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Experience in scheduling the batch jobs using workflow monitor, Autosys and CA7 scheduling tools.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter v 8.6.1/ 9.6.1, Powerexchange 9.6, IDQ

Database: Oracle 9i, SQL Server 2000, PL/SQL, Teradata

Languages: PL/SQL, Unix Shell Scripting

Scheduling Tools: Autosys, CA7

Incident Management: Service Center, Infoman, Service Now

Other Tools: Toad 11, Teradata Studio 15.10, Teradata Unity Datamover, Teradata Viewpoint, Teradata SQL Assistant, Putty, WS - FTP, Endeavor & Harvest

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

Sr. Informatica Developer (Technical Lead)

Responsibilities:

• Interacted with business users and team leads for better understanding of business specifications & requirements, identifying data source and development strategies.
• Analysed business requirements, technical specifications, source repositories and physical data models for ETL mappings.
• Created technical Design documents and ETL jobs for extracting data from various heterogeneous sources, transforming it and finally loading it into the data warehouse using Informatica Powercenter v9.6.1.
• Developed simple and complex mappings for loading dimension and fact tables as per star schema technique using various active and passive transformations in Informatica Powercenter v9.6.1.
• Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines.
• Created re-usable workflows, sessions and other tasks like event wait, event raise, decision, command and email to run the workflows with the logic embedded in the mappings.
• Improved performance of ETL’s after applying advanced informatica concepts like session partitioning, high availibility, concurrent workflows and pushdown optimization.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Analysed session log files to resolve errors in mappings and managed session configuration for imporved performance.
• Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
• Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing Testing sessions and therefore meeting the business requirements and client standards.
• Creates and maintains all databases required for development, testing, education and production usage. Performs the capacity planning required to create and maintain the databases.
• Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments.

Environment: Informatica Powercenter v 8.6.1/ 9.6.1, Oracle 9i, PL/SQL, Teradata, TOAD, Teradata Studio, UNIX, Harvest, Autosys & CA7.

Confidential, Cleveland, OH

Sr. Informatica Developer (Module Lead)

Responsibilities:

• Prepared a detailed Technical Design Document after analyzing the Functional Specifications and Architectural Diagram. Technical Design Document captured all functional and technical requirements.
• Worked with different sources like Teradata, Oracle, SQL Server, DB2 UDB and flat files.
• Performed Data Cleansing before loading it on data warehouse.
• Developed numerous complex Informatica Mappings, Mapplets and reusable transformations using various transformations like Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Prepared datamaps for mainframe files/ datasets using PowerExchange v9.6.1.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings and sessions. This led to better session performance.
• Used Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Designed and developed pre and post session UNIX scripts (Extraction and loading scripts) and batch execution routines using mapping parameter/variable.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Created PL/SQL Procedures for data extractions, transformation and loading.
• Loaded data into Teradata by using BTEQ batch scripts.
• Performed Code review to ensure that ETL development was done according to client’s ETL standard and ensured that ETL best practices were followed.
• Raised ALM Defects, Change Requests and Incident Management, analyzed and coordinated resolution of code flaws for the development environment and hot fixed them in QA and production environments during the runs.
• Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments.

Environment: Informatica Powercenter v 8.6.1/ 9.6.1, Oracle 9i, PL/SQL, Teradata, TOAD, Teradata Studio, UNIX, Harvest, Autosys & CA7.

Confidential, Cleveland, OH

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of project (Gathering requirements from Business users, Preparation of detail Design, Development, Unit Testing, Deployment).
• Used Informatica PowerCenter for coding data quality rules and capture quality results.
• Developed mappings/ Reusable Objects/ Transformation/ mapplets by using mapping designer, transformation Developer and mapplet designer in Informatica Power Center 8.6/ 9.6.
• Created reusable transformations and mapplets which were used in other data quality mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and
• Sequence Generator, Update Strategy, Union, Lookup, Joiner, and Stored procedure
• Transformations.
• Used UNIX shell scripts in pre and post session commands to check whether ETL Audit succeeded or failed.
• Involved with Informatica migration team while migrating Informatica Environment from 8.6 to 9.6.
• Coordinated team efforts like handing over, tracking the timelines and reviewing the code and performing Testing sessions and therefore meeting the business requirements and client standards.
• Used Autosys JIL scripts for scheduling workflows.
• Status reporting and train new team members.
• Handling checking of informatica components into Harvest.
• Used Informatica Autosys and CA7 scheduler to run the Jobs in respective environments

Environment: Informatica Powercenter v 8.6.1/ 9.6.1, Oracle 9i - PL/SQL, TOAD, UNIX, Harvest, Autosys & CA7.

Confidential

Informatica Developer

Responsibilities:

• Daily load monitoring to provide results to business users on time.
• Respond to the incidents raised by users.
• Investigate and provide solution to the problems raised by users.
• Escalate the issues to the concerned groups (Admins, DBA etc) as per their requirement using Infoman and Service Center.
• Code review & EQA for all new applications which didn’t adhere to development standards.
• Defect assignment and resolving escalated issues.
• Defect tracking and maintaining defect and issue logs.
• Co-ordinate maintenance activities with Admins and DBA’s.
• Respond to Adhoc requests raised by users.
• Enhancement’s to the existing application, creation of value addition for process improvement.
• Giving updates to clients, end users, business users regarding issues.
• Manual processing of files in case of an incident.

Environment: Informatica Powercenter v8.6, Oracle 9i - PL/SQL, TOAD, UNIX, Harvest, Autosys & CA7.