PROFESSIONAL SUMMARY:

• 9+ years of work experience in IT industry in Analysis, Design, Development and Maintenance of various software applications mainly in Data Warehousing and windows environments in industry verticals like Banking, HealthCare, Telecom and Insurance.
• Professional understanding of Software Development Life Cycle (SDLC).
• Strong data base experience in Oracle 10g/11g, Microsoft SQL Server 2008.
• Experience in Data Warehousing and Data Processing based applications using Informatica Power Center 9.x/8.x/7.x.
• Knowledge in Teradata Database and Fast load, Multiload, Bteq (scripts) utilities.
• Developed Complex mappings from varied transformation logic like Unconnected /Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Worked on UNIX - shell Scripting for Pre-Session, Post-Sessions tasks and also automated the scripts using a scheduling tool.
• Expertise in Developing Mappings, Define Workflows & Tasks, Monitoring Sessions, Export & Import Mappings and Workflows Knowledge of using Debugger in mapping environment.
• Experience in performance tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions.
• Strong working experience in the Data Analysis, Design, Development, Implementation and testing of Data Warehousing using ETL tool Informatica Powercenter.
• Knowledge of different Schemas (Star and Snow Flake Schemas) for query and business analysis requirements.
• Extensively worked on Data Extraction, Transformation and Loading with Oracle,Teradata,SQL Server,Flat Files and XML Files.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Experienced in identifying Bottlenecks in ETL Processes, improving the Performance of the production loads and data access using Database Tuning, Index Usage.
• Experience in creating Reusable tasks (Sessions, Commands and Email) and Non Reusable tasks (Decision, Timer, Assignment, Worklets, and Control).
• Experience in working on implementation of Data warehouse and strong understanding of Data warehouse concepts, data modeling experience using star schema/snowflake modeling for OLAP systems, ER Diagrams, Dimensional Data modeling(Kimball), Fact & Dimensions tables, physical & logical data modeling using ERWIN.
• Experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views.
• Through Knowledge of different OLAP’s like DOLAP, MOLAP, ROLAP, HOLAP.
• Self-motivated and able to work independently and as a member of a team.
• Quick learner and adaptive to new and challenging technological environments.
• Commitment, result oriented and interested to learn new technologies.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x,Informatica B2B tools(DT 9.01,DX 9.0.1)

Data Modeling: Star Schema Modelling, Snow Flake Modelling, FACT & Dimensions.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008,Teradata

Languages: SQL, PL/SQL, UNIX Shell Script

Database Utilities: Toad, SQL developer, Teradata SQL Assistant

Operating Systems: Windows 7/XP Professional/2000

Reporting tool: Cognos,Business Objects 6.0/6.5

Scheduling Tools: Control-M,EIS

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

Responsibilities:

• Interact with users to gather the requirements, analyze them, raise clarifications and freezing the requirements.
• Involved STT (Source to Target) logics preparation, walkthrough them with users and freezing the STT’s.
• Imported Source tables using Source Analyzer and Target tables using Target Designer and Extracted flat files from file systems.
• Created reusable transformations using Transformation Developer and Mapplet Designer.
• Created ETL mappings using Mapping Designer and used many transformations like Expression, Lookup (connected & unconnected), Sorter, Source Qualifier, Aggregator, Router, Filter, Joiner, Union, Update, Sequence generator etc...
• Developed mapping reusability using Mapping Parameters and incremental loading process with the help of Mapping Variables.
• Designed ETL mappings to maintain a full history using SCD Type-II
• Created Hints in the SQL Query and Lookup Sql Override for improving query performance.
• Used Debugger to see/analyze how the data flowing from Sources to Transformations and Targets.
• Optimized various Mappings, Sessions, Sources and Target Databases.
• Created Source and Target database connections for Oracle, Teradata,Sql Server tables.
• Created reusable tasks for Session, Command and Email using Task Developer and Worklets using Worklet Designer.
• Created various non reusable tasks like Sessions,Event Wait,Decision,Link Tasks and Workflows using Workflow Designer.
• Created sequential and parallel batches among the dependencies.
• Created Pass Through partitions in the sessions for improving session performance.
• Created Indexes,Partitions on Target tables to improve target load performance.
• Created Stored procedures in the Target database and calls them in Command task.
• Created Control-M jobs and Reusable schedulers to trigger Informatica workflows through Control-M and Informatica Scheduler.
• Created Workflow Parameters and Session Parameters for parameterizing DB connections,Directories,File Names,Email notifications,Dynamic entries generation etc..
• Applied Pushdown Optimization on source tables to improve performance.
• Created TPT load and stream connections to improve performance.
• Involved in creating informatica labels,queries,ITSM,SVN links for migrating objects from lower environments to Higher environemnts.
• Performed unit testing and documented the unit test plan and its results.
• Good experience in communicating with offshore team.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 9.1.0, Oracle/11g, Teradata, UNIX,Windows 7, Control M,PuTTY,WinSCP,Toad,Teradata SQL Assistant,SQL Server Management Studio.

Confidential, Lewisville, TX

Responsibilities:

• Involved in STT (Source to target) documents preparation.
• Involved in various support activities i.e. DEV, SIT, UAT and Prod environments.
• Designed various mappings using transformations like Expression, Lookup (connected & unconnected), Aggregator, Router, Filter, Joiner, Union, Update, Sequence generator etc... To load data into Dimension and Fact tables.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations
• Created sequential and parallel batches among the dependencies
• Created Pass Through partitions in the sessions for improving session performance.
• Created Hints in the SQL query for improving query performance.
• Work on creating jobs and maintaining jobs in Control-M scheduling tool.
• Involved in creating informatica labels,queries,ITSM,SVN links for migrating objects from lower environments to Higher environemnts.
• Performed unit testing and documented the unit test plan and its results.
• Good experience in communicating with offshore team.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 9.1.0,Oracle/11g,UNIX,Windows 7, Control-M,PuTTY,WinSCP,Toad.

Confidential, Pennsylvania

Responsibilities:

• Initial analysis and understanding of HL7 file formats.
• Involved in developing Informatica Data transformation project using Informatica Data Transformation studio.
• Getting HL7 version 2.3 standard Libraries from the vendor and Importing HL7 version 2.3 standard Libraries into Informatica Data Transformation studio.
• Deploying the Informatica Data transformation project into Service DB directory.
• Involved in developing Informatica Power Center mappings to call Informatica Data Transformation project using Unstructured Data Transformation.
• Designed various mappings using transformations like Expression, Router, Joiner, Unstructured Data Transformation and XML Parser Transformation.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Analyzed Events errors in Informatica Data Transformation studio.
• Performed unit testing and documented the unit test plan and its results.
• Good experience in communicating with offshore team.
• Communication with the client for weekly status report.

Environment: Informatica Power Center 8.6.1,Informatica DT 9.1.2,Informatica DX 9.1.2,Oracle 10g,UNIX,Windows 7, Control-M,PuTTY,WinSCP,Toad.

Confidential, California

Responsibilities:

• Involved in various Business related documents i.e. Business Design Document (BSD), Technical Design Document (TSD), Unit test cases and System test cases documents.
• Involved in various support activities i.e. SIT, UAT and Prod environments.
• Designed various mappings using transformations like Expression, Lookup (connected & unconnected), Aggregator, Router, Filter, Joiner, Union, Unstructured Data Transformation and Sequence generator Transformation.
• Configured and ran the Debugger from within the Mapping Designer to troubleshoot predefined mapping.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Performed unit testing and documented the unit test plan and its results.
• Attended regular status meeting to update the project on daily basis with onsite.

Environment: Informatica Power Center 8.6.1,Informatica DT 9.0.1,Informatica DX 9.0.1Oracle 10g,UNIX,PuTTY,WinSCP,Toad.

Confidential, Rochester, NY

Responsibilities:

• Initial analysis and understanding of specification documentation.
• Involved in developing the reusable business logics in the form of mapplets and reusable transformations.
• Involved in designing various mappings with transformation rules using transformations.
• Designed test mapping to perform various tuning operations.
• Involved in developed mapping to relate values from source system using lookup transformation and aggregator transformation.
• Used Workflow monitor to see the work flows running and get the session properties and session log.

Environment: Informatica Power Center 8.6.0,Oracle 10g, UNIX,PuTTY,WinSCP,Toad.

Confidential, Chicago

Responsibilities:

• Involved in designing various mappings with transformation rules using transformations.
• Involved in developing mapping to merge the data from file system using file repository.
• Involved in designing various mappings with transformation rules using joiner, expression, aggregate, rank, lookup, update strategy, and filter transformations.
• Involved in developing mapping reusability using mapping parameter.
• Designed test mappings to perform various tuning operations to improve the performance of interface.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Created sequential and parallel batches among the dependencies.
• Performed unit testing and documented the unit test plan and its results.

Environment: Informatica Power Center 8.1.1,Oracle 9i,UNIX,Toad and Windows XP.

Confidential

Responsibilities:

• Used Informatica power center for (ETL) extraction, transformation and loading data from homogeneous and heterogeneous source systems.
• Used various transformations like Source Qualifier, Lookup, Router, Expression, Sequence Generator etc.
• Created reusable sequence generator for same sequence to be used in more than one mapping.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Involved UNIX shell scripts which triggers the informatica session and make the session runs.

Environment: Informatica PC 7.1.2, Oracle 9i, SQL Developer, Windows XP and UNIX.