SUMMARY:

• Ten (10) years of experience in Information Technology with a strong working background in Data warehousing using Informatica and SAP BI nearly 8+ years of experience in ETL process using Informatica Power Center.
• Good Domain knowledge in Finance, Insurance, Retail, Investment Banking and HR systems.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata, DB2 and Worked on integrating data from flat files.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Strong experience with Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager and Informatica Server Manager, Workflow Manager/Monitor.
• Strong expertise on the various data design models like Star Schema and Snowflake models.
• Worked extensively with complex mappings using different transformations Like Source Qualifiers, Expressions, Filters, Joiners, Routers, Java with API Functions, Union, Unconnected / Connected Lookups and Aggregators.
• Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions.
• Experience of using Tortoise SVN to promote the code for other environments.
• Good knowledge on PWX and CDC for the different relational and other sources.
• Experience in peer reviews for existing developed mappings and provide the review comments for better quality.
• Working experience on Informatica Admin console using creating users, groups and assign the roles also migrate the informatica to upgrade versions.
• Good working knowledge about SQL and PL/SQL programming.
• Good working knowledge on Teradata TPT(MLOAD) to improve the performance of the data loads.
• Created and executed the workflows with sequential and concurrent in advance mode.
• Involved in extensive Production Support for crucial issues, Migration activities, and Production Support and deployment activities.
• Having Exposure on informatica cloud services using Data Syncranization, Tasks and Mapping creations using various cloud sources like Salesforce (SFDC) and relational database.
• Strong knowledge in Informatica Data Quality 9.6.1 using Developer and Analyst tools.
• Good knowledge on B2B integration solutions using Informatica B2B DT/ DX
• Very good team player with good communication and coordination skills, highly motivated and enthusiastic professional with a strong duty-first attitude.

TECHNICAL SKILLS:

Operating System: WINDOWS 2003/2000/NT/XP/7, AIX, Unix,Linux,WinSCP

Database: ORACLE 10g/9i/8i and EBS,MS SQL Server, DB2,Teradata

DB Tools: Toad for Oracle 11.5, SQL Developer, Sybase, Cerner,DB Visualizer Pro 9.0.6, SQL-Navigator, SQL*PLUS, SQL* Loader, PL/SQL 2.3/8.0,Epic

ETL Tools: Informatica Power Center/Developer 7.2/8.1/8.6.1/9.1.0/9.5.1/9.6.1, Informatica ILM, Informatica IDQ and Power Exchange.

Reporting Tools: Business Objects 6.2/5.1, Cognos7.0/8.0,Tabluea,Tabluea Admin,OBIEE Data Modeling Star Schema Modelling, Snow Flake Schema Modelling, ERWIN 4.0

Scheduling Tools: Autosys, ESP(Enterprise System Platform), DAC(Data ware house Administrative Consol),Control-M.

Project Mgmt Tools: Jira, Rally, Solution Manager, Remedy

Web Technologies: HTML, XML,Unix

Hardware: HP-K570, HP 9000/800, RS6000, Citrix Meta Frame

PROFESSIONAL EXPERIENCE:

Confidential,Saint Louise,MO

Sr.Informatica Developer

• Understanding the Business requirements based on Functional specification to design the ETL methodology in technical specifications.
• Followed Agile Model and daily involved in Scrum meetings.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture, EDW and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted data from different sources like SAP Power Designer, Flat files and into staging area and then to the access tables.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, JAVA with API, joiner and Rank transformations.
• Designed and developed with Confidential standard, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple source systems into the data warehouse.
• Modified existing mappings for enhancements of new business requirements through PCR’s and DMR’s.
• Created Unit Test documents for the mappings to test the data load.
• Documentation on Detailed Technical Design, Migration process, Test cases and ETL Run Book.
• Worked on Teradata TPT Loader to load the target tables.
• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.
• Extensively involved in writing queries for testing the target data against source data.
• Worked closely with QA team to discuss the UAT defects and responsible for maintaining.
• Offered production support services to resolve ongoing issues and trouble shoot them to identify the bugs .
• Experience in coordinating with cross functional teams and project management.
• Using Autosys scheduling tool to create jobs to run the informatica workflows.
• Involved in code Reviews as per ETL/Informatica standards and best practices.

Environment: Informatica Power center/Developer 9.6.1(HF2), UNIX,WinSCP, Teradata, Autosys, CA Workload control center, Toad for Oracle 11.5, IDR(Informatica Data Replicator), Remedy for project Management.

Confidential,Philadelphia,PA

Informatica Developer/Admin

• Responsible for Business Analysis and Requirements Collection.
• Followed Agile Methodology and daily involved in Scrum meetings
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture, EDW and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted data from different sources like Oracle, Flat files and Sql server databases into staging area and then to the base tables(DWH).
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Designed and developed with Cigna standard, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple source systems into the data warehouse.
• Modified existing mappings for enhancements of new business requirements.
• Created Unit Test documents for the mappings to test the data load.
• Involved in data validation from Source to staging to Target.
• Write BTEQ scripts to process and validate the data.
• Worked on TPT(Fast Load/MLOAD) to improve performance of the data loads.
• Worked on Informatica Admin consol creating users, groups and assign roles, And also validate integration services up and running.
• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.
• Extensively involved in writing queries for testing the target data against source data.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Worked closely with QA team to discuss the UAT defects and responsible for maintaining the
• Test results on Mercury Quality Center for defect tracking.
• Prepared and involved creating STM’s, TD and Job inventory as per the requirements.
• Using ESP(Enterprise System Platform) scheduling tool to create jobs to run the informatica workflows.
• Involved in code Reviews as per ETL/Informatica standards and best practices
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power center/Developer 9.6.1(HF2)/Admin, SQL Server Management Studio, UNIX,WinSCP, Oracle 10G, SQL, PL/SQL, SQL developer,SQL SERVER, Teradata, ESP(Enterprise System Platform),Rally for project Management, Microsoft Visio Standard 2010.

Confidential, Los Angeles,CA

Informatica Developer

• Responsible for Business Analysis and Requirements Collection.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Involved in building the ETL architecture and Source to Target mapping to load data into DWH.
• Created mapping documents to outline data flow from sources to targets.
• Extracted data from different sources like Oracle, Flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Used existing ETL standards to develop these mappings.
• Modified existing mappings for enhancements of new business requirements.
• Worked on extracting data from Oracle EBS and loading data to OLAP system
• Created Unit Test documents for the mappings to test the data load.
• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.
• Created SQL queries, for validating the target data against source data.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Created the users,groups and assign the role using informatica admin consol.
• Created and configured RS and IS through Admin consol.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Involved in code Reviews as per ETL/Informatica standards and best practices
• Creating task, subject areas and Execution plans and run the Execution plans.
• Running Informatica workflow through DAC and monitoring the data loads through DAC.

Environment: Informatica 9.1.0, Oracle 10G, Oracle EBS(CRM application),SQL, PL/SQL, DAC, IIR, OEDQ, OBIEE, Microsoft Visio Standard 2010 Informatica Admin.

Confidential, MO

Informatica Developer & Designer

• Analyze the business requirements and functional specifications.
• Involved in the design phase of the Informatica mappings.
• Review the Source to Target Mapping specifications and Transformation rules prepared by the Business Analyst.
• Used Informatica Power Center for extraction, transformation and load (ETL) of data in DWH.
• Extracted data from different sources like Oracle, Delimited and Fixed Width Flat files and load into ODS.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure for developing Informatica mappings.
• Parameterized the mappings and increased the re-usability.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Involved and writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Resolved Defects logged in the Mercury Quality Center during testing.
• Support to L2 team during any failures and delays of ETL workflows and autosys jobs.
• Extensively involved in writing unit Test Cases, queries for testing the target data against source.
• Involved in the documentation to describe program development, logic, and coding, testing, changes, corrections, preparing the test plan, execution and test report related to testing.
• Working with SVN(software versioning and revision control system) to update all the release related documents for every release with new release version number.
• For Release process guide the L2 team for DR in UAT and Release in PROD to make the release success.
• Involved and worked informatica migration from old version to new informatica version.

Environment: Informatica 8.6.1, 9.1,Windows XP, Oracle 11G, SQL, Sybase, PL/SQL, Toad, Autosys,Jira,Mercury Quality Center.

Confidential, Washington,DC

Informatica Developer & Designer

• Involved in Analysis phase of the business requirement, Functional Specifications and design of the Informatica mappings.
• Responsible for analyzing the Source to Target Mapping specifications and Transformation rules.
• Interact with the business analyst for any questions related to the business requirements, mapping Specifications and Transformation Rules.
• Extracted data from different sources like Oracle, Delimited and Fixed width Flat files and loaded into ODS.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure for developing Informatica mappings.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Preparation of LLD (Low level Design) documents, of HLD (High level Design) documents, UTP documents and Unit test cases.
• Involved in data validation from Source to staging to Target.
• Resolved Defects logged in the Mercury Quality Center during Testing.
• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.
• Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
• Extensively involved writing queries for testing the target data against source data.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica 8.1.1, IBM DB2, UNIX, Windows XP, SQL Server, Mercury Quality Center,Control-M.

Confidential, Fairfield,CT

Informatica developer

• Involved in the Design phase of the Informatica mappings.
• Analyzed the Source to Target Mapping specifications and Transformation rules.
• Extracted data from different sources like Oracle, Flat files and loaded into ODS.
• Used various transformations of Informatica, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter, Router, Joiner transformations etc for developing Informatica mappings.
• Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.
• Creating sessions and work-flows for the Informatica mappings.
• Creating various mapplets as part of mapping design.
• Used Exception handling logic in all mappings to handle the null values or rejected rows.
• Created Unit Test documents for the mappings to test the data load.
• Prepared SQL Queries to validate the data in both source and target databases.
• Resolved Defects logged in the Mercury Quality Center during Testing.
• Involved in Performance tuning for sources, targets, mappings, sessions and server.
• Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.
• Extensively involved in testing by writing some QA procedures, for testing the target data against source data.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Writing UNIX shell scripts for execution of the Informatica sessions and work-flows.

Environment: Informatica 7.1.4, UNIX, Windows XP, Oracle 9i, SQL, PL/SQL.

Confidential

BI Support & Development

• Understanding the system requirements
• Involved in Analysis and design of the system.
• Involved in deployment of the application on the server.
• Involved and worked on change requests(CR) as per the new business changes.
• Involved and worked on enhanced objects will be transported to respective target systems
• Testing the application (UT & IUT)

Environment: SAP BI, BEx Suite, Web Application Designer (WAD), Solution Manager.