Professional Summary:

• Over 7 years of IT Experience in Data Warehousing, Database Design and ETL Processes in the Test and Development environments of various business domains like finance and Health Care Insurance domain
• Highly proficient in Development, Implementation and Support of ETL processes for Large-scale Data warehouses using Informatica Power Center.
• Worked extensively on ETL process using Informatica Power Center 9.x/8.x
• Experience in Database Development, Data Warehousing, Design and Technical Management.
• Good understanding in database and data warehousing concepts OLTP OLAP .
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys. In-depth understanding of Data Warehousing and Business Intelligence concept
• Proficient in RDBMS Oracle, SQL
• Understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact anddimension tables, Normalization
• Experience in creating transformations, mapplets and mappings using Informatica Designer and sessions and tasks using Workflow Manager to move data from multiple sources into targets.
• Worked with different data sources like Flat files, Vsam Files, and other relational and non-relational databases.
• Participated in agile product life cycle development of Data Warehouse systems such as Analysis, Design, Development, Testing, and Technical Documentation. Stupendous experience in Developing Mappings, Mappletsand Transformations like Lookup, Router, Aggregator, Normalizer, Source Qualifier, Joiner, Expression, Update Strategy, etc. between Source and Target using Informatica Power Center Designer.
• Excellent analytical skills with a good understanding at conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• HealthCare Domain Trainings undertaken.
• Undergone Trainings for Project leader's role.
• Have Secondary knowledge on Integrated Quality Management System Project estimation, efforts, Cost, Timesheet .

Technical Skills:

• ETL Tools : Informatica Power Center 9.5/9.1/8.x
• RDBMS : Oracle 10g/9i/8i, SQL, SQL Server
• Technologies :Data warehousing, ETL, Reporting
• Data modeling : Visio
• Navigation Tools : Toad, SQL Navigator, SQL Developer, Ultra Edit, Putty, WINSCP, SQL Server Management Studio
• Operating Systems : Windows XP/98/2000/2003, UNIX

Professional Experience:

Confidential

Role: Sr. Informatica developer

Responsibilities:

• Extensively used Informatica Power Center 9.5/9.1 to extract data from various Oracle sources and load in to staging database and from staging database to Sql Server and files. Also included mappings which directly loaded Oracle tables to SQL server databases
• Working on Alternative approach Stream, which includes mapping creation for 51 to 60 tables
• Included Error Handling strategy in all the Mappings.
• PreMigration, Migration and Post Migration Stages of the project present in Dev, Test, QA and Prod Environments
• Developed UNIX shell scripts to run batch jobs automate workflows.
• Worked on Informatica Trigger Process to initiate Informatica Events
• Contributed in developing each test plan and test case based on the high-leveled and detailed design.
• Worked on Defect Solution of the existing process.
• Did Performance tuning of the main down conversion workflow to tune the worklets for Optimum performance, Dependencies and Batch Design.
• Worked cooperatively with the team members and have also leaded them to identify and resolve various issues relating to Informatica and other database related issues.

Environment: Informatica 9.5/9.1, Oracle 10.0.1, PL/SQL developer, SQL Server Management Studio, Putty

Confidential

Role :ETL Team Lead/ Senior Systems Engineer.

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 to extract data from various sources and load in to staging database and from staging database to EDW database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, SQL and Stored Procedure.
• Developed UNIX shell scripts to run batch jobs automate workflows.
• Extensively used ETL to load data from multiple sources to Staging area Oracle 10g and EDW using Informatica Power Center 8.x Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Contributed in developing each test plan and test case based on the high-leveled and detailed design.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Extracted Data from multiple operational sources of loading staging area, Data Warehouse
• Worked cooperatively with the team members and have also leaded them to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.

Environment:Informatica 8.6.1, Oracle 10.2.0, Visio, SQL developer

Confidential

Role:ETL Module Lead/ Senior Software Engineer

Responsibilities:

• Development of Informatica mappings, mapplets, workflows and worklets. Design and development error handling processes.
• Worked within a team to populate Type I and Type II slowly changing dimension tables from several Mainframe files and Oracle Source tables.
• Assisting in the implementation of the scheduling strategy.
• Analyzed/modeled current information flows and recommended solutions.
• Developed complex mappings for de-dup and merge process.
• Performed incremental loadings and loads in different environments DEV, SIT, DIT and UAT.
• Prepared UTC for the developed mappings tested mappings as per ETL specification.
• Helped in Defect fixing in DIT, SIT and UAT environment.
• Developed re-usable UNIX scripts for flat file validation that includes source header/trailer stripping, Count Check, Merging header and trailer for the target files and various file checks as per the requirement.
• Implemented CR's and tested.
• Fixed High priority Production issues.
• Participated in Review of Test Plan, Test Cases and Test Scripts prepared by system integration testing team.
• Worked on creating and editing sessions using Informatica pre- and post-session commands, performance and advanced options, error handling settings.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.

Environment:Informatica 8.6.1, Oracle 10.2.0, Flat files, legacy systems, SQL, PL/SQL

Confidential

Roles : Informatica Senior Developer

Responsibilities:

• Worked on Informatica Power Center 8.6.1 - Source Analyzer, Data warehouse designer, Mapping Designer Mapplet, Transformations, Work Flow Manager Task Developer, Worklets, and Work Flow Designer and Work Flow Monitor.
• Responsible for developing, Testing, support and maintenance for the ETL processes using Informatica Power Center.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Used Informatica Power center workflow manager to create sessions, workflows and Worklets to run with the logic embedded in the mappings.
• Unit tested and tuned SQLs and ETL Code for better performance.
• Created various Documents such as Source-To-Target Data mapping Document, Unit Test Cases and Data Migration Document.
• Monitored the performance and identified performance bottlenecks in ETL code.

Environment:Informatica Power Center 8.6.1, Oracle 9i, Visio, TOAD, SQL

Confidential

Role: Informatica Developer Delivery Trainee Software Engineer

Responsibilities:

• Responsible for preparing the technical specifications from the business requirements
• Analyze the requirement, work out with the solution. Develop and maintain the detailed project documentation.
• Improved performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.
• Created mappings and used reusable Mapplets and transformations using Informatica Power Center.
• Documented processing times for each module, developed test cases and used them to run through each process.

Environment:Informatica Power Center 8.5.1, Oracle 9i, Visio, Toad, SQL