Oracle PL/SQL and ETL Analyst

Profile

Looking for a candidate for a LONG TERM Contract (1 to 3 yrs with a fortune 500 company).
Must have Informatica, Strong Oralce and Unix Scripting.
Looking for Informatica consultant with Unix and Oracle skills plus excellent communication skills (this person will be working with business partners as well as IT).
Please send your resumes to ****. **** only if you have questions.
The assignment is going to be for 1 to 3 years
Knowledge and Skills
Proficient in data extraction and management (Data management entails data capture, refresh, business rules execution, lists creation and reporting as well as on-going maintenance.)
Entry-level Oracle DBA skills
Basic understanding of Direct Marketing and response analysis.
Basic understanding of the Vacation Ownership business
Excellent oral and written communication, with proven experience in the creation and revision of technical process documentation.
Knowledge and understanding of data manipulation and aggregation to facilitate a flexible reporting environment.
Understand business processes and systems and know how to use this knowledge to develop and enhance existing processes to reduce costs and create efficiency.
Proficient in Unix shell scripting
Proficient in writing/tuning Oracle SQL queries and PL/SQL procedures/functions
Proficient in VBA scripting
Proficient in DOS batch scripting
Proficient in Informatica data integration tools (or other enterprise ETL tool)
Experience developing reports using BI software packages such as Business Objects, Cognos, or SAS highly desired
Data manipulation using Oracle SQL querying tools such as Oracle SQL*Plus, SQL Navigator, Toad
Working knowledge of SQL Server, Transact SQL, programming in a current language (.net, ASP, VB, or C#)
Knowledge of Microsoft Office products; Microsoft Access skills highly desired.
Experience using SAS highly desired
Job experience
Experience with DOS and shell scripting (5 years).
Experience with large Oracle (10g preferred) relational databases (5 years).
Experience in data manipulation using Oracle SQL querying tools such as Oracle SQL*Plus, SQL Navigator, Toad (5 years).
Experience with Informatica integration or other ETL tools (1 years).
PL/SQL programming for complex stored procedures, SQL*Loader, packages and triggers. (4 years).
Database monitoring, performance tuning, identifying and trouble-shooting bottlenecks. (2 years).
Experience extracting data from multiple source systems and translating this data into meaningful analyses, reports and recommendations (3 years).
Experience as Marketing Analyst or Business Analyst, preferably as Database Marketing Analyst (5 years)
Related data processing and data management experience in a database or direct marketing organization (5 years).
Experience working collaboratively with system stakeholders and Information Technology staff to champion the successful development, testing, implementation, and training of database marketing technologies and the use of statistical analysis (2 years).
Data integration, including import, export and synchronize data between different systems. (3 years).
Latha Manian
IBIZ Group LLC,
1315 E 126th St.
Carmel, IN 46033
****
Web: ****

Company info

Sign Up Now - SQLCrossing.com