Previous Job
Previous
PL/SQL Lead
Ref No.: 18-00595
Location: Louisville, Kentucky
Position Type:Full Time/Contract
Experience Level: 6 Years
Start Date: 05/17/2018
 
Job Title PL/SQL Lead- GRS ID: 119272
Relevant Experience
(in Yrs)
8 to 12 Years
Technical/Functional Skills Business Knowledge in healthcare domain & writing PL/SQL scripts &  ETL
Experience Required 5 to 10 Years
Roles & Responsibilities ·        Strong knowledge of PL/SQL, ETL, and SQL
·        Strong debugging and problem solving skills.
·        Agile/Scrum methodology experience a plus
·        Design all SQL requirements and perform and implement all tests and assist to evaluate all code
·        Ensure compliance to all requirements and maintain accuracy for same and design all technical system documents and architectural standards..
·        Analyze all existing programs and perform appropriate coding and tests on all programs and implement.
·        Provide assistance to all end users and coordinate with business analysts and document all technical requirements.
 
Generic Managerial Skills Communication, Coordination skills, Offshore Coordination
Education Bachelor or Master Degree
Start date (dd-mmm-yy) 15-Mar-18
Duration of assignment (in Months) >12 Months
Work Location Louisville, KY
Rates payable to vendor $/hr $80,000/year plus benefits 
Key words to search in resume PL/SQL Developer
Prescreening Questionnaire Differentiate PL/SQL and SQL
What are the data types available in PL/SQL?
Explain the purpose of %TYPE and %ROWTYPE data types with the example?
What do you understand by PL/SQL packages?
What do you understand by PL/SQL cursors?
Explain cursor types?
When do we use triggers?
Explain the difference in execution of triggers and stored procedures?
Explain the difference between Triggers and Constraints?
Differentiate between syntax and runtime errors?
What are COMMIT, ROLLBACK, and SAVEPOINT?
What packages are available to PL SQL developers?
What are different methods to trace the PL/SQL code?
When a DML statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the ways on commenting in a PL/SQL code?
What do you understand by Exception handling in PL/SQL?
List different type of expressions with the example.
What are INSTEAD of triggers?