|Organization Name||6789-DDC - Conversion & Integration|
Analyzing, designing, developing and testing of ETL codes. Creating ETL interfaces, workflows and dataflows to transfer data from various complex formats. Creating complex SQL queries, procedures, functions and packages. Maintaining, enhancing and supporting existing complex ETL codes. Analyzing, recommending and resolving complex issues as well as developing alternate methods of code. Modifying database programs to improve processing performance. Creating end-to-end Business Objects Data Integrator (BODI) ETL mapping documents. Implementing data flows, workflows and jobs using BODI. Creating UNIX shell scripts for automating BODI jobs through the Tidal scheduler.
Master's degree or foreign equivalent in Computer Science, Engineering, or related field, and 3 years of professional experience in the job offered or related Programmer Analyst position. In lieu of a Master's degree or foreign equivalent and 3 years of experience, employer will accept a Bachelor's degree or foreign equivalent in the above-listed fields, followed by 5 years of progressive, professional experience in the job offered or related Programmer Analyst position.
Experience and/or education must include the following:
1. Oracle, HP-UX, Unix, Korn Shell scripting, Toad, Clearquest, and Tidal.
2. Development of tools and programs using Business Objects Data Integrator (BODI), Oracle SQL and Oracle PL/SQL.
Any suitable combination of education, training, or experience is acceptable.