SUMMARY:

• 7 Years of experience in IT industry including expertise in design and development of Relational Database Systems, Design and Development of Data Warehousing using Informatica Power Center ETL tool.
• Extensively worked on data warehousing concepts using various ETL tools like Informatica and Oracle Warehouse Builder.
• Experience in ETL tool, INFORMATICA V 7.x V 8.x . Experience in Using Repository Manager, Designer and Workflow Manger, Workflow Monitor Tools in Informatica Power Center.
• Extensive understanding of Transactional and Dimensional Data Modeling, Data Ware house concepts and Designing Star schemas Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 version, flag and time .
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source,Target, Mapping, Session and System in ETL Process.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Transaction Control, Filter and Update Strategy.
• Expertise in data extraction from Flat Files XML, excel, csv, fixed width, delimited, txt , and Oracle server.
• Good experience in handling terabytes of data and good at analyzing the data related issues.
• Extensively worked on oracle warehouse builder tool. Supported customizations and testing.
• Created various tasks like sessions, and workflows in the workflow manager to test the mapping during development.
• Hands on experience on SQL and PL SQL concepts. Working experience on oracle server.
• Extensively worked on performance tuning areas. Good knowledge on partitions, indexes, table space related issues.
• Good at analyzing AWR Automatic Workload Repository report and good in providing suggestions on SQL tuning techniques using explain plans.
• Worked with Teradata including loading targets, executing SQL and troubleshooting and optimization of ETL components.
• Good working experience on partition exchange load process offline data loads in oracle.
• Good in providing estimations on hardware sizing for the database servers.
• Good in suggesting the performance tuning techniques to increase the data load through put.
• Implement UNIX shell scripts for scheduling various tasks.
• Strong Knowledge in ETL design document and mapping sheet creation.
• Good in scheduling jobs and administration activities.
• Proficient in understanding Functional Requirements and Design documents.
• Good in creating HLD and other design documents as needed.
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Worked predominantly in billing systems.
• Possess good communication skills and effective client communication.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutionsleading to high customer satisfaction.
• Having good experience as team lead and led the team with team size 3-5.
• Self-learner and highly self-motivated attitude.
• Knowledge of Change Data Capture CDC using Oracle 9i and Informatica Power Exchange.
• Followed effectively industry standards of HIPAA, ANSI837 and PHI concepts.
• XML source and target schema and object definitions.

Technical Skills:

CAREER PROGRESSION

Confidential

Informatica developer Business Process Integration

Responsibilities:

• Understanding existing business model and customer requirements in different local markets.
• Implementation of the dataware house part in all the local markets based on the requirements.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
• Used Teradata Administrator and Teradata Manager Tools for monitoring and control the system.
• Performed database health checks and tuned the databases using Teradata Manager.
• Worked with Teradata 12 utilities like BTEQ, Fast Load, Multi Load and Query man.
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Implementation and up gradation of the billing system for all the local markets.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Excellent understanding of Star Schema modeling, Snowflake modeling.
• Coordinating with the team and interacting with the client for implementation of deliverable.
• One to one interaction with the clients.
• Proactively interacting with clients in understanding the requirements and fixing the issues.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Played key role in performance improvement activities like query tuning.
• Design document creation and implementation.

Environment: Informatica-Power Center 9.5.1, Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager , Oracle 11g, Toad, Java, Netbeans, View Point Erwin 7, MS Visio, Windows, Autosys.

Confidential

Sr.ETL Developer

Responsibilities:

• Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
• Extensive experience in using ETL process using Informatica Power Center 8.x/7.x.
• Have participated in exporting the sources, targets, mappings, workflows, tasks etc. And imported into the new Informatica 8.X, tested, reviewed to make sure that all the workflows are Execute as per the Design documents and Tech specs.
• Developing the Mappings using needed Transformations in Informatica tool according to technical specifications
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Extensively used XML Source, XML target and XML Parser transformations
• Imported Source and Target tables from their respective databases
• Developing Mapplets and Transformations for migration of data from existing systems to the new system using Informatica Designer.
• Excellent understanding of Star Schema modeling, Snowflake modeling.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter,Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, and Sorter.
• Interacting with off-shore people and Database team if any issues.
• Preparing the Documentation for the mapping according to the designed logic used in the mapping.
• Preparing Test Cases and executing them along with the Testing team.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Informatica PowerCenter 9.1, Oracle 10g, IDQ, IDE, SQL, PL/SQL, TOAD 8.5, Teradata, Erwin, PeopleSoft, Mainframe, Unix, BO XI, Tivoli, AIX, Sun Solaris Windows NT.

Confidential

ETL Developer

Responsibilities:

• Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
• Involved in analyzing the requirements and created Design Documents and Data Mapping Documents.
• Worked with Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Workflow Manager and Monitor.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
• Used Mapping Parameters and Variables to implement object orientation technologies and facilitate the reusability of code.
• Developed mappings to implement Slowly Changing Dimensions Type 1 2 .
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Developed Audit Strategy to validate the data between Source and Target System.
• Involved in Production Support.
• Supported the Implementation and Post-Implementation process.

Environment: Informatica PowerCenter 8.6.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor , Power Exchange Navigator 8.6.1, IDE, SQL Query Analyzer 8.0, Oracle 9i/10g, SQL Server 2005, SQL Server Management Studio, Toad, SQL Developer 1.1.2, PVCS, Tivoli, AIX, Sun Solaris Windows NT, Shell Scripting.

Confidential

Application Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Developed mappings using informatica for data flows from Source to Target.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc... In mappings to perform the ETL process.
• Worked on mapping review, if design flaws found as a part of peer testing.
• Created Effective Test Data and Unit Test cases to ensure successful execution of data loading processes.
• Performed Informatica code migrations, testing, debugging and documentationLead the activities, growth and professional development for three staff members.

Environment: Informatica PowerCenter 8.6.1/8.1.1 Repository Manager, Designer, Workflow Manager, Workflow Monitor , Power Exchange Navigator 8.6.1/8.1.1, IDQ Workbench, SQL Server 2008, SQL Enterprise Manager, SQL Query Analyzer, Teradata 13.10, TPT 13.0, SQL Assistant, DB2, Java, Tivoli, AIX, Sun Solaris Windows.

Confidential

ETL Developer Migration from DataStage to Informatica

Responsibilities:

• Understanding existing business model and customer requirements.
• Developed mappings using informatica for data flows from Source to Target.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc... In mappings to perform the ETL process.
• Worked on mapping review, if design flaws found as a part of peer testing.
• Created Effective Test Data and Unit Test cases to ensure successful execution of data loading processes.
• Performed Informatica code migrations, testing, debugging and documentation.
• Create and maintain documentation related to production batch jobs.

Environment: Informatica PowerCenter 8.1.3 Repository Manager, Designer, Workflow Manager, and Workflow Monitor , Ascential DataStage, MicroStrategy 7.1.5, Oracle 9i, TOAD 8.6.1, Sun Solaris Windows NT, Shell Scripting.