SUMMARY

• Over 11 years of IT experience in diversified fields like Data Warehousing and Mainframe application development, out of which 8 years of experience in various Data warehousing applications.
• Extensively worked with large EDW systems in all functional areas including Insurance, Banking & Financial, Healthcare, Telecommunications and Retail.
• Design and develop Extraction, Transformation and Loading (ETL) processes using Informatica to streamline and automate the collection of data from source systems, as well as the production and distribution of ad - hoc reports.
• Experience in Data Warehousing, Ralph Kimball Methodology, Bill Inmon Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, Fact tables, Dimension tables.
• Extensively worked on Informatica Designer components - Source Analyzer, Warehouse designer, Transformation Developer, Mapplet, Mapping Designers and Workflow Manager Tools.
• Well versed in developing and testing complex mappings, using transformations like Filter, Router, Expression, Aggregator, Connected and Unconnected Lookup, Source Qualifier, Update strategy, Sequence Generator, Normalizer, Rank, Joiner and more
• Extensively used SQL Override function in Source Qualifier Transformation.
• Handling various loads like Daily Loads, Weekly Loads, Monthly Loads and Quarterly Loads using Incremental Loading Technique.
• Hands on experience in writing UNIX scripts for various purposes including FTP, Creating Parameter Files, file manipulation & keyword search, PMCMD scripts for triggering Informatica workflows.
• Experience using Oracle, SQL Server, DB2 databases for data warehouse, data mart.
• Knowledge on Teradata databases, SFDC model.
• Experience in understanding the Business requirements and translating them into detailed design along with Technical specifications.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• Extensively worked on applications using TSO/ISPF, COBOL, JCL, VSAM, DB2, SQL and CICS.
• Excellent Communication & interpersonal skills.
• Strong analytical skills, able to work independently and manage/lead Informatica ETL Teams.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center9.x/8.x/7.x, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Developer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer.

BI Tools: Cognos 8.x,10.x

Data Modeling: ERwin Data Modeler 9.x

RDBMS: Oracle 10.x/9.x/8.x, SQL Server 2008, DB2 on OS/390, Teradata

Languages: COBOL, JCL, CICS

Job Scheduling: Autosys, Informatica Scheduler, CA-7, OPC, ESP, Tidal

O / s: HP- UNIX, Windows XP/ 2003/2000/98, IBM OS/390

Tools: FTP, NDM, Telnet, SQL plus, SPUFI, QMF, ENDEVOR, FILE-AID

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Lead Reporting ETL Developer

Responsibilities:

• Developed new data model using ERwin Tool to accomplish the new Data flow for LODS Reporting.
• Responsible for end to end Informatica ETL Process Design, like Requirements gathering, preparing Technical solution document, Detail Design, Unit Test Cases and Deployment.
• For Business meeting, conversion of business rules into technical specifications.
• Prepared High Level Estimate and the milestone for whole team.
• Extensively used ETL Informatica for the extraction, Transformation and Load of source data which was from Oracle, DB2 and Flat Files.
• Extensively worked with Performance Tuning at the mapping level and session level.
• Responsible for mentoring Developers and Code Review of Informatica Mappings developed by other developers.
• Worked on Informatica Power Center Tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL Override.
• Developed Cognos framework and reports out of LODS.
• Extensive experience in onsite/offshore model and handled the work allocation and delivery to offshore teams.
• Responsible for best practices like Informatica naming conventions, Performance Tuning and Error Handling.
• Developed Reusable Transformations and Reusable Mapplets.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Create & schedule the Job using Tidal Scheduler.

Environment: Erwin Data Modeler Tool 9.5, Informatica Power Center 9.5.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Cognos 10.2.1, SQL Server 2008, Netezza, Tidal Scheduler.

Confidential, Wilmington, DE

Sr. Informatica Developer

Responsibilities:

• Gathered Business requirements from concerned users and analyzed the Functional Requirement Documents (FRD) and drafted the Technical Specifications based on the Informatica ETL standards and also conducted Impact and feasibility analysis.
• Used Informatica Power Center for extraction, transformation and loading (ETL) of data in the data warehouse.
• Created various Informatica jobs using transformations such as Source Qualifier, Normalizer, Union, Expression, Filter, Connected Lookup, Unconnected Lookup, Update Strategy, Sorter, Aggregator, Router, and Sequence Generator etc.
• Used Informatica Debugger for debugging mappings.
• Well versed in loading the Data into different targets from source systems like Flat files, Oracle, DB2 and loaded into Oracle and Flat files.
• Designed Reusable Transformations using the Transformation Developer & created Mapping Parameters and Variables.
• Extracting data from set of flat files through Direct or Indirect file methods.
• Created various Informatica tasks such as Sessions, Email, Decision, Control, Command, Timer, Assignment, Event Wait and Event Raise.
• Developed Error Logging and Error Handling methodologies.
• Implemented Global Parameter file to centralized all the parameters and variables for the Database connections, file paths etc.
• Tuned Informatica mappings for better performance using various strategies based upon the analysis done.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Created UNIX Shell scripts to create wrapper scripts to run the workflows and ftp the target files to Mainframes server.
• Installed Informatica PowerCenter 9.1 and configured in Development, QA and Production.
• Created deployment groups for deploying the mapping from one environment to another.
• Responsible for Release migration in between different environments.
• Provided 24/7 On-Call support to resolve the Informatica related issues on Production system and used to support ETL Applications.

Environment: Informatica PowerCenter 9.x/8.x, Oracle 10x, IBM DB2, UNIX Shell Scripting, CA-7 Scheduling tool, Windows XP, SQL Server.

Confidential, Pittsburgh, PA

Sr. Informatica Developer/Tester

Responsibilities:

• Responsible for end to end Informatica ETL Process Design.
• Extensively used ETL Informatica for the extraction, Transformation and Load of source data which was from Oracle, DB2 and Flat Files.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives.
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing.
• Performed data validation testing writing SQL queries.
• Extensively worked with Performance Tuning at the mapping level and session level.
• Responsible for Requirement Gathering Analysis and End user Meetings to obtain the valid mappings in informatica.
• Responsible for Business Requirement Documents BRD’s and converting Functional Requirements into Technical Specifications.
• For Business meeting, conversion of business rules into technical specifications.
• Responsible for mentoring Developers and Code Review of Informatica Mappings developed by other developers.
• Worked on Informatica Power Center Tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Extensively used Source Qualifier Transformation and used most of its features like filter, sorter and SQL Override.
• Extensively used LTRIM, RTRIM, ISNULL, ISDATE, TO DATE functions in Expression Transformation for data cleansing in the staging area.
• Responsible for best practices like Informatica naming conventions, Performance Tuning and Error Handling.
• Developed Reusable Transformations and Reusable Mapplets.
• Solid experience in debugging and trouble shooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Create & schedule the Job using IBM Tivoli OPC Job Scheduler.

Environment: Informatica Power Center 8.x/7.x (Repository Manager, Designer, Workflow Manager), Oracle 9x, SQL Server, OPC, ESP Scheduler.

Confidential, Woodland Hills, CA

Informatica Developer

Responsibilities:

• Worked with the Technical/Business analysts for requirements gathering, Business needs analysis, testing and project coordination.
• Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation
• Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier Transformation and Update Strategy Transformation.
• Worked extensively with various passive transformations in Informatica PowerCenter like Expression Transformation, Sequence Generator Transformation and Lookup Transformation.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data loads.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Responsible for performance tuning at the Mapping level, Session level, Source level and the Target level.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Worked with re-usable objects like Re-Usable transformations and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation.
• Extensively made use of sorted input option for the performance tuning of aggregator transformation.
• Used Filter transformation at the early stages of the mapping for the performance tuning of the mapping.
• Extensively used SQL Override, Sorter and Filter functions in Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and Master Outer Join in the Joiner Transformation.
• Used Update strategy transformation using functions like DD INSERT, DD UPDATE, DD DELETE, and DD REJECT to insert, update, delete and reject items based on the requirement.
• Responsible for migrating the workflows from development to production environment.
• Handled Unit testing for the mappings.

Environment: Informatica Power Center 7.x/6.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server 2000, Shell Scripting, UNIX, Windows XP, Autosys

Confidential, Duluth, GA

Informatica Developer

Responsibilities:

• Developed new mappings based on the business requirement document using Informatica Designer.
• Attended weekly Data Warehouse Team meetings on a periodic basis to update weekly status on pending enhancements.
• Directly responsible for the Extraction, Transformation and Loading of data from Source tables and files to Data Warehouse.
• Used different Data Warehouse techniques like Star-Schema, Snowflake Schema.
• Used different transformations like Joiner transformation, Update Strategy, Lookup transformation, Rank transformations, Expressions, Aggregator, and Sequence Generator.
• Extensively worked on performance tuning at the mapping level and session level in Informatica.
• Worked on Informatica PowerCenter Client tools like Designer, Workflow Manager, and Workflow Monitor.
• Worked with the Scheduling team for scheduling the Informatica Workflows.
• Worked with the Business Intelligence team for report generation.

Environment: Informatica Power Center 7.x/6.x (Repository Manager, Designer, Workflow Manager), Oracle, SQL Server, UNIX.

Confidential, Omaha, NE

Informatica Developer

Responsibilities:

• Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Loaded data from various sources like DB2, SQL Server, Flat files into Oracle data warehouse.
• Created Reusable Transformations, mapplets, Shortcuts for Sources and Targets to use across various Mappings.
• Created shell scripts using Informatica PMCMD command and scheduled using UNIX utility Maestro.
• Configured the sessions using workflow manager to have multiple partitions on Source data to improve the performance.
• Created and tested the data accuracy by creating complex Oracle SQL’s using analytical functions.
• Implemented screen door processing for validating and cleansing Flat file sources.
• Preparing and using test data/cases to verify accuracy and completeness of Informatica ETL process.
• Solid experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV Environment.

Environment: Informatica Power Center 7.x/6.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Oracle, UNIX, Windows XP.

Confidential, Columbus, OH

Software Developer

Responsibilities:

• Involved in Analysis, creating Low Level Design and High Level Design Documents.
• Analyzing the Cobol Programs and coding the COBOL programs as per requirements.
• Prepare High level Estimate and details project plan.
• Prepare Unit test cases and Unit plan for Testing.
• Implemented all the components into production and given support.
• Standards followed as per the client’s documentation.

Environment: COBOL, DB2, JCL, VSAM, Endevor, File-Aid

Confidential, Dodgeville, WI

Software Developer

Responsibilities:

• Involved in Analysis, creating Low Level Design and High Level Design Documents.
• Analyzing the Cobol Programs and coding the COBOL programs as per requirements.
• Prepare High level Estimate and details project plan.
• Prepare Unit test cases and Unit plan for Testing.
• Implemented all the components into production and given support.
• Standards followed as per the client’s documentation.

Environment: COBOL, DB2, JCL, VSAM, Endevor, File-Aid