|Position: Lead PL/SQL Developer Interview: Phone + Skype Mortgage Industry MUST HAVE Technical Expectations: Prior lead experience is mandatory PLSQL 8+ out of 10 Oracle Data Warehouse Experience Strong data analytical/ problem solving skills with understanding of the business drivers and goals of the project. Strong communication skills PLSQL key areas of knowledge: o Nested Tables o Associative Arrays o VArrays o Bulk Collects and Inserts o Dynamic SQL o Table Level Triggers and other types of triggers § Fire Order (Mid) § Compound Triggers – New to 11i (Mid) o Auditing o Sequence generation o Complex constraints where users interact directly with the database o Data types? § Scalar – Single Value with no internal components § Composite – Data values with internal components Strongly Preferred: Strong skills in MSSQL, SQL in Oracle environment - College degree from the US Prior experience leading developers and working as the link between the business and development teams. Nice to Haves: - Agile Teradata experience Reporting Experience Understanding of Java, ETL & Cognos Autonomous Transactions Exceptions VPD/RLS Familiarity with Chase IT systems and procedures preferred More Nice to Haves: · Autonomous Transactions · Exceptions · VPD/RLS · Java Stored Procedures Description: The Data Warehouse Developer is responsible for eliciting requirements; designing dimensional data models; preparing written design documents; developing extract/transform/load routines using PL/SQL; performing intensive data analysis; and migrating releases into testing and production environments. In addition, the Data Warehouse Developer performs non-development work to include monitoring scheduled jobs; reviewing the results to determine success/failure; documenting success/failure; troubleshooting failures; providing up-to-date communication with the user community; and maintaining documentations Requirements: BA/BS degree and a minimum of 5 years experience in data warehousing and business intelligence project work Minimum of 4 yrs exp. Requirements elicitation and analysis experience Demonstrated strong problem-solving abilities and multitasking capabilities Ability to perform well in a high pressure, time-sensitive environment Strong written and verbal communication skills Demonstrated ability to understand and document business processes Demonstrated ability to work within an established timeframe to complete tasks Strong organizational skills Strong Oracle, Unix experience. Note: Please send the resume at email@example.com|
Jobs Like This Near columbus, OH
GO TO EMPLOYER WEBSITE
Click on the button below to go to the Dew Softech Inc website and apply for Lead PL/SQL Developer.