Thursday, 16 July 2015

Sr Oracle Developer (Pl/SQL) Data Warehouse


NOTE: Need Minimum 10 + years of Experience

New Jersey
Contract Duration - 2 to 5 Years
Interview - Phone + In-Person

Primary Skill: PL/SQL, Stored Procedures, Performance Tuning, SQL Loader
Secondary – ETL, Unix/Linux

Responsibilities
·         Develop and maintain Data Repositories using Oracle database programming skills with Oracle PL/SQL, SQL, SQL Loader, Sync Sort and Linux shell scripting
Provide business expertise for the development of Business Intelligence solutions
Assure quality of design and implementation of projects
·         Provide technical expertise to the development and implementation of solutions using basic dimensional modeling techniques, make recommendations for improvements in these areas when necessary
·         Provide technical support for existing Data Warehouse ETL (Extract, transform, load) processes
·         Trouble-shoot application software/hardware problems as they apply to design, implementation, or installation activities
·         Follow DMS related standards and procedures, knows where they are located, and incorporates them; follows CLIENT’S software development processes
·         Research, evaluate, and test new software and DW related tools and facilities as they pertain to the existing DW environment and applications
·         Monitor current DW applications and develop procedures, where necessary, to improve the DW environment as required
·         Comply with all CLIENT’S security and audit standards
·         Manage the work of CLIENT’S vendors to achieve quality results at a market based price using CLIENT’S SR&T policies and procedures
  
Requirements:
·         Must have extensive knowledge in Oracle database programming skills with Oracle PL/SQL, SQL and SQL Loader
·         Must have extensive knowledge in advanced Oracle PL/SQL to maintain existing processes and create new ETL processes.
·         Must have Oracle knowledge for performance tuning.
·         Must have technical skills in Unix and Linux environment
·         Strong knowledge of UNIX/LINUX shell scripting
·         Experience with Sync Sort for UNIX/LINUX
·         Experience with Data Warehouse implementations and ETL skills
·         Prefer Autosys Job Scheduler
·         Prefer Micro Focus Cobol experience
·         Prefer IBM Mainframe JCL/COBOL



No comments: