| ONSITE as Sr. Oracle PL SQL Developer at Houston, Texas, USA |
| Email: kartik.mahajan@gvrinfotek.com |
|
https://jobs.nvoids.com/job_details.jsp?id=1821609&uid= From: Kartik Mahajan, GVR Infotek kartik.mahajan@gvrinfotek.com Reply to: kartik.mahajan@gvrinfotek.com Sr. Oracle PL/SQL Developer Location: Downtown Houston, TX (Onsite) Duration: 24 + Month Interview: Initially Virtual (and final on-site interview with their team as a cultural fit) Visa: USC/GC/H4EAD/GCEAD/OPTEAD/H1B Must Have: Must HAVE LinkedIn profile Need Local to Houston candidate only ORACLE APPLICATIONS DEVELOPER: This will be a contract duration of 12-24 months and candidates MUST be willing to work ON-SITE Monday-Friday. Please ask your proposed candidate : How long has it been since you did PL/SQL development in Oracle Give me some examples of where you recently did development with PL/SQL ( She added We are NOT interested in candidates that have only use reports or ETL work as part of this work experience). As they support Web-Based front-end applications , Developers submitted to this role need to have either XML, Python or JSON experience. They had provided us previously a Questionnaire they asked we apply to all prospective candidates. Here below is the Questions along with some of the answers expected. Get their true reply and do not coach them on the answers: 1. What are various Oracle database objects ANSWER: Table, View, Index, etc. 2. What is an integrity constraint ANSWER: The constraint is used to identify wrong data and generates an error , as to validate data accuracy. 3. What is the difference in a Primary Key and a Unique Key ANSWER: Primary: Can only have one Primary Key and it cannot store null values. Unique: You can have more than one Unique key in a Table, but it can accept Null values. 4. What are Analytical queries How they are different from aggregate functions ANSWER: Analytical queries use Analytical functions Aggregate do Group-By 1 row/ group Analytical Functions dont useGroup-By 5. Types of Partitions ANSWER: List, Range , Hash 6. What are ref cursors ANSWER : Type of Dynamic cursor used to return multiple rows , I refer to them as Explicit Cursors What Web Apps Have You Supported 8. Give Example of Business Logic You Created to Invoke Web Applications 9. Give Example of Complex Batch Processes and Job Schedulers to Automate Data Processing Tasks You Created to Support the Web Apps Functionality 10. Give examples of Performance Tuning you do that Ensures Web Apps run Smoothly Thanks & Regards, Kartik Mahajan IT Recruiter GVR Infotek LLC: 13573 Tabasco Cat Trail, Frisco, TX 75035 Keywords: information technology green card procedural language Texas ONSITE as Sr. Oracle PL SQL Developer kartik.mahajan@gvrinfotek.com https://jobs.nvoids.com/job_details.jsp?id=1821609&uid= |
| kartik.mahajan@gvrinfotek.com View All |
| 06:47 PM 08-Oct-24 |