PROFESSIONAL SUMMARY:

• 8.5 Years of experience in development and design of ETL & ELT methodology in Development, Maintenance and Support projects using Informatica 8.x and 9.x
• Experienced in Analysis, Design, Development, Testing and Support of ETL components
• Worked on Informatica Power Center 8.x and 9.x using tools like Designer, Workflow Manager and Workflow Monitor
• Experienced in working with different relational systems like Oracle, Teradata, SQL Server, Netezza and UDB2 as source/target databases for the ETL components.
• Experienced in working with different application systems like SalesForce and SAP acting as source to the ETL components
• Working experience of Unix shell scripting
• Exposure to reporting tools like Business Objects XI
• Strong verbal and written communication skills and applied them effectively working with global teams
• Strong analytical skills and ability to apply them for effective execution of the deliverables

TECHNICAL SKILLS:

Primary Skill: Informatica 8.x, 9.x

Databases/Application systems: working experience, Oracle, Teradata, UDB2, SQL Server, Netezza, SalesForce, SAP

Trained/Project Acquired Skills: Business Objects XI, Unix shell scripting, Cognos 8, Control - m

PROFESSIONAL EXPERIENCE:

Confidential

ASSOCIATE

Environment: Informatica 9.1.0, Teradata, Unix, Control-m

Responsibilities:

• Analysis of the business & technical requirements
• Design, develop database scripts to create objects required in system to perform ETL or ELT
• Design of the components meeting the requirements
• Development of the components using Informatica 9.1.0
• Testing the components developed
• Support the components developed through QA, UAT and PROD phases of SDLC

Confidential

Senior ETL Developer

Environment: Informatica 9.1.0, SalesForce, Oracle, Unix, ESP Workload automation

Responsibilities:

• Analysis of the requirements
• Develop database scripts to create tables required in EDW system
• Design of the ETL components meeting the requirements
• Development of the ETL components using Informatica 9.1.0
• Testing the ETL components developed
• Change ETL components through UAT phase per inputs from users
• Support system in PRODUCTION

Confidential

Senior ETL Developer

Environment: Informatica 9.1.0, SAP, Oracle, Unix

Responsibilities:

• Analysis of the requirements provided by functional and business users
• Design of the ETL components meeting the requirements
• Development of the ETL components using Informatica 9.1.0
• Unit testing the ETL components developed
• Change ETL components through UAT phase per inputs from functional and business users

Confidential

Senior ETL Developer

Environment: Informatica 9.1.0, SAP-BW (UDB2), Oracle, Unix

Responsibilities:

• Analysis of the requirements
• Develop database scripts to create tables required in EDW system
• Design of the ETL components meeting the requirements
• Development of the ETL components using Informatica 9.1.0
• Unit testing the ETL components developed
• Change ETL components through UAT phase per inputs from users
• Support system in PRODUCTION

Confidential

Developer

Environment: Informatica 8.6.1, UDB2, Netezza, Unix, VSAM Files

Responsibilities:

• Analysis of the requirements.
• Design of the ETL logic meeting the requirements.
• Development of the ETL code using Informatica 8.6
• Testing ETL code developed.
• Preparation of LLD and UTC documentation

Confidential

Developer

Environment: Informatica 8.6.1, UDB2, MSSQL Server 2005, Unix

Responsibilities:

• Analysis of the requirements
• Design of the ETL logic meeting the requirements
• Development of the ETL code using Informatica 8.6
• Testing ETL code developed
• Preparation of LLD and UTC documentation

Confidential

Developer

Environment: Informatica 8.1, UDB2, MSSQL Server 2005, Unix

Responsibilities:

• Analysis of the requirements
• Design of the ETL logic meeting the requirements
• Development of the ETL code using Informatica 8.6
• Testing ETL code developed
• Preparation of LLD and UTC documentation

Confidential

Developer

Environment: Informatica 8.1, UDB2, MSSQL Server 2005, Unix

Responsibilities:

• Involved in Analysis, Design, and Development of the ETL code using Informatica 8.6
• Involved in interactions with Data modeling and Reporting teams to ensure business reporting requirements are met with the existing data model and ETL code developed and making necessary changes if any deviation
• Involved in Unit Testing of the ETL code developed
• Prepared migration requests for moving the Informatica as well as Database Objects from DEV to QA and from QA to PROD environments
• Prepared alter table scripts to handle change required to the table structures as a part of each version of release
• Resolved Production Load related issues as a part of Monthly load support activity
• Involved in fine tuning of Informatica mappings for improved performance

Confidential

Developer

Environment: Informatica 8.1, UDB2, MSSQL Server 2005, Unix

Responsibilities:

• Involved in Analysis, Design, and Development of the ETL code using Informatica 8.6
• Involved in interactions with Data modeling and Reporting teams to ensure business reporting requirements are met with the existing data model and ETL code developed and making necessary changes if any deviation
• Involved in Unit Testing of the ETL code developed
• Prepared migration requests for moving the Informatica as well as Database Objects from DEV to QA and from QA to PROD environments
• Prepared alter table scripts to handle change required to the table structures as a part of each version of release
• Involved in fine tuning of Informatica mappings for improved performance

Confidential

Developer

Environment: Informatica 8.1, Cognos 8, Oracle 9i, Teradata, Unix

Responsibilities:

• Involved in Analysis, Design, Development and Deployment of the ETL enhancement requests
• Resolving ETL Problem Tickets with in stipulated time as per the priority involved using Informatica 8.1
• Involved in preparation of Migration documents, Process Documents required per process set up by client
• Involved in development and testing of the Informatica mappings and documented the test results
• Involved in Maintenance, troubleshooting and fine tuning of Informatica mappings for maximum Performance
• Involved in analyzing of requirements for developing ETL code of new applications
• Involved in Development and Unit testing of Informatica mappings
• Documentation of all the process involved like Analysis Document, Design Document, Code Document, Test Cases and Delivery Document