PROFESSIONAL SUMMARY:

• 10+ years of experience in all phases of software development life cycle ( SDLC ) including Analysis, Design, Development, implementation, Testing & Support in Data Warehousing implementations such as Financials and Banking,Oil & Gas , Health Care, Insurance.
• Expertise in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x and PowerExchange 8.1. .
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management .
• Extensively worked on the ETL mappings, analysis and documentation ofOLAP reports requirements.
• Experience in Database development skills using Oracle 11g/10g/9i/8i, SQL Server 2008, DB2, PL/SQL stored procedures and TOAD.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non - Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers , job scheduling .
• Extensively worked on developing and debugging Informatica mappings , mapplets , sessions and workflows.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Extensively worked on various Data warehouse projects using Informatica Client Tools - Source Analyzer, Transformation Developer, Workflow Manager, Workflow Monitor, Server Manager, Mapping Designer, Mapplet Designer and Warehouse Designer
• Experience in creating High Level Design and Low Level Design in the Design phase.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions, Dimensional Modeling (Star Schema and Snow Flake Schema), Normalization and De normalization Concepts.
• Experience in integration of various data sources like Oracle, SAP, SQL server, Mainframes, XML files and non-relational sources like flat files into staging area.
• Worked on Performance Tuning , identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Involved in Unit testing, Integration testing, System testing to check whether the data loads into target are accurate.
• Knowledge in using BI tools OBIEE , Business Objects.
• Experience in support and knowledge transfer to the production team.

TECHNICAL SKILLS:

Testing Tool: QC/ALM, Postman, SOAP UI, Rally, Jira, Clear Quest, Doors, QTP,TOAD, SQL Developer, Informatica, OBIEE, SharePoint

Programming Languages: .NET, SQL/PL-SQL, HTML, DHTML, Perl, PHP, Java, XML, CSS. Json

Databases: MS Office (Word, Excel, Power Point)

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Informatica ETL Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners (BRD).
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, HTTP, XML Parser, Mapplets, connected and unconnected stored procedures , Transaction Control SQL overrides usage in Lookups and source filter usage in Source qualifiers , and data flow management into multiple targets using Routers .
• Involved in data model structure and E-R modeling with all the related entities and relationship with each entity based on the rules provided by the business manager using ER/studio.
• Integrated Mortgage , Deposit data from Oracle to RDW database
• Integrated Customer data from SAP (Flat Files)to Oracle database using Informatica Power Center.
• Extracted Transactional data from SQL Server source systems and loaded into Data Warehouse using Informatica Power Center.
• Performed Informatica Administrator functions like creating Folders in Repository Manager.
• Extracted Products, Accounts data from Flat Files to oracle.
• Extensively used Change Data Capture ( CDC ), Incremental data load, Slowly Changing Dimensions ( SCD 1, 2).
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, Timer and scheduling of the workflow.
• Writing Oracle Stored Procedures , SQL scripts and calling them by using Perl shell scripts at pre and post session.
• Troubleshoot the issues by checking sessions and workflow logs .
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts in order to fetch the input files and archive them.
• Used UNIX shell scripts for scheduling and pre/post session management.
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Scheduled for daily and weekly batches using Control-M .
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.
• Involved in writing Unit test cases for complex scenarios.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Generated reports using Business Objects reporting tool .
• Prepared the Standard Operating Procedure ( Knowledge Transfer ) document, which provides necessary information, required for the Maintenance and Operation of the application.

Environment: Informatica Power center 9.5.1, Oracle 11g, SQL, PL/SQL, SQL server 2008,ER-studio, Flat Files, Windows, HP-UNIX and Linux (Perl),Control-M, Business Objects.

Confidential, Dallas, TX

Informatica ETL Developer

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners (BRD).
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Developed ETL routines using Informatica PowerCenter and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, HTTP, XML Parser, Mapplets, connected and unconnected stored procedures , Transaction Control SQL overrides usage in Lookups and source filter usage in Source qualifiers , and data flow management into multiple targets using Routers .
• Involved in data model structure and E-R modeling with all the related entities and relationship with each entity based on the rules provided by the business manager using ER/studio.
• Integrated Energy data from Oracle to RDW database
• Integrated Customer data from SAP (Flat Files) to Oracle database using Informatica PowerCenter.
• Extracted Transactional data from SQL Serversource systems and loaded into Data Warehouse using Informatica PowerCenter.
• Performed Informatica Administrator functions like creating Folders in Repository Manager.
• Extracted Billing data from Flat Files to oracle.
• Extensively used Change Data Capture ( CDC ) using PowerExchange .
• Worked on Incremental data load, Slowly Changing Dimensions ( SCD 1, 2).
• Worked on different tasks in Workflows like sessions, event wait, decision, e-mail, command, Timer and scheduling of the workflow.
• Writing Oracle Stored Procedures , SQL scripts and calling them by using Perl shell scripts at pre and post session.
• Troubleshoot the issues by checking sessions and workflow logs .
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts in order to fetch the input files and archive them.
• Used UNIX shell scripts for scheduling and pre/post session management.
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Scheduled for daily and weekly batches using Autosys .
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.
• Involved in writing Unit test cases for complex scenarios.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Generated reports using Microstrategy reporting tool .
• Prepared the Standard Operating Procedure ( Knowledge Transfer ) document, which provides necessary information, required for the Maintenance and Operation of the application.

Environment: Informatica Power center 9.6.1, Informatica PowerExchange 9, Oracle12c, SQL, PL/SQL, SQL server 2008,ER-studio, Flat Files, Windows, HP-UNIX and Linux (Perl), Autosys, Microstrategy.

Confidential, Windsor, CT

Informatica ETL Developer

Responsibilities:

• Responsible for coordinating with the Business Analysts to understand business requirement, functional requirements and conversion of business rules into technical specifications
• Responsible for creating High level and low level design specification documents for the ETL mappings.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Worked on Administration of Informatica Power Center .
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures , SQL overrides usage in Lookups and source filter usage in Source qualifiers , and data flow management into multiple targets using Routers .
• Integrated customer Remits(835) and customers Benefits(834) from PeopleSoft (RequestIT) to RDW database.
• Integrated Claims (837) and 277CA (Claim Acknowledgment) data from SAP (Learnet) environment using Informatica Power Center.
• Extracted data from DB2 and ORACLE source systems and loaded into Data Warehouse using Informatica.
• Performed Informatica Administrator functions like creating Folders in Repository Manager.
• Involved in the Conversion of Vantive master and transaction data to PeopleSoft CRM database.
• Involved in the conversion of Vendors and Customers masters data from legacy system Vantive to PeopleSoft CRM and RDW database.
• Reviewed various processes for Data integration into the enterprise data warehouse.
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Developed Slowly Changing Dimensions for Type 1 SCD.
• Writing Oracle Stored Procedures , SQL scripts and calling them by using Perl shell and Korn shell scripts at pre and post session.
• Troubleshoot the issues by checking sessions and workflow logs .
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management.
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.
• Created testing metrics using MS-Excel.
• Involved in writing Unit test cases for complex scenarios.
• Developed Schedules for daily and weekly batches using Control-m.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Generated reports using Business Objects reporting tool .
• Prepared the Standard Operating Procedure ( Knowledge Transfer ) document, which provides necessary information, required for the Maintenance and Operation of the application.

Environment: Informatica Power Center 9.0, PeopleSoft, Oracle 11g, SQL, PL/SQL, SQL server 2008, Solaris DB2. ER-studio, Control-M, Flat Files, Windows, HP-UNIX and Linux (Perl & Korn), Business Objects.

Confidential, Houston, TX

Informatica ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Prepared the High-level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Interacted with Administrationteam of Informatica PowerCenter .
• Developed ETL routines using Informatica PowerCenter and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures , SQL overrides usage in Lookups and source filter usage in Source qualifiers , and data flow management into multiple targets using Routers .
• Integrated Well, Well Bore, Area, Field, PU data from Oracle to RDW database
• Integrated Daily and Monthly volumes data from SAP ( MPRT ) to Oracle database using Informatica PowerCenter.
• Extracted Revenue and Transactional data from SQL Serverand ORACLE source systems and loaded into Data Warehouse using Informatica PowerCenter.
• Extracted Daily Volumes data and Gas analysis data using XML parser transformation to parse the XML source from Flowcal to TIPS
• Performed Informatica Administrator functions like creating Folders in Repository Manager.
• Reviewed various processes for Data integration into the enterprise data warehouse.
• Extracted Products, Accounts data from Flat Files to oracle.
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Extensively used Change Data Capture ( CDC ), Incremental data load, Slowly Changing Dimensions( SCD 1,2)
• Writing Oracle Stored Procedures , SQL scripts and calling them by using Perl shell and Korn shell scripts at pre and post session.
• Troubleshoot the issues by checking sessions and workflow logs .
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Written and used UNIX shell scripts in order to fetch the input files and archive them.
• Used UNIX shell scripts for scheduling and pre/post session management.
• Involved in the performance tuning process by identifying and optimizing source, target, mapping and session bottlenecks.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Interacted with key users and assisted them with various data issues, understood data needs and assisted them with Data analysis.
• Created testing metrics using MS-Excel.
• Involved in writing Unit test cases for complex scenarios.
• Scheduled for daily and weekly batches using Informatica power Center .
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Generated reports using OBIEE reporting tool .
• Created model using Framework Manager which is used to store the structure of table, column name using OBIEE .
• After creating model then created and published reports using Report Studio in OBIEE.
• Prepared the Standard Operating Procedure ( Knowledge Transfer ) document, which provides necessary information, required for the Maintenance and Operation of the application.

Environment: Informatica Power center 9.5.1, Oracle 11g, SQL, PL/SQL, SQL server 2008,ER-studio, Flat Files, Windows, HP-UNIX and Linux (Perl & Korn), OBIEE.

Confidential, Woonsocket, RI

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD ( Functional requirement Document ) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Experience in writing optimized queries in DB2 and Oracle environment for using in Informatica Power center mappings.
• Developed mappings for the conversion of Customers, Contacts, Products and Orders from Vantive to PeopleSoft database.
• Created mappings using the Transformations like Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Sequence Generator and Update Strategy .
• Created Mapplets , reusable transformations and used them in different mappings.
• Used Normalizer transformation to normalize COBOL source which is in a denormalized format.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation of Informatica mappings for source compatibility due to version changes at the source.
• Trouble shooting of long running sessions and fixing the issues.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Implemented daily and weekly audit process for the Claims subject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Developed shell scripts for Daily and weekly Loads and scheduled using UNIX utility.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Maestro .
• Involved in writing SQL scripts, stored procedures and functions and debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Used T-SQL for procedural programming, local variables, various support functions for string processing, data processing and changes to UPDATE and DELETE statements.
• 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.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scripts from development environment to production environment.
• Extensive experience in troubleshooting and solving migration issues and production issues.
• Used ILM for regulatory compliance.
• Supported technical teams involved with ORACLE issues and operations.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6.1, Oracle 10g, DB2, Mainframes, Unix, Maestro, Solaris, Business objects XI Release 2.