ETL Developer Resume

PROFESSIONAL SUMMARY:

14 years of experience using SQL, Oracle 10G/9i/8i/ 8.05/7.1/7.0 , PL/SQL, SQL *Plus, PL/SQL Developer and Informatica.
8 years experience in Data Warehousing and ETLs.
Experience in Relational Database Design and Client/Server Application Development.
Experience in Data Warehousing application ‘Informatica’.
Sound knowledge in Relational Database Design fundamentals and principles.
Experience in writing Stored Procedures, Functions, Packages and Database Triggers using PL/SQL.
Versatile Team Player with Excellent Communication and Interpersonal Skills.

TECHNICAL SKILLS:

Databases: Oracle v11i, 11G, 10G/v9i/v8i/v8.05/v7.3

Software: Oracle, Informatica

Application Tools: PL/SQL Developer, Tool for Oracle Application Developers (TOAD), SQL Plus, PVCS Version Manager, Serena, Informatica, SQL Navigator.

Languages: SQL, PL/SQL

Operating Systems: Windows7, Windows XP, Widows 2000, Windows/NT, UNIX, MS - DOS, Windows98, Windows 95

Hardware: IBM PC, IBM VM

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential

Wrote plsql programs for the Data Warehouse team.
Created ETLs using Informatica for loading Data warehouse data.
Requirement study, analysis, design, & development using Oracle 10G.

ETL Developer:

Confidential

Wrote plsql programs for the Data Warehouse team.
Created ETLs using Informatica for loading Data warehouse data.
Requirement study, analysis, design, & development using Oracle 10G.
Provide recommendations for enhancements to department processes and procedures.

P/L Sql/ETL Developer

Confidential

Wrote procedures, functions, packages, triggers and anonymous scripts using P/L SQL Language and SQL Navigator.
Created many ETLs using Informatica for loading Data warehouse data.

Technical Analyst

Confidential

Involved in the Maximilian Project which includes various products like Enrollment & Eligbility, Benefits Billing System, and Administration, Flexible Spending Account.
Involved in the Transit Project which includes Parking and Transportation Reimbursement.
Requirement study, analysis, design, & development using Oracle 9i and Oracle 8i.
Design and Development of new applications and tuning existing applications for high optimal performance and throughput.
Tuning Oracle PL/SQL packages, functions and procedures using Explain Plan.
Develop, write and execute scripts and utilities.
Develop and execute test plan on all scripts/utilities prior to running in production.
Identify software bugs and/or system modifications needed.
Interface with customers, vendors, and managers to resolve problems.
Provide guidance to less experienced personnel with required processes and procedures.
Provide recommendations for enhancements to department processes and procedures.
Wrote many procedures, functions, packages, triggers and anonymous scripts using P/L SQL Language and P/L SQL Developer tool.

Accountant

Confidential

Worked as a Staff Accountant supervising AP, AR, and GL employees.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship