Informatica ETL Developer Resume

SUMMARY:

8 Years of Professional Experience in S/W development Industry on platform Oracle (8, 8i, 10g, 11g), forms and reports and PL/SQL.
4 Years of experience in Progress 4GL (Progress 4GL Database, App Builder).
2 Years of experience in Informatica ETL (Power Center).

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/XP/2003/2007/UNIX

Primary Skill: Oracle, Sql/Plsql and D2K( Forms & Reports 6i/10g), Progress 4GL, Progress App Builder

Language: SQL, PL/SQL(Cursor, Procedure, Function, Package, Trigger), Progress, Shell Script

Tools: Sql Developer, TOAD( 9.5), PLSQL Developer 7.1, ETL Tool (Kettle 5.4 ETL, Informatica 8.1.1), Progress 4GL Open Edge10.2

RDBMS: Oracle 8i/9i/10g, Progress 4GL

ETL Tools: Informatica 9.6.1, Kettle ETL

Reporting Tools: Business Object R2

PROFESSIONAL EXPERIENCE:

Confidential

Informatica ETL Developer

Technology: Oracle 10g, PL/SQL, Progress 4GL.

Responsibilities:

In Maintenance creating or modifying store procedures, functions, collections, ref cursor etc as per requirement in different modules.
Analyze and design enhancements.
Create Stored Procedure, Function, Triggers, Packages as per enhancement requirement.
Active participation in meeting with clients, gathering their requirements in order to develop User friendly system.
Run the script files in Unix and little changes as per requirement.
On Call Support for these module as well.
Designing and coding of the Application.
Resolving incidents by using Performance tuning. Using SQL Loader as per users requirement to load the data.
Use Support work/Cherwell tool to resolves tickets, incidents, task and enhancement. Maintain SLA on time of all incidents.

Confidential

Informatica ETL Developer

Technology: Oracle 10g D2K, Pl/Sql, Unix

Responsibilities:

In Maintenance creating or modifying store procedures, functions, collections, ref cursor etc as per requirement in different modules.
Analyze and design enhancements.
Create Stored Procedure, Function, Triggers, Packages as per enhancement requirement.
Active participation in meeting with clients, gathering their requirements in order to develop User friendly system.
Run the script files in Unix and little changes as per requirement.
On Call Support for these module as well.
Designing and coding of the Application.
Resolving incidents by using Performance tuning. Using SQL Loader as per users requirement to load the data.
Use Support work tool to resolves tickets, incidents, task and enhancement. Maintain SLA on time of all incidents.

Confidential

Informatica ETL Developer

Technology: Oracle 10g Sql, Pl/Sql, Unix (Back end Process)

Responsibilities:

Develop database design; create store procedures, function, triggers etc.
Making change in the existing system, Code Reviewing, Creating new procedures, triggers.
Used Collections, Ref cursor, Bulk collect etc.
Applying Triggers, LOV’s as required, Forms/Report as per requirement.